Change dropdown menu to toggle

(0) Share

Report

Posted on by Applicable88

254

Hello,

previously I have a toggle menu based on a sharepoint list yes/no column.

I just found out that yes/no columns are not delegatable, since I cannot use lookup function on that column type.

Now I thought using a choice column to do that, but I don't know how to switch the drop down menu to a toggle with yes and no.

At least in a choice column I can use the lookup function.

I hope someone can tell me what value needs to be change when I replace the dropdown menu in the update and default part of the datacard.

Thank you very much in advance.

Best.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

WarrenBelz 153,034 Most Valuable Professional on at

Like (1)

Report

HI @Applicable88 ,

I recommend you throw away all of those and simply write the value back (as I do) to a Single Line of Text of "Yes" and "No". Please read this section of my blog on data structure.

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Applicable88 254 on at

Like (0)

Report

@WarrenBelz thank you. Thats a wonderful tip and I definitely will go through your wonderful blog.

I changed that column to a plain single text column. But still when I replace the input field with a toggle, and do exactly what you explained at your website, the lookup for duplicates won't work.
Even though Yes and No are Text, but when using a toggle PowerApps regards them as Value.
I tried this as a composite key duplicate check.

Submit button OnSelect:
If(IsBlank(LookUp(Quality; QualityID = DataCardValue1.Text && YesOrNo=Toggle3.Value ).....

I can submit but duplicate search isn't working.
Is the Value of the Toggle the problem or simply that I'm doing a lookup of different Datatypes?
The other thing that I noticed is the equal sign between YesOrNo=Toggle3.Value has a blue mark below and not hte typical red line for errors.

Best.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,034 Most Valuable Professional on at

Like (1)

Report
Hi @Applicable88 ,

You simply convert it here

With( { wYesNo: If( Toggle3.Value, "Yes", "No" ) }, If( IsBlank( LookUp( Quality; QualityID = DataCardValue1.Text && YesOrNo = wYesNo ). . . .

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Applicable88 254 on at

Like (0)

Report

@WarrenBelz, I definitely will following your recommendations to stick with simple plain text and number columns. I would not have run into so many problems afterwards, if I would set it right already at the SharePointList.
Thank you.

Was this reply helpful? Yes No