I am having a Listbox and Button in Powerapps. Based on the Listbox multipleselection I should Update a Bit column in SQL.
In Listbox Items : Sort(Filter('[dbo].[TEST_TASK_MAP_VIEW]', TEST_ID = Gallery1.Selected.TEST_ID), TASK_NUM, Ascending)
In Button Onselect : Updateif('[dbo].[TEST_TASK_MAP]', ListBox.SelectedItems, {ISACTIVE: 0}) or
Updateif('[dbo].[TEST_TASK_MAP]', ListBox.SelectedItems, {ISACTIVE: false})
For both the above Updateif formulas, I am getting error. Can anyone help me how to update SQL column based on Listbox Selection.
Solved! Go to Solution.
Hi @Anonymous ,
Try this
ForAll(
ListBox.SelectedItems As MySel,
Updateif(
'[dbo].[TEST_TASK_MAP]',
TEST_ID=MySel.TEST_ID,
{ISACTIVE: fslse}
)
)
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.
Hi @Anonymous ,
Try this
ForAll(
ListBox.SelectedItems As MySel,
Updateif(
'[dbo].[TEST_TASK_MAP]',
TEST_ID=MySel.TEST_ID,
{ISACTIVE: fslse}
)
)
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.
User | Count |
---|---|
262 | |
110 | |
98 | |
54 | |
39 |