PowerApps Tracker App including Add row numbers to a gallery

[@StevenGillenwater]

Hello Shane, when using the AddColumns(DropColumns code powerapps now returns an error stating that the dropped column already exists. Is there a workaround for this?

[@andycreigh]

Every time without fail Shane your videos have the solution I'm looking for!! Thankyou

[@ShanesCows]

Thanks 😊

[@hyperlance]

Thanks Shane, I've been getting frustrated with doing something like this all day and this works brilliantly.

[@ShanesCows]

Awesome possum!

[@justindavid8401]

Hi i am encountering problems with the code on the final submission button what would be a alternate way to write the rows backs to one record on SharePoint

[@justindavid8401]

Thanks for the video i am stuck on the final patch though I am unable to patch the collection to the list what would be my other option ?

[@moseszaman9273]

Shane the man! Thanks. Such a simple thing but such a complex solution. Standard Microsoft.

[@ShanesCows]

Glad to help

[@kishorec1117]

Finally I think I can add colors to my gallery rows based on current data...fingers crossed ..great help, thanks.

[@ShanesCows]

Glad it was helpful!

[@powerappstw]

it's really awesome and helpful, every time I watch your video, makes me progress a little :)

[@ShanesCows]

Awesome 😎

[@alexanderr2688]

Awesome, I was expecting a video about row numbers! Thanks Shane. PS I haven't checked yet if this will be working for dynamic filter, for example, I have a gallery with searchable items

[@ShanesCows]

You can add row numbers to any collection no matter how you get it.

[@mariyaleepnaretchakar519]

Thanks Shane for this video, But i have a query like i want to display the decimals in consistent way fr ex 1.) 23 means it should show 23.00 in text label if it is fr 29.13 that is fine i used round function if you help me on that that would be helpful

[@Ballistik3]

Thank you for the video. Do you have any tips/suggestions on how one would be able to re-sort a numbered collection in a gallery? For example, instead of having the row number displayed as a label, having it appear as a dropdown where a user could select another number and trigger the entire collection and gallery to re-sort? Say you change Row "3" to "1", and it would automatically change Row "1" to "2" and "2" would change to "3"? Thank you!

[@ShanesCows]

We have done it for customers. The key if you have to write if logic to account for and find all of the scenarios. It isn’t trivial. The key is to solve tiny problems one piece at a time. If you change 3 to 1 then you need to save that. Then you need to get everything after 1 and increment their value by 1.

[@marney720]

hey Shane, instead of the drop down with the two choices (chewy and Ferguson), how would you use entries from a SP Person column please? (column is already populated with users). Cheers!

[@qwertyytrewq8796]

Hello mr. Shane I am looking for way to connect two smart phons without using net for example, Farmer who work at farm need to prove the time attend, so if the boss has powerapp application on his phone which receive signal from worker’s phone to prove attendant time So can you help me to make this app Thanks

[@ShanesCows]

I don't think I know how to do that one. :(

[@qwertyytrewq8796]

@@ShanesCows ok now , I am looking for trigger concerns to Location like” When I enter or exit an area” which was availabel but now is not on the triggers list at power automate. So please helpe

[@wendymason3263]

Great video Shane, let me assure you that grown up boys never stop make those sounds too!! 😉

[@ShanesCows]

😂

[@jasonholland83]

Hello Shane, I have been searching for an answer for this and no one online has explained it or even know the right way to do. Have a download button linking to your SharePoint Library that downloads a spread sheet once clicked.

[@ShanesCows]

I haven't done it but there is a Download function in POwer Apps and an item in a doc library has a link. So in theory should be posssible.

[@abbgtpopkipog]

Hello Shane, do you happen to have any tutorial based on internal company delivery tracker. The idea is for the business to monitor the merchandise movements through AWB's or through own fleet where the drivers will be given the smartphones and the recipient will have the smartphones (with access to powerapp) as well to receive. (kind of like Amazon Shipper/recipient transaction)

[@ShanesCows]

kzbin.info/www/bejne/foW8aXSkgt9oqNk This video covers inventory check in and out. THat is about at close as I have gotten.

[@louismartini6983]

Very Cool! Do your kids have any room left on their mobile devices for like games or are all their icons Shane Young Apps?

