FLOW Question : how to Copy value from choice field into another field in the same record

[ReflexBSC]

In Sharepoint Online - I have a simple list with 2 choice columns to select certain values.

So Title is filled out, then Choice 1 = "TBD" and Choice 2 = "2. Scheduled"

I need these values to then be copied into other fields called "Auditor" and "Status" in that same / current record.

I'm using the Sharepoint Connector "When Item is created or modified"

Problem 1: In update Field "Auditor" i select "Choice 1" field. After saving this - the value changes itself to "Auditor"...

Problem 2: The Flow keeps looping and making many "runs" before stopping despite i use "Terminate : Succeeded" action

Any ideas? 

It works perfectly find when using Sharepoint Designer - but thought i should start to learn Flow as well...

[v-xida-msft]

Hi @ReflexBSC,

Could you please share a screenshot of your flow’s configuration?

For your first question, please check if you have selected proper choice filed value.

For your second question, I think there is something issue with your “When an item is created or modified” trigger. When you add an item in SharePoint, the flow is triggered. Then you add a “Update item” action, then the flow will be triggered again. The flow falls in a “Update” loop. Please consider switch the trigger to “When an item is created”. I have made a test on my side and the flow works well:

Within Condition box, type the following formula:

@and(equals(triggerBody()?['Auditor'], triggerBody()?['Choice_x0020_1']?['Value']),equals(triggerBody()?['Status'], triggerBody()?['Choice_x0020_2']?['Value']))

Best regards,

Kris

[ReflexBSC]

Here is my Flow.

As you will notice - originally was not using any conditions at this point (because i don't have to do any conditions in sharepoint designer to update an item, when the record is created or modified).

So i'm starting to think that there has been an oversight in developing FLOW.

If i'm picking "when an item is created or modified" isn't that my trigger/condition?

Step 2 is : what should be done...

Step 3 is : workflow completed and should terminate.

In any case - I updated the condition per your suggestion with the right values but it still loops because the condition is not met.

So i've tried these two formula's. The actual choice field in sharepoint is just "Auditor Select" and copied into "Auditor"

Same for "Audit Status Select" into "Audit Status".

FLOW seems to thing this condition is not met.... and continues looping.

Much appreciate your help to resolve this. It seem pretty complex for a simple task - don't you agree?

@and(equals(triggerBody()?['Auditor'], triggerBody()?['Auditor_x0020_Select']?['Value']),equals(triggerBody()?['Audit_x0020_Status'], triggerBody()?['Audit_x0020_Status_x0020_Select']?['Value']))

@and(equals(triggerBody()?['Auditor'], triggerBody()?['Auditor_x0020_Select_x0020_Value']?['Value']),equals(triggerBody()?['Audit_x0020_Status'], triggerBody()?['Audit_x0020_Status_x0020_Select_x0020_Value']?['Value']))

Here is the Flow after i updated it with your suggestions: