dependant dropdown and add of new values (no Valid_If possible)

[joe_mouth]

Hi all,

I try to have a dependant dropdown with the ablility to add new values.

I use

"SELECT(Table 1[Name], [Email] = [_THIS].[Email], true)"

in Suggested_Values, but all values of the column [Name] are shown.

Because the user should be able to add a new value, Valid_If cannot be used.

Thank you for your help, Joachim

[Gustavo_Eduardo]

Hey, first off, you don't need the 'true'. The expression simplifies to:

SELECT( Table1[Name], [Email] = USEREMAIL() )

Secondly, when you're trying to create a selection from one table column to another, you can't directly add the new value into the field of the table you're querying; instead, you must add it to the table. Every time you deploy, a list like this will appear:

Check out the 'new' button above. That button triggers an action that takes you to the table where you can add a new record. Let me know if it helped you, and if so, mark the post as solved so it doesn't remain pending on the list. Have a great day

[joe_mouth]

thank you,

my problem is the list.

The "select" statement will not work, it lists every time all values of the column instead of only the selected ones.

[Suvrutt_Gurjar]

You may want to try

SELECT(Table 1[Name], [Email] = [_THISROW].[Email])