onpremise data gateway files table data to powerapps

[Veblitz]

im thinking how to display data to PowerApps and source files are from on-premise data gateway folder path and it contains txt files which contains rows & columns data like information.

currently, i used power automate to transfer files from on-premise folder path to SharePoint document library.

so,we need to create an canvas app or am not sure which apps will suits to display these tables.txt files from document library(office 365)

Kindly advice

[VauBee · Accepted solution]

Hi @Veblitz ! I have some general thoughts around your question. Since your data originates from an on-premise data gateway folder and is transferred to SharePoint via Power Automate, you're on the right track for making this data accessible to PowerApps. To display this data within a Canvas app (which is the most flexible and suitable type for this scenario), you can should consider these general steps:

1. Prepare Your Data

• Format Consistency: Ensure that the .txt files have a consistent format in terms of how data is structured (e.g., consistent use of delimiters like commas or tabs to separate columns).
• Data Parsing: Consider preprocessing the data if necessary to ensure it is in a format easily consumable by PowerApps, such as converting .txt files to a more structured format like .csv or directly into SharePoint lists if the data structure allows.

2. Use Power Automate to Process Files

• Automate Data Processing: Since you're already using Power Automate to transfer files, enhance your flow to either convert .txt files into a more structured format or directly input the data into a SharePoint List. SharePoint Lists are natively supported as a data source in PowerApps and provide a more straightforward way to display and manipulate data.

3. Create a SharePoint List (if needed)

• If not already done, consider creating a SharePoint List to hold your data. Power Automate can be used to parse .txt file contents and populate this list automatically.

4. Develop Your Canvas App

1. Start Your App: In PowerApps, choose to create a new Canvas app and select the layout that best fits your needs (e.g., phone or tablet layout).

2. Add Data Source:

   • Add your SharePoint site as a data source by navigating to View > Data sources, then select New connection and choose SharePoint. Follow the prompts to connect to your SharePoint site where the Document Library or List is located.

3. Display Data:

   • If using a SharePoint List, you can easily add a Data table or Gallery (I personally prefer galleries) control to your canvas and bind it to the SharePoint List data source. This will allow you to display the data rows and columns directly within the app.

4. Customize and Publish:

   • Customize your app with additional features, such as filters, search capabilities, and forms for editing data. Once completed, save and publish your app for users to access.

Additional Considerations

• Performance: Large datasets directly parsed from .txt files may impact app performance. Using SharePoint Lists as an intermediary can help optimize data handling.
• Security and Permissions: Ensure proper permissions are set up in SharePoint and PowerApps to control access to data.

Happy building 😉

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question / helped to solve your problem, please accept as solution and give me a Thumbs up. Thanks! - Remember: you can accept more than one post as a solution.

[Veblitz]

Fantastic and Much appreciated.

Really helpful and excellent response and clear step by step inputs to implement .

[VauBee]

@Veblitz thanks! I'm happy if it was helpful 🤜

[Veblitz]

Do you have any reference for Power Automate which is used to parse .txt file contents and populate this list automatically.

[Veblitz]

Power Automate can be used to parse .txt file contents and populate this list automatically. So in this scenario,please advise if we have 5 different txt files as below

Stores.txt

Location.txt

Customers.txt

Address.txt

Country.txt

These above files getting created in daily basis to our document library so how we can plan such kind of data to ensure it's populated to different list and getting updated to respective list in daily basis.