How to sync toggle

(0) Share

Report

Posted on by KK76875875

105

Hello community!
Any ideas how to synchronize toggle in a canvas app with SharePoint choice column (true/false)?

So when it's true in SharePoint list toggle is on, when it's false in SP list it's off.~
Column might be specific.

Any ideas?

If(LookUp(ListName,Title="UCC" && ForceClosed.Value="true"), Set(locToggleValue, false),Set(locToggleValue, true))

I tried this one but my first part of the formula doesn't work, Invalid argument type (record) expecting Boolean. I guess I'm missing synaxis somewhere true/false.
locToggleValue is on select for my toggle
Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hey @KK76875875

This should help, you can refer to the column directly for boolean yes/no when doing lookups like this:

If( //if set to true on the list for that lookup LookUp(ListName,Title="UCC").ForceClosed, //then set to true via variable Set(locToggleValue, true), //otherwise its false on the list and should be false here Set(locToggleValue, false) )

Cheers,

Sancho

Was this reply helpful? Yes No
KK76875875 105 on at

Like
a
(1)

Report
Copy link

Link copied!

Greetings Sancho @iAm_ManCat
Thanks for your reply!

It still gives me the same error 😞

I think the problem is in ForceClosed column, do we need to specify true/false choice somehow?

Was this reply helpful? Yes No
iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Ah, you have a choice column, not a boolean yes/no column!

So your Default property of the toggle will be:

LookUp(ListName,Title="UCC").ForceClosed="true"

Then your OnSelect, you should be patching the list directly, although I see you have a popup there - does the popup change the value on the list?

Was this reply helpful? Yes No
KK76875875 105 on at

Like
a
(1)

Report
Copy link

Link copied!

It's slightly different:
If(
//if set to true on the list for that lookup
LookUp(ListName,Title="UCC").ForceClosed.Value="true",
//then set to true via variable
Set(locToggleValue, false),
//otherwise its false on the list and should be false here
Set(locToggleValue, true)
);

You still need a .Value
I need to learn PowerFX 🙂
Thanks for your help Sancho , I appreciate that!

Was this reply helpful? Yes No