Hello everyone,
Here is the crack of my problem. I am working with Powerapps and Flow. I click one button in my powerapps and the scenario should go like:
- Copy an Excel file from one location, in my one drive, and past it with a new name in another (i.e. creating a new file).
- find a unique field (specific text in a cell) and replace it with a new one (obtained from Powerapps).
The problem I am facing:
- I can't use Powerapps functions, such as Patch, Substitute, and Replace, because I need a predefined-already-connected datasource, which is not the case. i.e. the datasource is being created in the process after the click of the button.
- I created a flow, which allowed my to do the first step. I, however, got stuck in the second.
- In the process of creating a flow, I need an existing file to operate on, which is something I don't have.
To sum up, how do I deal, using Flow, with a datasource/excel table/file that is being created in the process and not preexisted ? For your convenience, I am attaching a screenshot of my accomplishment so far.
PIC 1
PIC 2
Thank you for your time,
