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

5 REPLIES 5
rampprakash
Super User
Super User

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
Super User
Super User

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.

ps6000
New Member

Did you end up finding the right table and field?  I am unable to find the right one.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (1,628)