cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ian3
Resolver I
Resolver I

Using flow lookup lists

Quick question, i have a SharePoint list with a person/group column and a choice column. What I want to do with flow is is an email address is entered into the manager person column (email address) get flow to check the Area director column Choice = corporate AD. Lookup list has corporate AD then AD name is email address. If the manager and AD name match then do not send email.another flow is set up for AD choice column if condition to send email to AD. Manager and AD can sometimes be the same.any help you can give would be greatly appreciated.thank you in advance ian

3 ACCEPTED SOLUTIONS

Accepted Solutions
PrasadAthalye
Community Champion
Community Champion

Are you trying to match Person Group Column name with Choice column name? OR Person Group Employee ID to Choice Column employee id?

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

View solution in original post

 

I am trying to do the first one with a lookup to a second list looking up the choice to get the corresponding email address to check if they match and if they do don't send email,but if they don't match send email.

Cheers

 

Ian

 

 

View solution in original post

PrasadAthalye
Community Champion
Community Champion

What is stored in second list choice? Is it email address?

 

If yes, in Get Items for 2nd list, you can apply filter something like below...

 

Approver eq '<Select Email property of Lookup Column from first list trigger>'

 

This should return you the data from 2nd list. Then you can check count of the output of getitems. If its 0, you can send email.

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

View solution in original post

3 REPLIES 3
PrasadAthalye
Community Champion
Community Champion

Are you trying to match Person Group Column name with Choice column name? OR Person Group Employee ID to Choice Column employee id?

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

 

I am trying to do the first one with a lookup to a second list looking up the choice to get the corresponding email address to check if they match and if they do don't send email,but if they don't match send email.

Cheers

 

Ian

 

 

PrasadAthalye
Community Champion
Community Champion

What is stored in second list choice? Is it email address?

 

If yes, in Get Items for 2nd list, you can apply filter something like below...

 

Approver eq '<Select Email property of Lookup Column from first list trigger>'

 

This should return you the data from 2nd list. Then you can check count of the output of getitems. If its 0, you can send email.

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,932)