Showing results for 
Search instead for 
Did you mean: 

Power Apps and Cookies, Not the kind you eat!

Do you ever find yourself wishing that you could harness the capabilities of ‘Cookies’ inside Power Apps to remember choices like not seeing a static notification every time you open a specific app?


This article will show you how to allow your users to ‘opt-out’ and remember their choice in a Power App.


Using a separate data source, a collection and a lookup we can effectively keep a record of everyone who chooses to opt-out.   The Lookup function doesn’t care how many rows are in the data source, making it an ideal option for those using SharePoint, as long as the formula only returns a single row.


Start by creating a new data source (SharePoint List, Table etc.) with a single text column to contain the identities of the users who have ‘opted out’ in the app and add it to the app.


NOTE: If you think you might want to expand the use of this to multiple apps and only want a single data source to manage it, add a second text column to identify the app each entry belongs to.  The end result should be an individual record per app for a user.   Example: If you have 5 apps using this functionality, you should have no more than 5 entries for a single user, 1 entry per app.



 1. Add the Office 365 Users Connector (if it hasn't already been added).   You could use the User() function, but please be aware that the information may not match the current user's information in Office 365 or other services.




2. Add a checkbox for the 'Opt-Out' control




3.  In the App 'OnStart', add 2 new formulas


NOTE: When setting the user variable I recommend using the mail property, as that will be unique, where displayName might not be.  Substitute your information for CollectionName, DataSource, ColumnName and varXXX.   (Add an additional parameter to validate against the application column if you are using this for multiple apps).


  • Set(varXXX, Office365Users.MyProfileV2().mail)
  • ClearCollect(CollectionName, LookUp(DataSource, varXXX = ColumnName))
  • ClearCollect(CollectionName, LookUp(DataSource, varXXX = ColumnName And ColumnName = “AppName”



Example 1Example 1


Example 2Example 2


4.  Select the control you added in step 2 and in the OnCheck property, set this formula:


If(CountRows(CollectionName) = 0, Patch(DataSource, Defaults(DataSource), {Title: varXXX}))


If(CountRows(CollectionName) = 0, Patch(DataSource, Defaults(DataSource), {Title: varXXX, AppName: "AppName"}))


NOTE: You may also wish to set an OnUncheck formula to remove the record from the data source if you want to ensure the user can still see the notifications in case they have selected the Opt-Out box by accident. (See Examples 2 & 3).  Don't forget to refresh your tracking collection :


Example 1Example 1


Example 2Example 2


Example 3Example 3


5.  Set the ‘Visible’ property on the controls you want to show/hide to this formula or add the red text into an existing



     CountRows(CollectionName) >0, false,



Example 1Example 1



Example 2Example 2


You can easily test all of this on a blank screen before making major modifications to your app.


Simply add a button for the OnStart formulas, a checkbox for the OnCheck and OnUncheck formulas, an icon for the Visibility formula and a label to display CountRows(collectionname).


Create, modify, tweak and test, then once it works to your satisfaction, make the changes to your app.

Meet Our Blog Authors
  • PowerApps Community Mentor 2018, Practicing surgeon and former Professor of Surgery, University of Illinois, Chicago.
  • Jill of All Trades (Power Apps, SharePoint, PowerShell, Exchange, Power Automate and odds & ends of assorted other things)
  • I am the Owner/Principal Architect at Don't Pa..Panic Consulting. I've been working in the information technology industry for over 30 years, and have played key roles in several enterprise SharePoint architectural design review, Intranet deployment, application development, and migration projects. I've been a Microsoft Most Valuable Professional (MVP) 12 consecutive years and am also a Microsoft Certified SharePoint Masters (MCSM) since 2013.
  • I'm Tim Leung - a PowerApps builder. In addition to PowerApps, my main interests include building software with SQL Server and Microsoft .NET. I'm the author of 'Beginning PowerApps' - the first published book on PowerApps. You can buy this from Amazon and other leading bookstores.
  • Systems developer
  • My name is Timothy Shaw and I create digital solutions using the Power Platform, Office 365, and Azure SQL and handle the IT for a small company in the energy sector. When not building the future :), I enjoy playing guitar, good (or really bad!) sci-fi, Xbox therapy, and hanging with my wife and son. Twitter: @ShortForTim