Hi All,
I'm working on an approval process in Power Automate (Flow). I've run into an issue on the flow. Here is the Process:
3 Different SPO Lists are used
1. SPO List #1 is an input form for users to choose which sports game they want to belong to. Here they choose a Team and which Manager they belong to. Both the Team and Manager column are the CHOICE COLUMN.
2. When the item is submitted it will kick off the flow. The Flow's first step is an approval process. Based on the Team the user choose in SPO LIST #1 then we will use SPO LIST #2 to get that teams manager. SPO List #2 contains all the teams with a manager. The manager is the people column.
So the team from SPO LIST #1 will match an item in SPO List #2 where we will get the manager email and send the approval to them.
3. Once that approval is ready, then SPO LIST #3 comes. SPO LIST #3 contains another set of approvals and their emails. Based on a column in SPO List #1 (Manager Column) It will go into SPO List #3 and pull that items information and send the Approval to the user.
I'm having issues with the GET ITEM option. It will fail and not send to the user.
