Possible to convert toggle boolean values into string?

(1) Share

Report

Posted on by Applicable88

254

Hello,

is there a way to convert the output of a toggle from Values into Text?

Its a column with only two options, like Yes and No.

Since I need a delegatable column I chosed a plain text column. That column I want to check as a composite key for duplicates. A toggle is seemingly always If ( IsBlank(Lookup(Table; YESNOColumn= Toggle.Value. , but for look up to work I need it to be like

Toggle.Text.

The alternative would be a dropdown menu instead of toogle, which is definitely a Text type. But I find a toggle for two choices has much more usability than a drop down menu with two choices.

Thank you very much in advance.

Best.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

PowerPuffKK 316 on at

Like (0)

Report
Copy link

Link copied!
Hi @Applicable88,

I do this for a lot of my apps built on SharePoint to avoid delegation - here's the formula that'll convert your toggle value to text:
Text(Toggle1.Value)

Please see screenshot below - you can see that it was converted to text.

If this answer helps you, please mark it as a solution to help future forum visitors 😊

Kristine

Was this reply helpful? Yes No
Applicable88 254 on at

Like (0)

Report
Copy link

Link copied!

Hi @PowerPuffKK I tried that on my submit button:
If(IsBlank(LookUp(Quality; QualityID = DataCardValue1.Text && Delivered = Text(Toggle1.Value) ));
SubmitForm(Form1);; NewForm(Form1);
Notify("That combination is already in the list"; Error); SetFocus(DataCardValue1))

But it doesn't work.

What I want to achieve:
PostID YESNO
1234 Yes
1234 NO
1111 YES
1111 NO

Duplicates are allowed, but the same number can only be with yes or no one time each. (composite key)

The duplicate check simply doesn't work, its lets every number past through. I think the problem is the toggle which output are false and true and not "No" and "Yes". So it doesn't find those words in the table, hence I can submit duplicates.

Any idea how to solve that?

Was this reply helpful? Yes No
Verified answer

PowerPuffKK 316 on at

Like (2)

Report
Copy link

Link copied!
Hi @Applicable88 ,

Sorry, I didn't realise you had a Yes No column!

For your scenario, you can try something like this - if the Toggle is set to true, then the filter should search for 'Yes', if it's set to false - it should search for 'No'. The formula would look like this:

If(Toggle1.Value = true, "Yes, "No")

So your whole formula would look like this - just make sure the name of the toggle matches the toggle name in the formula.

If(IsBlank(LookUp(Quality; QualityID = DataCardValue1.Text && Delivered = If(Toggle1.Value = true, "Yes", "No") )); SubmitForm(Form1);; NewForm(Form1);

Please let me know if this works 😊

Was this reply helpful? Yes No
Applicable88 254 on at

Like (0)

Report
Copy link

Link copied!

@PowerPuffKK wow....never thought that you can put one more If-statement after the "Delivered=..." to convert back to strings!
Thank you so much:) Finally a solution to keep the slider after so many approaches.
I wish you a nice weekend!
Best.

Was this reply helpful? Yes No
PowerPuffKK 316 on at

Like (2)

Report
Copy link

Link copied!

@Applicable88 , you're very welcome!! We learn something new every day 😊

Thank you and have a fantastic weekend too!

Was this reply helpful? Yes No