You’re offline. This is a read only version of the page.
133
Hi, guys! I'm stuck in logic here... So I have partners who are responsible for 1 or more departmenst.In my report I want to have all the departments information that "x" partner manages. So if I manage 3 department i want all the 3 departments info. If I manage 1 department, I want this 1 department info from the sharepoint list. Partners and their departments info is stored in "Partner" sharepoint list. I filtered my sharepoint database "fulldata" like this: Filter(fulldata, department=First(Filter(Partners,Lower(User().Email)=Lower(Title))).department || department=First(Filter(Partners,Lower(User().Email)=Lower(Title))).department1 || department=First(Filter(Partners,Lower(User().Email)=Lower(Title))).department3) but it's not filtering. It filters only according to 1st logical test... Have you any suggestins how to modify this code so it takes all the data that are matched to these criteria?
Like this...
Share
Report
All responses (
Answers (
Filter(fulldata,
First(Filter(Partners,Lower(User().Email)=Lower(Title))).department in department
|| First(Filter(Partners,Lower(User().Email)=Lower(Title))).department1 in department
|| First(Filter(Partners,Lower(User().Email)=Lower(Title))).department3 in department
)
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
