cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jlynch92009
Frequent Visitor

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions
jlynch92009
Frequent Visitor

assignedto.PNG

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.

View solution in original post

4 REPLIES 4
rampprakash
Community Champion
Community Champion

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
Frequent Visitor

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
Community Champion
Community Champion

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
Frequent Visitor

assignedto.PNG

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.

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (1,585)