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 / When saving to a colle...
Power Apps
Unanswered

When saving to a collection with toggle change, selected label change to another and basically restarts

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi,

 

I'll do my best to explain mye issue. 
I have a gallery that gets data from a collection. When I enter numbers into labels in the gallery, I have set it to automatically save back to the collection once that label doesn't match my corresbonding column value in my collection. 
This works great and I want to keep it this way, because then I have one button above my gallery that saves the collection to sql, which after testing a lot and finding articles that suggest this I know this is the fastest way to save data. 

However the issue is that once I enter data, the toggle saves, and it jumps back somehow to another label. 
Is there a way to have it not jump back. 
Kind of difficult to explain, but consider this screenshot. 
if I enter data in the label with black square around it, then it jumps back up to the label with the red square.

Powerapprookie2_0-1644857191835.png

Anyone else have this issue and have found a way to solve it?

 

Thanks!

Categories:
  • PowerAddict Profile Picture
    7,316 Most Valuable Professional on at

    Hi @Anonymous , 

     

    A recording of your screen would be helpful. You can use this free software if you like: Screen2Gif (I have no affiliation to it, its just the one I use). 

     

    What might work best for you is to have two collections. One that populates the gallery and another identical one that gets updated when you enter values. Then use the 2nd one to patch to SQL. The problem is that it when u update the collection which is the same as the one that is populating your gallery, it reacts in a weird way. 

     

    Try this out and let me know if it helps. 

     

    ---
    If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions. 

     

    Thanks!

    Hardit Bhatia

    Microsoft Business Applications MVP

    Microsoft Certified Trainer MCT

    Blog | Twitter | LinkedIn | Facebook | YouTube  |  Email

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hei @PowerAddict ,

    Thanks for the reply, sorry my late respons. 
    Not sure if I completely understand how to use two collections, but I'll give it a try.

    I have used the software you suggested and recorded my issue, hope it will become more clear after that.save to collection.gif

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 382 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 329

#3
WarrenBelz Profile Picture

WarrenBelz 187 Most Valuable Professional

Last 30 days Overall leaderboard