So my current flow waits for a file with a specific filename to be dropped into OneDrive;
Filename: OPNO - DOCNAME.docx
The flow parses the filename to retrieve OPNO then creates a folder in a static sharepoint doc library and then moves the file to that folder.
HI @AndrewSmith84 , I think the final solution for this will be fairly straight forward, but I just want to make sure that I understand your requirements before I dive into an explanation. Please confirm if this is right:
Am I on the right lines with this?
Community Leader: Black Country PowerApps & Flow User Group
Hi, thanks for replying thats almost right.
The current flow in place was the initial design request, that design has now changed but the current design is as follows;
1: Document with specific naming is dropped into OneDrive labelled OPNO - DOCNAME
2: The flow then parses that filename looking for " - " and taking the text to the left (OPNO) and then creates a folder in a specified sharepoint site labelled "OPNO" then drops the file in there.
The new design request is as follows;
1: A folder with a unique ID is dropped into onedrive, this unique ID is already pre-mapped to a sharepoint list that has two columns, Sharepoint URL as you stated below and the corresponding unique ID. (Sharepoint list is in some master site, it won't reside in each customer site).
2: The flow should detect the folder creation in onedrive then parse the folder name and map it back to the sharepoint list to retrieve the sharepoint url for the customer.
3: The flow will then proceed to the original design and parse the filename then create a folder in the shared documents location of that site and drop in the file.
Thankyou very much.
@MattWeston365 if parsing a folder name in OneDrive for Business is not supported by Flow currently then we could add it to the original design part but filename being;
(UniqueID)" - "(OPNO)" - "(DOCNAME).docx
Therefore the flow will see the file dropping into OneDrive, firstly parse the UniqueID and match that to sharepoint list to find the sharepoint site, then parse the OPNO field and then create a folder in the shared docs of that site and finally paste in the file but if possible cleanup the filename so it only contains the OPNO - DOCNAME.docx and delete the file from OneDrive.
Features releasing from October 2020 through March 2021
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!