Iteration and Loop Expressions Is there some...

(Colin) #1

Iteration and Loop Expressions

Is there someway to build and use an expression for iteration/looping please?

For example something programatically like a statement for:

FOR 1 to 100 DO WHILE (condition = true) or DO UNTIL (condition = true)


(Aleksi Alkio) #2

Not directly, but would you please explain your user case little more… so it would be easier for community users to find out the answer, thanks.

(Steven Coile) #3


(Marc Dillon) #4

Start expressions can kind of be used as loops. Only usable in workflows. - Template Start Expressions Template Start Expressions

(Colin) #5

@Aleksi_Alkio I have a need to concatenate a text where I am looking for a list of authors who are working on a document from a table of assigned documents.

For example:

KeyID Full Name

Document_Name 1

Selma Lane

Proposal 2

Abram Waller

Proposal 3

Concepcion Collier

Proposal 4

Freda Crane

Proposal 5

Hilda Mathews

Proposal 6

Micah Meza

Proposal 7

Selma Lane

Report 8

Concepcion Collier

Report 9

Freda Crane


What I want is to put in a text string all those who are authors on the Report, i.e:

Selma Lane, Concepcion Collier, and Freda Crane

How can I do this please?

(Aleksi Alkio) #6

Okay… this is not the Loop case. You can do that with the formula TEXT(SELECT(TableName[Full Name],[Document_Name]=“Report”))

(Colin) #7

@Aleksi_Alkio Well, I’ll be… It works! Thanks!

I did try to see if there is any online help for TEXT(), but there is none I can currently see: - Search results for: text

nor in:

Text Expressions

Column Value Expressions

Other Expressions

Do you have some other possible link that explains how TEXT() works please?

Search results for: text

(Aleksi Alkio) #8

That’s true, TEXT() seems to be missing from the documentation. We will fix that. Thanks for this!

(Steven Coile) #9

CONCATENATE() would also work in place of TEXT().