cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Black7830
Advocate I
Advocate 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
v-yuazh-msft
Community Support
Community Support

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

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?

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 

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.

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/

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
Community Support
Community Support

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

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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (2,364)