web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate Join two items with sh...

Power Automate

Answered

Join two items with shared column value

(0) Share

Report

Report

Posted on by Jiis

254 Moderator

I have 2 SP lists, one for Questions and one for Answers

In Answers i dont have question title, only questionID.

I need to get a new object based on answers item with title included.

I already got the Question item connected to the Answer item (From Filter Array)

but unsure how to join them from here.

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Chriddle 8,513 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!
A simple and powerful way to query elements (or their values) based on IDs is to use XPath.

Then use addProperty to add the queried value to the object.

An example:

From: @{outputs('Compose-Questions')}

Map:

addProperty( item(), 'Answer', first( xpath( xml(json(concat('{"Root": {"Item": ', outputs('Compose-Answers'),'}}'))), concat('//Item[QuestionId="', item()['QuestionId'],'"]/Answer/text()') ) ) )

Was this reply helpful? Yes No

Join the conversation