Scenario:
I have 2 existing lists, SourceList and TargetList, using PowerAutomate, how can I manage to pull data from the SourceList when a new item is created in the TargetList.
- The output I'm trying to achieve is similar to a vlookup function of excel.
- In TargetList, I have a column with choices, and based on the value of this column I would like PowerAutomate to get items from the SourceList and update another column in the TargetList.
SourceList Columns:
| SourceCategory | TestData1 | TestData2 |
| CategoryData1 | Data1Value | Data2Value |
TargetList Columns:
| TargetCategory | TestData1 |
TestData2 |
| CategoryData1 | (I want this to be filled automatically, if the TargetCategory value, submitted by the user, matches with the SourceCategory value) | (I want this to be filled automatically, if the TargetCategory value, submitted by the user, matches with the SourceCategory value) |
Would appreciate any help!


Report
All responses (
Answers (