How to download file from sharepoint document and View CSV File in PDF viewer ?

[Tapesh]

Hi 

I'm trying to use the downloadn functtion and pass the link item in the Download () fucntion to download the file but seems like the file is always opening in new page, is there any option I can download it from powerapps with Onselect of button. 

Also Is it possible to show the CSV file in PDF viewer? I know it is possible to show docx, xlsx and pdf or png as per one of the experts video by  @RezaDorrani, it seems not working for CSV i tried to turn and twist the formula and also use flow to achieve this but seems like not working for me. 

For download I tried below fucntion- but show Access Denied 

Download("https://my.sharepoint.com/_layouts/download.aspx?SourceUrl=/sitename/Shared%20Documents/foldername/PC__2021-03-09T14_41_51.3282891Z.csv")

I also tried to pass link as below - but only opens the file in new tab.

Download(ThisItem.'Link to item')

Any help form all experts is helpful and apprciated. 

Thanks

[zmansuri]

Can you download file from SharePoint directly? Because many organization have this policy that restrict user from downloading anything from SharePoint. Even my company has the same.