web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Autofill SharePoint li...
Power Automate
Answered

Autofill SharePoint list cell with data from another list

(0) ShareShare
ReportReport
Posted on by 11

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:
I have the same question (0)
  • Verified answer
    hhh312 Profile Picture
    11 on at

    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. 

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 67

#2
David_MA Profile Picture

David_MA 64 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 39 Most Valuable Professional

Last 30 days Overall leaderboard