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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Retrieve specific valu...
Power Automate
Unanswered

Retrieve specific value from one Sharepoint list and pass it to the column on another list

(0) ShareShare
ReportReport
Posted on by

Hi all,

 

I was wondering is there a solution to this: I created two Sharepoint lists, first list contains this columns: Type of Doc, Price < 300, Price 300-500, Price 500-1000. Second list contains The same Type of Doc, Choice Column with the the same prices, Approval Person(More than 1). My flow needs to work like this: When the new item is created(Type Of Document and The price is passed) algorithm have to compare these values on the second list and Update Approval Person of the Item to the column on the first list.

 

Capture.PNG

Categories:
I have the same question (0)
  • PrasadAthalye Profile Picture
    on at
    Re: Retrieve specific value from one Sharepoint list and pass it to the column on another list

    I think you can build flow something like below..

     

    • Add GetItems action after trigger on 2nd List.
    • Apply filter on type of document. 
    • Declare a string variable to hold approver emails.
    • Then loop through the items and add a switch on price from first list i.e. trigger.
    • Then on the conditions add, second list columns. If they match, map approver name to string variable using Append to string variable option.

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 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard