Forum Discussion
Unique Email address - Power Automate
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!).
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-files
Send an HTTP request info: https://learn.microsoft.com/en-us/connectors/sharepointonline/#send-an-http-request-to-sharepoint