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.

All responses (3)

Answers (1)

Verified answer

Expiscornovus 31,758 Most Valuable Professional on at

Like (1)

Report
Re: HTML table

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']}'
kingy61422 on at

Like (0)

Report

Re: HTML table

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?
Expiscornovus 31,758 Most Valuable Professional on at

Like (0)

Report
Re: HTML table

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