For my app, I am trying to use an existing excel data source with multiple tables as the template for my client database. I would like to use a Flow for adding a new client.
What I'm looking to do:
Click a button -> Creates an excel file that duplicates the template file but names the new file after the text in an inputtext box.
Then I'll use Patch to update information in the tables in the file.
What do I do in the flow to do this?
Hi Silverleaf,
For current flow actions, you can create a file in OneDrive/OneDrive for Business/Dropbox etc. When you create the flow using these actions for exmaple: Dropbox-Create file, you can name the file based on a Text contol on PowerApps, however, for the Content of the file, we could not use an existing Excel with multiple tables, like the screenshot below:
So, I am afarid you could not create a file using an existing Excel template with multiple tables in Flow.
Thanks,
Wendy
Share
Report
All responses (
Answers (
342
