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 / Automatically assignin...
Power Automate
Answered

Automatically assigning a user to a new item created in a SharePoint list based on another SharePoint list

(1) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello -

 

My goal is to auto-assign a user in a SharePoint list based on an assignment matrix from another SharePoint list. In the screenshot below you will see that I have one list Task Tracker Assignment and the Task Tracker list itself.

 

epannell3223_0-1705594223756.png

 

 

  1. When a new item is created, I would like Power Automate to match the RAU# in the new task request list with the owner of that RAU in the assignment list.
  2. When there is a match update that owners name in the Task Request list as the owner of that item.
Categories:
I have the same question (4)
  • Verified answer
    trice602 Profile Picture
    16,021 Super User 2026 Season 1 on at

    Hi @epannell3223 ,

     

    To auto-assign based on your requirements, you will need the following:

     

    A Get Items action from the assignment list and filter by your RAU.  One way you can do this by first creating the item in your task list first, then capture the RAU for your filter.  Your process may be slightly different but haven't seen your flow.  If you already have the RAU for the task (as dynamic content), then your filter would be:

     

    RAU eq 'dynamic_content'  -- remember this is inside apostrophes.

     

    This is going to give you the row from the assigned list and this will give you access the dynamic content of the assignee.

     

    Once you have the dynamic content of the assignee, you use that dynamic content to assign in your task.

     

    As mentioned above, you can either create the task with the assignee, or if the task is already created, you can update an item with the assignee.

     

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thank you, it worked exactly the way you spelled it out. Really appreciate it.

  • trice602 Profile Picture
    16,021 Super User 2026 Season 1 on at

    Hi @epannell3223 ,

     

    Always great to hear!  

     

     

  • tor Profile Picture
    2 on at
    Hi, do you have screenshots of how you got this to work?

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
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard