cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Kudo Collector
Kudo Collector

How can i retrieve the individual COMMENTs of the APPROVERS in the Modern Approvals template

How can i retrieve the individual COMMENTs of the APPROVERS in the Modern Approvals template.

Currently, details such as below are retrievable as dynamic content

Approver: 

Response: Approved

Request Date: Friday, February 23, 2018 3:05:35 AM

Response Date: Friday, February 23, 2018 3:19:18 AM

 

But the Comments of the approvers is lost ?

It is only available in the OUTPUTS BODY of  the Approvals 

as 

"responder": {
        "id""36b57607-4b4b-4220-9fdd-f606ab78ef71",
        "displayName""Pagulayan, Cat",
        "email""Cat.Pagulayan@unilever.com",
        "tenantId""f66fae02-5d36-495b-bfe0-78a6ff9f8e6e",
        "userPrincipalName""Cat.Pagulayan@unilever.com"
      },
      "requestDate""2018-02-23T03:05:35.7924714Z",
      "responseDate""2018-02-23T03:07:42.1835463Z",
      "approverResponse""Approve",
      "comments""Approviiiinngg!! :)"

 

I need to be able to store the individual comments 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Power Participant
Power Participant

Re: How can i retrieve the individual COMMENTs of the APPROVERS in the Modern Approvals template

Hi @JenVitug,

 

I used loop throught all responses and then I'm cehcking if comment is not empty and then working with variables to add comment of each approvar name and date of comment.

 

CommentsInApproval.PNG

 

In condition there is expression:

@empty(items('Add_to_string_variable_value_of_comment')?['comments'])

 

Then the variable is loaded with this expression:

concat(items('Add_to_string_variable_value_of_comment')?['responder']?['displayName'],' - ',utcNow('MM/dd/yyyy hh:mm:ss'),': ',items('Add_to_string_variable_value_of_comment')?['comments'],';')

As I need to format it and add it to SharePoint column.

 

Hope this will help you.

P.

 

 

 

 

View solution in original post

2 REPLIES 2
Highlighted
Power Participant
Power Participant

Re: How can i retrieve the individual COMMENTs of the APPROVERS in the Modern Approvals template

Hi @JenVitug,

 

I used loop throught all responses and then I'm cehcking if comment is not empty and then working with variables to add comment of each approvar name and date of comment.

 

CommentsInApproval.PNG

 

In condition there is expression:

@empty(items('Add_to_string_variable_value_of_comment')?['comments'])

 

Then the variable is loaded with this expression:

concat(items('Add_to_string_variable_value_of_comment')?['responder']?['displayName'],' - ',utcNow('MM/dd/yyyy hh:mm:ss'),': ',items('Add_to_string_variable_value_of_comment')?['comments'],';')

As I need to format it and add it to SharePoint column.

 

Hope this will help you.

P.

 

 

 

 

View solution in original post

Highlighted
Kudo Collector
Kudo Collector

Re: How can i retrieve the individual COMMENTs of the APPROVERS in the Modern Approvals template

@vecerpa

 

Thank you so much, i'm new to this Variable thing in Flow, i'll try to "copy / mimic"  your steps (even the scripts)  and try to make it work in my flow app 😉  

Helpful resources

Announcements
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Users online (6,253)