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

Notifications

Announcements

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard