Answered

Using a toggle

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I've started today with the powerapps, so maybe i'm missing something.

All i want is a toggle button that toggles the value of my field in excel. When i connect my colum that contains only true or false in plain text, the powerapps shows me a warning that it expects a true or false value. THis works though, it toggles the button if it's true.

But when i toggle the button from my preview or from my phone, it doesn't write back to excel.

Do i need to use the on change event to write the value back to excel, and if so how does that work?

Thanks for reading!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

hpkeong 2,944 on at

Like (1)

Report
Copy link

Link copied!

Hi

Please set:
- OnCheck with Patch function to save your intended results into the column
E. g. Patch(TableX, Defaults(TableX), ,{ColumnTitle : Toggle. Value})

Please try and check.

Hope this helps. Tq

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Thanks for your help!

Your function was quite close, i used the following on the " on check" :

Patch(Table1,First(Filter(Table1,ID=TB_ID.Text)),{ColumnTitle:"true"})

Also had to format the the column in excel as text otherwise it would regocnise it as a boolean TRUE. Now it also works with the bind to defaults(which doesn't work with a booleanTRUE/FALSE sadly)

Funny thing though, it doesn't work from my android phone

Edit: oh i had excel open, somehow it locks the file from writing then. after closing the powerapp writes to excel

Was this reply helpful? Yes No
hpkeong 2,944 on at

Like (2)

Report
Copy link

Link copied!

Hi

Excel is a container for data. When apps is executing, this must never be opened.
Otht, dropbox will create a conflict file and eventually, nothing will be patched.
Just sharing months of experience on this issue.

Happy apping.

Was this reply helpful? Yes No