Group by name and show only TOP 1 row inside groups

Like (0) Share

Report

Posted on 4 Sep 2023 12:33:40 by konsysszl

Hello,

I have a Sharepoint list. I would like group by 'Name' column and show only the latest row (TOP 1 by 'Creation Date' DESC) inside every group. How can I setup this in Power Automate? In the "Get Items" step I cannot find Group by.

Thank you!

BR, SZL

All responses (2)

Answers (0)

konsysszl 2 on 05 Sep 2023 at 06:32:51

Like (0)

Report

Re: Group by name and show only TOP 1 row inside groups

Hi, thank you for help! Sorry, I probably phrased the question wrong. I prepare a T-SQL script with Sample data. I would like get the same result in Sharepoint view or with a flow.

I am very beginner in Sharepoint, sorry.

Thanks for help!

BR, SZL
ChristianAbata 8,949 Most Valuable Professional on 04 Sep 2023 at 23:57:52

Like (0)

Report

Re: Group by name and show only TOP 1 row inside groups

hi @konsysszl you can try adding a filter array step.

That groups your sharepoint result.