web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / User only can access A...
Power Apps
Unanswered

User only can access App 1 in 3 months

(1) ShareShare
ReportReport
Posted on by 2
I am trying to write an application where I need the end user to only be able to access it 1 time every quarter. So for instance if John accesses this today they wouldn't be able to access it again until January. Now the same would be true if they waited until November or December. But they can only access it 1 once in that 3 month period.  
I have the same question (0)
  • WarrenBelz Profile Picture
    154,966 Most Valuable Professional on at
    You are going to need a control list with the user's email and a date last accessed. On user login, you would look up the date and test whether it was more than three months ago - if not, give the user a message, otherwise write the new date and let them in.
    With(
       {
          _LastDate:
          LookUp(
             YourList,
             YourEmailField = User.Email        
          ).YourDateField
       },
       If(
          DateDiff(
             _LastDate,
             Today(),
             TimeUnit.Months
          ) > 3 && !IsBlank(_LastDate)
       ),
       Navigate(
          YourDesiredScreen
       );
       Patch(
          YourList,
           LookUp(
             YourList,
             YourEmailField = User.Email
          ),
          {
             YourDateField: Today(),
             YourEmailField: User().Email          //allows for new records
          }
       ),
       Notify(
          "Only one visit in three months allowed - last visited on " & Text(_LastDate, "dd/mm/yyyy"),
          NotificationType.Error,
          5000
       )
    )
    
    
     
    Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
    MVP (Business Applications)     Visit my blog Practical Power Apps    Buy me a coffee

     
  • WarrenBelz Profile Picture
    154,966 Most Valuable Professional on at
    Just following up to see if you received the answer you needed, or if you require further assistance.

    Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
    MVP (Business Applications)     Visit my blog Practical Power Apps    Buy me a coffee

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 510

#2
WarrenBelz Profile Picture

WarrenBelz 426 Most Valuable Professional

#3
Vish WR Profile Picture

Vish WR 281

Last 30 days Overall leaderboard