Power Platform Integration - Better Together! 'Request Phase')),ClearCollect(colStatus,"Display All"),Collect(colStatus,Choices('Tool Design Support Requests'. Concurrent(Set(varUser,User().Email),Set(varColors,{TealDark:RGBA(0,98,129,1),TealBright:RGBA(28,181,216,1),GrayCharcoal:RGBA(62,67,74,1),GrayMedium:RGBA(215,215,215,1),GrayLight:RGBA(245,245,245,1)}),Set(isAdmin,If(CountRows('Tool Request Admins')>0,true,false)),ClearCollect(colRequests,'Tool Design Support Requests'),ClearCollect(colPhase,"Display All"),Collect(colPhase,Choices('Tool Design Support Requests'. I used flow to update Sharepoint list for Email_Column from Created By column, which seems to hold the correct case in place.

Still confused on how case sensitivity plays a role with filters. I was able to get the following App OnStart formula and my gallery filters (not shown here) working, thanks to tutorials delivered by Reza Dorrani and Matthew Devaney, but I'm getting errors when I attempt to wrap all of this in the Concurrent function. For example to filter a data source by the current user, you would use someting like this: Filter(MyTable, User_email_column = CurrentUser.Email). You can always check if the variable is set properly by creating a label and setting its text property to: Don’t forget that PowerApps is case sensitive. Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment. I really appreciate you handing it to me on a silver platter. Warren, your formula worked great. This will help others find it more readily. The generated parameter. For example, Sqrt(25) returns 5. Featuring samples like Return to the Workplace and Emergency Response Applications, Features releasing from October 2020 through March 2021. I am not running into case sensitivity issues. This can cause you app to slow down, or … This OnStart formula throws errors.

Try this - note I have also shortened one of the other statements as you do not need the true/false on a Boolean argument - it is self-generating. Set(varUser,User().Email);Set(varColors,{TealDark:RGBA(0,98,129,1),TealBright:RGBA(28,181,216,1),GrayCharcoal:RGBA(62,67,74,1),GrayMedium:RGBA(215,215,215,1),GrayLight:RGBA(245,245,245,1)});Set(isAdmin,If(CountRows('Tool Request Admins')>0,true,false));ClearCollect(colRequests,'Tool Design Support Requests');ClearCollect(colPhase,"Display All");Collect(colPhase,Choices('Tool Design Support Requests'. Powerapps formulas run from top to bottom. The items to be added can be: 1. PowerApps bug: default property of check box is ignored on app launch, PowerApps: Concurrently returning variables and multiple arrays from Azure SQL Database, PowerApps: Repeating section with editing, PowerApps: How to update SharePoint choice and lookup type columns with Patch, PowerApps: Caching lookup tables to improve performance, PowerApps: Replace the Defaults() function to improve performance, PowerApps: Cryptocurrency exchange rate API custom connector, PowerApps bug: IsBlank(“”) is not the same as “”=Blank(), Microsoft Flow: Automatically uploading foreign exchange rates daily from the European Central Bank, PowerApps 101: Implementing many-to-many relationships between tables, PowerApps and Azure SQL Database: Current issues and how to work around them, PowerApps: A simple app using Azure SQL Database, PowerApps and Azure SQL Database: a step-by-step beginner’s guide, PowerApps: How to reuse your code (at least in the same screen), PowerApps bug: formatting of integer leaves stray decimal point, PowerApps issue: cannot update Azure SQL DB / SQL Server column value to NULL, Once you set the OnStart property you need to save/close and re-open the app in order for the OnStart property actions to be executed, CurrentUser will be a record type variable. Collect(colPhase,Choices('Tool Design Support Requests'. It also closes the item. I would like my app to load as quickly as possible so your help with the syntax is appreciated. I was looking for something like that, but didn't realize it is located on a screen. To see it practically, let’s open PowerApps editor and add a new screen and OnStart function to create a collection. I was looking for something like that, but didn't realize it is located on a screen. This can cause you app to slow down, or expressions with User() to not work at all. In order to avoid the issue of case sensitivity, you can use the Lower() function, so that for the OnStart property you do this: and ensure that User_Email_Column contains the email addresses all in lower case. You can do this through the OnStart property of your app. 'Request Phase'));ClearCollect(colStatus,"Display All");Collect(colStatus,Choices('Tool Design Support Requests'. PowerApps User() function – cache current user OnStart The User() function currently gets called by your app every time it is used. Thank you both! Power Platform Integration - Better Together! Some functions have side effects, such as SubmitForm, which are appropriate only in a behavior formula such as Button.OnSelect.