web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps If Lookup is match ret...

Power Apps

Answered

If Lookup is match return specific field else Custom Text

(0) Share

Report

Report

Posted on by Stuznet

71

Hi,

I am struggling with the lookup function.

I have two Lists built in the SharePoint.

List 1

Project ID

List 2

Project ID
Category

This is the formula I created. My goal is to lookup List2 based on the Project ID if is a match then return Category else "Complete"

Lookup(List2, Project ID = ProjectID_Input.Text, Category)

Thank you

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

WarrenBelz 156,750 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Stuznet
Try
With( { vPID: Lookup( List2, Project ID = ProjectID_Input.Text, Category ) }, If( IsBlank(vPID), "Complete", vPID ) )

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.
Stuznet 71 on at

Like
a
(0)

Report
Copy link

Link copied!

Brilliant thank you so much!

Join the conversation