Errors in Split function

(0) Share

Report

Posted on by vas1969

I keep getting an error with this

split(item()?['Tools'],';')

The error I get is this.

Unable to process template language expressions in action 'Select_Tools' 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'.

I can't understand it

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report

Hi @vas1969,

Null error normally means that the Tools field of the current item is empty. If this is the case the split function will result in this type of error.

This is either caused by the Tools field value actually being empty or that the reference in the expression you used to that field is incorrect (It can be nested within another field for example).

Have you double checked if the Tools field of the current item is empty?

Was this reply helpful? Yes No
RobotRising 402 on at

Like (0)

Report

Hi Vas,

That error means the value you are trying to split is blank.

The dynamic content for "tools" is empty so the split function has nothing to split.

You can use a filter action to filter out blanks or alternatively use a condition to check if the field is blank before splitting it.

You could also start at the trigger and only get items where tools is not blank or at data entry make sure that the field is required so that tools field is never blank (fill it with a default value as well)

Was this reply helpful? Yes No