Handling data in power automate

(0) Share

Report

Posted on by Johnnyoc

I have a flow where I am taking two CSV files (Customers and Products) and splitting the data into an array with field names:

I have an excel sheet that, using the excel list rows present in a table/for each, I am filtering on the 'Customers' data.

In the customer data there is one or more products per line. I'd like to do two things which I am unsure of the best method:
1 - check the customer product against the 'Products' data and take a different action depending on this result

2 - One of these actions where the data is present - transform the customer data so that instead of a line per customer, per product, I have a single customer entry and add columns per product and their associated count

Before

Company	Product	Count
Company a	Product 1	50
Company a	Product 2	100

After

Company	Product 1	Product 2
Company a	50	100

Categories:

Business Process Flows

All responses (2)

Answers (0)

Johnnyoc 41 on at

Like (0)

Report

Re: Handling data in power automate

This doesn’t help at all.
lbendlin 8,041 Super User 2025 Season 1 on at

Like (0)

Report
Re: Handling data in power automate

One of these actions where the data is present - transform the customer data so that instead of a line per customer, per product, I have a single customer entry and add columns per product and their associated count

Nooooo... that's the antithesis of good data modeling. Please don't.

Your Before format is perfect.