web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / the data is a mass!!!
Power Apps
Unanswered

the data is a mass!!!

(0) ShareShare
ReportReport
Posted on by

Hi,

i have the weirdest experience with my app.

i have an excel data source, which the user can update form the app, to add a comment.

when I'm doing the patch the data is not reflected in the gallery although I'm recollecting it right after the patch, but wait this is still not the wired part (or weirdest) .

the excel is updated correctly in timely manner so after I'm refreshing the dataset and run the on start i can see the items but with a -2 items offset i.e. if i updated item #6 i will see it on #4!!!

when checking in the collection view, i can see it is actually collected on the wrong number, seems like there are 2 missing items.

 

this is my formula from the on select:

Patch(
 Table17,
 LookUp(Table17,IncidentIdentifaier=varThisItem.IncidentIdentifaier),
 {
 Comment:TextInput3.Text
 }
);
ClearCollect(IncidentsDB,SortByColumns(Table17,"CreatedOn",SortOrder.Ascending));

i use the am clear collect formula on the app on start

some screenshots:

in the dataset it looks like this:

Perez_0-1708618719532.png

but in then app this how it look like:

Perez_1-1708618972716.png

so my question is:

1. why the data is not refelcted imidiatly on the galley unless im manually refreshing

2. why i have this offset?

 

any idea?

thanks in advance

Eyal

 

 

 

 

 

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 320 Most Valuable Professional

#2
11manish Profile Picture

11manish 210

#3
Valantis Profile Picture

Valantis 167

Last 30 days Overall leaderboard