I am using a Query action to lookup at the Project List :
- ProjectManager (is set to People or Group)
- FreightChargeValue (is set to Single Line text because numbers or names are stored in it)
Based on the above, it should pull up some info and store them in variables.
However, the Query fails at that point where it tries to compare ...
Furthermore, when running in the CALM query as a test and manually type in my Surname, Name then the query is able to lookup at the Project List and pull up the relevant information associated to the column name ProjectManager.
Now, question is; why does it not work with the FreightChargeValue ?
Is it because its attribute is set to SingleLine as Text and not as a People or Group ?
How would I fix this in the workflow then?
I also tried using SET VARIABLE action to say set ProjectManager as FreightChargeValue but no help
Solved! Go to Solution.
You can try to convert field "project manager" to String use "Query user Profile) and then you can try to filter ( use equal or contains).
Hope this can help you
Reva Eka Patria
Do you mean this?
But the User field which looks at the FreightChargeValue is not a People of Group but a Single Line Field.
The pog_ProjectManager is a variable: People or Group.
However the source to pull the Manager's name from is a different customList.
In other words, there are 2 different custom lists: one for the Project List and one Form List.
The Form list is where users submit the request and the Query is supposed to pull info from Project List.
Not sure how to convert it but the only way I do is by setting a variable.
Do you mean this ?
What next... ??
Now you want the Query to compare the ProjectManager field with pog_ProjectManager?
<FieldRef Name="ProjectManager" LookupId="FALSE" />
I have converted the field to String and this is the error message:
Failed to query list data. Data type returned from the list is incompatible with the variable to store the result in.
To visualise what I want to do, so maybe you understand:
I am not able to get the relevant information from the QUERY.
Please help ... possibly with pictures to visualise the solution.
How do I convert a Text SingleField which contains a name Surname, Firstname into a People or Group field??
I have used SET VARIABLE and UPDATE FIELD actions but not having much luck...
Could You share full Workflow screen,
I still don't understand your problem, do you want to get all data project list (manager, Reference, Exces, etc) based on FreightChargeValue?
(Get project list data and insert to work list )
Reva Eka Patria