
Announcements
Hi, for the "Populate Word" piece, I'm attempting to lookup the company name (Company_Name) from my company table, based on the Company_ID. I've tried some different pieces for arrays, etc. but I'm failing somewhere.
| Audit_ID | Company_ID |
| 1 | 3 |
| 2 | 4 |
| 3 | 5 |
| Company_ID | Company_Name |
| 3 | ABC Company |
| 4 | DEF Company |
| 5 | XYZ Company |
Hi @ez1138,
If you want to use the filter query to find the associated columns, you should use the syntax:
Company_ID eq '5'
Here is a post with a similar requirement for reference:
Solved: SQL Lookup Expression - Power Platform Community (microsoft.com)
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.