How to update the status in dataverse table

(0) Share

Report

Posted on by 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-status-in-Dataverse/m-p/2073894#M229357

Thanks,

Asha

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@Priyanka03 ,

Please share a screenshot of your flow.

Was this reply helpful? Yes No
Priyanka03 2 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Priyanka03 2 on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Priyanka03 ,

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

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

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

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

Was this reply helpful? Yes No
Priyanka03 2 on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No