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" )
Solved! Go to Solution.
I am in need of help related to the same issue for a customer and it is business critical . Let me know how I can connect offline please.