Using the ParseJSON function with SharePoint API

Even though there is a ‘Send an HTTP request to SharePoint’ action in Power Automate that allows us to call any SharePoint Rest API endpoint, there is no equivalent action for the same in Power Apps.

We can leverage Power Automate Flows to help with any action that is exposed through the SharePoint Rest API, but as previously there was no easy way to parse JSON objects in Power Apps without a premium license, the process could be a little bit cumbersome (using RegEx techniques with the MatchAll function).

Read the full article:

https://michelcarlo.com/2022/09/13/using-the-parsejson-function-and-a-generic-flow-to-call-any-sharepoint-rest-api-endpoint-and-manipulate-the-results-from-power-apps/

Working with the SharePoint Send HTTP Request flow action in Power Automate

In Power Automate, the SharePoint Send HTTP Request flow action lets you construct and execute SharePoint REST API queries. This action is particularly useful in cases where the existing SharePoint flow actions do not handle your requirements, or the action you are looking for is not yet available in the SharePoint connector.

https://docs.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/working-with-send-sp-http-request?WT.mc_id=M365-MVP-5004644

ParseJSON function in Power Apps (experimental)

Interprets a JSON string and returns an untyped object.

https://docs.microsoft.com/en-us/power-platform/power-fx/reference/function-parsejson?WT.mc_id=M365-MVP-5004644

More about Parse JSON:

https://www.hubsite365.com/en-de/news?id=6be91724-9b32-ed11-9db1-6045bd8f953f&search=json