cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Can we update Excel file content outside Power APPs?

Hi,

 

Using Excel file of One Drive for Business I have Create a Simple Power Apps. App is working as it should be. But I want to add some data(records) into the excel outside the app, Like open the excel file add rows into the excel file. How can I show this records in my Power Apps. With the every row in Excel the PowerAppsId is associated. So when I manually add that records how can I add this ID. And How can I display those records in my Power Apps. And After How much time it will display it in the Power Apps. 

 

Thanks

3 REPLIES 3
Community Support
Community Support

Hi KrunalPatel,

 

My understanding about your issue is that, after you update the data source of an app, how could you refresh it and let the update show in app. If this is the situation, 

 

> In edit mode, on right navigation pane, click Data sources, click the ellipsis then the Refresh button to refresh the data source, the changes you made on the data source would be updated on the app.

medium.png

 

>On Preview mode, you could add a Refresh button on the app to refresh the records of a data source. Please check the article about Refresh button:
https://powerapps.microsoft.com/en-us/tutorials/function-refresh/

 

>Every time you reopen the app, the records of a data source would also be refreshed. This article about data sources in PowerApps could be a reference for you:
https://powerapps.microsoft.com/en-us/tutorials/working-with-data-sources/

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-monli-msft,

 

Thanks for your reply. I have seen this blog before but I am not able to get the data that I have manually added in the excel file. I have tried to refresh by both way as mension in your reply. But couldn't get any success. Is it the issue of PowerAppId field in excel file?

 

Thanks

Hi Krunal,

 

I used the same data source like yours - OneDrive for Business, after I updated the excel, I tried to first refresh the data source in the app, the new record didn't show in app. But later I completely close the app and then reopen it in PowerApps, the update shows in the app successfully. Have you tried to reopen the app to have a test?

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (103,188)