cancel
Showing results for 
Search instead for 
Did you mean: 

Import txt and csv into Powerapps

Hi, Currently have credit requests from customers that come through in txt or csv formats. Each of these requests has a lot of information such a reference number, item codes, amounts, etc. We have to manually input all this information into an app we have created in Powerapps for credit request approval by sales managers. It would save so much time and inputting if there was a way we could import txt files and csv files into Powerapps. This would pretty much eliminate a whole bunch of manual inputting.

Status: Completed

Thank you for your feedback.

 

You may use our data integration features to bring data in from a CSV file into CDS. Learn more:

Overview: https://docs.microsoft.com/en-us/powerapps/administrator/data-integrator

Import/Export: https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-import-export

 

If you would prefer not to leverage CDS, and are working in Canvas apps, then you only need to Save-As the CSV file as an Excel file, then you'll be able to save it to OneDrive to connect to it from PowerApps, and/or you may import it as static data. (Please remember that we would need you to configure the range as a table to ensure it is available to PowerApps.)

Also review these articles:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/get-started-create-from-blank 

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/how-to-excel-tips

 

Thank you for your continued feedback,

Audrie

 

Comments
Level: Powered On

TEST

Level: Powered On

TEST

Power Automate Staff
Status changed to: Completed

Thank you for your feedback.

 

You may use our data integration features to bring data in from a CSV file into CDS. Learn more:

Overview: https://docs.microsoft.com/en-us/powerapps/administrator/data-integrator

Import/Export: https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-import-export

 

If you would prefer not to leverage CDS, and are working in Canvas apps, then you only need to Save-As the CSV file as an Excel file, then you'll be able to save it to OneDrive to connect to it from PowerApps, and/or you may import it as static data. (Please remember that we would need you to configure the range as a table to ensure it is available to PowerApps.)

Also review these articles:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/get-started-create-from-blank 

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/how-to-excel-tips

 

Thank you for your continued feedback,

Audrie