How can I create a Sequence for gallery items that will get updated everytime an item is added or removed?

(0) Share

Report

Posted on by Robert94

520

This is how the gallery looks like.

Add new row code:

Patch(S2T1_MeetingAgenda, Defaults(S2T1_MeetingAgenda), {Title:"", AgendaItem:""});
Collect(colMeetingAgenda, Last(S2T1_MeetingAgenda));

Remove item code:

Remove(S2T1_MeetingAgenda, LookUp(S2T1_MeetingAgenda, ID = ThisItem.ID));
RemoveIf(colMeetingAgenda, ID = ThisItem.ID);

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

subsguts 1,259 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I would read this solution and see if that gets you pointed in the right direction. Sounds like they were doing something similar to what you want to do.

Solved: Re: Numbered Items in a Gallery - Power Platform Community (microsoft.com)

Let me know if this helps, or if this leads to more questions. Thanks.

Was this reply helpful? Yes No
Mayuresh_Joshi 54 on at

Like
a
(0)

Report
Copy link

Link copied!

Please refer below article:

http://powerappsguide.com/blog/post/generating-row-numbers

You need to add a column in your collection as "RowNumber" and use ThisItem.RowNumber as sequence column

Was this reply helpful? Yes No
subsguts 1,259 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

I think the problem is that when you remove a row, how will the collection get renumber? I think you'll have rebuild the collection each a user hits the "remove" button. Thoughts?

Was this reply helpful? Yes No
subsguts 1,259 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Researching this some more, I found an old post that Randy Hayes discussed with another person. I think it will be helpful and it does talk about the issue of having to reload the gallery when data is changed. Hopefully, this will give you the info you need to get your solution working. Randy's very knowledgeable, so I'll let this post to the talking 🙂

https://powerusers.microsoft.com/t5/Building-Power-Apps/Renumbering-Unique-IDs-when-item-is-deleted-in-a-Gallery/td-p/1771232

Let us know what works for you and provide examples please. I learn from reading this stuff, it's why I spend time trying to answer them as well 😉

Was this reply helpful? Yes No