Hi experts,
I have a general question about the best way to store and access the data when creating a Power App.
The basis of my app to be created is data which is stored in the form of a .txt file on SharePoint. This data has a heading followed by hundreds of records in the following form:
1001;Production Material;;;0;;Pcs;;10;
So the separator symbol is ;
Roughly speaking, this data is to be displayed in a list in the app. This is about different articles with the number of pieces and other data (weight, price, ...).
To keep the data up to date, this file is replaced automatically and weekly by a more up-to-date file from the system. This file has the same name and is stored on the same path.
My question now is whether I should/can build my PowerApp directly on this .txt file or is there another way?
For example, it would occur to me to transfer the file (by means of a flow, which is triggered when a new SharePoint document is created?) into a SharePoint list, which already formats the source data better for the app (how=?)
Since I'm relatively new to this topic, I'm hoping for some valuable tips or instructions on how best to implement this so that I don't build my app on the wrong foundation.
Many thanks in advance!
