Video Screencast Help

Workflow and SharePoint Lists

Created: 21 Sep 2012 • Updated: 26 Sep 2012 | 1 comment
This issue has been solved. See solution.

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

Comments 1 CommentJump to latest comment

AshWard's picture

Solved...

Sadly it is incredibly simple... upon creating the constant mapping be sure to double click it and check the checkbox to say the value is 'true'

SOLUTION