Hi!
Any help is greatly appreciated.
I am wanting to have a gallery that displays information from three different SharePoint lists based on what the user filters. The search will pull from list 1 then additional information from list 2 and 3.
For example, if the user filters for PNumber 123 the gallery will display Super Man and Company A.
Orientation list
| PNumber | UNumber |
| 123 | 1 |
| 456 | 2 |
| 789 | 1 |
User list
| UNumber | First Name | Last Name | CNumber |
| 1 | Super | Man | 1 |
| 2 | Bat | Man | 2 |
List Three
| CNumber | Company |
| 1 | A |
| 2 | B |
Looking for a formula that can display all this information based on the filter field.
Thank you!

Report
All responses (
Answers (