Unanswered

Update Row Returned by Dataverse Trigger When Row is added, modified or deleted (Project for the Web Project Task)

(0) Share

Report

Posted on by PSTYO

I want to assign a project task to the Completed bucket when the progress is set to 100% using Power Automate. I got all the steps done, but I am stuck with the last step which uses the Update a row (Dataverse) action. The action requires the unique row id of the project task, but I have no idea how to get the row ID. I did try triggerBody()?['msdyn_projecttaskid'], but this results in the following error: URL was not parsed due to an ODataUnrecognizedPathException. Resource not found for the segment provided in the URL. (triggerBody()?['msdyn_projecttaskid'] did result in a GUID to be used in the action; I guess not the correct one).

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @PSTYO

You need to pass the unique identifier from the trigger action in "Update a row" action. The unique identifier display name will be the same name as that of table. Here is an example of 'Account' table:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
PSTYO 2 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the response. I did pass the correct row ID to the Update a row action. The problem was with the value of the field (Project Bucket) I was trying to update. I was passing the corrent GUID of the project bucket. However, it was expecting the OData ID of the project bucket. This is an URL. After passing the OData ID, the error I had went away. I got a new error which I probably never will be able to resolve 😥 Action 'Update_Project_Task' failed: We’re sorry. You cannot directly do 'Update' operation to 'msdyn_projecttask'. Try editing it through the Resource editing UI via Project. I suspect the Project for the Web Dataverse tables cannot be updated using Power Automate.

Was this reply helpful? Yes No