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:
- Created an action to find the table.
- 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?