Unanswered

Powerapp Lookup value not returning anything

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi everyone

I am trying to get a lookup value to look at a sharepoint list datasource and return a value based on a selected value in my powerapp form.

I have 2 sharepoint lists

List 1 - Cars List

List 2 - Maintenance Works

Cars List has the following fields

-Name (text)

-Insurance (yes no)

-Insurance expiry (date)

Maintenance Works has the following fields

-Name (lookup to name Cars field)

-Date of works (date field)

-Works to be carried out (multi line text)

-Insurance expiry (lookup to Insurance expiry cars field)

I have created a sharepoint form on the Maintenance list, what i am trying to achieve is when the name of the car on the form is selected from the dropdown i want it to check the insurance expiry to see if its in date or not.

I created a label field to test the output but keep getting a formula error, this is what i have tried

LookUp('Cars List', Name =DataCardValue7.selected.value.insurance expiry)

DataCardValue7 is the drop down list for the Name field on the form

Can anyone put me out of my misery 🙂 im very new to this i must add

Thank you

Categories:

Building Power Apps

All responses (6)

Answers (0)

Sort by

Akash17 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

HI
LookUP('Car list' , Name =DataCardValue7.selected.Value , 'insurance expiry')
Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

LookUp('Cars List', Name =DataCardValue7.Selected.Value).'insurance expiry')

FYI, Name is a reserved word and should be avoided in naming a column. Selected and Value have to be capitalized. If there is a space in the insurance expiry then it should be enclosed in single quotation marks.

For some more tips on working with SharePoint in PowerApps see my blog post https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/The-Ten-Commandments-of-SharePoint-in-PowerApps/ba-p/848842
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp Thank you very much for this. Just read your blog post as well which has some fab pointers for a newcomer like myself.

would you be able to elaborate on the parent/child linking separate lists instead of using lookup columns? Sounds like a much better way of doing things
Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

Please check out my 5 part series starting with the overview here. I go into the way to work with one to many relationships and how to implement them in part 4 and part 5. https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Database-Design-Fundamentals-and-PowerApps-An-Overview/ba-p/184485?search-action-id=172232353086&search-result-uid=184485
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for this i shall give this a good read over today. I have one more quick question if thats ok

The formula you mention
LookUp('Cars List', Name =DataCardValue7.Selected.Value).'insurance valid')

How would i be able to make this into an 'IF' to fill a colour for example
IF LookUp('Cars List', Name =DataCardValue7.Selected.Value).'insurance valid') = yes fill data card green

Hope that makes sense, appreciate any advice
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

IF( LookUp('Cars List', Name =DataCardValue7.Selected.Value).'insurance valid') = "yes",Green,Transparent)