web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Looking for a way to l...
Power Automate
Unanswered

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

(0) ShareShare
ReportReport
Posted on by

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.

jeffpham_9_0-1690791351254.png

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

Office LocationTeam member
Office 1member1@xyz.com
Office 2member2@xyz.com

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

jeffpham_9_1-1690791600253.png

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

jeffpham_9_2-1690791679335.png

this is a result

jeffpham_9_3-1690791846602.png

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 ! 

 

Categories:
I have the same question (0)
  • Verified answer
    Expiscornovus Profile Picture
    33,189 Most Valuable Professional on at

    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?

  • Community Power Platform Member Profile Picture
    on at

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard