Everything Sharepoint is kludgy once you try to step outside it’s domain. I was surprised recently that Power Automate has a built in JSON parser, but CSV is by

Everything Sharepoint is kludgy once you try to step outside it’s domain. I was surprised recently that Power Automate has a built in JSON parser, but CSV is by a third party. Still, I wouldn’t say it’s overly onerous if getting things into JSON or a spreadsheet are all you need. Very common for people building Power BI dashboards, or using the list to construct API queries to other systems. Weird example, but you can build what is effectively a DSL, so users can create queries and workflows just by creating list items with the available options, which can then be translated into code. “Stupid Sharepoint Tricks” but it’s nice because they’re self documenting, come with authoring history and access control, and doesn’t seem scary to some users.