Power Platform Community Forum Thread Details

Hi,

I am looking to see if anybody would have any ideas as to how one would build a power app that could be capable of building a large number of word and excel documents with data pulled from a form on Apps or something of the sort. Essentially. I am looking for a way for a power app to pull from a large pool of templates(I work for a Contractor so all our trades) and replace specific words for a new project so that all the templates would be applicable.

Basically, I have all my files and folders for Project A (about 60 folders 300+ files). Project A is written in, Project Manager is written in, project number, and other project specific data in each of the documents. I want to see if there is a way to run an app with Project B written in, a different project number, a different project manager, etc. and essentially create a new folder tree with Project B as the title and all the associated templates within. I want to save all the templates in a sharepoint folder then have this app repeatedly pull from that one folder for consistency.

I have an iteration of this currently, but it is a clunky VBA code where I have my base folders/files and an excel VBA macro that "Find's and Replace's" data through all folders and subfolders for my base template folder. I copy the template folder, rename it for my new project, then run the VBA to find and replace all the data for each project. I want to see if there is a cleaner way to run this through power apps/flow.

I am very new to Power apps and don't even know if this is possible.

I appreciate anybody's help in figuring this out!