web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to add a row in Da...
Power Automate
Unanswered

How to add a row in Dataverse Project Tasks using a flow

(0) ShareShare
ReportReport
Posted on by 2

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.

 

Flow.PNG

Flow error.PNG

Categories:
I have the same question (0)
  • Linn Zaw Win Profile Picture
    2,996 on at

    @DiegoMoura1 

    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://learn.microsoft.com/en-us/dynamics365/project-operations/project-management/scheduling-apis-powerautomate

    https://learn.microsoft.com/en-us/dynamics365/project-operations/project-management/schedule-api-preview

    https://crmchap.co.uk/whats-the-deal-with-schedule-api-dynamics-365-project-operations/

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 785

#2
Valantis Profile Picture

Valantis 669

#3
Haque Profile Picture

Haque 563

Last 30 days Overall leaderboard