DataTable not udpating correctly when adding a function in the "items" bar

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Everyone, I'm struggling with an error and I have no other choice that posted it here.

I have a table on Sharepoint called "Capa_Machine" which is an excel Table

I created an application that fill this Table and also show this table in the application with a DataTable.

The problem is the following : if I just show my DataTable by just putting " Capa_Machine" on the "Items" property, all works fine, all the element are dynamic and when I add or delete a new element from the application, the dataTable instantly update.

But if I use a function in the "Items" property of the table for exemple :
LookUp(Capa_Machine;Atelier=Drpd_Atelier.SelectedText.Value) or SortByColums(Capa_Machine;"Atelier";Ascending), the DataTable is not updating instantly, I have to wait like 2 or 3 minutes, it depends.

It is not depending of refreshing the Dataset (already tried it)

I don't know where this probleme come from, it's really when I put a function in the "Items" property that the problem occur.

Tank's in advance for your help.

Noah

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-chengfen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous ,
Excel has many limitations as a data source.
We can see it through the official documentation of the excel connector.
When you update the new data and immediately use filter, lookup, search to filter the excel table, there will be a period of delay.
Here is a link about excel limitations for your reference:
Excel Online (Business) - Connectors | Microsoft Learn

If your data will not exceed two thousand, and you still need to use excel as the data source.
It is suggested here that you can collect the excel table into a collection, and then filter the collection, so that you can avoid restrictions

Best Regards
Cheng Feng

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

Like
a
(0)

Report
Copy link

Link copied!

Thanks a lot @v-chengfen-msft ! Indeed in my case my excel has only few row so I used à collection with the ClearCollect() function before filtering and it's work fine now ! The only thing is that I have to trigger the ClearCollect() function everytime I used my button but that's not a problem.

It's also good to know that there is a official documentation about the connector and their limitation.

Wish you a good day

Noah

Was this reply helpful? Yes No