News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Join two items with sh...

Power Automate - Building Flows

Answered

Join two items with shared column value

(0) Share

Report

Report

Posted on by Jiis

241

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:

Flow Mobile App

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Chriddle 7,077 on at

Like (1)

Report
Join two items with shared column value

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()') ) ) )

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Announcing Mentions and Quick Responses!

Give Back to the Community this Month

Join us in the Community for an AMA: December 12th Register Today

Quick Links

Leaderboard

#1

WarrenBelz 143,532

#2

RandyHayes 76,308

#3

Pstork1 64,050

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans