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 / Gallery Refresh Challe...
Power Apps
Answered

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
    155,190 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

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 March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 633

#2
11manish Profile Picture

11manish 588

#3
Valantis Profile Picture

Valantis 457

Last 30 days Overall leaderboard