Add a new value in a dropdown column with a bot/action

[Espegg]

I have created an action with "Set the values of..." the column "STATO RATEO" with the value "PERSO" with "Only if this condition is true" [ID PRATICA].[STATO PRATICA] = "Pratica NON IDONEA"

This action is included in a bot that when in the table PRATICHE the column STATO PRATICA is in "Pratica NON IDONEA" the bot must to do in RATEI Table with Referenced rows with this expression FILTER("RATEI", [ID PRATICA] = [_THISROW].[ID PRATICA]) seems to be right, but the problem is that the value PERSO is not expected in the ENUM column "STATO RATEO" cause I don't want that the user could select it, but in the case the bot must to add this value.
How could I proceed?

[lynchk21]

You can turn on "Allow other values" for your ENUM column. After which, if you want to prevent the user from adding other values, you can set the input mode to 'Buttons" or "Stack".

[Espegg]

Hello @lynchk21 thanks for your reply.
This is the only way?

[CleanSheets]

Hi @Espegg,

I'm not sure I quite follow your needs, but I think you might be looking to add a value to a list via a bot, and that value cannot be selected by users from the list?

If your list is an enum with a type of ref, that points to the table with the list values. you could add the population of the list in the "Suggested Values" option. But you could, if you don't want people selecting the option, exclude particular values, like this example:

ORDERBY( SELECT( Enum Status Active[Active Status], [Active Status] <> "Peso", true ), [_RowNumber] )

That would give users the option to select any of the other values in the list but not peso, but will allow peso as a value.

Sorry if I misunderstood.

Cheers

[Espegg]

Hello , the dropdown is not enum of ref but enum text

[CleanSheets · Accepted solution]

You should make it an Enum Ref instead. You can do that by making another table, called something like "Enum Stato Rateo". Then that becomes the ref and source of your list and gives you more options. I usually set all my lists up that way.