LinkedIn
Twitter
Hi there
I’ve been struggling, looking deeply in articles and post…cannot get out of this (I suspect I need to take a step back 
)
I want to nest multiple select expression, I cannot get something that make sense in the output.
Here is the expression:
<<Start: SELECT(Employes[Barcode Employe],ISNOTBLANK([Related Fiche_Heures By Related_author][numSemaine]))>> [Nom Employe]:<<[Nom Employe]>> <<Start:[Related Fiche_Heures By Related_author]>> [numSemaine]:<<[numSemaine]>>, [Label_FH]:<<[Label_FH]>> <<End>> <<End>>
I’m OK with the first Start Statement.
In my examples, I’m supposed to get multiple output with the nested statement:
<<Start:[Related Fiche_Heures By Related_author]>> [numSemaine]:<<[numSemaine]>>, [Label_FH]:<<[Label_FH]>> <<End>>
As I can see it in the app, I get this:
But in the output, I get this: (same employee shown here)
If I’m correct, I should see multiple lines with:
numSemaine:14,
numSemaine:15,
numSemaine:16
Do you have a clue on what I’m getting wrong ?
Solved
1 ACCEPTED SOLUTION
So, after investigation and contact with @Oleg_Andrusenko from Support, here is the solution:
-
This is not because I use to see information on top of the View Data panel, that there is no data at all when I don’t see it.
Because of various related children for my entries, I had to scroll dooooooown in order to find the first entry. I could have seen it if I had scrolled on the right end, but because it was after many hours of unsuccessful tries with the nested Start/Select issue, I got tired and forgot the basics Beginner’s mistake !
The tip: look at the size of the scrollbar: tiny, tiny, tiny !
I don’t know if this features already exists, but it could be interesting to displays an alert “no result to show” or something similar. I will look if a feature request have been made about that. -
With the “Test” feature :
Because I wanted to save time on testing, I did not develop the workflow entirely, just firing it with the test button after refreshing, in order to test if my template was correct.
A try/fail method.
The “Execute” button in the Test panel fails to correctly develop nested Start/Select.
That’s a bug, that won’t be fixed if I’m correct.
BUT when I try to fire it on “normal behavior”, which means trigger it from a change on my table, the workflow produces the expected result !
Thanks @Oleg_Andrusenko for suggesting that basic try !
By the way: do someone know another method to test Template structure ?
Once again, thank you all for your help on it !
