Forum Discussion
Marcelo675
May 27, 2023Copper Contributor
Need to insert url on PNG files inside the spreadsheet
Hello, as you can see above, the spreadsheet already has a column with PNG files inside it. I need to put a url on these files so they can be used in the cloud. How can I do this? Remembe...
Marcelo675
May 28, 2023Copper Contributor
Thanks jimmaphy.
Unfortunately it didn't solve my problem. In the first case, insert the hyperlink, as I said I don't have these PNG files outside the excel sheet. So I have no way to point to any file outside of excel.
In the second case, that of VBA code, it does not appear in the options for macros to be executed. I followed a tutorial on how to insert your code into a macro and it didn't work. I'm completely new to this.
I'll try to explain better what I need.
These PNG files inside the spreadsheet need to become hyperlinked files as they will be used in a PowerApps application, they will be the images of the products in the gallery.
I have already imported the spreadsheet as a table into PowerApps, but as the PNG files do not have a hyperlink, these files are not recognized as an image within PowerApps.
Did I explain it better now?
Thanks for your help.
Unfortunately it didn't solve my problem. In the first case, insert the hyperlink, as I said I don't have these PNG files outside the excel sheet. So I have no way to point to any file outside of excel.
In the second case, that of VBA code, it does not appear in the options for macros to be executed. I followed a tutorial on how to insert your code into a macro and it didn't work. I'm completely new to this.
I'll try to explain better what I need.
These PNG files inside the spreadsheet need to become hyperlinked files as they will be used in a PowerApps application, they will be the images of the products in the gallery.
I have already imported the spreadsheet as a table into PowerApps, but as the PNG files do not have a hyperlink, these files are not recognized as an image within PowerApps.
Did I explain it better now?
Thanks for your help.
peiyezhu
May 28, 2023Bronze Contributor
https://answers.microsoft.com/en-us/msoffice/forum/all/how-do-i-use-the-image-function-with-local-images/e539c52e-fe3c-40d0-b0da-fcbcc16802b2
or implement your own host and publish it with NAT service
or implement your own host and publish it with NAT service
- Marcelo675May 29, 2023Copper ContributorThanks so much for all your help!
Another colleague gave me the answer.
There is another folder with the images , I need to upload those images to sharepoint or Onedrive
and use that URL link to be pasted in the dataset to show the pictures in the cloud.
The problem was solved.
Thanks again for all your help guys!