Select only checked records and make changes to those only

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

I am new with PowerApps and struggling in creating an app.

In this I have gallery in screen 2(Gallery 2) which is coming from the main screen(Screen 1) using Filter function:

Filter(DbAbstract,name=NameVal.Text) where DbAbstract is Database, In here I am using the condition to make only some records visible which meet the condition.

Now in Screen 2 and Gallery 2, I have checkboxes in Gallery and you can see only one checkbox is coming in Tree View how can I select only two records from these three and once I click on the create changes it will navigate me to next page and land to screen 3(Next Screenshot attached).

Once I am in screen 3 whatever I write on the four blocks and click on submit it will reflect only on those two records in SQL which I have checked in Screen 2

Kindly let me know how can I do this.

Do let me know on which property I need to make these changes.

Help me in this.

Thanks!

Anmol

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Verified answer

KeithAtherton 3,709 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous,

Try code similar to the following to save the selected items to a collection on your Create Changes button OnSelect property:

ClearCollect(colSelectedItems, Filter(galMyGallery.AllItems, chkSelected.Value) );

Then you can refer to the selected items colSelectedItems on screen 3 when saving data to the data source.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

I am supposed to move to next screen when I click on the button if I will OnSelect for this, Which property I should use to navigate to next page?

Was this reply helpful? Yes No
KeithAtherton 3,709 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Use the Navigate function:

Navigate(Screen3);

As data collection colSelectedItems is globally available, you can refer to it from screen 3.

Navigate function reference: https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-navigate

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

I am using this line on Code on OnSelect

Should I use Navigate(Screen3) in OnSelect only?

Was this reply helpful? Yes No
KeithAtherton 3,709 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

After the ClearCollect function call, place Navigate(Screen3). This is so the data collection and the navigation are both done.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

@KeithAtherton

Now, whatever I insert in these Text fields should be updated in SQL server in column i.e DateProposed, Remarks, ApprovedDate, Status to those specific records which I have selected from checkbox. These are text Fields not Forms

How can I do that?

Was this reply helpful? Yes No
KeithAtherton 3,709 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Look into using the Patch function to insert new records into a data source:

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-patch

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

Was this reply helpful? Yes No