web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

Full sync files in SP site & subsites with Master list items (get file content error)

(1) ShareShare
ReportReport
Posted on by 40
Hi guys!
 
I have built a SharePoint on-premise which has 1 main site with 3 public libraries and then subsites where every area will work their files privately (1 library per subsite) . In the main site, there is a list which will contain all the files uploaded in every subsite library.
 
The thing is, I have problem attaching the content of the subsites library files into the item in the Master list. When I am trying to add the attachment I get an error when finding the file.
 
 
I have different flows:
1. One flow for each subsite library that when it creates or modify a files, it creates or updates an item in the Master list. If it exists it updates the item and if not it creates it with all the metadata from the subsite library columns.
2. Trigger condition flow that when one column of the files is modified from "No" to "Yes", it runs the flow and it publishes from the private subsite library to the public one.
 
So in both flows I have the same problem with the getting the attachment of the file in the subsite.
I am not getting it and can't understand what I am doing wrong
The error I get when putting body/ID is that it gets the /Ciutadania (that is the subsite of the SP on-premise) so it doesn't get the ID value (in this example  479), it gets the part of the site adress (/Ciutadania) + the body/ID (479) so it doesn't exist.
 
Is there a way to get the ID file identifier?
 
The next question is: with the flow I am showing, will the private library files update when the version in the public library will upgrade from 1.0 to 2.0?
Like, will it changed to the approved one or should I add something more? 
 
I can't try it because I can't make the flow run.
 
I would appreciate some help with this issue :)
 
Thanks!!
I have the same question (0)
  • abm abm Profile Picture
    32,772 Most Valuable Professional on at
    Full sync files in SP site & subsites with Master list items (get file content error)
    Hi
     
    There are few issues here
     
     
    Above you need to set the Id as List Id not the file Identifier.
     
     
    Next under the add attachment you need the File content from the Get file content action step.
     
     
     
     
     Make these changes and see. This will give you the right direction to resolve your current issue.
     
    Thanks
  • Charlito Martharper Profile Picture
    40 on at
    Full sync files in SP site & subsites with Master list items (get file content error)
     
    The thing is the ID of the get file content gets the /UQT from the subsite link, so the ID it gets is /Subsite/ID, look:
     
    As you see it says it doesn't exist. So the flow stops at the second action after when a file is modified:
  • Charlie Martharper Profile Picture
    281 on at
    Full sync files in SP site & subsites with Master list items (get file content error)
    In Catalan ID is Identificador. In the example I shown you before you can see
  • abm abm Profile Picture
    32,772 Most Valuable Professional on at
    Full sync files in SP site & subsites with Master list items (get file content error)
    Hi
     
    I need to see the full flow and mappings. I could offer a screen share. If thats ok then send me an email to ajith.b.madathil@gmail.com We will arrange a time and have a look.
     
    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 489 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 471 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 261

Last 30 days Overall leaderboard

Featured topics

Restore a deleted flow