web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Getting a value from a...

Power Apps

Answered

Getting a value from a SharePoint list based on value in the original list

(0) Share

Report

Report

Posted on by Stout

5

Hi everyone, I’m very new to Power Apps so apologies in advance for this question. I’ve been looking through the forum but haven’t been able to find an answer that fits my situation.

In a Power App, I’m trying to get a value from SharePoint LIST_1 and add it to SharePoint LIST_2 based on a value entered in LIST_2.

Filter('LIST_2, LIST_1_DataCard1.Value#1 = LIST_2.Value#1, LIST_2.Value#2)

Currently, the Value#1 in LIST_2 is a SharePoint column of type Lookup. I don’t know if this matters.

I’m not sure what I’m doing wrong. Can anyone point me in the right direction?

Thanks very much for the help.

Stout

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Stout ,

You need LookUp, not Filter

LookUp( 'LIST_2, Value#1 = LIST_1_DataCard1.Value#1, Value#2 )

I assume you will be putting in the actual references.

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
Stout 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much @WarrenBelz. Very much appreciate the help. Stout.

Join the conversation