Power Platform Community Forum Thread Details

I have a model driven App for Approvals where I have 3 tabs (1 main form, 1 timeline , 1 Approval table Grid).

Now I have made a Power automate Flow that Sends emails to different users at various stages of a BPF.

The emails also contain Approver Name and Approver Comments which are made for the Same Record having the primary key of the main form as the way of mapping the Approval action and That are filled by 3 approvers by Making 3 different records in the 'Approval Tab's Grid (Made on the Approval Table)'.

Now I am able to Extract The Approval Name and Comments if a record is made by the Approver in the Approval Table in my Power automate flow by having 'List Rows' on the Approval Table(having Primary key of main form as Filter) and initializing a Variable as 'Approval Action' and setting its initial value as -

1) Approver Name - @{outputs('List_rows_(_Approval_Table)')?['body/value'][0]['_approvername_value@OData.Community.Display.V1.FormattedValue']}
2) Comments - @{outputs('List_rows_(_Approval_Table)')?['body/value'][0]['approvercomments']}

{extracted Using Dataverse Rest Builder}

The problem now is that the Flow only works if the records are created in the Approval table and when a new record is created the flow crashes showing that the Variable initialization error as the variable is fetching an empty string.

If I initialize any random string in the Variable then it only prints that string in the Email and not the Approver Name and Comments.

How to solve this error/situation ,

Kindly Someone Help,

your reply will be highly appreciated.

Categories:

Building flows