Answered

An Excel Table is not refreshing each time the app is reloaded

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone,

I have a Data Table in my Power App which uses an excel table as the data source. one column in particular of this excel table changes regularly, and is the important info from this table. For some reason, these updates are not reflected in the app, even after closing the app and reopening.

I have tried Refresh, but i get an error that "only managed connections can be refreshed"

The app is meant to be housed in a Microsoft Teams channel, so i have housed the source Data in the Teams files section as well (SharePoint), but I don't think that is the issue because this was happening when i was housing the source data on OneDrive for Business, too.

Any help or insights greatly appreciated! I can also provide more detailed info upon request if it is needed in order to find a resolution.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

You will not be able to Refresh an Excel file stored in Teams (aka SharePoint). From what I know its not a feature that PowerApps currently has.

Excel files can be refreshed from a OneDrive connection though. I would recommend doing that instead and then working through any refresh problems after you've made the switch back.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

@mdevaney thanks! I will give it another shot and report back.

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

When you respond back please be sure to share the code you used to REFRESH the datasource 🙂

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much! I honesty thought I had tried storing the data on OneDrive first before switching it to SharePoint, but I must have been mistaken because this worked absolutely perfectly.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

So once you helped me know WHERE to put this data, and got it refreshing properly, i decided to change the control in PowerApps to a gallery. This is the first App i've ever made, so i've had a lot of fun changing things around, and overall just learning what is possible, and figuring out how to make it possible.

Here's the formula i used to filter the data....for context on the dormula, i wanted the gallery to sort the data by team members with the most availability first, then filter the data by either their primary service line alignment or secondary service line alignment.

SortByColumns(Filter(All_TAs_Table, ServiceLineTextInput.Text in ('Primary SL' & 'Secondary SL')),"Availability_x0020_(_x0025_)",Descending)

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous
This question is on a new topic so you should make a new post in the forums to ask it

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

Was this reply helpful? Yes No