I have easily looked this formula up on your website 50 times. About time this got its own article plus video! I wish you lots of success on your UA-cam journey!
I did the exact the same. This seems no longer works in PowerApps since Value returns table values :( I would be grateful if there will be any update on this.
For me Once I write it (which I re-checked multiple times for any typos) It displays an empty gallery and says we didn't find any data (Was trying to number the sample accounts table)
I am trying to count the number of occurrences of each item in a PowerApps Collection. SharePoint List Name: Product Desired Result Fruit Number of Occurrences Apple 1 Orange 1 Apple 2 Banana 1 Orange 2 Apple 3 Banana 2 Banana 3 Watermelon 1 Apple 4 I don't want to group these. I want to display every record in the collection with the number of occurances of each item
Dataking, you will want to group the items and then do a row count of the groups. It will not be possible to avoid the delegation warning using the Power Fx language.
It would be helpful if you had zoomed in a bit so that we could clearly see what you had typed in. For beginners, it can be challenging to understand or remember this formula just by saying it verbally.
@@matthewdevaney3912 Иногда, когда люди оставляют мне комментарии, мне приходится использовать Google Translate, когда люди используют другие языки, потому что английский - это все, что я знаю. Затем мне нравится использовать тот же инструмент, чтобы отвечать на их языке. Я люблю это.
Great tip Matthew, the only change i would do to make it look cleaner is replacing Last FirstN with the new Index function.
Agreed. I wish I thought of it!
I have easily looked this formula up on your website 50 times. About time this got its own article plus video!
I wish you lots of success on your UA-cam journey!
Hahaha. I personally think the article is more useful. But the video will help in Google Search rankings.
Great and simple Matthew! Thank you!
Thank you Matthew, this was quick easy and very good.
Thank you so much, i was searching for simple pagination to tell the users there are still items in a gallery controller ,finally you made my day
You are welcome!
OMG! THANK YOU! - I have seen crazy complicated ways to do this, and now here it is, a simple way that really works! TYSM!
Simple is my middle name. Matthew "Simple" Devaney. Hey, wait a minute. No its not...
Another great tip. Thanks, Matthew
Thanks Olu 😊
EXTREMELY HELPFUL! Thank you Matthew!!!
Epic Biz Hero, I like your name!
Thanks@@matthewdevaney3912!!!
Matthew, great video, thanks. I'm trying to figure out how to combine your code to generate row numbers and sorting of the collection. Can you help?
Brilliant, thank you Matthew!!
You are an actual magician.
And one cool cat 😎 🐈⬛
I did the exact the same. This seems no longer works in PowerApps since Value returns table values :( I would be grateful if there will be any update on this.
Hi, it worked for me creating a row number in my collection but now I am getting an error on my Remove(CollectionName, This Item). :(
Thanks Matthew!
Thanks a lot it works sir!
hey Matthew How To remove item in gallary ?
Hey Matthew, Can you please suggest how to do a full outer join using collections.Thanks!
You can find a post about it here on my website here:
www.matthewdevaney.com/powerapps-collections-cookbook/join-all-columns-from-another-collection/
fantastic! Thank you
Tu es un génie qui fait tout ça en moins d'une minute. Tous les Canadiens parlent français, n'est-ce pas?
If you didn’t use Google Translate, this is is impressive Darren.
Thank you Matthew
For me
Once I write it (which I re-checked multiple times for any typos)
It displays an empty gallery
and says we didn't find any data
(Was trying to number the sample accounts table)
Me too! Did you find a solution?
Hi mat, ive read your blog on ranking, but is there a way that we can rank based on value and category?
No way do it that I know about
I am trying to count the number of occurrences of each item in a PowerApps Collection.
SharePoint List Name: Product
Desired Result
Fruit Number of Occurrences
Apple 1
Orange 1
Apple 2
Banana 1
Orange 2
Apple 3
Banana 2
Banana 3
Watermelon 1
Apple 4
I don't want to group these. I want to display every record in the collection with the number of occurances of each item
Dataking, you will want to group the items and then do a row count of the groups. It will not be possible to avoid the delegation warning using the Power Fx language.
It would be helpful if you had zoomed in a bit so that we could clearly see what you had typed in. For beginners, it can be challenging to understand or remember this formula just by saying it verbally.
Lesson learned for sure. These were some of my first videos ever. I'll try to find a way to zoom in the next time.
Nice ! Good job.
😎
Very good :)
Круто, спасибо!
What does this say?
@@matthewdevaney3912 cool / awesome)
@@matthewdevaney3912 Иногда, когда люди оставляют мне комментарии, мне приходится использовать Google Translate, когда люди используют другие языки, потому что английский - это все, что я знаю. Затем мне нравится использовать тот же инструмент, чтобы отвечать на их языке. Я люблю это.
Thank you VOLTRON!
Every text I send you will now be in Webdings Darren.