
Announcements
Hello! So i am currently trying to understand if its possible to do a vlookup in power-apps with the data source being a SharePoint list. The POC i am working on will take an ID number then populate text boxed with information from different columns based on that ID number.
Has anyone else done this?
@Anonymous
The LOOKUPfunction will do exactly the same as VLOOKUP in Excel. See the link below for some usage examples.
Example
LookUp(your_datasource_name,ID=your_id_number,your_target_column)LookUp('Clients List',ID=1001,'City')
Link to LOOKUP Documentation
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."