Answered

Moving Gallery Items only works if ID is greater

(0) Share

Report

Posted on by dfarrar

Hi all!

I have a gallery that I have added up and down arrows to to facilitate shifting the order. The gallery is a collection from a Sharepoint list. On the up arrow's OnSelect I have:

Select(Parent);Set(previousRecord,LookUp(KeyAreaOrder,Order=ThisItem.Order-1));Set(currentRecord,LookUp(KeyAreaOrder,Order=ThisItem.Order));Patch(KeyAreaOrder,ThisItem,{Order:previousRecord.Order});Patch(KeyAreaOrder,LookUp(KeyAreaOrder,Order=currentRecord.Order),{Order:previousRecord.Order+1});Set(previousRecord,Blank());Set(currentRecord,Blank())

The first number column is the 'Order' column and the second is the ID

It works if the ID of the selected item is greater than the one above it, but not if the ID is less than.

Any ideas?

Thanks!

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @dfarrar

ItemOrder = Order Column in my SP list

Select(Parent); Set( currentRecord, LookUp( 'Key Aisle', ItemOrder = ThisItem.ItemOrder ) ); Set( CurrentItemOrder, currentRecord.ItemOrder ); If( CurrentItemOrder > 1, Set(PreviousId, LookUp( 'Key Aisle', ItemOrder = currentRecord.ItemOrder - 1 ).ID); Patch( 'Key Aisle', ThisItem, {ItemOrder: currentRecord.ItemOrder - 1} ); Patch( 'Key Aisle', LookUp( 'Key Aisle', ID = PreviousId ), {ItemOrder: currentRecord.ItemOrder} ); ); Set( currentRecord, Blank() )

Sample

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.
dfarrar 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @StalinPonnusamy
That has worked, but I also want to change the order number for the record above so that I don't end up with multiple records with the same order number.