cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerBSC_Dev
Regular Visitor

Filter 2 tables in order to get a result

Hi Mates, 

 

I'm creating an app and I have a dropdown that should give me a 'contact person' depending on a "Customer Name" and "Department", let me show you:

PowerBSC_Dev_0-1653471064165.png

So, In my sharepoint Lists, I have 2 Lists: 

PowerBSC_Dev_1-1653471214240.png

The "Contacts and depart" and the "Costumers Contacts".

  1. The DropBox Costumer name is linked to the result of the ComboBox, associated to the list "Costumers Contacts" to the 'Title' Column, that is in the previous screen (it should appear the costumer name).
  2. The department dropbox is linked to the "Contacts and Depart" list

Note: In the "Contacts and depart" list, i have the contact person column too. 

-----

So, in order to get a Contact Person in the dropbox, i made this formula:

  • Distinct('Contacts and depart','Contact Person', Filter(Dropdown11.Selected.Title in Dropdown13.Selected.Result))

However, the formula it doesn't work (probably, it's wrong)

I tried a lot of formulas and i always have an error or otions in blank.

 

Could you help me to discover the correct formula? 

1 ACCEPTED SOLUTION

Accepted Solutions
PowerBSC_Dev
Regular Visitor

Solved!

I had to change the dropdown11 formula to:

Filter('Costumers Contacts',Title = ComboBox11.Selected.Title)

View solution in original post

2 REPLIES 2
PowerBSC_Dev
Regular Visitor

I made a update in the formula:

Filter('Contacts and depart', Department = Dropdown13.Selected.Result, Hospital = Dropdown11.Selected.Title)

PowerBSC_Dev_0-1653491009300.png

 

The formula don't show me any error but I can't see any contact person yet. 

 

 

PowerBSC_Dev
Regular Visitor

Solved!

I had to change the dropdown11 formula to:

Filter('Costumers Contacts',Title = ComboBox11.Selected.Title)

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (1,825)