Power Apps Number Sequence function + ForAll, Concat, Date Times, and strings

In this video, you will learn how to generate a table of numbers using the Sequence function. Then after covering the basics we dive into how to use sequence with dates, text, random numbers, controls, ForAll, Concat, LookUp, Patch and more. Lots of little things in this video.

[antoniomartinezjurado]

Thanks so much, Shane. You're still my hero. Your videos are allways my lifeline.

[michaeldeabreu]

Recently built an app where I needed to calculate 4 hours worth of 1 min intervals. While I got it to work using quite a large ForAll statement this would have been 10X faster... Thanks for the great share Shane.

[marcsavoie]

Again, really nice video. The sequence() function is really neat. I'm using it with the trick you showed with patching multiple records in a data source through a gallery. User picks a number (n) and n numbers of lines are generated in the gallery. The user can then type in the data and finally patch the datasource only once.

Thank you!

[GrittyDuckGrin]

Great video sSane you are a true power apps genius

[AssassinUK]

Nice, using 'Sequence' to update my 2001+ record grab code. Technically speaking I can now bring in a max of a 100, 000, 000 records into an app.... but if that was a requirement for an app, I'd have to really sit down with the customer and find out what was wrong with their life! 😂

[pedroeleftheriou]

thank you Shane for another session of valuable tips!

[sitanshugurung]

Thank you Shane.. your videos are great!!

[Excel-power-users]

Nice tutorial Shane. How to generate unique random 10 numbers(no repetition) between say 1 to 20.

[jonathanwatkins]

Thanks Shane! As always, very helpful video! I was able to use this to make a collection of A-Z with their associated Char Values! Very helpful for my app. :)

Clear(Alphabet);ForAll(Sequence(26, 65, 1), Collect(Alphabet, {Letter:Char(ThisRecord.Value), Number:ThisRecord.Value}))

[shane]

This is super interesting, Thanks Shane!

[franknielsen]

Liked the old background better than this blue one :)

[alisSpace]

In my power app, I have a multi screen form that I need to be able to number the questions on the datacards automatically. Right now, every time the customer wants a question added/removed, I have to rename the SharePoint List columns and reset my forms. Is there a way to do that?

[vanessacalalang]

Hi Shane! Thank you so much for all your awesome guide. Really appreciate it!
Do you have a trick in using sequence and for all function when I set recurring meeting? I'm creating a calendar app and I want to have a recurring functionality to book meeting daily, weekly and monthly? Also I need to be able to patch/ edit the sequence booked and be able to delete. I also need to be able to check for duplicates to ensure no one can book for the time range that's already booked. Any tricks please? Thanks!

[cornerstone]

Question.. Can you add a column that looks at the choices of another column and assigns that column a number value in MS Lists?

[samitbhattacharya]

Hello Shane ! I am new to Power apps and struck in an issue. There's single column collection having 3 rows and a text box. I want to store value of text box(constant), 1st value, 2nd value and 3rd value from collection in a SharePoint list. I know this can be done ForAll function but unable to move further. Hence your help.
Thanks

[Shorts_Newspaper]

how put text and number value togther in form (like vehicel number we want to define)

[cvkealey]

Hey, Shane, do you know if there's a way to do a "reverse sequence" and append a text value to that list? I'm creating an app with a "class year" field (combo box) and need the Items to be "N/A, 2027, 2026, 2025...<continue counting down to>...1940". I figured out the descending part by putting the sequence into a variable on screen visible, then wrapping it in a Sort formula, but I can't figure out the syntax to add a text value. I'm trying (in the Items property): ["N/A", Sort(varClassYears, Value, Descending)], but it doesn't seem to like adding the (array) variable as an item.

[rkaji]

Shane, good night. I would like to know if you could guide me in making a simple sequence from 01 to 30 (for example), that would be with two characters, so that when you sort, the sequence of will not appear: [0, 1, 10, 11, 12....18, 19, 2, 21, 22, ...]

[larryheimendinger]

My scenario is for a collection of a variable number of rows each of which will PATCH DEFAULTS as new rows in a data source. On of the data source columns is SEQNO a numeric field such that the record for row number of the collection will be the value of SEQNO, row 1 is 2, row 2 is 2, etc. I have a FORALL that operates on the collection. I created another collection {SeqNo:0} and tried to PATCH First(colseqno), {SeqNo: SeqNo+1} inside the FORALL, don't get a formula error, but if I use that for a button to test, SeqNo+1 throws an error. Is SEQUENCE() a solution to this problem? I understand how to create SEQUENCE() based on COUNTROWS(colitems), but then how can I get the SEQUE{NCE() value that corresponds to the collection row number for the items? That is the value I need to use in the PATCH to create new rows.

[brightonalbert]

thanks Shane can we use sequence in dropdown by showing the number in text for example 1 " Jan - Mar ".