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
Super User
Super User

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
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,759)