cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Black7830 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
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
Super User
Super User

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?

Black7830 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 

Super User
Super User

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.

Super User
Super User

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/

Black7830 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

 

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

Black7830 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

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

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!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (7,319)