Power Platform Community Forum Thread Details

I have 2 SharePoint lists, list 1 has 2 Choice columns called part1 and name1 list 2 has 2 single line of text columns (can be switched to choice if it makes it easier) part2 and name2. List 2 has all possible records with both columns filled in already. list 1 will be entered by users and they will only be filling in part1 and leaving name1 blank. i want to when an item is created in list 1 look up the value in part1 that the user entered in part2 and fill in name1 based on the value in name2. below is a visualization of what type of flow i need. when user creates item in list1 they will only be entering value in part1 i want the flow to run automatically and look up part1 in part2 and return corresponding value in name2 and update name1 with that value. Additionally both columns in List1 are type Choice and both columns in List2 are type Single line of text but can be changed to Choice

List1		List2
part1	name1	part2	name2
5		1	Blue
		2	Red
		3	Pink
		4	Purple
		5	Yellow
		6	Orange
		7	Black

Categories:

Building flows

@PR-10121935-0

Hello! If both lists are on the same SharePoint site, you can avoid using the Power Automate flow. I will show you both options.

Lookup columns

I have a 'List2' as in your sample.

In 'List1,' I created a lookup column named 'Part1' and referring to the 'Part2' column in the 'List2.' Also, I selected the 'Name2' column as additional.

Thus, the 'Name1' column will be filled automatically on filling the 'Part1.'

Power Automate flow

The 'Part1' and 'Name1' columns are choice ones.

The flow starts on the item creation in the 'List1.'

Get items form the 'List2' filtering them by the value from 'Part1' in the 'Part2' column. If values are unique in that column, it will return an array with just one item.

Finally, update the newly created item in the 'List1' using the value from the 'Name2' column. It will put the action into an 'Apply to each' control automatically but there will be just one iteration as there is just one retrieved item on the previous step.