Gallery5.Y + If(
LookUp(
colItems,
MainItem = Gallery5.Selected.Value
).RowNumber = 1, //Replace with ID if you have a SPList
0,
LookUp(
colItems,
MainItem = Gallery5.Selected.Value
).RowNumber * 35 //find the value that works best for you
)
Distinct(colItems, MainItem) //replace colItems with your Data
Filter(colItems, MainItem = Gallery1.Selected.Value)
WarrenBelz
146,631
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,991
Most Valuable Professional