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 / Problem with the Refre...
Power Apps
Unanswered

Problem with the Refresh function in Gallery control - Power Apps

(0) ShareShare
ReportReport
Posted on by 13

Hi all, 

Have anyone have seen this problem with "Refresh" function? I created a view that consumed the information from the table in SQL server. For the browse gallery I used the view to show the information and the table I used it for update a status. 

So far, I have the following status.Scenario4.png

 

Scenario
 

  1. There are two records with status not approved by default and with no observations – This means that have status with color gray .
  2. There are two records from the same employee and I changed the first record the toggle to “Yes – Approved” and when I saved the record I also refresh the table and view successfully.
  3. The second record I added a “CPE observation” and the toggle I leave it as “No – Not approved” and the status color is change to red.
  4. After saving the second record I refresh the table and also the view and the problem it’s that the first record that was in status “Yes – Approved” with status color green, automatically change it to red. I do not understand why a “Refresh” function could cause this, it’s doesn’t make any sense and for the Patch function I’m passing the unique Id from the record and it seems to do it correctly.

Scenario5.png

 

Here is some screenshots of each scenario from the first screen and second screen 

 

Scenario1.png

Second screen - The save button from the second screen where the user updates the status.
Scenario2.png

First screen - Icons status change based on the CPE Observations (ThisItem.CPEComment) and status ThisItem.Status
Scenario3.png

 

I also tried to use the table as the source for the gallery control but that makes the gallery really slow, so I leave the view as data sources. 

 

Please let me know if you need more details from my side to understand the problem.

 

If we need to set a quick meeting to review this real quick, send me an email to: pengwenying1994@gmail.com

 

Thanks in advanced.
Wen Ying Peng

Scenario3.png
Scenario2.png
Scenario1.png
Categories:
  • ricardox180 Profile Picture
    190 on at

    Hi @WenYing94 , in the pictures I saw that you use Patch when Toggle is Checked or Unchecked, maybe there will be a conflict when the tables Refresh. If is possible, I recommend Patching everything in the "OnSelect" function of the save icon.

    Hope It helps you, if i can help with other issue or share knowledge between us, you can send me private message

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

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 402 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 296 Most Valuable Professional

Last 30 days Overall leaderboard