Autofill SharePoint list cell with data from another list

[hhh312]

Hello,

I'm a newbie to PowerAutomate and have searched for solutions to no avail... Hoping you smarties can help (in beginner friendly language). I want to auto-populate a field in one list from data in another list. Here's my setup and desired flow.

LIST 1: Captures questions from form submissions. There are columns for the 'Question Category' and for an 'Assigned SME' (the subject matter expert who will answer the question)

LIST 2: Is a contact list that outlines 'Question Category' and the name of the person who is assigned to answer that question category (under column 'Primary SME')

I would like to create a workflow that does the following:

• When a new item/submission is created in LIST 1...
• Read the 'Question Category' value in LIST 1, then...
• Match that value to the 'Question Category' in LIST 2, and...
• Read the corresponding 'Primary SME' name/value from LIST 2, and...
• Input that value in the "Assigned SME" cell back in LIST 1.

Thank you for any assistance you can provide.

[hhh312 · Accepted solution]

Never mind! I finally figured out on my own. Thank you, anyway, for this site.

I don't see a way to delete my post, so I'm posting my solution.

My solution was to click "Condition" as the next step and not "Apply to each" (which is auto-added); then to be super careful on how I populated the variables from the Dynamic Content lists.