web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Convert Excel with dyn...
Power Automate
Unanswered

Convert Excel with dynamically generated QR Code to PDF

(0) ShareShare
ReportReport
Posted on by 12

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 1Flow part 1Flow part 2Flow part 2

ExcelExcel

PDFPDF

Categories:
I have the same question (0)
  • David_MA Profile Picture
    12,966 Super User 2025 Season 2 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 523 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 406 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard