New
#PowerApps
Book 📕
I wrote a book with 50+ pages of coding rules, guidelines and best practices I use everyday to create
#PowerApps
Canvas apps 😀
Download the PDF version for FREE 👇
🔗
I just found a treasure trove of free
#PowerApps
training materials
App In A Day
PowerApps Admin In A Day
Connector In A Day
Flow In A Day
Thanks so much
@chass
#PowerAddicts
NEW Website:
#PowerApps
Collections Cookbook
I wrote a “Collections Cookbook” with over 50 visual examples and code you can COPY + PASTE into your own apps
Check it out for FREE and bookmark it for future use.
Link
#PowerAddicts
1/3
You don’t need a
#PowerAutomate
“Apply To Each” loop to get only one record. 🛑
Use this expression to eliminate the loop 👇
Code:
first(body(‘Get_Items’)?[‘value’]))?[‘columnName’]
New Blog Post 😃
In this
#PowerApps
article I share a cheat sheet of all 150+ Power Apps functions categorized by type 📚
I've also included 3 HIDDEN functions which do not appear in the official documentation 🔥
🔗
#PowerAutomate
can write to
#Excel
at blazing fast speeds using
#MSGraph
🔥
I created 10 rows in 1️⃣ second with Graph vs. 10 rows in 1️⃣4️⃣ seconds with the built-in Excel connector.
The best part is it scales to 100k rows! 👍👍
Here's how I did it:
🔗
Today I started my new job as a Consultant at Hitachi Solutions Canada 🇨🇦
Being a part of the
#PowerApps
community for the past year has changed the course of my life 🌟
Now I get to bring that passion to my work everyday. I’m excited to see what the future holds 😊
#PowerApps
, please remove the back button from studio mode! 🤬🪧
How many times have we all tried to click "File" but hit "Back" instead and lost our work 🤦
LIKE THIS MESSAGE if you agree ❤️
Lately I've been obsessed with using
#PowerAutomate
&
#MSGraph
to work on
#Excel
files 🤖📝
Here's the top 5 things I learned 😲
1️⃣ Reading
#Excel
tables is faster with Graph. I read 50k rows in 7s vs. the Excel connector which took 5m. 🔥
2️⃣ Multiple rows can be written to
Creating
#PowerApps
is so much more than just writing some code ✍️
That’s why
#CoPilots
will never fully take over this space 🧑🚀
You have to understand the business process you’re replacing 💼
You have to understand the product you are making and the pain points it
#PowerApps
Idea 💡
We could eliminate 50% of the controls in a form if input fields had a Label property 🔤
I want to see this property added to Text Input, Date Picker, Dropdown/Combobox, etc. 🎨
Let me know if you love this idea ❤
#PowerApps
Progress Indicator Component V2 😀
Show the status of an 'approvals process' or other workflows with this
#MSTeams
style component.
Use your own images or the built-in icons. Fully customizable to match any theme.
Link To Free Download
🔗
#PowerApps
Game: Pipe Dream
I built the classic PC game Pipe Dream in PowerApps featuring all custom artwork by my wife. Connect the pipes and try to beat all 10 randomly generated levels.
Download it for FREE on the community gallery
#PowerAddicts
#PowerAutomate
can now trigger a flow...
from
#CoPilot
!!! 👨✈️ ✈️ 🔥
But there's no documentation on it. 📃
First one to figure out how it works wins! 🏆 🎉🎈
#PowerApps
Collections Cookbook
I wrote a “Collections Cookbook” with over 50 visual examples and code you can COPY + PASTE into your own apps.
Check out the full list of examples on the Community Gallery and download it for FREE.
Link:
#PowerAddicts
Pull to refresh is a feature I really want to see in
#PowerApps
modern controls ♻️
No apps in the App Store require the user to press a refresh button for updated results 🔘
So I think it’s time to add this… 😺
#PowerApps
Alert ⚠
The DISTINCT and SPLIT
#PowerFX
functions now output a field named "Value." 😲
Previously, those functions output a field named "Result." 🔠
Watch out for this potentially breaking change when republishing your old apps 🚨
#PowerAppsTip
🔥🔥
You can make a time-picker⏰
with only 1 line of code😲
Get the code here 👇
Items property of a dropdown:
👉 ForAll(Sequence(96), Time(0,Value*15-15,0))
You need to know this
#PowerApps
error-handling pattern 😺
When we create a new record with the PATCH function it returns either:
✅ The newly created record
❌ Or an error message
continued in the post below (1/3)👇
I've solved phone number formatting in
#PowerApps
for every country 🔥🔥🔥
All you have do to is define the phone number as a text string like this☎️
"(###)-###-####"
Then the number is automatically formatted as you type 😲
Learn how to do it here:
🔗
#PowerAppsTip
🔥🔥🔥
Remove all duplicate records in a
#PowerApps
collection using the ThisRecord operator. FINALLY, a simple way!
ClearCollect(colNoDuplicates,ForAll(Distinct(colWithDuplicates, ThisRecord),ThisRecord.Result));
#PowerAddicts
🔗
5 New
#PowerApps
Modern controls launched yesterday 🚀
1. Tab List 🗂️
2. Info Button ℹ️
3. Spinner 🛞
4. Progress Bar 📈
5. Web Link 🔗
See what they look like in this thread 🧵 👇
New
#PowerApps
Feature (Coming Early 2024) 💡
Simple controls will now include a Title & Required property built in 😲
This capability will only be found in the Modern Controls 🕹
I can't wait. It will save me so much time and help declutter my app screens. ⏰
(Mockup below)
New
#PowerAutomate
Book 📕
I wrote a book with 60+ pages of coding rules, guidelines and best practices I use everyday to create
#PowerAutomate
Cloud Flows 🤖
Download the PDF version for FREE
🔗
I really like
#PowerAutomate
Desktop but I really dislike the product name. Why?
1. It's too long
2. It's too similar to Power Automate (cloud)
3. It's RPA (robotic process automation)
Just call it "
#PowerRPA
" like you did for "
#PowerBI
"
#PowerApps
Idea 💡
Wouldn't it be cool if we could seamlessly switch between low-code and pro-code pressing a hotkey?
Imagine editing
#PowerApps
in
#VSCode
without any export.
Programming is hard.
The struggle is real even for experienced developers.
Why? Our job is to solve problems, and by definition, every problem starts at the same exact place: “I don’t know.” We have to figure it out.
Remember this and be kind to yourself and other devs
#PowerApps
Drag & Drop Control
How cool is this?😎
@ScottDurow
made a control where you can drag & drop items in a canvas app.
Its fully customizable and a FREE download. Here's a link to the full video on YouTube:
🔗
#PowerApps
User() Function has a NEW property 😲
"Microsoft Entra Object ID of the current user, useful for calling APIs that use this value. This is a GUID value and unique for each user." 👨💻
If
#ChatGPT
has taught me one thing... 👨🏫
It is that people are going to value trusted sources of knowledge alot more. 🧠
That's why I will continue to write
#PowerApps
and
#PowerAutomate
blogs. ✍
#PowerApps
Drag and Drop
🖱 Click to drag between zones
🎨 Fancy HTML +
#CSS
styling
🧩 Free canvas code component
♥ Made by Scott Durow
🔗 Learn how to use it here:
I enjoy teaching people how to build
#PowerApps
😊
And I like doing projects that will benefit the community 🙋♂️ 🙋♀️
But I also need to make a living from
#PowerApps
💰
So here’s my thoughts on how to do both 👇
/1
What's the fastest way to load the Alphabet into a
#PowerApps
collection?
Take a look at how my answer to this simple question has changed from when I started learning PowerApps 6 months ago.
Practice the skill you want to improve at everyday!
#PowerAddicts
#PowerApps
Progress Indicator Component
Use your own images or the built-in icons. Fully customizable to match any theme. Show your app users the current progress of a workflow.
Link to FREE download:
#PowerAddicts
@MSPowerApps
My “Complete
#PowerApps
Functions List” outranks the official
#Microsoft
docs in search results 😳
(Thanks for the image
@abcguzowski
)
Check it out here 👇
🔗
1️⃣0️⃣, 0️⃣0️⃣0️⃣ Subscribers Achieved 🏆
My
#PowerApps
blog hit a huge milestone today. After 3️⃣ years of writing I now have a readership of over 10k!
Thank you to everyone who has:
👀 Read my blog articles
✉ Signed up for weekly emails
💬 Commented on articles
🔗 Shared a link
New
#PowerApps
Modern Controls Guide 📕
I wrote a guide to the new
#PowerApps
Modern Controls. It explains how to use all 13 controls and has an explanation for each property.
Get info that doesn’t exist in the official
#PowerApps
documentation 👇
🔗
He did it! Reza Dorrani's Youtube channel just hit 100k subscribers😺
Reza is truly one of the masters of teaching
#PowerApps
,
#PowerAutomate
.⭐
Without his encouragement I might not have started on my own journey 🙀
Well deserved. Hats off to you Reza! 🎩
The Complete
#PowerApps
Functions List
✅ All 150+ functions
✅ Even the undocumented ones
✅ Organized by category
✅ With parameters like a cheat sheet
🔗
#WeightLoss
Goal Achieved 🏋️♀️
Started out with a 38” waist pants on New Years Eve 💥
Here’s me fitting into my wedding suit at 34” waist pants. So happy 😀 👖
For a little more info on my strategy check the thread below 👇
New
#PowerApps
Feature 🚨
Variables and Collections Viewer is updated! 😎
To use the new feature, make sure your Power Apps authoring version is 3.23042.5 or higher! 🗻
See a preview here 👇
You're wrong if you think
#PowerApps
only has 10 fonts
Here's my canvas app that uses 177 custom fonts 😲
Want to know how I did this? It's dead simple 👇
...
Go to the Font property of any label then type in a font name like this:
"Times New Roman"
If the font is supported
NEW
#PowerApps
Feature 😲
Drop Shadow For Containers 🐱👤
Available on authoring version 3.23044.4 📱
You can select a drop shadow weight from the properties menu
- None
- Regular
- Semibold
- Bold
- etc.
THANK YOU
#PowerApps
Team 😃
100th Blog Post Milestone ⭐️
I’ve been writing a new weekly
#PowerApps
article for 2 years now. Consistency pays off.
Started June 2020 (2k visits/month)
Currently May 2022 (135k visits/mo)
Subscribe to learn something new about
#PowerApps
each week.
I just noticed that Reza's (
@rezadorrani
)
#PowerApps
channel is about to hit 1⃣0⃣0⃣k subscribers 👀
Go smash that Youtube subscribe button if you haven't already 🚨
4 New
#PowerApps
Functions are now available 😲
EOMonth is my favourite 📆
It returns the end of the month for a given date
Example: EOMonth( Date(2024, 1, 5), 0) = 1/31/2024
Other new functions are: EDate, Dec2Hex, Hex2Dec
The fastest way to read an
#Excel
table in
#PowerAutomate
is
#MSGraph
. Check out how freaking quick I pulled 5️⃣0️⃣ k rows 🏃♂️
7️⃣ seconds with
#MSGraph
vs. 5️⃣ minutes with the
#Excel
connector 📚
And it scales to 100k rows!👍👍
Here's how I did it:
🔗
It is time to switch to the new
#PowerAutomate
designer. 🥳
There are many things to like about the
#UI
👍👍
⭐ Multiple line code editor
⭐ Left-pane to fill action properties instead of a floating box
⭐ Compact action boxes, can see more
⭐
#CoPilot
right-pane
Create a new
#Excel
file in
#PowerAutomate
with
#SharePoint
REST API.
The advantage of this method is you do not need to work from a template.
Or copy the content from a blank
#Excel
file
You can enerate a new Excel file in a single action ❤
🔗
New Blog Post 😃
In this
#PowerApps
article I will improve your coding style with 1⃣0⃣ Power Apps code examples.
You, my fellow human, are about to become better at writing Power Apps code 👨💻 🔥
🔗
Missing
#PowerAutomate
actions can often be done with
#MSGraph
. 🤖 💭
I use code to send email with an inline embedded image. It is compatible with all mail clients. 📫
#PowerAutomate
has many ways to generate a
#PDF
. Here are some pros and cons of each 👍 👎
1️⃣ HTML to PDF
Compose an HTML web page and convert it to a PDF with the OneDrive create file action
Pros 👍
- Standard license
- No template to maintain outside of the flow
- Template
Fill-in an
#Excel
template using
#PowerAutomate
.
Read the article here 👉
Excel offers many advantages over HTML and the
#MSWord
methods when creating a PDF:
💎 Standard license
🦶 Headers and Footers
🖼️ Repeating Images in tables
🤓 Build logic into
I Love This
#PowerApps
Blog Post ❤️
By
@GeorgeCusworth
This is a step-by-step guide on how to take a plain looking gallery and make it look beautiful. Easy to follow style and lots of screenshots.
🔗 Read the article here:
Don't be intimidated by writing a blog. You don't need to be an expert to start. You will learn along the way 🤓
All great explorers "documented their journey" in a logbook. They didn't wait until the end to chronical their adventures 📕✍️
8 New Delegable
#PowerApps
Functions 🔥
1️⃣ UpdateIf
2️⃣ RemoveIf
3️⃣ GUID
4️⃣ IsToday
5️⃣ Now
6️⃣ Rand
7️⃣ RandBetween
8️⃣ Today
⭐️ What does it mean?
It will be easier to write delegable functions. You will see less errors showing a blue underlined section of code.
What are the biggest missing features in
#PowerApps
?
I'll start the list:
🎨 Format painter - quickly copy + paste a theme from one control to another
Tell me yours in the replies 👇
Top
#PowerAppsTip
Posts Of 2020 🔥🔥🔥
I've made a list of the top
#PowerApps
tips from this year. Check out how to use them in the article below.
🔗Link To Article
2,000 Free
#PowerApps
Icons 🤩
Get the entire SVG icon set for FREE to use in your own apps. Available in 30 different pre-set colors 🎨 or choose your own!
#PowerApps
Date & Time Formatting Tip 📅 ⏰
Here's how I format dates to make them more user-friendly 😁
Date is today:
☀️ 7:00PM
Date is this week:
☀️ Friday, 7:00PM
Date is older than this week:
☀️ Nov 26, 7:00PM
What are some techniques
#PowerApps
developers should be using but most don’t?
I think the ERRORS function should be used when patching a datasource.
Also, CONTAINERS aren’t as widely used as they should be…