
Hi, I'm creating a flow (using Power Automate) to automatically add a new row in Dataverse Project Tasks table from an Excelsheet.
The new tasks created on the Project Tasks table should appear on my Project for the Web schedule.
I've created my flow, but it doesn't work. Could someone check what is wrong with my flow? See the flow and error message.
Thank you.
If I am not wrong, the prefix for setting the lookup value is the slash character '/' and not the backslash as in your screenshot. Actually, the slash character is optional and you don't just remove it completely.
e.g. msdyn_project(«Project GUID»)
For Project and Project Bucket, those are lookup columns and you need to provide the GUID of those records and name.
e.g. msdyn_project(b2a1f08d-5034-429f-9beb-8f165a60b030)
Project Task Name is a text column, so you don't need \msdyn_subject( )
Just Task Name is good enough.
I have never tried building cloud flows for Project Operations but as far as I understand, you cannot create the Scheduling Tables (Project Task, Project Team Member, etc.) directly by calling Dataverse CRUD methods. In that case, you will have to call msdyn_PssCreateV1 from Schedule API with Perform Unbound Action in that case.
Please refer to the following MS Docs and blog articles
https://crmchap.co.uk/whats-the-deal-with-schedule-api-dynamics-365-project-operations/