[@ShanesCows]

This is the first of hopefully many. 😂

[@TheToni2123]

thx Shane. I don't have an idea yet, but I'm looking forward to it when I need it

[@ShanesCows]

Awesome

[@debbiewilliams3799]

I spent a day tearing my hair out over an issue that you resolved in less than 5 minutes. I should know better and check with you first!

[@ShanesCows]

Glad it helped Debbie. 😀

[@RobFahndrich1]

Great Video Shane! One thing I missed was how do you apply alternating colors in your galleries to the odd/even rows? Thank you!

[@RobFahndrich1]

I think I figured it out I set the TemplateFill property of my gallery to this: If( Mod( ThisItem.row, 2 ) = 0, White, LightGray )

[@RobFahndrich1]

For fun, I tweaked it a bit more to show which item you have selected If( ThisItem.IsSelected, Cyan, If( Mod( ThisItem.row, 2 ) = 0, White, LightGray ) ) Thank you Shane for this tip on the row numbers. This is great!

[@ShanesCows]

Good job Rob and boo me for not sharing if I forgot.

[@Hdghhdjsjsj8800]

Nice video sir. Sir how to repeat label that contains some text while click on button repeatedly??

[@ShanesCows]

Set it in a variable? Not sure.

[@Hdghhdjsjsj8800]

How to display different text/data in same gallery while click on different buttons. Can anyone tell me please?

[@ShanesCows]

Hard to make one gallery work with two different data sources. You could have two galleries and only show the 1 gallery that you want.

[@paulgreen2372]

Great little trick to add the row numbers and be able to remove and then add others and it recounts everything, I tried to use this to capture a list of Actions from an Audit review, which worked really well until I wanted to go back and edit that list of actions, I tried to use all the same that you had originally but it appeared as I was getting the data from a saved datasource it already had the row column, which it complained about. I tried pulling the data from the saved datasouce into a collection and then removing the row column, but it just didn’t want to play. Any thoughts on how saved data could then be edited and still retain the neat trick of updating the row values?

[@ShanesCows]

Hey Paul. I would think when you are editing you would not renumber, only when adding or subtracting.

[@Alex-sl8vs]

Hey Shane, love your videos about PowerApps, making my life a whole bunch easier! I got a question about attaching files in a form, is it possible to have something like drag & drop there?

[@ShanesCows]

Not that I know of. 😑

[@Alex-sl8vs]

@@ShanesCows Alright, thanks for this quick answer, appreciate it 👍

[@josecarlosbenitezmeyer645]

Hi Shane, I just Watch it, great video, I have the need of get the average scores made bu different user, in 3 moths, any ideas. I have a list with 75 récords, with duplicated users, I need to get the amount of users and it averages scores in 3 months

[@ShanesCows]

Check out this video using flow. I think it would be an option for you to calculate things kzbin.info/www/bejne/jGK3mXSCltupnJI

[@josecarlosbenitezmeyer645]

@@ShanesCows I have, it has help me, but my varavgwag doesnt increase, so the avg isnt correct 🥲

[@josecarlosbenitezmeyer645]

​@@ShanesCows You're the MAN. Thanks

[@deepthikj-ui5iu]

I am getting error while coping from tempcollection to actual collection

[@deepthikj-ui5iu]

Incompatible type ... Do you know where I am going wrong

[@otitoexcelomeje3498]

I had the same issue, but I later found the 2 places where the error was from: I wrote the code in the wrong property and I had mismatched data types between the two collections. I hope you were eventually able to fix yours too.

[@shaantoshholaay3310]

Wel done Sir. Superb session

[@ShanesCows]

Thanks! 😎 🐶

[@avinoamrothenberg1244]

Great video (as usual 😁). You've got me challenged now - I MUST understand the "row count magic" (I've been struggling with this for ages...). One thing I'm still confused about, is - what's the difference between "With" and "UpdateContext"? 🧐

[@ShanesCows]

With is only for that instance of that function. UpdateContext is available throughout the screen.

[@jasonholland83]

Here is a good one. Can you make a ticket tracker? Meaning, after a user submits a form they get a ticket number to track the status

[@ShanesCows]

Sorry for the delay. I wonder if the Deep Linking vidoe would give you an idea. kzbin.info/www/bejne/d2azmmiGZ75-mtU

