Moving Files on premise from Logic Apps

Doug Parkhouse 6

From this Arcicle:
https://learn.microsoft.com/en-us/azure/connectors/connectors-create-api-sharepoint

It lists: SharePoint Online or in SharePoint Server on premises
and that we can
Create, copy, update, or delete files

However when using a logic app over an on premise gateway to on site Sharepoint server, when trying to copy a file we receive the error:

"This copy operation is not supported when using this with the On-Premises Data Gateway"

This seems to be the same for Move file as well. This seems somewhat fundamental to the use of Logic apps and the on-premise gateway. Is there something obvious I am missing or is the article incorrect in stating this is supported for both online and on-prem.

Thanks

Mike Urnun 9,676 Reputation points Microsoft Employee

2020-10-23T03:56:56.723+00:00

Hello @Doug Parkhouse - What is the version of your Sharepoint Server?

4 answers

Jerryzy 10,566 Reputation points

2020-10-23T07:31:41.393+00:00

Hi @Doug Parkhouse ,

I'm using the SharePoint Server 2016 On-Premise, configured on-premise data gateway.

If using Copy file action, it will also meet the same error:

If I use Copy file (deprecated), then it's working to copy file in On-Premise environment:

![34446-snipaste-2020-10-23-15-21-26.png][2]

![34460-snipaste-2020-10-23-15-29-28.png][4]

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

[2]: /api/attachments/34446-snipaste-2020-10-23-15-21-26.png?platform=QnA [4]: /api/attachments/34460-snipaste-2020-10-23-15-29-28.png?platform=QnA
Please sign in to rate this answer.

0 comments No comments
Sign in to comment
Doug Parkhouse 6 Reputation points

2020-10-23T08:12:29.607+00:00

@Mike Urnun It is sharepoint on prem 2019

@Jerryzy-MSFT Will try this this morning and see if it works
Please sign in to rate this answer.
Jerryzy 10,566 Reputation points

2020-10-23T08:37:55.78+00:00

@Doug Parkhouse ,

Yes, if have updates, please share with us :-)

Doug Parkhouse 6 Reputation points

2020-10-23T09:31:24.793+00:00

Hi,

We are having some success with Copy File Deprecated however we cannot seem to:

Copy the file to another site
Copy the Metadata

Do you have any further recommendations on how best to do this with this Action
Sign in to comment
Jerryzy 10,566 Reputation points

2020-10-23T09:49:52.987+00:00

Hi @Doug Parkhouse ,

This action is used to copy file between library folders within same site and only copy file which isn't including metadata, as in the parameter only single site url provided.

A workaround is using SharePoint Event Receiver to copy file into other site using SharePoint Server Object Model:

Copy files across site collections in SharePoint
Please sign in to rate this answer.
Doug Parkhouse 6 Reputation points

2020-10-23T13:18:21.723+00:00

Hi,

Frustratingly, using event receives in combination with logic apps would involve creating a great many hidden fields so we could store results from the event receiver codes to ensure they worked properly and reading them back into the logic application. This would turn a 150step workflow into a 400+ step workflow and rapidly expand on costs.

I think in this case writing our own handler locally as a service would be better as we can use HTTP post to submit to it to handle the work.

This is however a somewhat daft solution to a problem I don't think should exist. @Jerryzy-MSFT or @Mike Urnun , would you happen to know if the current Copy-file/Move-file etc are planned to be supported when communicating with an on-prem Sharepoint box?

Regardless, thanks for your assistance.

Jerryzy 10,566 Reputation points

2020-10-26T01:28:41.127+00:00

Hi @Doug Parkhouse ,

Using Event Receiver would be a better solution instead of Logic Apps, as data gateway copy file action didn't support to copy file in On-Premise per the testing.

You can write farm solution with ItemAdded Event to handle copying file and setting metatdata between sites:

Create SharePoint event receiver using Visual Studio
Sign in to comment
Mike Urnun 9,676 Reputation points Microsoft Employee

2020-10-23T16:32:10.147+00:00

Hello @Doug Parkhouse

I believe this might be due to an incompatibility with Sharepoint 2019. Presently, the Sharepoint connector supports Sharepoint 2013 or 2016 on-prem servers, as per the reference doc: https://learn.microsoft.com/en-us/connectors/sharepointonline/
Please sign in to rate this answer.
Doug Parkhouse 6 Reputation points

2020-10-26T09:41:33.357+00:00

Hi Mike,

A bit frustrating but you might be right. Are you aware of any location I can leave feedback or development tracker where I can see when this feature will be enabled as using exclusively event handles is not fit for our purpose.

Mike Urnun 9,676 Reputation points Microsoft Employee

2020-10-26T23:21:42.653+00:00

@Doug Parkhouse Yeah, I've inquired about it in the late-June timeframe and learned that some operations weren't supported yet. I'm not sure if there's a publicly available dev item that you can follow and track for updates but you can post your feedback by opening a new Azure UserVoice here: https://feedback.azure.com/forums/287593-logic-apps

I will also share this post with the Connector team and relay your feedback & experience through an internal channel.

Doug Parkhouse 6 Reputation points

2020-10-27T10:19:27.057+00:00

Thanks for the relay Mike.

I have posted in the UserVoice as suggested. For now, we will have to use a rest API or custom CSOM connector for the moving/copying of files at the end of the logic apps workflow.

Previous suggestions to do the entire thing in event handlers will not work as the user needs to be able to adjust flows themselves when required. Only the last action of something like 200 steps is the actual copy/move part so we'll have to do this another way until support is added.

I need a drink!

Thanks for your help.

Doug.

Jerryzy 10,566 Reputation points

2020-10-28T00:46:48.357+00:00

Hi @Doug Parkhouse ,

Thanks for the feedback and need to wait for the copy action support in Logic App :-)
Sign in to comment