How to update the status in dataverse table

[Priyanka03]

Hi,

I'm looking for help on below post which its been a week ago but none of them were not responded. 

Please help me the logic on below post. 

Send To                                                          Received From           Status

CSE(Tom@gmail.com,John@gmail.com)  CSE(Tom@gmail.com)   Completed

1) Send To and Received from is never gonna equal to but not sure how to change the status is completed.

2) If i get 1 response from CSE dept then i need to change the status is completed.

https://powerusers.microsoft.com/t5/Building-Flows/How-to-Check-the-Condition-for-updating-the-statu...

Thanks,

Asha

[SudeepGhatakNZ]

@Priyanka03 ,

Please share a screenshot of your flow.

[Priyanka03]

join(createArray(variables('VarApproverReceivedFrom')),',')

My Data verse table

I would like to change the record status column is completed if i get the approvers from 2 department;

Here in LOB and marketing analytics is 2 department.

Kindly help me how to do this.

[Priyanka03]

@SudeepGhatakNZ 

I shared the screenshot of flow.

The context of the scenario is " i have the send to column has the separated with comma and semicolon" If it has the semicolon the flow has to be expected the approver from only 1 person and don't want to wait for other person to response back. if its comma then we need to get approver from all of them.

Eg: 

CSE(asha@gmail.com;tom@gmail.com),IT(test@yahoo.com),Finance(john@microsoft.com;sharon@microsoft.com)

So here i have mix up with semicolon and comma the mandatory approver is IT team has only one approver

Rest of 2 department CSE and Finance has to get one response from any one as its separated with semicolon.

I'm not able to figure it out the solution for updating the status column is completed. How to identfy that i could received the emails and changing the status. 

Thanks,

Asha

[SudeepGhatakNZ]

@Priyanka03 ,

If I were you this is how I would implement it.

1. Use the split operator to break the string into individual departments and use a switch case on each of the departments

1. I would then use a conditional action to use either of the two approval actions

1. The other option is to use separate HTTP-triggered approval flows that could act as your child flows, but that would be going down the complicated path

[Priyanka03]

@SudeepGhatakNZ 

Thank you for response.

I understand your approach .

I'm using the trigger of when an email arrives inbox to shared mailbox to tracking the approval emails with appropriate subject and body keyword. Also i would like to save the respective emails from that person for audit purpose.  so start and wait action is doesn't work.