Answered

Using excel in power apps form and sharepoint list

(0) Share

Report

Posted on by MH81003

Hello, I need some ideas on how to make this issue work. I currently have a power apps form connected to a Sharepoint list, one of the cards in the form is for the dealer ID and another is for the dealer name. I have an excel file that lists all dealer IDs and the corresponding Dealer names. I have connected the excel file to the power app but I am stuck on how to get the dealer name text box to fill with the name corresponding to the dealer ID typed in the other text box. Any ideas?

Thanks,

Madison

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Anonymous_Hippo 1,247 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @MH81003

In Power Apps, you can achieve this by using the Lookup function which works by searching your Excel table for a specific record, matching the Dealer ID entered with the corresponding Dealer Name. Here are the steps:

Upload your Excel file to a location that Power Apps can access. This could be SharePoint, OneDrive, or Power Apps' own data store.

Connect to the Excel data source in your Power Apps application.

On the data card for the Dealer Name, you will want to use the Lookup function in the Default property of the text box where you want the Dealer Name to appear. The formula might look something like this:

Lookup(ExcelDataSource, DealerID = TextInput.Text).DealerName

In this formula, ExcelDataSource should be replaced with the actual name of your Excel data source, DealerID should be the column name in your Excel file for the dealer ID, TextInput.Text should be replaced with the actual name of your text box where the dealer ID is entered, and DealerName should be the column name in your Excel file for the dealer name.

Cheers!

Was this reply helpful? Yes No
MH81003 56 on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous_Hippo Thank you for the quick response, this worked perfectly!

Was this reply helpful? Yes No
Colgreg 8 on at

Like
a
(0)

Report
Copy link

Link copied!

I have a similar issue. I have passed Power BI data into the Power APP as well as a Sharepoint list.

When users select the power app ID they can enter their rating which gets sent with the customer name, ID and rating to SharePoint List. The issue is when selecting a customer who already has a rating within the Power App how can I look up the SharePoint List based in Selected ID in Gallery and display Rating?

Was this reply helpful? Yes No