cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Bielstolze
New Member

comparing item from two lists

Hi, I have two list on sharepoint:

 

a demand list

a list of those responsible for each demand

 

I'm doing a flow that i need:

 

when I create a new item in the demand list, it checks the responsible list for who is responsible for that demand and sends them an email

 

but idk what is happend its dont works 

 

this is my flow:

img.jpg

 

 

help me please

 

(sorry for my bad english)

1 REPLY 1
AmDev
Continued Contributor
Continued Contributor

Hi @Bielstolze 

 

Use the Get Items action on the who is responsible list and open up the 'Show advanced options' at the bottom of this action to reveal the filter. Pick the 'Demand' column on the left and the 'Demand' dynamic content on the right from the trigger.

AmDev_0-1637888155723.png

 

This should filter down to the item you are interested in.

 

You can then just use the outputs from this GetItems step to send the email to the correct person/people. Note it will create an Apply to Each loop when you add dynamic content from the GetItems property into your next action even if it has filtered your list down to just one item as the output from GetItems is an array - don't worry about this - just go ahead and your flow should work fine.

 

Hope this helps - Good Luck!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,375)