Unanswered

Extracting records from DATAVERSE into SQL SERVER through POWER AUTOMATE

(0) Share

Report

Posted on by Chandan Mishra

Dear Team,

I have prepared a flow to extract RECORDS from DATA VERSE to SQL SERVER. The flow works fine if the NUMBER OF RECORDS = or <2000 IN THE ROW COUNT, if the THE ROW COUNT ID > 2000 it fails.

first 2000 is fine.JPG

Hence, if I have 6000 records, I am trying to pagination in the 'LIST ROWS' settings, so that I can extract data for the first 2000 rows then from 2001 to 4000 and then from 4001 to 6000.

What should I write in the 'TRACKED PROPERTIES' here?

next 2000.JPG

Please let me know.

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

eric-cheng 5,171 on at

Like (1)

Report

Hi @ChandanMishra ,

Please refer to this post on how to use loops to get more than 5000 items using the List rows action in Dataverse

Conversely, consider also using :

1) Data export function in Dataverse to SQL here
2) Using a created row trigger and writing to SQL straight away

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
Chandan Mishra 83 on at

Like (0)

Report

Thank you @eric-cheng ....I did eventually did it by following the link...

Was this reply helpful? Yes No