Unanswered

Import data from Excel to CDS using a canvas app

(0) Share

Report

Posted on by Community Power Pla...

I am converting an excel calculator into a canvas app that stores data in the CDS. There are a lot of fields that need to be entered, and I wanted to find a way that they could download an excel template of the entity and then reupload it from within the canvas app.

The functionality I want is what is currently available in a model driven app, where you can export to excel, then import back into CDS. It doesn't necessarily have to export the data, but being able to download a blank template that will upload back to CDS would be sufficient.

Is there a way to achieve this in a canvas app?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

CU-18081211-6 9,270 Moderator on at

Like (1)

Report

Hi @Anonymous ,

This seems to me a PowerAutomate job rather than a PowerApps canvas app.
You can create a flow with a trigger when a new file is created in a SharePoint Document Library, check if it is a excel file type, read the content using Excel connector and then write it to CDS entities (as you need).

There are some great workarounds to upload a file (in this case Excel file) in PowerApps canvas app using the attachment data card of one PowerApps forms, send it as a JSON to be readed in PowerAutomate and receive the content of the file as a response from PowerAutomate, and only after that to update the CDS entities from PowerApps. This way of thinking the solution creates a lots of Point of Failure and is not recomandable against my first proposal, but is an option.

Hope it helps !

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @gabibalaban

Thanks for your reply.

This isn't quite what I was hoping for, but for uploading the spreadsheet, I think it could work. Thank you.

Do you have a link to more details on the workaround you mentioned?

You wouldn't happen to know if there's an easy for for a user to download a spreadsheet? At the moment, I am thinking I will have to go with emailing it to them, but downloading it would be better.

Was this reply helpful? Yes No