Power Platform Community Forum Thread Details

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)