Knack Flows and Onedrive

Ask the Community Get Answers
1

Has anyone tried using the Onedrive Connector in Flows?

I am looking to have a form where someone uploads a document with some extra detail, and on a submit it would save that file in Onedrive under a particular folder, then link to that document, then remove the file that is in the record. Hoping I can save all our documents but not chew up all our space in Knack.

My first stumbling block is the first step. I can not get the connection to Onedrive working. I have tried several different Folder formats, file formats, and other options but I alwasy get an error. There are no guides or videos that I can find anywhere, the closest I got was a google sheets from Knack that is not very clear and suffers from poor editing, as it jumps around a lot.

I seem to get either

image
image716×105 5.77 KB

This when I give the full sharepoint filepath

Or

image
image1007×115 7.96 KB

I get this error when I remove the http:// or have no folder listed at all.

I can not find anywhere on the web what information are they looking for in the folder option.

Has anyone tried this and got it to work? or knows where I can get some guidance on how this all comes together?

As a note I saw the other article talking about the Add Folder option can only add to the root folder, I am so hoping this is not true because if I can get this to work I need to be creating a lot of folders on the fly.

2

Hi @Adrian_vD, I don’t think Flows would be capable of this, but I’m sure you could utilise Make, Zapier or Power Automate for this. I created a resource for how to do this in Power Automate quite a few years ago: Using Knack in Power Automate

3

Thanks @StephenChapman I will give this a bit more of a play around.

Have never used Power Automate before so will be another learning curve.

Just frustrated I couldn’t even get it to just save a file, without doing anything special.

I am just not sure about advertising a connection that is meant to save a file and it can not even do that. Seems like false advertising to have connections that don’t connect. Sorry just feeling a bit frustrated this has taken hours to find it just doesn’t work.

4

Just briefly tried the Google Drive connector. I have got it saving files there. Working with Directories took a bit of work. And I don’t know how to check if a folder already exists, as it seems Drive can have multiple folders with the same name. So really needs some finessing.
It was just a bit of practice in problem solving and testing how things stick together.

Only problem is Drive is not where our files are stored. So will look at Power Automate to see if I can get something going in Onedrive.