______________________________________________________________

RodneyCheung · ‎08-09-2023

Hi All,

Morning, can I using power automate flow to make below steps? thank you so much.

Can check / compare the "Zone" value between excel sheet "Zone distribution information and Data", then copy the full record to related sheets.

Example: Compare in excel sheet "Data - (column F)" and "Zone distribution information - (column A to C)", checked that if ABC is "Zone A", then copy the full record to Zone A excel sheet.

SamLed · ‎08-10-2023

Hi,

Is this layout fixed ? I would propose another one for "Zone distribution information" which would simplify the way to consume its data:

My excel file has 4 sheets, 2 tables "Distribution" and "Data" in sheet 1, and 3 tables ZoneA, ZoneB, ZoneC respectively in Sheet2, Sheet3 and Sheet4.

Use desktop Excel to modify table names:

Now here is the flow:

And here a walkthrough to implement it:

1° Add a "List rows present in table" for Distribution info table and one for Data table:

2° add a filter query to second action to filter data zone by distribution info zone (insert dynamic content between quotes), PA will move it inside an "Apply to each":

it becomes:

3° Add a "Add a row into a table" action inside "Apply to each", Select "Enter custom value' in table field and populate with "Sheet" dynamic content from "List rows present in Distribution Information table", PA will move this action inside a new Apply to each:

It becomes:

4° Finally, populate "Row" field with , PA will move the action inside a nested "Apply to each":

it becomes:

That's all folks !

______________________________________________________________

If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

View solution in original post

SamLed · ‎08-10-2023

Hi,

Is this layout fixed ? I would propose another one for "Zone distribution information" which would simplify the way to consume its data:

My excel file has 4 sheets, 2 tables "Distribution" and "Data" in sheet 1, and 3 tables ZoneA, ZoneB, ZoneC respectively in Sheet2, Sheet3 and Sheet4.

Use desktop Excel to modify table names:

Now here is the flow:

And here a walkthrough to implement it:

1° Add a "List rows present in table" for Distribution info table and one for Data table:

2° add a filter query to second action to filter data zone by distribution info zone (insert dynamic content between quotes), PA will move it inside an "Apply to each":

it becomes:

3° Add a "Add a row into a table" action inside "Apply to each", Select "Enter custom value' in table field and populate with "Sheet" dynamic content from "List rows present in Distribution Information table", PA will move this action inside a new Apply to each:

It becomes:

4° Finally, populate "Row" field with , PA will move the action inside a nested "Apply to each":

it becomes:

That's all folks !

______________________________________________________________

If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

RodneyCheung · ‎08-10-2023

Dear Sam,

Thank you so much for your help, I follow your steps, it can run successfully, but the "table: ZoneA, ZoneB, ZoneC" are no result on it. Would you please help to check on below which is not correct. thank you.