@FilipC2 if we assume:
- SharePoint List 1 contains the the phone model and employee level
- SharePoint List 2 contains the employee name and employee level
- The employee name field is a single choice people picker field
See the simple example below applied to the Items property of a Gallery:
Filter(
'SharePoint List 1',
'Your Employee Level Field from SP List 1' = LookUp(
'SharePoint List 2',
'Your People Field'.Email = User().Email,
'Your Employee Level Field from SP List 2'
)
)
If you're Employee Level fields are Choice fields, append the employee level field names with ".Value"
Filter(
'SharePoint List 1',
'Your Employee Level Field from SP List 1'.Value = LookUp(
'SharePoint List 2',
'Your People Field'.Email = User().Email,
'Your Employee Level Field from SP List 2'.Value
)
)
------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.
If you like my response, please give it a Thumbs Up.
Imran-Ami Khan
