OneDrive Create Share Link Issue

[WillPage]

I've been using the OneDrive Create share link action in a Power App triggered flow for users to get a CSV file generated by the flow.

The link type is Direct and the link scope is Organization:

A few days ago this flow began to fail at this step. The error message is very long:

{
  "error": {
    "code": 502,
    "source": "australia-001.azure-apim.net",
    "clientRequestId": "ca5b0308-bcbc-4280-8144-b77652cc1c4a",
    "message": "BadGateway",
    "innerError": {
      "status": 500,
      "message": "Exception occured. Message: The method or operation is not implemented.. Full: System.NotImplementedException: The method or operation is not implemented.\r\n   at OneDriveConnector.Providers.OneDriveFileDataProvider.<CreateShareLink>d__15.MoveNext() in D:\\a\\_work\\1\\s\\OneDriveConnector\\Providers\\OneDriveFileDataProvider.cs:line 570\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at OneDriveConnector.Controllers.Flow.OneDriveFileDataController.<CreateShareLinkAsync>d__4.MoveNext() in D:\\a\\_work\\1\\s\\OneDriveConnector\\Controllers\\Flow\\OneDriveFileDataController.cs:line 218\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Threading.Tasks.TaskHelpersExtensions.<CastToObject>d__1`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__5.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__5.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__15.MoveNext()",
      "source": "api.connectorp.svc.ms"
    }
  }
}

If I change the link type to View the action succeeds, but the link it returns to the app opens in Excel Online which is not what I want (they should get a download).

If I add the same action again, Direct is not in the list of link types.

Has this been deprecated? If so, what's the best practice alternative when I want to create a link to download the file? The app has B2B guest users accessing it and I don't want to use any premium connectors.

TIA.

[elcorazon]

Same problem here. Pretty strange to disable such a feature without any further notice? Any information from the OneDrive Dev Team?

[metsshan]

Hey @WillPage any chance you had any luck on this? I notice my Create Share Link in "Direct" mode are failing as well. I am using it in a similar way. Save CSV to OneDrive -> Download "Direct" -> Delete file 10 seconds later. This way users can download files from PowerApps.

I thought I'd ask how your issue is going as I begin investigating on my end too.

[WillPage]

@metsshan  I haven't revisited this since I posted the original question. Nobody from Microsoft has replied to this thread but I think the question answers itself now: Microsoft have updated the documentation:

https://docs.microsoft.com/en-nz/connectors/onedriveforbusiness/#create-share-link-%5bdeprecated%5d

[metsshan · Accepted solution]

Thanks mate, yeah I did a bit more digging and found this:

https://m365log.com/onedrive/retirement-of-direct-link-option-while-creating-a-sharing-link-in-the-o...

[WillPage]

And just like that, Microsoft quietly pulls a feature for the exact reason we use that feature. smfh.

[metsshan]

Yeah I'm really not stoked on it. It was actually a fantastic solution to the problem we applied it to here, so I feel your pain.

[WillPage]

I will try a workaround of saving to SharePoint then using the 'Link to item' property in the app to link to a download. It's more of a pain with permissions but it might work. I'll give it a go.

[metsshan · Accepted solution]

Sorry for the bump, but I've only just come around to solving this issue.

I learned a trick with SharePoint links recently, and applied the same here:

Using the OneDrive Create Share Link, I am now using "View" link type instead of the retired "Direct", then concatenating "?download=1" to the URL it's generating.

When PowerApps uses Launch() with this URL, you get a download prompt for the file.

Enjoy!

[WillPage]

Wonderful @metsshan  good work.

[Dany24P]

Hello Metsshan, do you think you can take a screenshot of that part you mention? I would like to understand a little, thank you very much.

[metsshan]

concat(outputs('Create_share_link')?['body/WebUrl'], '?download=1')

[Yoweel_94]

@metsshan Hi Metsshan. Could you please send a photo of what is inside "Compose"  in your flow? 

I'm trying to make this work from Power BI and I've completed most of the flow but after "Create share link One drive" I added the "Respond to Power app" as you did but I got an issue message that says "The workflow with response action type should not have triggers with SPlitOn powerty Defined manual" and the only thing that is different between my flow and your flow apart of Power Bi button at the beggining is your "Compose".

Thanks !