cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

PowerApps Onedrive for Business Excel Datasource Update

Hi . my PowerApps is connected to an Excel file in Onedrive for Business, whenever there is new submission by users, the latest data does not appear when i click the "Refresh" button in Excel. It will only appear when I close the Excel file and reopen it...this is somewhat different from PowerApps connected to SharePoint whereby the Excel table exported from SharePoint could be show latest updated data by just clicking the Refresh button.. Anyone could advise please?

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: PowerApps Onedrive for Business Excel Datasource Update

Hi @ngabougaifan,

 

Could you please share a bit more about your app's configuration?

Could you please show a bit more about the "Refresh" button in Excel? Do you mean that the latest data could not be shown up when clicking the "Refresh"  button?

 

I could not reproduce your issue on my side currently, I think this issue is related to the real-time data update.

 

You could consider take a try to configure "Automatically refresh data at regular intervals" within your Excel file, please check the following article for more details:

https://support.office.com/en-us/article/refresh-an-external-data-connection-in-excel-1524175f-777a-...

 

Please provide more details about your scenario, so we could provided a proper workaround for you.

 

Best regards,

Kris

 

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Advocate I
Advocate I

Re: PowerApps Onedrive for Business Excel Datasource Update

My app is connected to an Excel table in Onedrive for Business..say when I open the Excel file and somebody submit a new entry, I would not be able to view the latest submitted data in the Excel file when I click the "Refresh All" button in Excel. But thing is different when my app is connected to a SharePoint List whereby I can view the updated table immediately when I click the "Refresh All" button in Excel.
Luke.JPG

 

Also another question is the "Date of work" column converted to DateTime by itself even though I did nothing to the column setting in Excel..I replaced the text input with a datepicker in PowerApps for "Date of work" field and only want to store the Date data but the time value appears magically by itself at the back..Do you know how to fix this?

Highlighted
Regular Visitor

Re: PowerApps Onedrive for Business Excel Datasource Update

I have a similar issue. I removed and replace my Excel Datasource (saved OneDrive) for a Gallery lookup in my Canvas PowerApps. It never loads the complete file -- the most recent information that exists in my Excel does not show up in my gallery.  What can I do to get the most current, up to date, refreshed and COMPLETE file to show?

 

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Users online (4,491)