Empty field - Choice column

[Gorilla_8]

I have a simple flow with condition to check if it will occur or not ...

So if it is "true", it resets a text field (Ok, working) and another field of "LookUp - Choice column", but the last one will not.

I've tried "null" and it doesn't work and zero tbm, and it won't ....

What would be the solution?

Thank you very much 😄

[jinivthakkar]

@Gorilla_8 I tried setting the value of choice column and it works, I have used update item action.

please can you post screenshots of what your flow looks like 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[Gorilla_8]

@jinivthakkar 

Yes, I am using "Update item" too, but I wanna blank the choice

[jinivthakkar]

@Gorilla_8 I tried first having a blank value in column and then setting it to null and what I found was that SharePoint does not show me the blank value in the Update item action in Power Automate, additionally it also removes the blank value from the choice column option.

So what I did was I add a new value as -Select- as a option in choice column setting and then I am setting this value in the flow

Hope this helps.

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[Gorilla_8]

@jinivthakkar 

Yes, but I need it to be erased, nothing will appear.

One thing I didn't say is that this column is a "LookUp" field, and I need to delete it in the flow, that's my problem

Because then I will pass the data on to PowerBI

[jinivthakkar]

@Gorilla_8 be it choice column or lookup you won't be able to delete it in the flow.

The easiest solution is to have a another column which is a single line of text in which you show the value of lookup if it has value and set it to null/delete it from flow as required and then you are free to pass it to Power BI or any other application you want.

Hope this helps.

----------------------

Please like and Accept Solution.

[Gorilla_8]

@jinivthakkar 

Hi, so LookUp and choice column is not possible to be "NULL"? 

[jinivthakkar]

@Gorilla_8 yes thats correct, that cannot be done.

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[Gorilla_8]

@jinivthakkar 

You got some documentantion about this?

[jinivthakkar]

@Gorilla_8 There is no documentation for everything from Microsoft. Like I said earlier I have already tried the choice column and it did not work and I know lookup column cannot be set to null.

[Hardesh15]

@Gorilla_8  I think you should use one compose action and pass expression String(' ') (mind space here). Later in update action use Compose output. it will set choice field value as blank string.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

[Gorilla_8]

@Hardesh15 

Thanks for the help, I tried here with "string(' ')" didn't work...

[Hardesh15]

@Gorilla_8  It is working at my end. How is it possible it is not working at your end. Please show me how did you try it?

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

[Gorilla_8]

@Hardesh15 

here

The error text:

"OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of the 'Update_item_2' workflow operation of type 'OpenApiConnection' is not valid. Error details: The input parameter 'item / BusinessPlan / Id' must be of type 'Integer / int64'. The runtime value '""' to be converted does not have the expected format 'Integer / int64'."

[Hardesh15]

@Gorilla_8  So my previous solution for choice column not for lookup column. In case of lookup column  flow pick lookup id and based on that id it set value in field. If you check carefully your lookup id is started with 1 (int type). Work around for such situation is: Create first entry blank in your lookup list. Why? because it will give you lookup id value as 1. Later in your flow pass this value int(1). it will work.

That blank value will not be visible in lookup column.

Version history for reference:

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

[Chunks]

Saved me a lot of time - who would have figured it is so convoluted to clear drop list values.

[Premsai908]

Hi Everyone,
i am not sure this answer is already found by you or not, but on my research i found out that you can reset a choice field by selecting enter custom value and go to expressions and type '' but not "". it will work and your choice column field value will get reset

thanks and accept this answer if it works for you too

[manpreetkaur]

Use string(' ') in an expression.

[shavora]

I'm looking into this too. I have dataverse table that I need to reset the value of the choice column. Ideas? It has a drop-down. 

[landonjochim]

Within the Update Item action in your choice column, use "Enter Custom Value" then enter the expression string('')

This worked for me