
Announcements
Hello,
I created a flow in which the responses of a MS Form survey get added to a table in an Excel file, via "add a row into a table". The table also contains a column, which converts the content of another cell (here the response from the survey) to a QR code, via an external API (=IMAGE("https://barcodeapi.org/api/qr/" & B4)).
When I have the Excel file open, I can see that the new row is added and that the QR code is generated a few seconds later.
The flow continues with a delay (to make sure that the QR code has enough time to be generated) and actions to convert the Excel file to a PDF and save this PDF.
The flow returns no errors, but when the PDF file is opened, instead of the QR code an error message is shown in the respective cell "#UNKNOWN!".
I assume that the image is not rendered when it is not actively opened.
Is there a way to generate the PDF with the QR codes displayed?
I created an easier version of the flow for testing without the survey (see below).
Flow part 1
Flow part 2
Excel
PDF
The pdf conversion does not convert the images. What you are getting is expected. It is a limitation of the OneDrive connector. You will need to use one of the dedicated premium actions from Adobe.