Unanswered

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)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
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

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,189 Most Valuable Professional on at

Like (1)

Report
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