Hello all,
I have a Workflow issue when querying SharePoint.
My SharePoint list looks like:
SharePoint List
Title |
Description |
A |
Apple |
B |
Banana |
... |
... |
I want my Workflow to take the input of a letter and return the description.
I have created a SharePoint list integration library.
I can successfully use the "Search SharePoint List" component of my integration library with any constant value for a query of 'Title' and return the correct row. For Example:
Using the search component with the query value source set to use a constant value of UseTitle=true and Title="A" will return the appropriate array of "A","Apple"
If I want to use the value returned from my webform "Dropdown list of A B" then my *understanding* is that I need to use a Dynamic value which I setup like so:
When run in debug I get:
[...]
Letter = "A"
SearchItemsAlphabetErrors = array
[0] <errorstring xmlns="http://schemas.microsoft.com/sharepoint/soap/">Cannot complete this action.
Please try again.</errorstring><errorcode xmlns="http://schemas.microsoft.com/sharepoint/soap/">0x80004005</errorcode>
ThisFormData =
Log Debug: definition to check against SearchItemsAlphabetErrors String null allowed? False
Log Info: executed component Search SharePoint List:SearchItemsAlphabet in 1278.1278 milliseconds
[...]
Can anyone guide me as to where I might be going wrong?
Many thanks,
Ash