Connecting to Sharepoint for Spreadsheets

StuM
StuM Member
in Connectors

Hello!

For my current dataflow, one of my input datasets relies on an external file from my desktop:

image.png

I was wondering if there is a way to link it to a spreadsheet that is on Sharepoint.

I'm not too sure if I have to use this connector for that to happen:

image.png

Additional question:

If that excel file on Sharepoint is updated (with a new row of info for example), is there a way that it would automatically update the DF?

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    I use the Microsoft SharePoint Online Rest Connector to connect several Excel files to our Domo instance. You can use the scheduling section of the connector to have it pull data in from the spreadsheet as often as you would like. You will want to read through the KB article for this connector as it requires some initial work in the Azure Portal. Once that is done once, you can connect to any number of Excel files. Here's the KB link: https://domo-support.domo.com/s/article/360043436773?language=en_US

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    I use the Microsoft SharePoint Online Rest Connector to connect several Excel files to our Domo instance. You can use the scheduling section of the connector to have it pull data in from the spreadsheet as often as you would like. You will want to read through the KB article for this connector as it requires some initial work in the Azure Portal. Once that is done once, you can connect to any number of Excel files. Here's the KB link: https://domo-support.domo.com/s/article/360043436773?language=en_US

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories