7 Functions You Need to Know | ⚡️Expression Essentials: Part 1⚡️

Do you find writing expressions hard? Can’t seem to access dynamic content to insert into an expression? Are you super confused when it comes to nesting functions?
In this Power Automate tutorial I’m going to cover 7 functions you need to know when getting started with expressions.
1️⃣ empty()
2️⃣ coalesce()
3️⃣ equals()
4️⃣ if()
5️⃣ concat()
6️⃣ length()
7️⃣ split()
I cover how to use these functions in expressions and I’ll also cover common mistakes when it comes to writing expressions and show you a few tips and tricks along the way.
As a beginner or even an intermediate flow builder-expressions can seem a bit complex at first, I’m going to try to simplify it for you. If you want to level up your flows by writing expressions-keep watching!
IN THIS VIDEO:
✅ What is an Expression?
✅ What is a Function?
✅ What Does Wrapping a Function Mean?
✅ How Do I Insert an Expression?
✅ How to Use a Compose action
✅ How to Navigate the Expression Builder with Arrow Keys
✅ How to use the Expression Tooltip
✅ Common Mistakes When Writing Expressions
✅ How to differentiate a null from an empty string
✅ How to Get Dynamic Content When it’s Not Listed
✅ How to Use a Get Item Action to Verify Dynamic Content Output
✅ How to Convert Strings to Lower Case
✅ How to Troubleshoot the if() Function
---
SKIP AHEAD:
0:00 Intro
0:41 What is an Expression?
0:55 What is a Function?
1:16 What Does Wrapping a Function Mean?
2:12 How Do I Insert an Expression?
2:53 Tip: Use a Compose Action
4:04 Tip: Navigate the Expression Builder with Arrow Keys
4:35 Tip: Pay Attention to the Tooltip
5:00 Common Mistakes
5:07 Mistake 1: Writing Expressions as Text Strings
5:35 Mistake 2: Mismatched Data Types
7:11 Mistake 3: Null or Undefined Values
7:32 empty() Function
9:41 coalesce() Function
10:01 How to differentiate a null from an empty string
12:05 How to Get Dynamic Content When it’s Not Listed
17:39 equals() Function
21:27 if() Function
24:54 Tip: Troubleshooting the if() Function
25:30 length() Function
27:55 split() Function
----
💗 SUPPORT ME:
If you found this video helpful, please consider giving this video a like and leave a comment. You can also show additional gratitude by giving me a 💖 Super Thanks or ☕️ Buying me a Coffee: www.buymeacoffee.com/acreativ...
---
LEVEL UP YOUR POWER AUTOMATE SKILLS:
▶️ How to Get a Microsoft Form RSVP Response into a SharePoint List: • How to Get a Microsoft...
▶️ Save Email Attachments 📎 to SharePoint with Microsoft Power Automate: • Save Email Attachments...
▶️ Are you using the Microsoft Power Automate Filter Array Action wrong?: • Are you using the Micr...
▶️ 4 Ways You Can Use Trigger Conditions in Your Microsoft Power Automate Flow: • 4 Ways You Can Use Tri...
#microsoft365 #powerautomate #powerplatform #productivityhacks #productivitytips #techtips #techtipsandtricks #microsoftpowerautomate #sharepoint #sharepointonline #microsoftforms
SUBSCRIBE FOR NEW VIDEOS EVERY WEEK-ISH
👉 bit.ly/SubACreativeOpinion 👈
---
Teaching you how to make your workflows SUCK LESS.
Subscribe if you want to learn how to streamline your workflow, boost your productivity, and build innovative processes for yourself and your business! I wanna help you get more time in back your day.
Join me on my journey on learning new tools, levelling up my skills and creating more time to do the things that matter. I hope that I can inspire you to do the same and share all the things you learn from me with others.
Get curious. Be creative. Do better.
---
FOLLOW ME:
/ acreativeopinion
/ acreativeopinion
/ acreativeop

[@acreativeopinion]

What functions should I cover in Part 2? Let me know down below! 👇👇👇

[@shakisiva3656]

Great channel

[@JONGCHANKIM-n8l]

Really thankyou

[@AMindGame]

An other wonderful video.

[@dunewalks5988]

Fabulous. Thank you so much ❤

[@JONGCHANKIM-n8l]

Really thank you.
Do you know how to fix error that 'skip to main content' when space is entered as seperator in split function?

[@arunv1909]

thats great

[@abdimahamed2431]

Can you find a way to restore deleted list items