Skip to content

Let's POWER Automate

From no-code to low-code

Menu
  • Expressions
  • Filters
  • General
  • Problems
  • Triggers
  • Application specific solutions
    • Excel
    • Forms
    • Planner
    • Outlook
    • SharePoint
    • Teams
  • Resources
Menu

Category: Expressions

How to display assigned user(s) in Planner task with Power Automate

Posted on July 28, 2021August 4, 2021 by Tom

“I’m trying to list the user assigned to a Planner task, but all I can get from Power Automate is some complicated text without any names in it.”

Read more

Split choices in multiple selection Forms question with Power Automate

Posted on July 21, 2021February 11, 2022 by Tom

“I have a multiple selection choice question from MS Forms that I’d like to split into separate choices, how can I do it in Power Automate?”

Read more

How to add SharePoint list into navigation with Power Automate

Posted on July 14, 2021July 14, 2021 by Tom

“I use Power Automate for creation of new SharePoint list(s), but they’re not added to the navigation automatically. How can I add them in a flow?”

Read more

Display SharePoint time in the correct time zone with Power Automate

Posted on June 20, 2021June 20, 2021 by Tom

“My Power Automate report contains SharePoint date & time field, but the time is off by a few hours, how can I display the right time {in my time zone)?”

Read more

How to add hyperlink in the ‘Create HTML table’ Power Automate action

Posted on June 16, 2021June 16, 2021 by Tom

“I’ve got all the items in a single HTML table, but I’d like to include also clickable hyperlink to the items, is that doable with Power Automate?”

Read more

How to split file name for further processing in Power Automate

Posted on June 13, 2021 by Tom

“The files attached to an email have always the same file name format: ID_Type_User, how can I split it in Power Automate to get the information?”

Read more

How to send an instant message when your Power Automate flow failed

Posted on May 9, 2021January 5, 2022 by Tom

“I need to know asap if my Power Automate flow failed, I can’t wait a week for it to send a message or check daily the flow run history.”

Read more

How to add new line (‘\n’) to a string in Power Automate

Posted on April 28, 2021May 23, 2021 by Tom

“I am building a Power Automate flow and need to append values into a string variable, how can I add a new line/line feed into the variable”

Read more

How to format a date that can be empty (null) in Power Automate

Posted on April 21, 2021April 21, 2021 by Tom

“The Power Automate flow works fine if there’s a value for the date in Sharepoint, however, if it’s empty it’ll fail while trying to format the date.”

Read more

How to replace new line (‘\n’) in a Power Automate expression

Posted on April 11, 2021July 30, 2021 by Tom

“I can’t figure out how to replace a new line (‘\n’) or any other non-printable character in Power Automate expression.”

Read more

Posts navigation

  • Previous
  • 1
  • 2
  • 3
  • 4
  • 5
  • Next

Now available:

The Ultimate Power Automate expressions cheat sheet
Equip yourself with the tool to translate your thoughts into Power Automate expressions!

Do you struggle with the various expressions, conditions, filters, or HTTP requests available in Power Automate?

I send one email per week with a summary of the new solutions, designed to help even non IT people to automate some of their repetitive tasks.

All subscribers have also access to resources like a SharePoint Filter Query cheat sheet or Date expressions cheat sheet.

Zero spam, unsubscribe anytime.

Hello and welcome!

My name is Tom and I'm a business process automation consultant and Microsoft MVP living in the Czech Republic. I’ve been working with Microsoft technologies for almost 10 years, currently using mainly Power Automate, SharePoint, Teams, and the other M365 tools.

I believe that everyone can automate part of their work with the Power Automate platform. You can achieve a lot by "clicking" the flows in the designer, but you can achieve much more if you add a bit of coding knowledge. And that's what this blog is about.

To make the step from no-code Power Automate flows to low-code flows: using basic coding knowledge to build more complex yet more efficient flows to automate more of your daily tasks.

  • Format results of date calculation in SharePoint columnJune 29, 2022
  • Why is your Power Automate flow creating duplicatesJune 26, 2022
  • How to create a unique identifier in your Power Automate flowJune 22, 2022
  • How to assign custom SharePoint permission level with Power AutomateJune 19, 2022
  • Remove permissions from a specific SharePoint user with Power AutomateJune 15, 2022

Power Automate blogs worth visiting

Damien Bird
Dennis (Expiscornovus)
Paul Murana

© 2022 Let's POWER Automate | Powered by Superbs Personal Blog theme