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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.