Skip to main content
Community site session details

Community site session details

Session Id : fe0Gr5OoQuJ2tIyGz8u2Ik
Power Apps - Building Power Apps
Unanswered

Refreshing Excel Source

Like (0) ShareShare
ReportReport
Posted on 9 Aug 2022 19:09:53 by

Hi,

 

I'm building an app that uses Excel files as data source, using Excel Online (Business) connector.

This Excel file has several tables in it. The users insert data to these tables through forms, and this is working properly.

 

On the same file, there is a table that uses information from the other ones and have some columns with formulas.

Some screens in the app uses these calculated columns.

 

But here is the issue. The data on these screens, that comes from these calculated columns, only update after I manually refresh the Excel source (or if I open the app again).

I tried changing to OneDrive connector but it does not allow formulas in the table.

 

Is there a way to force a refresh on the Excel file after new data is inserted (clicking a button after the data insertion, for instance)? I'm trying to find a way with Power Automate but couldn't find yet.

 

Thanks in advance!

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2