cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
csantab3
Frequent Visitor

Dynamic MS Word Document Identification and Update: MS Forms - MS Word

I've got a problem that is difficult to articulate. 

 

So, I have an MS form that clients will submit to me, this MS form creates a new folder, and automatically populates MS Word, which creates a copy of itself in the new folder. This all works great. 

 

However, these dynamically created files will need to be later updated by 2 separate forms in the future, so I need to automate a process wherein when a future form is submitted a flow will be triggered by said form that can first identify the dynamically created word document file, then update the corresponding content controls. 

 

I have no idea how to go about a solution for this. I've got a feeling if I create an Excel document (upgraded to sql later) then the submission ID from the first form can be taken a Unique id that is mandatory on all future forms, the same submission id that would act as the document name? that way the Flow could search through a folder looking for a document with the name the same as the ID submitted in the second form, then update the word documents content controls from there? but does anyone know how I'd do this? 

0 REPLIES 0

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,132)