Hello PowerApps Community!
Working on building my first PowerApp (I’m a non-programmer). I’ve hit a wall and am hoping to get some guidance…
My collection: I’ve got a collection that includes images I’ve taken inside PowerApps (with the camera feature).
My goal is to get my collection data (including photos) to appear in an .HTML (that will then be converted in Flow to a PDF - NOTE: I've got that part ok).
My progress: I used Shane Young’s awesome solution https://www.youtube.com/watch?v=bfXV_GXc_JM (25 minutes, 17 seconds) – and poof – I have everything I need except the photos.
My issue: I can’t get the collection camera photos to into appear…(I know they need to converted – but I'm not sure how to best do this).
For my situation:
- The easier the code, the better (I'm not a programmer)
- I'd prefer not to use a ton of flows to do this (e.g. one per photo), but ok if that's the only solution.
- I can’t use a custom connector (already used my 1)
- I can (and wouldn’t mind using) sending the photos to Azure Blob temporarily (already have an account and do this for the pen and ink signature))
- I’m guessing I’ll need to be using the ForAll function somewhere – and if we don’t use Azure Blob, will probably want to use flow to convert to dataUriToBinary as described here - https://www.youtube.com/watch?v=ovLIwnj6QjU (18:18). Maybe I will need to use First or FirstN?
Anyways…Any guidance would be much appreciated.
I really appreciate the training and guidance put out by superusers – and appreciate this community. Here’s a few links that could be potential solutions.
- https://www.techmikael.com/2017/05/saving-collection-of-images-from.html
- https://www.youtube.com/watch?v=IhE0-HumNNo
- https://powerusers.microsoft.com/t5/General-Flow-Discussion/SP-Online-attachments-to-PDF-in-a-dynami...
- https://powerusers.microsoft.com/t5/PowerApps-Community-Blog/Using-email-templates-when-sending-emai...
- https://powerusers.microsoft.com/t5/Creating-Apps/HTML-Text-to-Flow-Convert-html-file-to-PDF/td-p/16...
- https://www.youtube.com/watch?v=mp-8B1fLrqs
- https://powerusers.microsoft.com/t5/General-Discussion/Dynamically-create-a-table/td-p/156766
- https://explore.emtecinc.com/blog/how-to-upload-camera-pictures-directly-to-microsoft-sharepoint-wit...
- http://johnliu.net/blog/2018/7/the-simplest-no-code-solution-to-save-pictures-files-from-powerapps-t...
- https://powerapps.microsoft.com/en-us/blog/upload-files-from-powerapps-using-the-azure-blob-storage-...
- https://www.youtube.com/watch?v=ya5A4HLx27Q
Here’s my code:
"<!DOCTYPE html>
<html>
<body>
<center>
<h2>Additional Information and Data</h2>
<table style='width:100%'>
<tr>
<td><b>Name</b></td>
<td><b>Details</b></td>
<td><b>Tab</b></td>
</tr>"
& Concat(CameraPhotos2, "<tr><td>" & Name & "</td><td>" & Detailss & "</td><td>" & Tab & "</td></tr>")
&
"
</table>
</body>
</HTML>
"
Helpful resources
Power Apps Community Call: February
Did you miss the call? Check out the Power Apps Community Call here.
Microsoft Ignite
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
