
Announcements
I am trying to set up a SharePoint lookup function where, if User().FullName matches a name in SharePoint, it will display 'COMPLETE,' and if User().FullName is not found in the list, it will display 'NOT COMPLETED.' How does this function work?
LookUp('Register Course Classes', 'Full Name' = User().FullName, "COMPLETED")
Hey @dylandavis09
You can write the following expression:
If(
IsBlank(LookUp('Register Course Classes', 'Full Name' = User().FullName)),
"NOT COMPLETED",
"COMPLETED"
)
But I hope, there will be only 1 entry for 1 person. I hope you are maintaining that properly.
I hope this helps 🙂