Announcements
No record found.
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.
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.
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.
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
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Muhammad Shahzad Sh... 69 Most Valuable Professional
ManoVerse 60 Super User 2026 Season 1
11manish 43
