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.
Hello @PowerAddict
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.
Thanks
Hi @pre
I would love to try to help you out. If you want to connect offline, you can send me an email at hardit.bhatia@thepoweraddict.com
Looking forward to hearing from you!
Thanks,
Hardit
User | Count |
---|---|
247 | |
103 | |
82 | |
49 | |
43 |