Hi, I have this particular issue that I just can't figure out and would love your possible solutions. The goal is to display the items in a gallery that match the filtered and searched constraints.
Context:
To start it off, the collection is a Parsed JSON file with the string content being converted to text via the Text() function. The two collections, df_coll and df_briefs, are collections with only string values. The collection look like this:
I'm trying to filter out and search the records in the collection and display them in a vertical gallery, using this code in the Gallery items:
If(brief_select,
Filter(
SortByColumns(
Search(
df_briefs,
search_bar.Text,
title
),
"release_date",
SortOrder.Descending
),
release_date >= DatePickerStart.SelectedDate && release_date <= DatePickerEnd.SelectedDate,
institution_select.SelectedText.Value = "All" Or (institution = institution_select.SelectedText.Value)
),
If(search_title,
Filter(
SortByColumns(
Search(
df_coll,
search_bar.Text,
title
),
"release_date",
SortOrder.Descending
),
release_date >= DatePickerStart.SelectedDate && release_date <= DatePickerEnd.SelectedDate,
file_select.SelectedText.file = "All" Or (file_1 = file_select.SelectedText.file || file_2 = file_select.SelectedText.file),
),
//ERROR IS HERE
Filter(
SortByColumns(
Search(
df_coll,
search_bar.Text,
summary
),
"release_date",
SortOrder.Descending
),
release_date >= DatePickerStart.SelectedDate && release_date <= DatePickerEnd.SelectedDate,
file_select.SelectedText.file = "All" Or (file_1 = file_select.SelectedText.file || file_2 = file_select.SelectedText.file),
)
//ERROR IS HERE
)
)
For better understanding:
brief_select: Boolean to separate the df_briefs and df_coll
search_title: Boolean to separate the search operation (between title and summary)
The problem:
The separation between df_coll and df_briefs works, and the searchability by title also works, but the moment I attempt to search by summary, I get this error:
with this under the code section of the items code section:
Any help would be appreciative.
