Hello! I have an app that I created where based on the employee number it finds an image on a form. Because of the limitations of powerapps, the SP list has a field called "Photo" set as Image, this way Powerapps can display the photo on the phone. The problem is, the image can't be submitted this way, the field remains empty after the form is submitted. The image is displayed on the form, but not submitted. Is there a way around this?
I thought about creating two image columns on the SP list, one set as hyperlink to submit with the form and create a calculated column where the image is displayed based on the link column, to show it on the app, but I don't know how to do this either.
Thank you in advance!
Hi @CarlosCalleja ,
Just checking if you got the result you were looking for on this thread. Happy to help further if not.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Hi @CarlosCalleja ,
Assuming you are using the image control name as the reference correctly, it should be possible to put this on the Update property of the Data Card containing the multi-line text field (ensure it is Plain Text).
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
@WarrenBelz thank you, I think that option would work great, my only question is where would I write the JSON conversion? I tried to put it on the text option of a DataCard, but I get an error message.
Hi @CarlosCalleja ,
A per this post of yours, if you have an image file stored in SharePoint, you cannot display it from a URL reference on a mobile app.
You need to link to the Library with whatever reference you have in the metadata and use the Thumbnail reference. The file name is present in the Library, is there, but the query is not Delegable if this is what you have to reference it, so you need an identifier such as the ID to link the items.
The other option you have is to store the photo in Base64 format in a the SharePoint List Multi-line Text field itself using JSON conversion.
Substitute(
JSON(
YourPhotoControl.Image,
JSONFormat.IncludeBinaryData
),
"""",
""
)
This will resolve in an Image control on both PCs and mobile devices as simply
TheItem.YourFieldName
however it is not saved as an image that you can view in SharePoint
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
WarrenBelz
146,645
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,997
Most Valuable Professional