Answered

Autofill SharePoint list cell with data from another list

(0) Share

Report

Posted on by 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.

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

hhh312 11 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@hhh312
Hi, I am having the same trouble right now, could you please kindly post your steps so that we can see how you solved it. I am also a newbie and would appreciate the help! thanks!

Was this reply helpful? Yes No