cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hhh312
New Member

Autofill SharePoint list cell with data from another list

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.

1 ACCEPTED SOLUTION

Accepted Solutions
hhh312
New Member

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. 

View solution in original post

1 REPLY 1
hhh312
New Member

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. 

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (3,072)