Problem to sync onedrive when connecting to Excel Online

[Alikecheese]

I’m having trouble working with powerapps and excel online. Here’s my setup :

Every minute an excel file is added to a local folder on my computer. This file does not contain data in table format, so I have a powershell script that retrieves the data and saves it in table format in a new excel file which is this time stored in a onedrive folder.

So every two minutes or so, I have a new file (same file name and same sheet name) which replaces the old one in this folder.

The file is 5kb.

Thanks to the table format, I can connect from powerapps to retrieve the data and display it in my application.

My problem is the following: each time the application is opened, I have the feeling that the connection is established between powerapps and one drive, and therefore that one drive can no longer synchronize the new file correctly.

My data on the front end does no longer reflects reality because even if locally the file contains the most recent data, one drive cannot load it into the cloud if powerapps is open.

Did anyone ever experience something like this ? Maybe this is not the best solution so feel free to suggest something else to work with.

[v-chengfen-msft]

Hi @Alikecheese ,

Could please tell me:

1. Do you use filter, lookup or search for excel(onedrive)?

If yes,

The reason for not being able to get the latest data is:

This is a known limitation:

Best Regards

Cheng Feng

[Alikecheese]

Yes I use lookup to set variable. 

So if I understand correctly, from the moment I use a lookup in my table, this will block the synchronization and therefore I will not be able to display my information in real time?

Can I then use a table object to display my excel on a screen, and do lookups in this table object rather than directly in the Excel?

[v-chengfen-msft · Accepted solution]

Hi @Alikecheese ,

It just has some delay, so you can't get the latest data right away.

Display the entire table directly without using filter, lookup or search, you could display the latest data.

Best Regards

Cheng Feng