[@amyclapp8457]

This is great Shane! But...what if you have a collection that displays in a gallery with a filter (for example filter by job number) and you want the row numbers to number within the correct job number. The numbering works across all job numbers but if I add a filter or If statement in that forall code, it breaks.

[@Benaxley]

Change the onchange action of the filter to run the forAll statement again with the new filtered collection

[@masterkin]

Thanks Shane for this awesome video. I have a query to the ForAll function, based on the document, records can be processed in any order, and may be in parallel. I used that functions many time with small collection, the processing seems sequence and in the same order of the collection. Due to the unsure behavior of this function, I always assume it may run in parallel or in any order. In your video example, to update the row number column based on the occurrence of the record in the collection, I think it can be done likes this. ForAll(Sequence(CountRows(colJuggles)), Patch(colJuggles, Last(FirstN(colJuggles, ThisRecord.Value)), {row: ThisRecord.Value}))

[@ShanesCows]

Thanks for sharing!

[@frenske2002]

Hi Shane, great tips again! Thanks! I was just wondering, why do you use the code below, I can't seem to figure out why. First you collect all the items into a collection and then cleared it right away Collect('Juggle Tracker Details', colJuggles); Clear(colJuggles); You don't use it in the rest of the code

[@ShanesCows]

You have it backwards. :) Collect('Juggle Tracker Details', colJuggles);

[@frenske2002]

@@ShanesCows That makes sence! Just me reading it wrong! Thanks for the clarification

[@JD-lx3cx]

That is awesome! ForAll statement usage here is a little bit inefficient, but for a small set of data, it is not problem.

[@ShanesCows]

🐶 Thanks

[@jimhoeger5232]

I agree, just don't use this on large collections. I tried this on a collection of 1300 items and it takes about a minute to populate the row numbers.

[@zero2herobeatspaul882]

I'm going to use this to track the number of formulas I add/edit in my app without errors. :-)

[@ShanesCows]

Awesome!

[@FelipeSilva-wr2mm]

Very nice trick, but for some reason stoped working and I don`t how why. My gol is to get the itens from a CDS table e calculate the row number. This is the first part that is not working any more. ClearCollect( NItens; Search( PedidosItems; PedCodIdValor.Text;"crcf7_pedcabcodi" ) );; ForAll( NItens; Collect( TempNItens; Last( FirstN( AddColumns( DropColumns(NItens;"Rows"); "Rows";CountRows(TempNItens) + 1 ); CountRows(TempNItens) + 1 ) ) ) );; ClearCollect( NItens; TempNItens );; Clear(TempNItens)

[@louiscutmore]

Very kool stuff!

[@ShanesCows]

You are very cool. Thanks as always Louis. 🐶

[@brentgoeller8257]

Update to Power Apps!!! You no longer put quotation marks around the column name in AddColumns or DropColumns.

[@ShanesCows]

Thanks Brent. Yeah, they changed that. Great for new people, stinky for old content. 🙃

[@brentgoeller8257]

@@ShanesCows I probably spent 2 hours troubleshooting before I finally figured that out.

[@thezeppo]

I have a trick for row numbers without collecting... and I hope I haven't butchered it by taking out the specific stuff - adapted from something I found online a while ago: AddColumns( GallerySource, "RowNumber", CountRows(Split(First(Split(Concat( GallerySource ,UniqueColumn(eg ID), "|"), UniqueColumn(eg ID))).Result, "|")) )

[@ShanesCows]

Thanks for sharing Ben!

[@sundrapillay6668]

Thanks Shane

[@ShanesCows]

Happy to help. Have a great day Sundra!

[@richardclowes6166]

talented kids!

[@ShanesCows]

Thank you. Sitting at practice watching one of them now. Hard work pays off. 😍

[@MehrdadOrdoukhani-sd1iv]

PowerApps is like playing piano with two long broom sticks.

[@gerfer6261]

🕶

[@ShanesCows]

😎

[@petrinnn]

nooooo waaaayyyyy

[@ShanesCows]

WAYYYYYYYYYYYYYYYYYYYYY! 😂

[@khargos7602]

Ummm... I'm gonna need to watch this one again. 🥸 OK I GET IT NOW! 🤯