cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Bala9677
Level: Powered On

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
Community Support Team
Community Support Team

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
manuelstgomes
Level 10

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

Bala9677
Level: Powered On

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.

Community Support Team
Community Support Team

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.
Bala9677
Level: Powered On

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

Community Support Team
Community Support Team

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,683)