Prevent Yes/No column from being changed on ShaerPoint Online Update Item

[Black7830]

I have a YES/NO column on a list. When the user goes in a changes the value of Lookup Column, I have a "When an Item is Created or Modified Action" that gets the lookup column and based on a condition does several things.

The last thing I do is an "Update Item Action" where I want to update the item on the same list with the value I worked on.  All of that works well and good.

The problem I'm having is some of my list items are marked with the Value NO and the default for the YES/NO column is YES. The Update Item Action sets them to YES.

The YES/NO is a drop down list in the Update Item Action and I have tried setting it to blank to see if that would work.  But it did not.

Is there any way I can stop it from using the default YES or at least restore the orginial NO value if that is current value of the item?

Thanks,

Joe

[Pieter_Veenstra]

If the flow is triggered by the item then you could simply use the dynamic data from the trigger to set the value of the YES/NO field to whatever it was during the trigger.

Does that answer the question?

[Black7830]

Hi Pieter:

On the Update Item trigger you can't use Dynamic Content for True/False,Choice, or Lookup columns.  They are shown as drop down lists.

A work around I tried is to add more Conditions to cover each alternative, e.g. True, False etc.  but this adds a lot more work and complexity to each Flow.

It would be great if you could use Dynamic Content for these columns.

Thanks,

Joe 

[Pieter_Veenstra]

Hi @Black7830,

On the trigger you can't configure the filter directly. I've been using conditions/switches in a similar way as well. I would also like to see this trigger be extended so that you can see the current value and the previous value when items are updated.

[Pieter_Veenstra]

I have added some ideas on this community site to improve the triggers, where these ideas didn't exist already. You can find the overview here:

https://veenstra.me.uk/2018/02/28/microsoft-flow-sharepoint-triggers-and-their-limitations/

[Black7830]

I also added the Idea to provide Dynamic Content on the Update Item Trigger.

Add-Dynamic-Content-for-Yes-No-Choice-and-Lookup-Columns

[v-yuazh-msft · Accepted solution]

Hi @ Black7830,

Could you please share a screenshots of the configuration of your flow?

The reason of the “Update item” action would update the YES/NO column is that you have choose the “Yes” or “No”,or leave it blank in the drop down list.

I have made a test on my side, you could choose the “Enter custom value” in the drop down list of the YES/NO column as screenshots below:

Then you could choose the YES/NO dynamic content of the trigger in the drop down list of your YES/NO column as me.

 

I have made a test on my side, and I have created a sharepoint list as below:

 

The “Yes or No” column is a YES/NO type column, the default for the column is YES

The “repairshop” column is a Lookup type column.

The “repairshop owner” column is a Single line of text type column.

The screenshots of my flow as below:

 

When I create new item in the sharepoint list as below:

The flow would run successfully as below:

And the item would be updated as below:

 

Regards,
Alice Zhang

[Black7830]

Helllo Alice:

This works.  In my case there is a delayed showing of Dynamic Content when you pick Custom. I initially get the no Dynamic Content is available message for the YES/NO column.  I have had to leave the column and then come back to see it.  This could be a learning issue for those new to Flow, like me, and have delays for whatever reason.