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).
Now with an experimental feature that enables the parsing of JSON objects, the process gets way simpler (as it is experimental, it should be used only in POCs/tests and not production scenarios by now).
We can use a generic flow accepting the SharePoint rest endpoint parameters as we would do to call it from Power Automat, in combination with the ParseJSON function to call the SharePoint Rest API and manipulate the results in a simple way from a Canvas App as in the…
More About This Author
SharePoint and Office 365 Consultant/Developer always trying to get the best from Microsoft stack (Microsoft 365/Azure/Power Platform and related stuff).
Living in Ireland since 2018, I had previously worked in Brazil as a consultant/developer for Office 365, SharePoint and related technologies for almost 10 years.
- Modern Workplace9 September 2023Using SharePoint list formatting and Power Automate to create linked items (via LookUp field) in a related list
- Modern Workplace1 September 2023Using the HTTP with Azure AD connector in Power Automate to create Planner Plans and add them as Teams tabs
- Modern Workplace26 August 2023Create an Issue Tracker App using Power Apps Copilot (Preview)