Use Information from one SPO List to create Approval Process When a new Item is Created in a different SPO List

[ValVaca]

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. 

[v-alzhan-msft]

Hi @ValVaca ,

Could you please share a screenshot of the configuration of your flow?

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[manuelstgomes · Accepted solution]

Hi @ValVaca 

The "Get Item" requires a valid ID for the element in that SharePoint list. Where are you getting the ID? Probably you picked an ID from another List and it's trying to fetch something that doesn't exist on the other list.

I need more details to go on but, reading your initial post, I think this might be your issue.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
​
Cheers
Manuelv