I want to fetch data from CRM and create csv file in azure blob.

(0) Share

Report

Posted on by arpit chouksey

Hello All,

I want to fetch data from CRM and create csv file in azure blob by MS flow but while fetching data from CRM formatted value available only for Starting 5000 record. i want all data formatted value at a time . I tried do until loop for process 5000 record per batch but unable to combine data and create csv file with all data.

Categories:

Development / Customization / SDK

Other

Data Loader

All responses (4)

Answers (0)

arpit chouksey 70 on at

Like (0)

Report

RE: I want to fetch data from CRM and create csv file in azure blob.

We tryed this but data format in CSV file not correct .all data show in single row of file.could you try this scenario may be I am doing some wrong.
Suggested answer

Pradeep Rai 5,490 Super User 2024 Season 2 on at

Like (0)

Report

RE: I want to fetch data from CRM and create csv file in azure blob.

Hi Arpit,

So, in above case we can use the concept of array and append array as described in below link:

https://vblogs.in/create-an-array-using-append-to-array-variable-in-power-automate/

Video Link:
https://www.youtube.com/watch?v=VAfwiN-vARQ

Thanks,
Pradeep
arpit chouksey 70 on at

Like (0)

Report

RE: I want to fetch data from CRM and create csv file in azure blob.

Hello Pradeep,

thanks for the reply.

I am able to fetch record in 5000 record batch in do until loop but how I combine all data at a time and create one csv file because in loop. I am creating csv file so its taking only last fetched records not all records.
Suggested answer

Pradeep Rai 5,490 Super User 2024 Season 2 on at

Like (0)

Report

RE: I want to fetch data from CRM and create csv file in azure blob.

Hi Arpit,

Please refer below blog to get 5000+ records in MSFLOW/Power Automate.

https://debajmecrm.com/how-to-query-more-than-5k-cds-records-using-fetchxml-in-powerautomate-microsoft-flow/

Thanks,
Pradeep.

Please mark this as VERIFIED if it helps.