Generate a dynamic URL to a fixed file name on One Drive for Buiness

[NewBee117]

My app calls a flow to create an Excel file, saving it to SharePoint does not overwrite the older version (versioning turned on in the file library). Is it possible to generate a dynamic URL to the file with a fixed name in One Drive for Business? I need that link for the Download() function in the app. Thanks.

[v-bofeng-msft]

Hi @NewBee117 :

You could add a "Create share link" to get a dynamic URL. I've made a test for your reference:

My Flow(qqq):

My app:

Run the flow:

Set(TheLink,qqq.Run().thelink)

Download:

Download(TheLink)

Best Regards,

Bof

[NewBee117]

Following your suggestion, I am getting an error: "Expression nesting too deep. An expression in your formula is nested more than 50 levels."

    

I was hoping to create a dynamic link within PowerApps to point to the file, without pulling from Flow.

[v-bofeng-msft]

Hi @NewBee117 :

According to the error message, you need to modify your formula because your formula is too complicated.

Best Regards,

Bof