Error when using split

[YDRDK]

Hi,

I have a flow, where someone is filling out a form that is then approved. Once it is approved I need to use the information from this form to enter information into a different form. I have one field where I need to split the information in order to use it in the new form that I am entering information into.

I got help previously for how to make this split and it works. Now I have had to do some changes to the flow (removing an adaptive card for approval and therefore moving this part of the flow to a new flow), but now it keeps failing. When I test it out it keeps giving me this error:

Unable to process template language expressions in action 'Split_first_2' inputs at line '1' and column '23835': 'The template language function 'split' expects two parameters: the string to split as the first parameter, the separator as the second parameter. The function was invoked with '1' parameter(s). Please see https://aka.ms/logicexpressions#split for usage details.'.

Does anybody know why it does that and what I can do?

Thank you!

Best,

Majken

[Expiscornovus]

Hi @YDRDK,

It looks like it is missing either the string or the separator, because the error says you only have 1.

Can you share a screenshot of your current flow setup and the split expression you are using?

[YDRDK]

Hi @Expiscornovus 

Yes for course.

The expression I am using is this: 

trim(first(split(triggerOutputs()?['body/Project_x0020_ID_x0020_Name']))) - and last in the other one. The "triggerOutputs()?['body/Project_x0020_ID_x0020_Name']" is chosen from dynamic content.

Before I had a adaptive card in where the user should approve some things before this split was used and it worked great in that flow, however the turns out that the adaptive card is not useful in this situation anyways. 

I hope this can help you.

[Expiscornovus · Accepted solution]

Hi @YDRDK,

Your expression is missing a separator in the split function. Normally this would be something like a comma, semi-colon or whatever character you want to use.

In your case the expression would be something like this. Replace the comma by something you want to use.

trim(first(split(triggerOutputs()?['body/Project_x0020_ID_x0020_Name'], ',')))

[YDRDK]

Thank you @Expiscornovus - that worked! 🙂 I must have missed that part of it and I was going crazy because I could not figure out how.

[MTEChris]

I have a similar case, where I need to do a split on a user defined input. The problem is that the user sometimes doesn't  use the delimiter. I've tried the following code but keep getting an error.  Essentially I want to split it if the delimiter is used, but no split if it is not.

if(length(split(triggerOutputs()?['body/subject']))>1,split(triggerOutputs()?['body/subject'],'_')[0],triggerOutputs()?['body/subject'])

Any ideas how to clear it? Thanks!

[VictorIvanidze]

Hi @MTEChris,

try this:

if(contains(triggerOutputs()?['body/subject'],'_'),split(triggerOutputs()?['body/subject'],'_')[0],triggerOutputs()?['body/subject']) 

[MTEChris]

That worked! Thanks @VictorIvanidze for the help!