I'm using the "Start an approval for new file to move it to a different folder and metadata" however when the approved file is moved it doesn't take the meta data associated to the file, how can this be achieved?
Do you mean the following template?
"however when the approved file is moved it doesn't take the meta data associated to the file, "
Could you please explain a bit for the meta data you mentioned here, do you mean the additional columns added for the Library item?
Apologies for the lack of detail.
I have two folders "Awaitng Approval" & "Issued Information", both folders have custom columns added for revision and document type and OOTB columns for Title, Modified & Modified By. I drop the files into the "Awaiting Aprroval" which starts the flow, add the meta data for the columns listed above. Upon approval the documents are moved into the "Issued for Information" folder but not the meta data associated with them.
My problems are:-
Any help would be greatly appreciated.
Actually the file content and the file meta data you mentioned are stored in different data structure.
The Meta data for the file in the library is stored in a List-like structure, we need to take use of the Get Item (or get file properties) Action to work with the corresponding MetaData, which would require the corresponding item ID.
While when working with the File content, we need the File Identifier, which is different from the item ID.
The additional columns added under the Library list would require user to pre-define the column, so a possible workaorund here should be:
1. Add columns for additional meta data in the target Library,
2. Use Get files (properties only), then filter for the special file, after that, loop through the target library to update the corresponding column field.
Step 2 would require some additional configuration steps, as nested Apply to each is not supported under Microsoft Flow, we need to take some additional steps to workaround that.
Post back if you would like to implement this, I will then share a guiding step here.
I'm not sure i fully understand the proposed solution if you can provide the step by step that wouldbe great.
FYI, the two folders are both in the same library so do share the same columns.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.