Hello, this is my first post so please go easy! it's also my first attempt at an automated flow.
I have a stock value CSV sent to me daily via email - I have created a flow to save to a folder once delivered to my inbox
I then have a flow triggered when a file is created to get file content using path.
Below is an example of the CSV format
This is where I hit a problem!
I add a new step to add a row to an existing excel table. When the flow is tested, it's successful, but it adds a row for each branch so the data has cascaded, and not entered on a single row.
For example, this is what I want happen.
This is what happens
Hello Dan,
What's your table size? Have you input all field value in 'Add a row into a table' as below
Hi Johnny
The table is already created with previous days values on.
When I enter my first branch value I get 'Apply to each' ??
I think this is causing the data to cascade
The above creates the below cascading line
Helpful resources
Join us for Microsoft Power Platform Conference
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Register for a Free Workshop
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Help make Flow Design easier
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!
