Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Inserting LookUp values from Excel Table into Word/PDF

Posted on 21 Nov 2024 16:20:24 by 49
Hi everyone,
I have a Purchase Order PowerApp Form I am designing using PowerApps, PowerAutomate, and Sharepoint Lists. After the approval occurs, I have a condition set where I am populating the Purchase Order data in a Word Document and converting it to PDF. Everything is working, except one small issue.
I have a dropdown box in PowerApps that is linked to an Excel table (APVEN) in the Vendor Name field (VENDNAME) which is populating my Sharepoint List. However, the row in APVEN also has information like ‘address’ and ‘vendorID’ that I would like to populate in the PDF document. I have attached a Label in my Form to LookUp the vendor ID so I know everything is connected, but when I try to pull that value into Word/PDF it is showing up as blank.
Label showing VENDORID, which is a LookUp function of VENDNAME in the Dropdown.

To do this I have followed these steps:
  1. Created an action to find the table.
  1. Added ‘Filter array’ to filter on VENDNAME based on the Vendor Name that was selected in PowerApps.

Added a Compose action to find the VENDORID value.

And finally I have included the output of Compose to my Word document.

The result is that the field is blank. I’m thinking the Compose function isn’t set up correctly?

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

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,051

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,793

Leaderboard