Hello,
I am updating our check request process. I built a Flow that is triggered by someone filling out an MS Forms when they need to pay a vendor without an invoice. The Flow creates a folder named with the Vendor name from Forms. (Let's call this folder "Vendor ABC"). In the Vendor ABC folder is a document the Flow creates which summarizes the Form answers. Up to this point the Flow works perfectly.
As part of the Check Request Form, users must upload supporting documentation for the check request. With MS Forms, there is a default Sharepoint location (let's call this folder "Check Request Support") where these uploads go and there is no way to change that (my understanding). I want to move the documents from Check Request Support folder to Vendor ABC folder, but I hit two issues:
1. It seems like a need a secondary trigger to move the documents from Check Request Support. I can do this with a separate flow using the trigger "When a file is created", but I think it needs to be all in one flow for issue #2.
2. I want the documents in Check Request Support to go to Vendor ABC folder that was created from the Form. Since Vendor ABC will be a different folder name each time I need the flow dynamic. I have no problem doing this with the Vendor Name location; my problem is I don't know how to tell power automate "Go get whatever is in Check Request Support and move it to Vendor Name". Documents in Check Request Support will be different names every time. I am using 'Move File' action for Sharepoint and more specifically I don't know how to reference the file uploaded in 'File to Move' field since it could be named anything.