I have a gallery that I'm trying to filter and search on. Everything works until I try to add the "ID" field from my SharePoint List. I get an error: "Wrong column type, Expects text type.". I've tried to cast the field as a text value and haven't had any luck there either.
Search(
Filter(
colAllRequestsConsultation,
If(
chkStatusClosed.Value = false,
true,
If(
chkStatusClosed.Value = true,
Status.Value in "Closed",
true
)
) && If(
chkStatusOpen.Value = false,
true,
If(
chkStatusOpen.Value = true,
Status.Value in "Open",
true
)
) && TextInput2.Text in ID
),
TextInput2.Text,
"Title",
"ID"
)
