I have a approval matrix which has different combination of items with approvers. I want to query this list and get appropriate item based on user input.
I tried using Get List Item reference and smartobjects get list item by titile method, but both these actions work with equal condition, there is no option to use contains.
How can I query the list with contains option?
Solved! Go to Solution.
How are you querying this Sharepoint List? Is it via SmartObject event, Sharepoint events, etc.; please attach a screenshot if possible.
Usually if it involves a SmartObject, the Get List Items method should allow for filters (such as StartsWith, Contains, etc.) on top of just Input Properties (which will do an 'Equals').
I am using GetList item reference list method which only has filter properties that only do 'equal' operation.
Smartobject methos dont have getlistitem method, it has only 'getlistitembyid'or 'getlistitembytitle'. Please find attached screenshots for more details.
Please let me know if I am doing anything wrong. Also please suggest any other way.
Perhaps usage of the 'Create Reference' wizard will provided you with the necessary functionality.