cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dxshyam
Level: Powered On

Re: MS Flow - Pagination Error from today on all instances

@aegt1510 I am using List Records for Common Data Service.

I had 4050 Active Contact records, My flow is supposed to deactivate all Active Contact records.

This time I kept the Pagination OFF and Threshold as 4050 to see if it helps (although in my case the number of records would vary and I can never keep the exact count here)

 

Observation: The flow processed the default limit of 512 records, so 512 out of 4050 Active Contacts were deactivated in this execution of flow and now I have 3538 Active Contacts.

 

In my case Turning OFF Pagination did not help

 

Regards,

Shyam

Rashkae
Level: Powered On

Re: MS Flow - Pagination Error from today on all instances

Can confirm turning pagination off for the Excel Connector and setting the threshold to 10k fixed the error

dxshyam
Level: Powered On

Re: MS Flow - Pagination Error from today on all instances

Another observation when using List Record connector for Common Data Service is, When the Pagination is OFF, you set some value say 10000 to Threshold and save. it actually does not save that value even though it shows that value in Threshold.

 

Confirmed this by opening the Flow again and checking the settings for Threshold. The threshold is empty and therefore the flow executes with default limit of 512 records.

 

Regards,

Shyam

dbridges101
Level: Powered On

Re: MS Flow - Pagination Error from today on all instances

I am having the exact same behavior with pagination using CDS List Records action. Worked up until last night for me. 

frantisekcapek
Level: Power Up

Re: MS Flow - Pagination Error from today on all instances

Super User
Super User

Re: MS Flow - Pagination Error from today on all instances

Latest info from support is that there has been rolled out fix to all environments. It should be applied till end of today. But not yet confirmed that it works.
Pavel
dxshyam
Level: Powered On

Re: MS Flow - Pagination Error from today on all instances

Hi Pavel,

 

Thanks for sharing the update, is there any URL to check the update on this or have they communicated to you via email.

 

Thanks,

Shyam

dxshyam
Level: Powered On

Re: MS Flow - Pagination Error from today on all instances

Hi @frantisekcapek ,

 

Thanks for sharing your temp solution. what expression have you used inside Condition2? is it length(List Records)?

 

9.PNG

 

Thanks,

Shyam

dxshyam
Level: Powered On

Re: MS Flow - Pagination Error from today on all instances

Hi All,

 

Spoiler
Looks like it is fixed 

 

Just triggered my flow manually with Pagination ON and Threshold 10000 and processed over 1000 records with List records for Common Data Service connector. After this completes execution, I will do another 3-4 rounds of testing with about 6500 records each. Will post my observation in about 4-5 hours from now.

 

Thanks,

Shyam

frantisekcapek
Level: Power Up

Re: MS Flow - Pagination Error from today on all instances

Hey @dxshyam ,

yes, the expression is length(body('List_records')?['value']).

Best Regards,
Frantisek

dxshyam
Level: Powered On

Re: MS Flow - Pagination Error from today on all instances

Spoiler
Resolved: List Records for Common Data Service

I have done 4 rounds of testing in two instances with about 6500 records to process by keeping Pagination ON and Threshold 10000. I can say that this is working fine for me now.

 

Thank you all for sharing your experience and expertise.

 

Regards,

Shyam

dxshyam
Level: Powered On

Re: MS Flow - Pagination Error from today on all instances

@frantisekcapek Thanks for sharing your work around.

frantisekcapek
Level: Power Up

Re: MS Flow - Pagination Error from today on all instances

 dxshyam No problem mate

Highlighted
Community Support Team
Community Support Team

Re: MS Flow - Pagination Error from today on all instances

 

Hi @dxshyam  & All,

 

The message I am currently receiving is "The hotfix has been deployed successfully to all the region, and the issue has been Mitigated."

What is the situation on your side? Please check it and if the problem still exists, please let us know.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

dxshyam
Level: Powered On

Re: MS Flow - Pagination Error from today on all instances

Hi Barry,

 

Yes, it is resolved. At about 15:00 hrs IST on 16th November this was resolved for me.

 

Thank you.

Shyam

dxshyam
Level: Powered On

Re: MS Flow - Pagination Error from today on all instances

Hi @v-bacao-msft 

 

Yes, the issue is resolved. All my instances start working as expected from 15:30 hrs IST of 16th November.

 

Thank you,

Shyam

mukie
Level: Powered On

Re: MS Flow - Pagination Error from today on all instances

Hi v-bacao-msft

 

Dynamics365 data acquisition
Error control when Dynamics365 data acquisition fails

Forms → Dynamics365 data flow processing
Error control when Forms → Dynamics365 data flow processing fails

 

I thought it would not fail to list Dynamics365 records
I was creating Flow without entering the scope.

However, based on this matter, the list of Dynamics365 records can also be included in the scope.
I thought I should catch the error.

I would like to tell you which configuration of the execution conditions of the scope that catches anomalies should be set.
Although “failed to” is always checked,
I'm wondering if I should add "I've timed out".

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,950)