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
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
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.
You may want to try
SELECT(Table 1[Name], [Email] = [_THISROW].[Email])
