Skip to main content

Notifications

Community site session details

Community site session details

Session Id : y8EgXEDw9xLcK5ckP3KhVn
Power Automate - Building Flows
Answered

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

Like (1) ShareShare
ReportReport
Posted on 18 Jan 2024 16:11:21 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.
  • tor Profile Picture
    2 on 07 Nov 2024 at 15:23:05
    Automatically assigning a user to a new item created in a SharePoint list based on another SharePoint list
    Hi, do you have screenshots of how you got this to work?
  • trice602 Profile Picture
    13,768 Super User 2025 Season 1 on 18 Jan 2024 at 18:04:16
    Re: Automatically assigning a user to a new item created in a SharePoint list based on another SharePoint list

    Hi @epannell3223 ,

     

    Always great to hear!  

     

     

  • Community Power Platform Member Profile Picture
    on 18 Jan 2024 at 17:39:12
    Re: Automatically assigning a user to a new item created in a SharePoint list based on another SharePoint list

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

  • Verified answer
    trice602 Profile Picture
    13,768 Super User 2025 Season 1 on 18 Jan 2024 at 16:30:50
    Re: Automatically assigning a user to a new item created in a SharePoint list based on another SharePoint list

    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.

     

     

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 66 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 65

#3
rzaneti Profile Picture

rzaneti 39 Super User 2025 Season 1

Overall leaderboard
Loading started