cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Parse excel file and create records in CDS entities

is there anyway to parse excel file from azure blob storage and put it into CDS entities? any help is much appreciated

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Parse excel file and create records in CDS entities

Hi @Bala9677 ,

 

You cannot import the excel file URL, file type, datemodified, etc, into cds, but you can import the data inside excel files to CDS entity. Please refer to below documentation of how to do this:

https://powerapps.microsoft.com/es-es/blog/cds-for-apps-excel-importexport/

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Highlighted
Super User II
Super User II

Re: Parse excel file and create records in CDS entities

Hey @Bala9677 ,

 

You can easily create a Flow to achieve this.

 

Just pass the URL to a Flow that has the "PowerApps" as the trigger and saves it.

 

I hope it helps, but if you have issues creating the Flow please let me know and we can try to work this out together.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Highlighted
Frequent Visitor

Re: Parse excel file and create records in CDS entities

Thanks @manuelstgomes for the response. I am not sure where to start, can you please help me how to do as I am quite new to this.

 

I have selected "PowerApps" as the trigger and where should i pass this URL of the excel file which is stored in the Azure blob storage?

 

Screenshot (213).png

Thanks,

Bala.

Highlighted
Community Support
Community Support

Re: Parse excel file and create records in CDS entities

Hi @Bala9677 ,

 

Are you trying to just add the excel file URL to CDS entities or did you mean you want to add records inside excel files to CDS entities?

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: Parse excel file and create records in CDS entities

Hi @v-monli-msft 

 

I would want to both, the excel file URL, file type, datemodified, etc, into CDS as well as the records inside the Excel file as well.

 

Any help/hint is much appreciated.

 

Thanks,

Bala

Highlighted
Community Support
Community Support

Re: Parse excel file and create records in CDS entities

Hi @Bala9677 ,

 

You cannot import the excel file URL, file type, datemodified, etc, into cds, but you can import the data inside excel files to CDS entity. Please refer to below documentation of how to do this:

https://powerapps.microsoft.com/es-es/blog/cds-for-apps-excel-importexport/

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (7,287)