Pretty simple. I need to do this:
apparently contains() is not allowed. Please advise!
Solved! Go to Solution.
Hmm, its a good try. However, seems my SQL column is 'multi-row' text which is a 'NOTE' in odata. I copied the table, then changed to column from 'text' to a 'varchar(MAX)' and same error occurs. It still sees it as a 'NOTE'. I'm not sure how to make sure this is a single string. It can be a very long field, but there is no reason for it to be multi-line. Any idea about this? How do I convert it, and not wipe out the contents of the column?
The field 'SN_List' of type 'Note' cannot be used in the query filter expression.
I didn't even think of asking that. I assumed that you were trying to collect SharePoint data. Glad you figured it out yourself and to see the contains actually works in the SQL - get rows action 🙂
You were absolutely correct, and it wasnt an assumption, because I had a Get Rows SP action in my initial post. Ooops. Totally wrong action and wrong dataset. I dont know what I was thinking. Duhhhh
So many events happening this month - don't miss out!
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.