Power Platform Community Forum Thread Details

Hi,

I am beginner in PowerApps. I have a scenario that i need to solve.

I have a SQL table with fields like PrimaryKeyID, SalesOrderNumber, PartNumber, LineNumber etc. One SalesOrderNumber can have multiple entries for PartNumber.

I want to build an app which has a gallery (gallery 1) showing all distinct SalesOrderNumber. Another gallery (gallery 2) which shows distinct PartNumber based on selection of the first gallery i.e gallery 1.

After this, i want to have a checkbox which allows user to select multiple PartNumbers from gallery 2. Once that is done i will have a form which will have few fields to update.

The OnSelect of button should work like, If there is no PartNumber selected in gallery 2 then it should update all records for SalesOrderNumber selected in gallery 1. Else if there are PartNumbers selected in gallery 2 it should update fields for those selected PartNumbers.

Appreciate your help..:)
@WarrenBelz , @eka24

Categories:

Building Power Apps

Follow these steps:

1. On Gallery1 Items: Distinct(SQLTable,SalesOrderNumber)

2. On Gallery1 Items: Filter(SQLTable,SalesOrderNumber=Gallery1.Selected.SalesOrderNumber)

3. This part of your requset no very clear:

"If there is no PartNumber selected in gallery 2 then it should update all records for SalesOrderNumber selected in gallery 1. Else if there are PartNumbers selected in gallery 2 it should update fields for those selected PartNumbers"

What are you updating it to?

Before you answer I suggest:

a. Insert checkbox in the Gallery2

b. Insert a Textbox1 also into the Gallery2 (To input what you want updated)

c. In the OnCheck of the Checkbox, put: Patch(SQLTable, ThisItem,{PartNumber:Textbox1.Text})

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.