Prafull
Novice

Query SharePoint list to get list item in workflow

Jump to solution

Hi Everyone,

 

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?

 

Thanks,

Prafull

0 Kudos
4 Replies
tin
Apprentice

Re: Query SharePoint list to get list item in workflow

Jump 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').

0 Kudos
Prafull
Novice

Re: Query SharePoint list to get list item in workflow

Jump to solution

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.

 

Thanks,

Prafull


get_list_item_reference_2585.png
no_get_list_item_option_for_list_items_2586.png
no_getlistitem_method_for_smart_object_2587.png
0 Kudos
tin
Apprentice

Re: Query SharePoint list to get list item in workflow

Jump to solution

Perhaps usage of the 'Create Reference' wizard will provided you with the necessary functionality.


 


5130i2389081D2F03C4C7.png


https://help.k2.com/onlinehelp/K2ForSharePoint/UserGuide/4.7/default.htm#Thin_Client_Wizards/General...

Prafull
Novice

Re: Query SharePoint list to get list item in workflow

Jump to solution

Thanks Tin,

 

This is what I wanted.

0 Kudos