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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Full sync files in SP ...
Power Automate
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!!
Categories:
I have the same question (0)
  • abm abm Profile Picture
    32,865 Most Valuable Professional on at
    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
     
    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
    331 on at
    In Catalan ID is Identificador. In the example I shown you before you can see
  • abm abm Profile Picture
    32,865 Most Valuable Professional on at
    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

Forum hierarchy changes are complete!

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

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard