I've been "banging my head to the wall" with this problem for a few days now. Tried all kind of recommended solutions, but none of them are working.
So, the flow is meant to be an approval flow, triggered by "For selected item". I want to build an approval flow that is triggered manually from a sharepoint document library. It's supposed to replace an old sign-off process done with pen and paper.
The troublesome part is the "Get file metadata", that isn't able to find the correct file ID. Apparently it needs a more specific URL with the library or folder name, I don't know.
Why I need the metadata, is because I need the eTag to be entered in.
Here are the first steps.
In "Get file metadata" selection menu, I cannot select the folder or library where my files are stored. Should I do something in the library settings in sharepoint side, to make it selectable?
Here's the error message: The file "..." does not exist. This error message only has the site root URL and the file ID, without the library or folder name. Of course, as I couldn't select it in the first place.
eTag from metadata is needed here, to find the exact file which the approval is for. The condition should check if the file is approved or not, but without the eTag it doesn't know which file to handle.
The steps after the condition are "Set content approval status" and "Update file properties." In plain terms, I want to update the approval status and then copy the approver name and comments back into the original document library.
Any ideas how to identify the file, get the eTag and use it in later steps?
I would greatly appreciate the help.
Solved! Go to Solution.
I tried with Get file properties. Now this step is ok in the test, but I can't pass eTag in step Set approval content. It's not available in dynamic content.
You wrote: "Make sure you select a view which contains the eTag column/field btw."
If eTag is something that needs to be first created in the sharepoint view and library, I don't have a clue how to do it. Does it require a lot of programming or some premium features?
Apologies, I now see that you were talking about the ETag and Content Approval. I thought you were talking about random metadata fields. Below is an example how you can set this up, ignore my previous suggestion.
I believe with Content Approval you first have to submit it. After that you can set it to Approved or Rejected btw.
1. Add get file properties action. Use the ID field from the for a selected file trigger action
2. Add a Get file metadata action. Use the Identifier field from the get file properties action
3. Add a Set Content approval status action. Use the ItemId and ETag field from the get file metadata action.
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!