Lookup based on Unique ID in another sharepoint list

(0) Share

Report

Posted on by MattRMI

Hello,

I'm trying to solve what feels like it should be a simple lookup -

I have two SharePoint lists:

Quotes - contains customer quotes, and a SharePoint generated unique ID number, and a column for the customer business.

QuoteID	Customer org	Type of work
1	Microsoft	Consultancy

Time spent - staff enter records of the time they've spent working on a particular quote.

User	Hours spent	Relevant QuoteID
John Smith	2	1

I have a ComboBox that gives users the option of selecting a Quote ID :1,2,3,4,5,etc

I then have a TextInput that I'm trying to use Lookup, looking in the Quotes table and finding the quote with the ID, and then populating with the data in the Customer Org

I've tried a few combinations of the following, but I keep getting hit by errors

LookUp(Quotes, ID=ThisItem.QuoteID.Value, 'Customer Org.')

So, this should be looking at the Quotes table, and if the ID number, i.e. "1" selected by the user in the combobox matches a QuoteID in the Quotes table, it should display the Customer Org column of that record.

So:

User selects QuoteID "1" in the combo box

Customer Org field is auto-populated with "Microsoft"

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

JD382 114 on at

Like (0)

Report

You can change the condition in your LookUp. ThisItem.QuoteID.Value can be something along the lines of comboBox.Selected.Value. The "Value" part of this could be something like "Result" or ".QuoteID", depending on how the items in comboBox are populated. Also, if Quotes contains a column titled QuoteID, then you need to change "ID" to "QuoteID".

Was this reply helpful? Yes No
MattRMI 4 on at

Like (0)

Report

I'm not sure what to change the value to,
In my Time Spent table, the QuoteID is a lookup column to the Quotes table.
From the Time Spent list, my users go New > and then select the Quote number in the form (lookup from the Quotes table). I just need the form to display the associated Customer of the quote when that drop-down has a number in it

Was this reply helpful? Yes No
JD382 114 on at

Like (0)

Report

What is in comboBox.Items?

Was this reply helpful? Yes No
MattRMI 4 on at

Like (0)

Report

Choices([@'Time log'].QuoteID)
This was auto-generated from the default form - remember the QuoteID source data is actually stored in the Quotes SharePoint list, not in the Time log list.

Was this reply helpful? Yes No
JD382 114 on at

Like (0)

Report

In that case, it's probably simply "comboBox.Selected.Value" as I wrote in the example. I should've been a bit clearer that this was the likely option and the others are alternative options.

Was this reply helpful? Yes No