How to send QR generated by Google API as attachment in PowerApps Flow?

[Anonymous]

Here's my current scenario: The QR code generated by Google API is using the Attendee's ID as it's parameter. This is meant for external use as these users don't have PowerApps account. What I intend to do is blast e-mails to every users with the QR code attached, so they can scan it using the iPad devices provided by me.

I'm currently having some issues on how to save this generated QR code for every users into SharePoint and then attach the QRs in the e-mails. I've thought about saving the QR codes by using a Picture or Hyperlink column, but I don't know whether this is the correct way of doing it, so I need some help here. Also, if I were to save the QR codes using the Patch function, do I just add it in the "Image" function under DATA?

[v-siky-msft · Accepted solution]

Hi @Anonymous ,

Please check my answer of this thread: Retrive base64 string from barcode generated from chart.googleapis.com 

Following the below flow steps, first to save the QR code to OneDrive for business by URL, then extract the image file content and save to SharePoint.

Hope this helps.

Sik

[Anonymous]

Nice, thanks! That worked to save the QR as an image file, but is it possible to take those image files that are currently in a folder and update them into a Picture column into an existing SP list? 

I've tried using SharePoint's "Update Item" flow action but unfortunately the Picture column doesn't show up.

[v-siky-msft]

Hi @Anonymous ,

The image column in sharepoint list actually is the Hyperlink type column, so it must be a URL of the image file that can be saved to the image column.

Hence, we need to compose the Image File URL, here is the URL composition:

https://DomainName.sharepoint.com/sites/SiteName/LibraryName/ImageName.jpg

Please try to add a compose action before the Update Item action to generate the URL of image stored in SharePoint Library, and then update the Compose Output to SharePoint list.

Hope this helps.

Sik

[Anonymous]

Just what I needed! Thanks for your help!