Hi @LYNCHJL ,
Based on the Filter formula that you mentioned, I think there is something wrong with it. The User().Email, "Supervisors" could not be used as filter condition in your Filter function.
I assume that the Supervisors column is a Person type column in your SPListDB, and you want to filter this column based on current sign in user, then you need to modify your formula as below:
AddColumns(
GroupBy(
Filter(
SPListDB,
Supervisors.Email = User().Email, // Modify formula here
"Ready for Review" in Status.Value
),
"Meeting Date",
"Grouped"
),
"Sum",CountRows(Grouped)
)
For your current question, do you want to filter Gallery Items based on the "StartDate" column value from your "SettingsList"?
1) If the "Country" in SPListDB could only match single one record in your "SettingsList", please try the following formula:
AddColumns(
GroupBy(
Filter(
RenameColumns(SPListDB, "Country", "Country1"),
Supervisors.Email = User().Email, // Modify formula here
"Ready for Review" in Status.Value,
If(
!IsBlank(LookUp(SettingsList, Country = Country1, StartDate)),
DateValue(Text('Meeting Date', DateTimeFormat.ShortDate)) >= DateValue(Text(LookUp(SettingsList, Country = Country1, StartDate), DateTimeFormat.ShortDate)),
true
)
),
"Meeting Date",
"Grouped"
),
"Sum",CountRows(Grouped)
)
2) If the "Country" in SPListDB could only match multiple records in your "SettingsList", and you want to show items with "Date" (from SPListDB) on or after that the latest StartDate value in your "SettingsList", please try the following formula:
AddColumns(
GroupBy(
Filter(
RenameColumns(SPListDB, "Country", "Country1"),
Supervisors.Email = User().Email, // Modify formula here
"Ready for Review" in Status.Value,
If(
!IsBlank(
First(Sort(
Filter(SettingsList, Country = Country1),
StartDate,
SortOrder.Descending
)).StartDate
),
DateValue(Text('Meeting Date', DateTimeFormat.ShortDate)) >= DateValue(Text(First(Sort(
Filter(SettingsList, Country = Country1),
StartDate,
SortOrder.Descending
)).StartDate, DateTimeFormat.ShortDate)),
true
)
),
"Meeting Date",
"Grouped"
),
"Sum",CountRows(Grouped)
)
Please consider take a try with above solution, then check if the issue is solved.
Best regards,
