web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Collection avoid galle...
Power Apps
Unanswered

Collection avoid gallery update

(0) ShareShare
ReportReport
Posted on by 14

Hi all, 

 

As i'm pretty new to Powerapps I would like to ask help from an issue i'm facing.

Let me try to describe this underneath :

 

I have a nested gallery, both based on a collection.

Dycons_0-1619081576535.png

 

Parent Gallery items definition :

 

 

 

SortByColumns(
 GroupBy(
 Filter(
 colQuestionnair,
 CheckList.Code = "XXXXXXX"
 ),
 "crbdd_subject",
 "grpBySubject"
 ),
 "crbdd_subject",
 Ascending
)

 

Child Gallery Items definition : 

 

ThisItem.grpBySubject

 

I've added some field on the Child gallery  

Dycons_1-1619081809475.png

 

What i'm trying to do is, update the collection based on selection of an icon.

Dycons_2-1619082567010.png

 

to achieve tis, i've added columns to the collection 

 

ClearCollect(
 colquestionnaire,
 AddColumns(
 'Safety Questionnaires',
 "OK",
 false,
 "NOK",
 false,
 "NA",
 false
 )
)

 

OnSelect of the icon(s) - (unbounded to gallery)

 

Patch(colQuestions,ThisItem,{Ok:true,Nok:false});

 

So far so good to update the record, but the screen is flashing.  I know the reason is because i update the collections so the gallery screen is refreshing.  This is not workable for the end user.  How can i avoid refreshing the screen but update the collection.

 

I tried al lot of different scenario's but i'm not able to achieve a good solution.

 

Please could someone help me with this ? 

 

Kind regards

 

Steve

Categories:
I have the same question (0)
  • BrianS Profile Picture
    2,407 Super User 2024 Season 1 on at

    The collection has to update or you will be viewing incorrect data. Why not add a pop-up in the OnSelect prior to the Patch? It could be something as simple as a label with a grey background that says "Working on it" You could add a timer so it would only stay up for 3 seconds or so. That way the end user knows the app is working and doesn't think something is wrong

  • Dycons Profile Picture
    14 on at

    Dear BrianS,

    Thx for your suggestion but as the data entry must be as quick as possible, i don't think this will be feasible.

    are there other suggestions ? 

     

    Kind regards

     

    Steve 

  • BrianS Profile Picture
    2,407 Super User 2024 Season 1 on at

    Unfortunately, there are limitations to all platforms. The data can only be manipulated so fast and only one piece of data can be manipulated at a time.

    If you need to get it done quicker, you could allow the user to mark all the changes and then push them all at the same time with a button press.

  • Dycons Profile Picture
    14 on at

    Hey Brian, 

    That seems a solution that i wasn't thinking about.

    Would you suggest to mark the changes into a separate collection or can i achieve this with unbounded controls and keep a variable on each level of record in the gallery with the status of changes ? 

     

    Kind regards

     

    Steve

  • BrianS Profile Picture
    2,407 Super User 2024 Season 1 on at

    That will depend on your user and the rest of the app. Since speed seems to be a premium I would stick with the collection. You should be able to find a place in the app to write the data where it will be noticed least, then you can patch all the data to your source at the end of the session, or when changing pages or some other time where users will be bothered least by the delay

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 834

#2
Valantis Profile Picture

Valantis 533

#3
Haque Profile Picture

Haque 410

Last 30 days Overall leaderboard