Help

Attach a Word Doc from Sharepoint to Airtable

150 1
cancel
Showing results for 
Search instead for 
Did you mean: 
mbrinkley
4 - Data Explorer
4 - Data Explorer

Hey everyone

Been fighting with this all day. Hopefully someone here can help point me in the right direction.

I am using PowerAutomate and Sharepoint. I have a Word document stored in a folder on Sharepoint that I would like to attach to a record in Airtable. I have gotten pretty far but as always that last bit is tripping me up.

Here is the setup.

Power Automate:

I have a 'Get Properties' node that is returning information about the Word document that I think I need to attach the file including the link and file name

I have an 'HTTP' node that points to the airtable API, the base, table and record in question. I am using PATCH as the method and I have the authorization working. Additionally, I have the content-type set to application/json.

In the body of the HTTP node, I have this JSON

{
  "fields": {
    "Contract": [
      {
        "url": "https://my.sharepoint.com/sites/My-Team/Shared%20Documents/Word%20Folder/File%20Name%20001%20%5BProject%202%5D%20-%20File%20-%203.docx",
        "filename": "File Name 001 [Project 2] - File - 3.docx"
      }
    ]
  }
}

The field 'Contract' is an Attachment field that is empty with nothing in it.

The Power Automate flow runs with no errors and its returns that it has succeeded. But there is no word document in the Contract field for the AirTable record. I know that AirTable does not return an error code for a failed attachment. 

So now I am stuck as I am not sure what I am missing or why its failing to upload into airtable.

Anyone have an idea on what I am doing wrong?

Cheers!

 

1 Reply 1

You need to make sure that your document is in a publicly-accessible location on the web that doesn't require a Sharepoint login to access the file.