Dear friends,
There is form view and i am adding data via that form [normal steps]. A name, B surname, C contact…and then save. Is it possible to have details if i write same name in column A? I know that not possible to save same name. Just i want to edit it.
name
surname
contact ABCD
EFG
123456 KLMN
IOP
987654
when i write ABCD system need to show me details of ABCD and then i will change something and then save
You can write below expressions in Suggested_Values property of ColumnB and Column C
SELECT(Tablename[ColumnB],[ColumnA]=[_THISROW].[ColumnA])
SELECT(Tablename[ColumnC],AND([ColumnA]=[_THISROW].[ColumnA],[ColumnB]=[_THISROW].[ColumnB]))
And in Initial Value you can use ANY() expression to select the first valid value from the list
@Levent_KULACOGLU Dear Levent, Shall i write both of them in same [suggested_value] section?
Writing both of the expressions to same suggested_value property (that means you concatenate 2 lists) gives you nothing. The first SELECT is for ColumnB’s suggested value and the second one is for ColumnC’s suggested value.
The first SELECT will filter ColumnB values as per your choice in ColumnA and the second one will filter ColumnC values as per your choices in ColumnA and ColumnB
@Levent_KULACOGLU Wow supper. What about if i have 40 column? Is it means that formula will be much big?
Es besteht keine Notwendigkeit, die Grenzen zu erzwingen😊 Translate
Haklısın. Kusura bakma. Translate
User | Count |
---|---|
60 | |
25 | |
13 | |
11 | |
6 |