cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

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
Super User II
Super User II

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

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.

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.

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

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
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Users online (8,096)