web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Problem to update more...

Power Apps

Unanswered

Problem to update more than one hundred records

(0) Share

Report

Report

Posted on by Nicolas85

2

Hello,

I built an application with sharepoint list datasource.

actually i've 300 records in my list.

I had a problem with a date field and I wanted to add 4 hours to all my recordings.

i built an admin screen with a gallery to list all th items and a button with an update IF to update all the records.

everything is ok except that I have no error message but I notice that not all records have been modified.

When i retry , it's the same but it is not always the same records that are modified. also it's not the same number of records that are be updated.

It's very strange and I am very worried about the reliability of powerapps.

have you already had the problem and have you an idea of how to solve the problem.

I specify that the treatment takes about 2 to 3 min

tks very much for your help

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Nicolas85

Please share your code
Nicolas85 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello,

in my example , i've 171 records in my list but the gallery only show me the first 100 hundred:
When I click on button , here my code. only first 100 worked :

ForAll(Gallery4.AllItems;UpdateIf(DEV_SUIVI_MATIERE;ID=Value(Label5.Text);{TEST:DateAdd(DateTimeValue(Label6.Text);2;Hours)}))

if i scroll down the gallery before , all records (171) seems updated.

I need to update all records, How can I be sure that everything will be updated without having to scroll all data to the bottom?
Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

The gallery only loads 100 items at a time. So "Gallery.AllItems" will only return up to 100 items when it is loaded. As you scroll down past the first 100 it will load the next 100. That is why "Gallery.AllItems" found all 171 items when you scroll to the bottom.

Join the conversation