Skip to main content

Notifications

Power Automate - Building Flows
Answered

CDS Approvals and Approval Requests

Posted on by 186

Hi everyone

 

My goal is to send an reminder email, every day at 8AM, to approvers who have outstanding approvals.

 

I am using the modern approval CDS approach, where the first flow creates the approval and writes it to the Common Data Service. The second flow kicks in when the statuscode in the Approvals entity changes (i.e. the approval has been actioned).

 

My first approach was to filter the Approvals entity by records that have a blank Outcome. This returns the correct records.

 

202002061350256lukask.png

 

Unfortunately, the owner of the record is the requestor and not the approver. I then went to the Approval Requests entity, where the owner of the record was the assignee.

 

My knowledge about CDS entities and the logic behind them stops here.

 

First, the records in Approvals and Approval Requests are not synchronised. I have a handful of active approvals in Approvals, but there are hundreds in Approval Requests. How come there are records that have been marked as inactive in Approvals but they remain active in Approval Requests? Is this intended?

 

Second, how do I use the Update a Record action to get the correct record from Approval Requests? When I use the Approval Id as the unique id, it can't find anything. Is my only option to return the whole list and then filter by Approval Id Index?

 

Thank you for your help!

  • Verified answer
    rimatos Profile Picture
    rimatos on at
    Re: CDS Approvals and Approval Requests

    Hi @LKS ,

     

    In terms of the difference between the number of records from the Approvals and Approval Request, this can be due to the fact that a single Approval might need more than one person to approve the request in order for the Approval to be succeeded.

     

    As for the second question, in order to update a specific record you should be able to do it by referencing the Approval ID, to specify which record you intend to Update.

     

    Could you show a print of how you are performing this action in the connector?

     

    Regards,

    Ricardo

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

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 142,473

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,659

Leaderboard