One thing we have realized over time is there aren’t many Power App formula examples across the internet. This post is dedicated to starting a list of formulas we find useful regardless of your skill level. We hope you enjoy!
Power Apps creates a lot of objects when you add fields and forms. Take some time and relabel objects if they will ahve any sort of logic added to them. It will help you long term in idnentifying what everything is doing behind the scenes. Datcard4.value is not every useful for anyone.
Nested OR / AND conditionals
In business terms, the below reads “Filter the list of projects if the current user is a developer, analyst or global user (admin) for the selected project and the project has a status of Active.”
Filter(Projects, User().Email in Developer_x0028_s_x0029_.Email || User().Email in System_x0020_Analyst.Email || User().Email in Global_x0020_Users.Email, Active_x0020_Project = true)
Since 2006, our specialized Microsoft Consulting teams have been delivering incredible solutions for clients all over North America and the world. Get in touchwith us today and let's talk about what it's like to have ESW on your team.