Their first solution was to use a Microsoft Power Automate flow to do the parsing which has excellent JSON support ... Text( untypedVariable.TextField ) Similarly, a JSON array of values or records ...