Answered

Finding data based off another list

(0) Share

Report

Posted on by DGWolfe

Hi all,

I have an app where by the User uses a drop down input to locate their role. Based on this, there are various screens that take to various information about their role.

All these screens and galleries of information point to the single drop down.

However, there is a second list of information I would like to also compare and provide information with.

Both lists live on SharePoint. Both have a "roleconnector" column on each list (numerical number given for each code).

Is there a formula that will take the result of the drop drown, find the roleconnector numerical of that list, and find and compare to the second lists roleconnector to enable to to the link up another gallery of info?

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Sort by

rb 835 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hey @DGWolfe, you will have to substitute your own Data Source names, but I can demonstrate this using the Filter() function used in the "Data source" property of a gallery:
Filter(SecondDataSource, ThisRecord.roleconnector = drpRole.Selected.roleconnector)

Does this help with your question?

Was this reply helpful? Yes No
DGWolfe on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks @metsshan

The above didn't work, but I continued to tweak and tried the below, which worked at the start, then I saved the app and now it's not working? So not sure what happened there?
Filter('Second SP list", roleconnector = roleconnectorGallery1(*this gallery is connected to first SP list*).Selected.RoleConnector && Title = TextInput.Text)

Was this reply helpful? Yes No
rb 835 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey, what's the error you are getting?

The only thing which stands out to me is the double quote at the end of <.. 'Second SP list" ..>, I think it should just be a single quote apostrophe.

Was this reply helpful? Yes No
DGWolfe on at

Like
a
(0)

Report
Copy link

Link copied!

There's no error, the galley just appears blank. And apologies, there is no " at the end, I just typed the code above, so that was a typo.

Strange, though? It worked...then it stopped but there is no error. Just a blank gallery?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@DGWolfe

To troubleshoot does your gallery show data with just

Filter('Second SP list', roleconnector = roleconnectorGallery1.Selected.RoleConnector)

Was this reply helpful? Yes No
DGWolfe on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp it does yes, but it shows all data for that specific role, where as I am trying to further define based on a second input.

But yes, it does show.

Was this reply helpful? Yes No
DGWolfe on at

Like
a
(0)

Report
Copy link

Link copied!

Correction. No, no that doesn't work either. Gallery remains blank

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@DGWolfe

Then try

Filter('Second SP list', Title = TextInput.Text)

I'm trying to see where the problem is, which part of the filter or the list itself. I'm assuming that if you just make 'Second SP list' as the items property, then the gallery populates! Check to make sure the double quote typo is fixed in your formulas.

Was this reply helpful? Yes No
DGWolfe on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Drrickryp ,this works, yes.

Was this reply helpful? Yes No
rb 835 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

If PowerApps is not generating errors, then I would suggest making sure all your Gallery controls are mapped to a field properly. Try changing the Gallery Data Source to just 'Second SP List' if you want to be sure PowerApps is properly pulling any data.

Was this reply helpful? Yes No