ApprovalRequestId finding it in the dynamic content

(0) Share

Report

Posted on by CU14071929-0

ApprovalRequestId can i find this in dynamic content?

Not approval id.....ApprovalRequestId

I know where to find this in the tables but i want it in the flow so that i can automatically write it to a sharepoint list.

Thank you

Categories:

Business Process Flows

I have the same question (0)

All responses (3)

Answers (0)

CU14071929-0 7 on at

Like (0)

Report

ApprovalRequestId finding it in the dynamic content

i have completed the test but when i put the approvalID into the dataverse table at get a different answer. Please see attached word documentation,.

thank you very much

problem.docx

Was this reply helpful? Yes No
Suggested answer

chiaraalina 445 on at

Like (1)

Report

ApprovalRequestId finding it in the dynamic content

Hi @CU14071929-0

As already mentioned, no, “Start and wait for an approval” doesn’t expose ApprovalRequestId in dynamic content.

To get it, you can try to query Dataverse’s Approval Requests table (filter by the parent Approval ID).

Use Dataverse → List rows on Approval Requests with an OData filter like:

_msdyn_flow_approvalrequest_approval_value eq @{outputs('Start_and_wait_for_an_approval')?['body/name']}

Then take:

@{first(body('List_rows')?['value'])?['msdyn_flow_approvalrequestid']}

Let me know if it worked!

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

UshaJyothiKasibhotla 114 Moderator on at

Like (0)

Report

ApprovalRequestId finding it in the dynamic content

Hi @CU14071929-0

No, you won’t find ApprovalRequestId in normal dynamic content of “Start and wait for an approval.”You will find it in the “When an approval response is completed” trigger, or by querying the Dataverse Approval Request / Approval Response tables.

Hope this helps,

Usha Jyothi

1 people found this reply helpful.

Was this reply helpful? Yes No