Unanswered

Lookup from List

(0) Share

Report

Posted on by PietM

Good morning,

Spent a decent amount of time looking for the correct syntax but seem unable to get it right. This is a first attempt at building an App because I couldn't get it right with forms and thought it would be a good start to learn.

Purpose of the app. We have different departments with different processes. I need to create an app accessible from the Intranet SP site where users will log issues with processes.

I have a MS List with three columns, at the moment.

Dept, Process and 'Process Owner'

Cascading drop down filtering from the Dept to the Process. This is working.

First drop down is 'Dropdown1_Dept

Second is 'Dropdown_Process'

I'd like to display the 'Process Owner" name in a text box once the Process has been selected.

Formula:

LookUp(ProcessesMasterList,Dropdown_Process.Selected.Value=Process,'Process Owner')

tired this

LookUp(ProcessesMasterList,Process=Dropdown_Process,'Process Owner')

tried this as well

Lookup(ProcessesMasterList, Column Process = dropdown_process.selected.value, column 'Process Owner')

Advice please?

Categories:

Building Power Apps

All responses (6)

Answers (0)

Sort by

WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @PietM ,
Are you putting this code in the Default of the Text Input ? I cannot see your data, but suspect that 'Process Owner' is a Person field ? If so

LookUp( ProcessesMasterList, Process = Dropdown_Process.Selected.Value ).'Process Owner'.DisplayName

Also and /or Process is a Choice field

LookUp( ProcessesMasterList, Process.Value = Dropdown_Process.Selected.Value ).'Process Owner'

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
PietM 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Warren,

Thanks for the response!
The List looks like this
I used a Text Label with a formula:
PietM 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Advanced Properties
WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@PietM ,

It seems that Process is a Choice field and 'Process Owner' is a Text field as you are getting no errors. Again, I cannot see your data, but providing the Process matches the value selected in your drop-down, the label should show the 'Process Owner' from the matching record.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
PietM 8 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz
Thank you for helping. I'm not sure what you mean with not seeing the data, but I'll take a chance that you are referring to the MS List that I'm using as source?
The list was created from an Excel sheet I imported.
Department, Process and Process Owner are all Single Line of Text in the settings of the List. I did not make any of the columns a Choice. At the moment the Process Owner is just a name although I might need to add the Display Name and address of the person in additional columns to be able to use it to email the process query to them.
PietM 8 on at

Like
a
(0)

Report
Copy link

Link copied!

I think I managed to get it. Code below gave me a result in the text box. Thank you for the guidance!
LookUp(
ProcessesMasterList,
Dropdown_Process.SelectedText.Value=Process,
'Process Owner'
)

I can now move on to the next to allow for a Text Input section that will create an item in a new SP List that will then email the Process owner with the query.