Keep row with highest value

(0) Share

Report

Posted on by baotran9103

Hi,

I'm trying to create a flow but I'm stuck at the moment. Hope someone can help me with this problem.

Here is what my share point list look like

Part	Qty	Date
A	1	1/1
A	2	1/1
A	3	1/1
B	2	1/1
B	3	1/1

I need to keep the highest quantity for that part on a specific day.
At the moment, I can only filter the date and send email.

Thanks for reading.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report

Hi @baotran9103

You can use odata filtering for that.

Here, ffe is a number type column in my list and in the order by option i have addedd ffe desc to order the item in descending order based on ffe. and then change the top count to 1 such that it returns only one item that is the having the highest number.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report

Hi @baotran9103,

@yashag2255 is correct, there is an Order By field in Get items action that could sort items in SharePoint by the quantity if the quantity is integer format.

And the Filter query on a specific day could also do in the Get items action. Then you will get an array of items, the first member is the item with the highest quantity, you could use the index (0) of array member to get it:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
baotran9103 5 on at

Like (0)

Report

Hi @YA, @v-litu-msft
Thanks for you response.
I understand the filter.

However, I need filter for many part items with highest number, not just highest on the list

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hi @baotran9103

You can use multiple filter queries to filter the data and then use the filter query in sort by to get the highest number on a particular range or set of data from the SP list.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (0)

Report

This template gives the largest / most recent or the smallest / oldest records for unique values in given columns. Kind of a Group By, then Max or Min.

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Get-Distinct-Records/td-p/2191533

Was this reply helpful? Yes No