Looking for a way to look up by key & value pair using Power Automate

(0) Share

Report

Posted on by Community Power Pla...

Hi Experts,

I am making a flow to create an issue in Azure DevOps when an email is received.

I have below action to get Office Location by sender email, and from Office Location, i will assign the work item to a team member.

i am having a SPO list with key & value pairs like this

Office Location	Team member
Office 1	member1@xyz.com
Office 2	member2@xyz.com

and an action Get items with Filter Query to get the items with Office Location

When i put email field from Get Items to Assigned To field of work item, it did not run as expected

this is a result

Does anyone know how to do this in the most dynamic way? i'm thinking of Switch Statement but it does not easy to maintain & not the best way in my opinion.

Thank you in advance !

full flow.png

All responses (2)

Answers (1)

Community Power Pla... on at

Like (0)

Report

Re: Looking for a way to look up by key & value pair using Power Automate

Thank you for pointing out this for me 😅 i just realize there was an external email sent to my account during the testing phrase.
Verified answer

Expiscornovus 31,637 Most Valuable Professional on at

Like (0)

Report

Re: Looking for a way to look up by key & value pair using Power Automate

Hi @Anonymous,

Did the Get Items actually return any items? The apply to each skipped the Create a work item action, which suggests your value property is empty ( aka [] ).

Can you double check the Get Items outputs section?