cancel
Showing results for 
Search instead for 
Did you mean: 
pscadmin
Nintex Newbie

Fetch multiple columns using Office 365 query list

Using Office 365 Query list can we fetch multiple column's ?

Say i have the following query to fetch "FirstName","MiddleName",LastName"

<Query>
<Where><Eq><FieldRef Name='Title' /><Value Type='Text'>001</Value></Eq></Where>
</Query>
<ViewFields>
<FieldRef Name='FirstName' />
<FieldRef Name='MiddleName' />
<FieldRef Name='LastName' />
</ViewFields>

By using O365 Query list action we can fetch the First column (here it is "FirstName") which we defined in the <ViewFields/>. So how is it possible to get the other columns like "MiddleName","LastName" and so on...

My query is how to fetch the complete row column values returning from the query output?

Since "Add Fields" is available, i am assuming that there should be some mechanism which i am missing to fetch the other column values.

Appreciate your assistance in advance.

 

Labels: (1)
0 Kudos
Reply
1 Reply
Automation Master
Automation Master

Re: Fetch multiple columns using Office 365 query list

Hi,

the CAML might be limited. Instead I would like to ask - why do you use CAML, not the visual editor?

2019-03-04_22h10_39.png

 

Regards,

Tomasz

0 Kudos
Reply