Parse excel file and create records in CDS entities

[Bala9677]

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

[manuelstgomes]

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]

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?

Thanks,

Bala.

[v-monli-msft]

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

[Bala9677]

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

[v-monli-msft · Accepted solution]

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