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!
Hello,
thank you for your answer, but you have repeated exactly what i have already written.
hello
building power apps can be done from sharepoint list directly
for flow you can call flow from power apps and flow will run based on logic you wanted your flow report to power apps
Hope this helps
Create a canvas app from a SharePoint list - Power Apps | Microsoft Docs
Have a good day.