Use Power Automate to add Assigned To to Task in P4W based on Roll

[jlynch92009]

I have a plan to assign the assigned to field in a task in Project for the Web based on the roll (a custom field I plan for the task list). However, in dataverse when you update a row in tasks, there is no field for Assigned To.  In fact there is no field for Assigned to in the table in Power Apps either.  How does the user get associated with the task in Project for the Web?

[rampprakash]

Hello @jlynch92009,

Try Searching Owner Field instead of Assigned to. Because when you set Owner Field with Update automatically the record will be Associated to the Assignee.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

[jlynch92009]

when I look in "Project task" table, I see Owner, but that data does not match with the assigned to person on the task.  I also looked at the related table "Owning User" but again, there is no correlation between that and assigned to in Project for the Web.  Does anyone know which table contains the Assigned To user?

[rampprakash]

Hello @jlynch92009,

Can you please share me the screenshot from DataVerse which field you are referring.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA

Blog : https://microsoftcrmtechie.blogspot.com

[jlynch92009 · Accepted solution]

when you look in the Project Tasks table there is no value that matches the assigned to value, there is no field for it and when I use power automate to "get rows" on the Project Tasks table there is no matching values.

What I have found is the Bookable Resources Table and the Resource Assignment Table, the Resource Assignment table holds the assigned to person.  Now it's a matter of figuring out which ID is needed to use Power Automate to create the Resource Assignment.