Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
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.
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/
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.
Business Applications communities