Share
Report
2Hi all,
I've been using PowerAutomate for a short while to do basic functions, like add rows to a spreadsheet, etc.
I'm looking to try something, which makes sense in my head, but I can't figure out a way for Power Automate to do this. My scenario is below.
At 23:00 each day, a business analysis tool creates a data dump in CSV format. The data dump is always in the same location, and contains data from the previous day.
The data dump contains a list of product IDs. The ordering of these IDs changes from day-to-day and is dynamic, depending on when orders were received, etc.
I'd like to combine data from another CSV, but the data would have to map to the correct rows, as the data would need to match with the correct order number.
So, ideally the flow that I'd be looking to set up is:
- Our Business Analysis tool generates the data dump in CSV to a location on a Sharepoint site at 23:00.
- A seperate CSV file is generated throughout the data that tracks order status.
- PowerAutomate then searches the data dump CSV file, and adds the values from the seperate CSV into the correct cells.
Is this possible? Or am I outside the realms of what PowerAutomate can do?
Many thanks,
Owen
Categories:
I have the same question (0)
All responses (
Answers (
