changing a yes/no switch back to yes consistenly

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hey there,

i have a list where each item has a yes/no field. im trying to change the yes/no value to yes when i press a button.

i did this using this code:

Patch(werkplekken, LookUp(werkplekken, BUREAU = bureau_Details.Text), { BESCHIKBAAR: 1 } );

this works, sorta.. for some reason if i do this on 2 records sometimes it sets both on available, sometimes it sets 1 to available but keeps the other unavailable and sometimes it doesnt change either.

is there a different way to do this consistently?

please let me know if u need more info, thanks in advance 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,117 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Try

UpdateIf( werkplekken, BUREAU = bureau_Details.Text, {BESCHIKBAAR: true} )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @WarrenBelz,

Sorry for the late reply.
I tried this and unfortunately it didn't work 😕

Hope to hear from you, thanks!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Some more info in case you need it,
the field info im trying to change:
I also tried using 1 instead of true and this unfortunately also didn't work

i also checked if the variable actually has info in it and it does,

for more context, i have a app with which you can "claim" a workspot at the office, im working on the ability to delete ur reservation by clicking on a button in the details page

Was this reply helpful? Yes No
WarrenBelz 156,117 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous ,

I cannot see your data, but that is a very simple update formula and should work if the filter

BUREAU = bureau_Details.Text,

is valid and

BESCHIKBAAR:

is a Yes/No field. Can you check this please.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

hey @WarrenBelz,

I found out last night my problem is a lot more complicated so I will have to make a new ticket for that, but i did your suggestions and after rechecking the field as yes/no the last formula u send worked, so thank you. i will mark it as the solution.

Was this reply helpful? Yes No