How to determine first time users

[duncant]

How can you determine if a user is opening a Power App for the first time?

[mdevaney · Accepted solution]

@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."

[duncant]

@mdevaney 

What if the data source is an excel spreadsheet or CDS?  How would you go about it then?

[mdevaney]

@duncant 
Process is the same for SharePoint, Excel and CDS. Just replace the word SharePoint with your desired datasource.

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.