web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Power Apps Gallery -> ...

Power Apps

Answered

Power Apps Gallery -> Form DataCard -> Toggle Help Request

(0) Share

Report

Report

Posted on by CeiBob

9

Hi! I am a bit new to Power Apps and I am trying to change how my powerapp is functioning.

TLDR:

Does anybody know how to get a gallery item to change a toggle in a datacard based on boolean data from an excel sheet?

Summary of issue:

I have a data set coming from an excel document, which has a boolean column. I have a gallery and a form, much like the default tablet setup which it auto generates.

What I mean to do is have the gallery selection set a form toggle instead of a text label for the boolean information. This way I can toggle it on or off (true / false states) rather than use the text field and manually type True / False.

I've been confusing copilot with various questions and decided to contact this forum instead.

I also wish to use the toggle value to update the form when submitted.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Sunil Kumar Pashikanti 1,077 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @CeiBob,

Here the AvailableText field (string) has values like [True/False] (text value). Based on true or false, I am showing the toggle control's value.

The toggle control's default property will have the following formula:

If the AvailableText field value is False, then it will be off, if it is True, the it will be on as shown in the above picture.

Use the toggle control's values to update the data source, you may need to use if condition to pass the value as text "True" or "False" based on the selection.
In the AvailableText DataCard - Update property add the below code.
If(Toggle1.Value, "True", "False")

Regards,
@SunilPashikanti

Was this reply helpful? Yes No
CeiBob 9 on at

Like (0)

Report
Copy link

Link copied!

Thank you for this reply. I will be trying this solution out sometime next week and will accept this as the solution then.

Edit: This solution worked! Thank you for explaining how this works!

Was this reply helpful? Yes No

Join the conversation