@duncant
Make a new SharePoint list called 'MyAppUsers'. Create a new column single line text column called 'UserEmail. Connect this SharePoint list to your app.
Now in the OnStart property of your app input this code
If(IsBlank(Lookup(MyAppUsers, UserEmail=User().Email),
Set(newUser, true),
Patch(MyAppUsers, Defaults(MyAppUsers), {UserEmail: User().Email});
Set(newUser, false)
)
When a user cannot be found in the MyAppUsers list the newUser variable is set to true and the user's name gets written into the list.
---
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."
