how do i filter out allready selected values from Enumlist list for new record
If the EnumList is selected in the same record, it would be something like..
SELECT(Table[ColumnA],IN([ColumnB],[_THISROW].[EnumList]))
In new record , enumlist should not contain detail selected and saved in previous record
“Selected and saved in previous record”.. do you want to exclude only the previous row or all previous rows?
exclude all previous row
whenever new record is added only unselected detail should populate in enumlist
let me explain
Table 1 name abcd has coulmn name rollno have unique 10 digit code
table 1 contains more than 1000 unique code
table 1 is read-only mode
table 2 xyz is in add/edit/delete mode
table 2 column myroll has valid if enumlist on abcd rollno
whenever a record is added in table 2
myroll should only populate rollno from table 1
which are not selected in table2 myroll column
scenario . if record no 1 has selected 01,02,03,04
in myroll through enumlist
in record 2 enumlist must not show 01,02,03,04
likewise in subsequent record addition
It would need something like..
SourceTable[ID]-SPLIT(CONCATENATE(SELECT(DataTable[EnumList],[ID]<>[_THISROW].[ID]))," , ")
Thanks Sir this work absolutely fine
please suggest how to modify valid if which populate enumlist of particular type/quality only and do this as mention down below
SourceTable[ID]-SPLIT(CONCATENATE(SELECT(DataTable[EnumList],[ID]<>[_THISROW].[ID]))," , ")
You need to remove those ones that you don’t want to see in your list like.. -LIST(Option#1,Option#2,..)