Set multiple variables with one LookUp

(0) Share

Report

Posted on by RobDin

In my Canvas Power App I've been running a vehicle search against a SQL Server data source, but I'd like to reduce my query costs at the server level. Currently my on select has the following code:

Set(XVIN,LookUp(Trucks,Plate = XPlate && PlateState = XPlateState,VIN));
Set(XManufacturer,LookUp(Trucks,Plate = XPlate && PlateState = XPlateState,Manufacturer));
Set(XModel,LookUp(Trucks,Plate = XPlate && PlateState = XPlateState,Model));
Set(XModelYear,LookUp(Trucks,Plate = XPlate && PlateState = XPlateState,ModelYear));
Set(XEngineType,LookUp(Trucks,Plate = XPlate && PlateState = XPlateState,EngineType));
Set(XVehicleClass,LookUp(Trucks,Plate = XPlate && PlateState = XPlateState,GVWR));

Is there a way to consolidate these six queries into one and get the same effect?

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

ANB 7,252 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @RobDin , Try This:

Set(gblvar,LookUp(Trucks,Plate = XPlate && PlateState = XPlateState))

Now you can use this gblvar using "dot" Example:

gblvar.VIN

gblvar.Manufacturer

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB