Answered

How to get data from Text Input Boxes and save in .csv or .xlsx

(0) Share

Report

Posted on by bwright

Hello,

I have built an app that serves as a part number return for our ERP system (Navision). Essentially, our customer service department gets an order form from a customer, inputs the selections (via cascading dropdown boxes) from that order form into this "Configurator" app and the app then outputs our ERP part numbers across multiple Text Input boxes, based on the selections made by our CS team. The app is fed by hosted excel files that serve as the data tables. Once the Text Input boxes have been populated, I'd like to collect all of the part numbers from the Text Input boxes and export to either .csv or .xlsx. How would I go about doing this?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,295 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @bwright ,

For exporting to CSV, this video from @RezaDorrani should be of assistance.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
bwright 16 on at

Like (0)

Report
Copy link

Link copied!

Thanks for sharing the video! I think this definitely got me started on the right path. I was able to get one of the values to pass to Power Automate. However, I have multiple part number returns boxes that I need to pass the text value for. I tried adding a handful of them to the run trigger, but it appears only the last one in the run formula is actually passing to Power Automate. Any advice how to pass multiple text value from the part number return boxes?

Was this reply helpful? Yes No
bwright 16 on at

Like (0)

Report
Copy link

Link copied!

The solution provided in the video worked! I had to do a little learning to figure out how to get the text values into a collection, but after doing so, this is working very well! Thanks for your assistance!!

Link to walkthrough of creating a collection from text inputs below...
PowerApps Collection: Add, Update, Remove and Filter items - SPGuides

Was this reply helpful? Yes No