How to update a bit column in SQL from Powerapps

[Anonymous]

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.

[WarrenBelz · Accepted 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.