70
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.
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.
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
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,
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (