Marcel Lehmann

learn and find tipps & tricks around the powerplatform

PowerApps Tracker App including Add row numbers to a gallery from Shane Young

With this formula you will save a lot of time and nerves. Because you can easily add the current row numbers to any collection (or via patch also data table). Watch this video.

ForAll (XY,
Collect (tempCollection,
Last (FirstN(
AddColumns (
DropColumns ( XY, row ),
“row” , CountRows (tempCollection)+1),
CountRows (tempCollection)+1)),
ClearCollect(XY, tempCollection),
Clear (tempCollection)

You can see this video here on my blog because I have rated this video with 5 stars in my Youtube video library. This video was automatically posted using PowerAutomate.

Published by

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: