cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

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

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:

1.png

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

 2.png

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

 3.png

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:

 4.png

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

5.png

The flow would run successfully as below:

6.png

 

And the item would be updated as below:

 7.png

 

 

Regards,
Alice Zhang

View solution in original post

7 REPLIES 7
Highlighted

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

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?

Highlighted
Helper I
Helper I

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

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 

Highlighted

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

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.

Highlighted

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

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/

Highlighted
Helper I
Helper I

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

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

 

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

 

Highlighted
Community Support
Community Support

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

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:

1.png

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

 2.png

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

 3.png

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:

 4.png

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

5.png

The flow would run successfully as below:

6.png

 

And the item would be updated as below:

 7.png

 

 

Regards,
Alice Zhang

View solution in original post

Highlighted
Helper I
Helper I

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

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.

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (7,913)