Unanswered

Recieve data from a different list

(0) Share

Report

Posted on by bodybenji

Hi there, i'm creating a online CMDB form in which i want to recieve cost centre information from a different sharepoint list based on the selected user. The image below gets me access to select a user based on their displayname which i,'ve also added in my other list

The image below is my COSTC list where i want to get their "title" from, i tried many ways of getting the data but can't figure it out. i would assume it's something like Get title from @costc where devices.email = costc.email

Anyone able to help me here?

Categories:

Building Power Apps

All responses (8)

Answers (0)

Sort by

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @bodybenji ,

What is the field name in COSTC that matches the selection made from the drop-down CurrentOwner field in Devices ?
bodybenji 8 on at

Like
a
(0)

Report
Copy link

Link copied!

The email field in COSTC matches the currentowner
bodybenji 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Due to it being work related with real first and last names i can't show TOO much in the screenshots @WarrenBelz
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@bodybenji ,

Your Filter should be

Filter( COSTC, Email = YourDropdownName.Selected.Value )

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
bodybenji 8 on at

Like
a
(0)

Report
Copy link

Link copied!

It should give me the accociated info from the title tab, not the email
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@bodybenji ,

Based on what you have posted (and I can only rely on that), it will show the entire matching record, You then simply need to display whatever field you need from the record. You have said that the Email field in COSTC matches the choices from the CurrentOwner field in Devices,
bodybenji 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Yeah i needed the info from Costs.title where Currentowner.devices = email.costc

and
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@bodybenji ,

You seem to have the wrong reference for the output of DataCardValue26. When you get this, the Title field would be

Filter( COSTC, Email = YourDropdownName.Selected.Value ).Title

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