I have a Power App where users can upload a file in the app that gets stored into a SharePoint list attachment (built in Power Automate flow). What I am trying to do is allow users to click an icon within a Power Apps gallery that will open the attachment file in SharePoint itself in a new window browser.
The issue that I'm having is: when you click on the icon within the gallery, it downloads a local copy of the file to the user's desktop instead of opening the file on the cloud. Can anyone advise on how to modify the current approach so that it opens the file in a new window within the SharePoint site? I should also mention that I tried to modify my SharePoint column settings and do not have the ability to adjust some of these settings.
Data Sources in Power App:
- Power BI data (using Power App visual embedded in report)
- SharePoint List data (where the file upload is being saved along with additional relevant columns such as UniqueID)
In my Gallery, I have a hidden Text label (renamed as "HiddenAttachmentUrlLabel") to retrieve the attachment URL:
LookUp('My SharePoint List', Title = ThisItem.'UniqueID', 'Attachment URL')
In the same Gallery, I have an icon with an On Select property of:
Launch(HiddenAttachmentUrlLabel.Text)
This is the Power Automate flow that I created for additional context. In the last step, I am responding to Power Apps to indicate if the run was successful or not.
I have seen some mention online about sending an additional parameter including the attachment URL that was just created in the "Respond to a PowerApp" module, but I am lost on how I would be able to insert this into the icon in the selected item of my gallery. It seems that there are two approaches here and I would like some advice on which one I should take and how to do so.
