Select step failed: concat('"', replace(item()?......

(0) Share

Report

Posted on by Crisml83

Hi,

I have an issue with the following step ("Select data Operation") it give me an error but nut sure where is the mistake:

Message:

The execution of template action 'Select' failed: The evaluation of 'query' action 'where' expression '@concat('"', replace(item()?['Market Unit'], ', ', '", "'), '"')' failed: 'The template language function 'replace' expects its first parameter 'string' to be a string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#replace for usage details.'.

concat('"', replace(item()?['Market Unit'], ', ', '", "'), '"')

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-yujincui-msft on at

Like (1)

Report
Hi @Crisml83 ,

According to the error message, it seems that the Market Unit field value of a record is Null.

Maybe you could try to check your data source or try the following expressions.

if(empty(item()?['Market Unit']),'N/A',concat('"', replace(item()?['Market Unit'], ', ', '", "'), '"'))

Best Regards,
Charlie Choi

Was this reply helpful? Yes No