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

Notifications

Announcements

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

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 (3)
  • Verified answer
    trice602 Profile Picture
    15,404 Super User 2025 Season 2 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
    on at

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

  • trice602 Profile Picture
    15,404 Super User 2025 Season 2 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 519 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 296 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard