Unanswered

Threshold as 3000 for "Get files" in Power automate

(0) Share

Report

Posted on by jyotiRajpurohit

Hi Team,

I have on pagination and set threshold maximum 3,000 in "Get Files" in power automate to have 3000 files. but I noticed strange behavior, I am getting around **3065** files.
also tried with top count as 3000 but still getting same count of files.

I don't understand why am i getting 65 files extra ?

I also did exercise with different count.

Threshold 1000 + Top Count 1000 = 1065
Threshold 1000 + Top Count nothing = 1065

Threshold 2000 + Top Count 2000 = 2065
Threshold 2000 + Top Count nothing = 2065

Threshold 3000 + Top Count nothing = 3065
Threshold 4000 + Top Count nothing = 4065
Threshold 5000 + Top Count nothing = 5065

and for **example** if keep threshold as **5000** in this condition also it takes 5065 files and it fails in apply to each

Could you please help me in this.

Categories:

General topics

All responses (8)

Answers (0)

Sort by

CFernandes 8,504 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @jyotiRajpurohit

When Power Automate executes the SharePoint “Get Items” action, it will call SharePoint and fetch 100 items. If we define the threshold as 5, Power Automate will fetch the data once and get 100 elements so it won’t discard the other 95 items. The same with 102, where it will fetch twice and return 200 items.

If you want to have a specific number of records, you should use the “Top Count” parameter if available.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.
jyotiRajpurohit 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CFernandes
I have added all conditions. I tested with different count.

I noticed. there is no use of top count.
Threshold 1000 + Top Count 1000 = 1065
Threshold 1000 + Top Count nothing = 1065

Threshold 2000 + Top Count 2000 = 2065
Threshold 2000 + Top Count nothing = 2065
same goes on....
CFernandes 8,504 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@jyotiRajpurohit

No need to Add Threshold or Turn on Pagination.

Just add Top 1000. I did a test on my end and I get correct results.

.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.
jyotiRajpurohit 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CFernandes Have to tried with "Get Files" ? with Document Library
i set up top count 2000 and got 401 items only and my folder "Copy Outdated Document" has 5000 items.
there is issue with Get Files.
Could you please try with get files ?
CFernandes 8,504 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @jyotiRajpurohit

I will try to test today evening - In the mean time can you please remove the filter Query and Try?
jyotiRajpurohit 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes sure
I tried filter query for "ContentType ne 'Folder'" because if i don't add content type it will give the counts for folders.

OR

with no filters
jyotiRajpurohit 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CFernandes
any updates?
CFernandes 8,504 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @jyotiRajpurohit

Sorry, I could not get back to you earlier. I am swamped with work.

That being said - I did a quick test and it returns be correct result - See screenshot below -

In Edit Mode -

Power Automate Output after TEST -

That being said if you are confident that the problem is indeed there, please open a Ticket with Microsoft and they will be able to assist you further.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.