Skip to main content

Notifications

Community site session details

Community site session details

Session Id : aiVWlpy6w1tyQu3nWjN2vM
Power Automate - Building Flows
Answered

Connecting Project Roadmap to MS Planner

Like (0) ShareShare
ReportReport
Posted on 17 Oct 2020 19:26:56 by

Creating a flow that will capture any tasks created in MS Planner to be captured in Project Roadmap. Halfway through the flow and getting the following error:

 

ExpressionEvaluationFailed. The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@outputs('List_records')?['body/value']' is of type 'Null'. The result must be a valid array.

 

Looking further into this I found the following:

Principal user (Id=88c2effb-030b-ea11-a811-000d3a5694eb, type=8, roleCount=4, privilegeCount=925, accessMode=0), is missing prvReadmsdyn_roadmap privilege (Id=c87433a4-9005-4a7b-98ad-f89c54f8f8f0) on OTC=10028 for entity 'msdyn_roadmap'. context.Caller=88c2effb-030b-ea11-a811-000d3a5694eb. Or identityUser.SystemUserId=12171f97-5c72-43a6-8853-442ab6a482bb, identityUser.Privileges.Count=3334, identityUser.Roles.Count=0 is missing prvReadmsdyn_roadmap privilege (Id=c87433a4-9005-4a7b-98ad-f89c54f8f8f0) on OTC=10028 for entity 'msdyn_roadmap'.

  • pjaws25 Profile Picture
    4 on 19 Mar 2021 at 20:27:47
    Re: Connecting Project Roadmap to MS Planner

    Hi @Anton9255 - Would you mind sharing a template of the flow you created. I also want to link planner to roadmap, but I have been really struggling.

  • v-alzhan-msft Profile Picture
    on 29 Oct 2020 at 04:18:17
    Re: Connecting Project Roadmap to MS Planner

    Hi @Anton9255 ,

     

    Have your issue been solved according to @ChrisPiasecki  'solution?

    If yes, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

     

    Best Regards,

    Alice

     

    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Verified answer
    ChrisPiasecki Profile Picture
    6,389 Most Valuable Professional on 18 Oct 2020 at 04:54:30
    Re: Connecting Project Roadmap to MS Planner

    Hi @Anton9255,

    Looks like a CDS permission issue. You don't have privileges to the Roadmap entity.

    My guess is that you don't have the correct licensing.

    Having just the Project Plan 3 or 5 does not provide entitlements to build standalone Power Apps or Power Automate against Project for Web data that sits in Common Data Service. 

    You'll need a Power Automate license in this scenario if you don't already have. 

    You'll also want to confirm that you have a CDS security role that has read/write permissions to the appropriate Roadmap and related entities. 

     https://docs.microsoft.com/en-us/office365/servicedescriptions/project-online-service-description/project-online-service-description#feature-availability-across-applications-and-subscriptions

    ---

    Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,745 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard
Loading started