Answered

HTML table

(0) Share

Report

Posted on by kingy61422

I'm trying to create an HTML table from selected items in a SP list. The SP list has a "Master ID" column witch ties multiple rows together and a "ID" column which identifies different lines in the SP list. I want to have all entries with the same "Master ID" to be in the table in a descending order by "ID". Is there a way to do something like this? Thank you for the help.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Expiscornovus 33,830 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @kingy61422,

You could use a Get Items with a filter query on the Master ID column. After that you can sort the results in descending order with a reverse function.

Below is an example of that approach.

reverse(body('Get_items')['value'])

Was this reply helpful? Yes No
kingy61422 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the help. My flow is triggered when an item is created or modified. I want to filter using the "ID" from the created/modified item that is the "Master ID" in another SP list. Is there a way for me to filter using dynamic content?

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,830 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @kingy61422,

Yes, in the Get Items you could use the ID from the trigger action in the filter query.

MasterID eq '@{triggerOutputs()?['body/ID']}'

Was this reply helpful? Yes No