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
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (5,948)