Unanswered

The template language function 'split' expects its first parameter to be of type string. The provided value is of type 'Array'

(0) Share

Report

Posted on by Nikhil2

522

I have a flow which should get the number from the Filter array and exclude string 'Quote number', but i get the error message of the type string.

Compose QuoteNumber

split(split(body('Filter_array'),'Quote Number - ')[1],'Kind Regards')[0]

Compose - to Remove whitespace

trim(body(QuoteNumber))

InvalidTemplate. Unable to process template language expressions in action 'Compose_-_QuoteNumber' 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 'Array'. Please see https://aka.ms/logicexpressions#split for usage details.'.

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (0)

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report
Hi @Nikhil2

Pls try the below expression for Compose QuoteNumber:

last(split(body('Filter_array'),'Quote Number - '))

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Nikhil2 522 on at

Like (0)

Report

@ManishSolanki I have tried the above expression but still shows the same error message.

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report
Hi @Nikhil2

Pls try the below one, ignore the previous one:

last(split(first(body('Filter_array')),'Quote Number - '))

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Nikhil2 522 on at

Like (0)

Report

@ManishSolanki Some how I get the complete value instead of number. But I need to only digits and no string.

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Nikhil2

Pls use replace() function to replace 'Quote Number - ' with empty string ('') in the output of compose action to get the digit part.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Nikhil2 522 on at

Like (0)

Report

@ManishSolanki I am using the expression in compose - Replace
replace(outputs('Compose-QuoteNumber'),'Quote Number - ','') but somehow it is same result

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report
Its working for me:

replace(outputs('Compose-QuoteNumber'),'Quote Number - ','')

Output:

Thanks

Was this reply helpful? Yes No
Nikhil2 522 on at

Like (0)

Report
@ManishSolanki Somehow I still end up with same issue, I have a filter array on top of compose quote number in the OutPuts I get the Quote number but how come it still passes the complete value and not replacing the string.

Filter Array: I get the email of the body. (HTML to Text)
item() contains Quote Number

Compose quote number:
last(split(first(body('Filter_array')),'Quote Number - '))

Compose - Replace
replace(outputs('Compose-QuoteNumber'),'Quote Number - ','')

Was this reply helpful? Yes No