Answered

Creating html table across two sharepoint lists

(0) Share

Report

Posted on by BenBennett321

114

I have created a flow that creates a HTML table from a Get_Items_2 Sharepoint List but there is another column I wish to add which comes from another Sharepoint List (Get_Items_4) is there anyway of adding this column like you would if you were creating a query in access, I'm sure Ive' done this previously but can't find it in any of my previous flows and internet searches aren't helping me.

columns in Html table and source

Area - Get Items 2 (sharepoint list A)

Column 2 - Get Items 2 (sharepoint list A)

Column 3 - Get Items 2 (sharepoint list A)

Advisor - Get items 4 (Sharepoint list B)

the sharepoint list B also has a Area column which would be the way i would join it in Access, so is there any way of doing similar in power automate. I've tried the union function but they didn't populate any of the information to the data from sharepoint list A it just added it to the end of the table.

Please let me know if you require any more information

Categories:

General topics

I have the same question (0)

All responses (10)

Answers (1)

BenBennett321 114 on at

Like (0)

Report
Copy link

Link copied!

Bumping this, in case any one knows the answer.

Was this reply helpful? Yes No
BenBennett321 114 on at

Like (0)

Report
Copy link

Link copied!

Still not had a response to this, if I've explained anything poorly, please do let me know .

Was this reply helpful? Yes No
Chriddle 8,513 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

You can use xpath

Here an example

Was this reply helpful? Yes No
BenBennett321 114 on at

Like (0)

Report
Copy link

Link copied!
Thanks for this information. I've looked into it and tried to replicate it for my particular intention.

I have two Select elements:

Select: This gives me the outputs I need from Sharepoint List A.
Select_2 : this gives me the outputs I need from Sharepoint List B

I have then created Select_4 whose output is from Select (Sharepoint List A)

and with an expression in the Map field that reads:

addProperty( item(), 'Advisor', first( xpath( xml(json(concat('{"root":{"item":', outputs('Select_2'),'}}'))), concat( '//item[Area="', item()['Area'], '" and Advisor="', item()['Advisor'], '"]/Advisor/text()' ) ) ) )

When I test this, the flow fails and states:

cannot be evaluated because property 'Advisor' doesn't exist, available properties are 'Area, Date logged, Number of days waiting'.

which means the expression I've done is not finding any of the Select_2 (sharepoint list B) element. So not sure what I've done wrong.

thanks,

Was this reply helpful? Yes No
Verified answer

Chriddle 8,513 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
I can spot 2 issues with your expression:

It's probably body('Select_2')

Advisor is in Select_2, hence you won't find it in item()

Try this:

addProperty( item(), 'Advisor', first( xpath( xml(json(concat('{"root":{"item":', body('Select_2'),'}}'))), concat( '//item[Area="', item()['Area'], '"]/Advisor/text()' ) ) ) )

Was this reply helpful? Yes No
BenBennett321 114 on at

Like (0)

Report
Copy link

Link copied!

Thanks for this, that's stopped the error message, but the Advisor Column is giving null values, so it doesn't seem to be working as intended.

Was this reply helpful? Yes No
Chriddle 8,513 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Can you show example JSON from these lists?

Was this reply helpful? Yes No
BenBennett321 114 on at

Like (0)

Report
Copy link

Link copied!

Sorry, how shall I do that, is it the Outputs from a Compose element on those lists?

Was this reply helpful? Yes No
Chriddle 8,513 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Yes

Was this reply helpful? Yes No
BenBennett321 114 on at

Like (0)

Report
Copy link

Link copied!

Ah I've found what went wrong, I had removed the 'Area' mapping in Select_2 in a desperate attempt to make it work, I've restored this now and it now works. Thanks, this is really invaluable to me, and I've learned a lot. thank you, I'll accept your response as the solution.

Thanks very much.

Was this reply helpful? Yes No