web

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

News and Announcements icon

Power Platform CommunityForums Power Apps How to update a bit co...

Power Apps

Answered

How to update a bit column in SQL from Powerapps

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

WarrenBelz 156,425 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No

Join the conversation