Unanswered

Sum excel rows when multiple fields match

(0) Share

Report

Posted on by Craig Stewart ABZ

959 Super User 2024 Season 1

I'm currently hitting a blank on this issue, so I'm going to log off for the night and hope that I'm either hit with inspiration or someone can point me towards the logic.

I have a table in excel that I need to match multiple columns then add the value in a 4th.

I would like to get all the rows that have identical Project, Person and Code combinations be a single row with a total

so that, my 20 rows here would become 14

In my List Rows action I'm filtering on ISP eq 'Yes' so that I will only get Yes lines, then I've filtered array so that I don't get empty Code lines.

I just can't seem to get my head around what logic I need to apply here to combine these rows to get a cleaner output once I get here.

Hopefully a good nights sleep will help me 🙂

Thanks

Craig

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Rhiassuring 8,690 Moderator on at

Like (1)

Report

Ooh - fun!

I think the first thing I'd do is turn that result from Excel into an array, and then add a field:value that concatenates Person-Project-Code. Then you can do a union on that concatenated field to pull back the ones that are unique combos, then loop through that union output to grab the associated data from the Excel array stuff.

Let me know if you want to see a step by step of that.

R

Was this reply helpful? Yes No
Craig Stewart ABZ 959 Super User 2024 Season 1 on at

Like (0)

Report

Thanks Rhia. That's really helpful.

After a bit of tinkering around I have indeed managed to concatenate the items and insert them into the array.

However I got stuck here on how to get this working and couldn't find anything in my searches for a solution. 😪

So I'd love to see a step through if this is something you've been through before, but please don't be putting yourself out to do so as I have a working solution.

In the end I opted to put a concatenated column in the excel document and worked through using that field as the one to drive the output following this topic which I previously used Solved: use flow to sum some row in excel - Power Platform Community (microsoft.com)

My concern with the way I'm doing it now is the time it takes it's around 5 minutes for 19 lines and going forward we'll be upwards of 1000 at a time, so I'd be keen to see if there is an alternative option.

Thanks again for your assistance here, it was useful and pointed me in the right direction.

Was this reply helpful? Yes No