web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : 2sOP+JAh1V1JRvRwVZWG4i
Power Automate - Building Flows
Unanswered

Using Caml join query with sharepoint online, showing parent list field.

Like (0) ShareShare
ReportReport
Posted on 28 Apr 2024 10:27:01 by 160

Hi there,

 

Has anyone used caml join queries when querying data from sharepoint? Do you know if is possible to retrieve fields from the parent list through projectedfields, I can join and return fields from the child list but not the parent. Have been playing with this for sometime but no joy. I am wondering if this only works server side and not through the web api. Below is what I am working with: Nomination Detail is the child list with a lookup to the parent list using column 'Nomination'. I want to show the NominationDate from the parent list (Nominations), so I created a projectedfield and added it to the viewfields. But it will only show fields from the child list. Any guidance appreciated. 

 

 

_api/web/lists/GetByTitle('Nomination Detail')/GetItems(query=@v1)?@v1=
{"ViewXml":"
<View>
	<ViewFields>
		<FieldRef Name='ID'/>
		<FieldRef Name='YearOfService'/>
 <FieldRef Name='NominationDate'/>		
 <FieldRef Name='Nomination'/>
	</ViewFields>
	<Joins>
		<Join Type='INNER' ListAlias='Nominations'>
			<Eq>
				<FieldRef Name='Nomination' RefType='Id'/>
				<FieldRef Name='ID' List='Nominations'/>
			</Eq>
		</Join>
	</Joins>
<ProjectedFields>
	<Field Name='NominationDate' Type='Lookup' List='Nominations' ShowField='NominationDate'/>
</ProjectedFields>
</View>	
"}

 

 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete