Unanswered

Change Field Value depending on Condition Outcome - Flow

(0) Share

Report

Posted on by Marlon89

Hello!

I would like to add an action to the below flow whereby if the value of the Condition is 'Yes', in addition to sending out an Email, I would like to change the value of the field 'Progress' on the Sharepoint list item from 'Not Started' to 'In Progress'. I've tried using the action: 'Get changes for an item or a file(properties only)', but have had no luck

Flow Steps:

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (1)

Report

Re: Change Field Value depending on Condition Outcome - Flow

Hello @Marlon89 ,
you should use the SharePoint "Update item" action, specifying the ID got from the Trigger:

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.
BR,
Marco

Was this reply helpful? Yes No
Marlon89 41 on at

Like (0)

Report

Re: Change Field Value depending on Condition Outcome - Flow

Hi @MarconettiMarco

Many thanks for your reply!

I have tried including the Update Action Item under 'Condition' 'If Yes', however the value of the field is not changing if am approving the request.

Checked flow and this is the error

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Re: Change Field Value depending on Condition Outcome - Flow

Hi @Marlon89 ,

I can reproduce this issue, when there is a Choices column which allows multiple selections, it cannot be updated using the same value from the trigger directly. Please try below method:

So, you can use a Select Control to generate a single column array to store all the choices values, and use this array to populate the field in Update item action. Each multiple selections Choices column needs a Select Control.

Best regards,

Was this reply helpful? Yes No
Marlon89 41 on at

Like (0)

Report

Re: Change Field Value depending on Condition Outcome - Flow

Hi @v-jefferni ,

Thanks for the above. The flow is failing because of the following error:

BadRequest. The 'from' property value in the 'select' action inputs is of type 'Object'. The value must be an array.

Inputs:

{
    "from": {
        "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
        "Id": 0,
        "Value": "Not started"
    }
}

Just to note, I have tried including the Value of the Field 'Progress'. This is a 'triggerOutputs()'. I believe this error is because the trigger output is referencing an object, and not the item array

Flow after Condition of Outcome is 'Approved':

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Re: Change Field Value depending on Condition Outcome - Flow

Hi @Marlon89 ,

I was mentioning the allow multiple selections Choices column, which in your case is the Internal column. Progress column should be a single selection Choice column, so it can be populated from dynamic contents directly. Besides, if the column values do not need to update, you can leave the input areas blank unless it's required. The Update item action will ONLY update the fields that have values in the action.

Best regards,

Was this reply helpful? Yes No
Verified answer

Marlon89 41 on at

Like (0)

Report

Re: Change Field Value depending on Condition Outcome - Flow

Hi,

Issue resolved. The prevalent error was the following:

"the 'inputs.parameters' of workflow operation 'update_item_2' of type 'openapiconnection' is not valid. error details: the api operation does not allow writing a value for parameter 'item/assignedto[0]/displayname'. this parameter is read only."

One work around was to change this List Item Field from Mandatory to Optional, therefore I did not need to reference it in the 'Update Item' Section and the flow was able to run successfully. The dynamic fields containing 'Yes/No' Options were successfully changed depending out the outcomes mentioned within 'Update Item'

Was this reply helpful? Yes No