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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Gallery Refresh Challe...
Power Apps
Unanswered

Gallery Refresh Challenge - Refresh(Datasource) isn't working

(0) ShareShare
ReportReport
Posted on by 716 Moderator

So I hate to even ask because this has come up multiple times here obviously.

Little pat on the back for me since I did a diligent search and tried posted solutions.

 

But they didn't work.

 

I have a gallery of tickets on a dashboard page. Clicking an item navigates to a details page where values can be changed. In addition to updating the actual Tickets datasource, I also write activity logs to a related table.

 

When the user Saves on the detail page, everything writes successfully to both Tickets and ActEntry tables. I can see the data land immediately upon save. The app navigates the user back to the Dashboard at Save on Details page. In that save, I added a Refresh(ActEntry) which didn't solve the problem. After landing back on the Dashboard, if you click the Ticket you just modified, the details page loads with all of the correct data from the Tickets table. But, the ActEntry gallery doesn't show the most recent values.

 

So then I thought I'd move the refresh closer to the view. So when the item is clicked in the Tickets gallery, the very first command in OnSelect is Refresh(ActEntry).

 

Still no go. I'm stumped.

 

ps. I'm using an Excel file as the data store. Is that my pain?

Categories:
I have the same question (0)
  • Verified answer
    WarrenBelz Profile Picture
    153,026 Most Valuable Professional on at

    Hi @DCHammer ,

    Short answer with Excel - probably yes - it is a terrible data source - have you considered a SharePoint List ?

    Also is the Gallery "pointing" directly at the data table in Excel ?

  • DCHammer Profile Picture
    716 Moderator on at

    Yes I've considered it. I almost did it last week and may still yet. 

    In theory, it should be really simple to copy the data into SP and then connect but I also know theory often runs into reality during implementation. LOL

    And yes, the gallery is pointing directly and not to a collection in between.

     

    Thanks Warren.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard