cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
PravK
Level: Powered On

FindbyId query from PowerApps - SharepointList or Excel

Hi,

I am very new to PowerApps. Would like to know what is the best way to achieve the below requirement in PowerApps.

 

Given a CustomerId in PowerApps input field, the corresponding details of the customer (only) has to be fetched from SP List or Excel. Example : The excel or SP list has details of customers (CustId, Name, Locataion, PhoneNo, Address etc). There are 2000+ records and do not want to fetch many & apply filter at the PowerApps side in UI. Rather looking for an option to just fetch records that has the given CustId.

 

Thanks,

Prav

2 ACCEPTED SOLUTIONS

Accepted Solutions
Edwin-Abdalian
Level 10

Re: FindbyId query from PowerApps - SharepointList or Excel

if you are planning to show the Customer details in a Form (in View mode), create a textInput as your search ID textbox outside of the form.

Then set the Item property of the Form to : 

 

LookUp('Customers List', CustomerID = Value(txtCutomerSearch.Text))

there is no delegation issue and you should get 1 record back if the ID in textInput matches with any ID in your list

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

Please Accept as Solution if this post answered your question so other members can find it. If you found this post helpful consider giving my post a Thumbs Up!

View solution in original post

Community Support Team
Community Support Team

Re: FindbyId query from PowerApps - SharepointList or Excel

Hi @PravK ,

Do you want to retrieve corresponding customer detail info from a SP List or a Excel based on the specific CustomerId within your app?

 

Based on the needs that you mentioned, I think the LookUp function could achieve your needs. I have made a test on my side, please take a try with the following workaround:

Set the Default property of the Name Text Input box to following:

LookUp('SP List', CustId = CustomerIdInputBox.Text, Name)

Set the Default property of the Location Text Input box to following:

LookUp('SP List', CustId = CustomerIdInputBox.Text, Location)

Set the Default property of the PhoneNoText Input box to following:

LookUp('SP List', CustId = CustomerIdInputBox.Text, PhoneNo)

Set the Default property of the Address Input box to following:

LookUp('SP List', CustId = CustomerIdInputBox.Text, Address)

 

Please consider take a try with above solution, check if the issue is solved.

 

Best egards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Edwin-Abdalian
Level 10

Re: FindbyId query from PowerApps - SharepointList or Excel

if you are planning to show the Customer details in a Form (in View mode), create a textInput as your search ID textbox outside of the form.

Then set the Item property of the Form to : 

 

LookUp('Customers List', CustomerID = Value(txtCutomerSearch.Text))

there is no delegation issue and you should get 1 record back if the ID in textInput matches with any ID in your list

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

Please Accept as Solution if this post answered your question so other members can find it. If you found this post helpful consider giving my post a Thumbs Up!

View solution in original post

Dual Super User
Dual Super User

Re: FindbyId query from PowerApps - SharepointList or Excel

There will definately be a delegation issue if you store them in Excel, since Excel doesn't do delegation.  But if you store them in a SharePoint list you should be fine.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Community Support Team
Community Support Team

Re: FindbyId query from PowerApps - SharepointList or Excel

Hi @PravK ,

Do you want to retrieve corresponding customer detail info from a SP List or a Excel based on the specific CustomerId within your app?

 

Based on the needs that you mentioned, I think the LookUp function could achieve your needs. I have made a test on my side, please take a try with the following workaround:

Set the Default property of the Name Text Input box to following:

LookUp('SP List', CustId = CustomerIdInputBox.Text, Name)

Set the Default property of the Location Text Input box to following:

LookUp('SP List', CustId = CustomerIdInputBox.Text, Location)

Set the Default property of the PhoneNoText Input box to following:

LookUp('SP List', CustId = CustomerIdInputBox.Text, PhoneNo)

Set the Default property of the Address Input box to following:

LookUp('SP List', CustId = CustomerIdInputBox.Text, Address)

 

Please consider take a try with above solution, check if the issue is solved.

 

Best egards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

PravK
Level: Powered On

Re: FindbyId query from PowerApps - SharepointList or Excel

Thankyou @Edwin-Abdalian  @v-xida-msft  @Pstork1  ! your inputs were helpful.

 

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,033)