Concat + Split + Disregard Null Values

(0) Share

Report

Posted on by notepadapp

143

Hi,

I have a sharepoint choice column which I would like my flow to show the values in an email body on seperate lines concatenated with "- [ ]" before the value.

My statement is as follows:

concat('- [ ] ', split(triggerOutputs()?['body/column/Value'], ',')[0])

My error is that if there are no values (null) it gets stuck. Is there away to ignore/disregard null values?

InvalidTemplate. Unable to process template language expressions in action 'Send_an_email_(V2)_-_Accounts_Ticket' inputs at line '0' and column '0': 'The template language function 'split' expects its first parameter to be of type string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#split for usage details.'.

Output should look like:

- [ ] Value 1
- [ ] Value 2
- [ ] Value 3

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @notepadapp ,

Please try:

if( empty(triggerOutputs()?['body/column/Value']), triggerOutputs()?['body/column/Value'], concat('- [ ] ', split(triggerOutputs()?['body/column/Value'], ',')[0]) )

Best Regards,

Bof

Was this reply helpful? Yes No
notepadapp 143 on at

Like (0)

Report
Copy link

Link copied!
Still getting the error:
Unable to process template language expressions in action 'Send_an_email_(V2)_-_Accounts_Ticket' inputs at line '0' and column '0': 'The template language function 'contains' expects its first argument 'collection' to be a dictionary (object), an array or a string. The provided value is of type 'Null'.'.
Is it possible that it's looking a t column called '0', which would be wrong?

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @notepadapp ，

Please try:

if( empty(triggerOutputs()?['body/column/Value']), ' ', concat('- [ ] ', split(triggerOutputs()?['body/column/Value'], ',')[0]) )

Best Regards,

Bof

Was this reply helpful? Yes No
notepadapp 143 on at

Like (0)

Report
Copy link

Link copied!

Thanks, it is no longer failing, however now no result is given and there are values within the column.
It doesn't add the "- [ ]" either

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @notepadapp ,

You could try:

if( empty(triggerOutputs()?['body/column/Value']), '- [ ]', concat('- [ ] ', split(triggerOutputs()?['body/column/Value'], ',')[0]) )

Best Regards,

Bof

Was this reply helpful? Yes No
notepadapp 143 on at

Like (0)

Report
Copy link

Link copied!
Output is now
- [ ]
Without any values 😞

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @notepadapp ,

Cause there is no value in triggerOutputs()?['body/column/Value'] , what do you want it be if triggerOutputs()?['body/column/Value'] is null.

Best Regards,
Bof

Was this reply helpful? Yes No
notepadapp 143 on at

Like (0)

Report
Copy link

Link copied!

Nothing, however the example I'm working with has 8 values that don't display 😞

Was this reply helpful? Yes No
Verified answer

notepadapp 143 on at

Like (0)

Report
Copy link

Link copied!

Thanks I managed to so it out for myself. As it was an options column I initizied a string variable and put all the values together.

Was this reply helpful? Yes No