how to assign null value in Insert Row (V2) for MS SQL server by using if statement

(0) Share

Report

Posted on by Kinson-Lam (WCC)

Hi,

How can I assign null to a varchar field in MS SQL using "Insert Row (V2)" action by checking a condition.

In the below example, I have a simple table (WCC_Testing) having 2 data fields.

When I directly put @{null} in the data field, it is correctly assigned NULL into the table.

However, if I use @{if()} to evaluate and then assign null, it inserts empty string rather than NULL to the table.

If this case, I have a variable 'vTest' with initial value @{null}, then in the insert row action, I put @{

if (empty(variables('vText')), null, variables('vText'))}, trying to assign null to the datafield. However, it is not a NULL in database but empty string.

I would like to put NULL in database base on the evaluation result in the if statement. What's wrong and how to fix it?

Thanks for any help.

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (0)

v-yueyun-msft on at

Like (0)

Report

Hi , @Kinson-Lam

As i test it in my side , i use the same expression as yours.

It can work in my side , can you try to convert to the classic mode in Power Automate and re-create a action and try again?

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
Kinson-Lam (WCC) 36 on at

Like (0)

Report

Hi, Zhang,

I have switched back to classic mode as below,

However, after run, the TestCode is still not NULL in database after using the if-statement. But it will be NULL is I assign @{null} directly. Any idea?

Any idea?

Was this reply helpful? Yes No