Hello,
I want to create a toggle button in gallery so users can quickly change a true/false value I have a toggle with the default set as:
ThisItem.Show_Flag
Where 'Show_Flag' is the true/false value in my SQL database.
But this doesn't get the correct value (Usually all true or all false).
Also, I have the Onchange value set to:
Patch('[DATA]' , First(Filter( '[DATA]' , Measure_Name=ThisItem.Measure_Name )), {Show_Flag: Toggle1_3.Value} )
I can't tell if the Onchange formula is working correctly and the default value is causing the issue or they are both wrong.
Any help appreciated,
Thank you
Solved! Go to Solution.
Hi @Connor_Taylor,
Is the Show_Flag column a Bit type column in your SQL table?
Do you mean that the Show_Flag column value could not be displayed correctly within your Gallery?
I suppose that you created a Bit type column in your SQL table to store your Show_Flag value, is it true?
I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below:
The data structure of my SQL table as below:
Note: The Show_Flag column is a Bit type column in my SQL table.
App's configuration as below:
Set the OnChange property of the Toggle control within the Gallery to following:
Patch(
'[dbo].[TaskLists]',
ThisItem,
{
Show_Flag: Toggle1.Value
}
)
Please check if you have used proper data type to store the Show_Flag column value (True/False value) within your SQL table. Please consider take a try to use Bit type column to store your Show_Flag column value.
You could also consider take a try to add a Label control within your Gallery, set the Text property to following:
ThisItem.Show_Flag
then check if the Label control show correct True/False value within your Gallery.
Best regards,
Kris
Hi @Connor_Taylor,
Is the Show_Flag column a Bit type column in your SQL table?
Do you mean that the Show_Flag column value could not be displayed correctly within your Gallery?
I suppose that you created a Bit type column in your SQL table to store your Show_Flag value, is it true?
I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below:
The data structure of my SQL table as below:
Note: The Show_Flag column is a Bit type column in my SQL table.
App's configuration as below:
Set the OnChange property of the Toggle control within the Gallery to following:
Patch(
'[dbo].[TaskLists]',
ThisItem,
{
Show_Flag: Toggle1.Value
}
)
Please check if you have used proper data type to store the Show_Flag column value (True/False value) within your SQL table. Please consider take a try to use Bit type column to store your Show_Flag column value.
You could also consider take a try to add a Label control within your Gallery, set the Text property to following:
ThisItem.Show_Flag
then check if the Label control show correct True/False value within your Gallery.
Best regards,
Kris
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
201 | |
180 | |
62 | |
32 | |
30 |
User | Count |
---|---|
324 | |
268 | |
104 | |
74 | |
56 |