Hi Team,
I have a requirement to filter a gallery based on three different columns in sharepoint. I have used a if condition in the gallery items property to filter based on the button selected.
The three columns are person type columns ==admin,supervisor,submittedBy
Sharepoint list name----TestSp
I need to display the records in the else condition whereever the
- current loggedin user is present in the admin column (and)
- current loggedin user is supervisor but not equal to submittedBy (and)
- current loggedin user not equal to submittedBy
I have used the below code: It is not throwing syntax error but not displaying any record.
Totally i have 2 items tagged as admin and 2 items as supervisor(SubmittedBy != Supervisor)
So i should see 4 records in the gallery.
=====================
If(
varSet = true,
Sort(
Filter(
'TestSp',
StartsWith(
'Opportunity name',
'txt.Search'.Text
),
Status.Value = "Approved" && (Lower('SubmittedBy'.Email) = Lower(User().Email)) && (Assessment_status.Value = 'Drp.Status_1'.Selected.Value || 'Drp.Status_1'.Selected.Value = Blank()),
(DateValue(Created) >= DateValue(Date_1))
),
Modified,
Descending
),
Sort(
Filter(
'TestSp',
StartsWith(
'Opportunity name',
'txt.Search'.Text
),
(Lower(User().Email) = Lower('admin'.Email)),
((Lower(User().Email) = Lower('Supervisor'.Email)) && (Lower(User().Email) <> Lower('SubmittedBy'.Email))) && (Assessment_status.Value = "Draft" || Assessment_status.Value = "Approval Pending" || Assessment_status.Value = "Approved" || Assessment_status.Value = "Rejected") && (Assessment_status.Value = 'Drp.Status_1'.Selected.Value || 'Drp.Status_1'.Selected.Value = Blank()),
(DateValue(Created) >= DateValue(Date_1))
),
Modified,
Descending
)
)
Please help me out .
Thanks and Regards,
Kiruthika
