Notifications
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tom_Gioielli 70 Super User 2025 Season 2
Gerardo RenterÃa Ga... 33 Most Valuable Professional
Daniyal Khaleel 32 Most Valuable Professional
