cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
EMohaisen
Helper I
Helper I

Lookup some fields from excel file to PowerApps form

Hello,

 

I have a PowerApps form and excel file on a SharePoint document library, I would like to look up some fields from the excel file to the PowerApps form.

 

i.e. I enter the PO# and lookup other fields from the excel file, please see attached screenshot.

 

any ideas? if you can please provide the steps, thank you!

1 REPLY 1
FabianAckeret
Solution Sage
Solution Sage

Hi @EMohaisen 

 

Excel files work the same as any other data source. The only difference is that you're loading your Excel table into your Power Apps. Once you did that, the handling is the same.

 

So, to create a lookup and auto-fill your country/state/city based on your Purchase Orderyou can add something like this to the Default property of your fields:

LookUp(<your Excel table>, 'Purchase Order' = PurchaseOrderTextbox.Text).Country

 

I hope this helps.


Please click Accept as Solution if my post answered your question. Like my answer? Consider giving it a Thumbs Up. Others seeking the same answers will be happy you did.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (1,847)