
Announcements
Hi!
I have a SharePoint List that have a multiple names but different access type when I used this code below,
If(LookUp(dbase, 'Email Address' = User().Email, 'Department Access Type') = "Signer", DisplayMode.Edit, DisplayMode.Disabled)
It only shows up the first result, which is "Maker" other columns shown below have the same value except the last column.
Please help me to find a best solution.
Try to switch the LookUp to Filter
If(Filter(dbase, 'Email Address' = User().Email, 'Department Access Type') = "Signer", DisplayMode.Edit, DisplayMode.Disabled)
And you might even be able to skip the filter part.
If(
ThisItem.'Department Access Type' = "Signer",
DisplayMode.Edit,
DisplayMode.Disabled
)
This depends if your control is in the gallery or not.