Forall on collection

[IrnBruMuffin]

Something I feel is so simple is the reason I cant find an answer for so please bear with. 

I'm writting an email with HTML and within the HTML I want to write every item I have stored in a collection 'colToWrite'. This collection is dynamic and variable in size so I cant use Last and run through a certain amount. 

Cant I use Forall here? "This is the body of text, here's the list"& Forall(colToWrite, allItemsInColumn) &" -list"

[dinusc · Accepted solution]

Hello,

You should be able to use ForAll formula. Please note though that ForAll returns a table so you will also have to use something like "Concat" function in order do create a text value:

Concat(Forall(colToWrite, allItemsInColumn), Value & "")

See more information on Concat function here: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-concatenate

[v-micsh-msft · Accepted solution]

The below blog could be a good reference for you:

Html Email reporting with tabular Data

Especially for the Formatting the Collection Data Part.

Regards,

Michael

[v-micsh-msft]

Hi @IrnBruMuffin,

Do you need any further help on this topic?

Regards,

Michael