Hi @pandachan48 

Hope you are doing well.

Here is the one that worked for me, this is on 2022 R2, so the formula is “=Null”:

Please let me know if it worked for you, if not your welcome to share your import scenario with me and then I can have a look further.

Kind Regards

Marilize

Hi @pandachan48 

 

Hope you are doing well.

Here is the one that worked for me, this is on 2022 R2, so the formula is “=Null”:

 

Please let me know if it worked for you, if not your welcome to share your import scenario with me and then I can have a look further.

 

Kind Regards

Marilize

What should I put in the Excel file template? Should I also put "Null"?

Hi @pandachan48 

No, you put nothing in the Excel template if you want to make it blank, only the formula on the Import Scenario.

Hi @pandachan48 

You can put any dummy value in the excel and map the =’Null’ in the Import scenario

if you want to pass blank detais then you import scenario should have Null https://www.augforums.com/forums/everything-else/setting-a-field-to-empty-or-null/