Power Platform Community Forum Thread Details

Hi,

I have a approval model-driven app in which I have a sub-grid that references another table(Approval table) , The referencing column is the primary column of the main form of the app(eg. product ID),

Certain records are created in the sub-grid and by different users, The users select 2 columns in the Sub-grid table , one is the 'Stage of Approval'{1,2,3} and the other is the 'Status of the Approval{Approve,Reject,Re-work}'.

Now, I have a BPF having 5 stages , I want to send emails to different users based on the stages of the BPF ,

1) On the 1st stage of BPF - I want to send the email with the 2 column values of the sub-grid table like this

Stage of Approval - 1

Status of Approval - Approve/Reject/Rework

1) On the 2st stage of BPF - I want to send the email with the 2 column values of the sub-grid table like this

Stage of Approval - 2

Status of Approval - Approve/Reject/Rework

1) On the 3st stage of BPF - I want to send the email with the 2 column values of the sub-grid table like this

Stage of Approval - 3

Status of Approval - Approve/Reject/Rework,

Please tell me how to send the email on the next stage of BPF based on the input of the sub-grid made by the user made at previous stage in the sub-grid.

[ I know how to extract all the responses made for a particular product ID in the sub-grid table but I don't want all the responses , rather only the required responses based on the above mentioned scenario]

Your response will be Highly appreciated and help me and any other facing the same issue .

Categories:

Building Power Apps