Forum Discussion
Unique Email address - Power Automate
Could you create a SharePoint list to store the approvers? Then in the Power Automate, lookup the approvers (from SP) based on your conditions. That may be the easiest to implement and maintain. Otherwise, how are you determining the approver?
- wilson1231805Feb 18, 2023Copper Contributor
Thank you jefmeyer
I hadn't thought of doing it like this. So, I create the list of approvers within SharePoint and then somehow within the flow I've created I add this in? (not done this before!).
- jefmeyerFeb 20, 2023Iron Contributor
wilson1231805 - Yes, correct. You'll need at least two columns in the list: 1) for looking up the approvers. 2) Approvers column. You can then use the Get Items (SharePoint connector) to retrieve the approver from the list. This approach will return a collection and when trying to access the result (this throws people sometimes). It should look something like this;
The other approach to retrieve the data would be the "Send an HTTP Request", but this is a bit more effort to implement. It's more efficient, but a little harder to implement. It should look something like this:
https://learn.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/working-with-get-items-and-get-filesSend an HTTP request info: https://learn.microsoft.com/en-us/connectors/sharepointonline/#send-an-http-request-to-sharepoint