Let's POWER Automate

From no-code to low-code

Menu
  • Expressions
  • Filters
  • General
  • Application specific solutions
    • Dataverse
    • Excel
    • Forms
    • Planner
    • Outlook
    • SharePoint
    • Teams
  • Triggers
  • Resources
  • ABOUT ME
  • Get help with your flow
Menu

Category: Expressions

Most common reasons for an invalid expression in Power Automate

Posted on December 26, 2021August 23, 2022 by Tom

“Power Automate tells me that “The expression is invalid” but it doesn’t tell me what’s wrong, how can I fix it?”

Read more

How to split string by the first space in Power Automate

Posted on December 15, 2021December 19, 2021 by Tom

“My string has the data after an id number and a space, how can I split it by the first space and process only the data with Power Automate?”

Read more

How to format numbers (currency, percentage,…) in Power Automate

Posted on December 5, 2021April 6, 2022 by Tom

“I’m using Power Automate to send an email with proposal after it’s approved, but the numbers format for price and percentage look terrible.”

Read more

Get previous value(s) of SP multiple selection columns in Power Automate

Posted on November 28, 2021March 21, 2022 by Tom

“The previously described solution works fine, but Power Automate returns an error on a multiple selection columns, how can I fix it?”

Read more

Stop Power Automate flow from adding ‘Apply to each’ automatically

Posted on November 21, 2021January 28, 2022 by Tom

“Sometimes when I use specific dynamic content, Power Automate adds the ‘Apply to each’ action automatically, how can I stop it?”

Read more

Change the name of SharePoint list ‘from template’ with Power Automate

Posted on November 17, 2021February 20, 2022 by Tom

“You create the new list from template but it is creating it with the same name, if it already exists Power Automate won’t create a new one.”

Read more

Export Planner task status as text instead of percentage (Power Automate)

Posted on November 14, 2021November 14, 2021 by Tom

“Power Automate allows me to get the Planner task progress as a percentage rather than as ‘Not started’, ‘In progress’, or ‘Completed’ text.”

Read more

How to use number from MS Forms in a Power Automate condition

Posted on November 7, 2021November 7, 2021 by Tom

“I’d like to send different notification for good and bad rating via MS Forms form, but my Power Automate condition with number doesn’t work.

Read more

How to ‘Get changes…’ based on date and time in Power Automate

Posted on October 6, 2021October 6, 2021 by Tom

“I’d like to use the Power Automate action ‘Get changes for an item or a file’ to return all changes since a date, but all I get is error: ‘Invalid format for version input value’.”

Read more

How to get a specific value from a JSON in Power Automate

Posted on September 26, 2021September 26, 2021 by Tom

“Is it possible, maybe with an expression, to get only a specific value(s) from a JSON object in Power Automate, so I can work with them later in the flow?”

Read more
  • Previous
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • Next

Do you know what to do, but not how to do it?

Get The Ultimate Power Automate expressions cheat sheet and translate your thoughts into flows with ease!


There's also the HTTP requests to SharePoint cheat sheet to help you overcome limitations of some standard actions!

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.

  • How to find Excel rows missing in SharePoint list (Power Automate)March 29, 2023
  • Check whether user exists in AAD with Power AutomateMarch 26, 2023
  • How to highlight whole SharePoint row based on calculated dateMarch 22, 2023
  • Why is your Power Automate flow running so slow?March 19, 2023
  • How to add multiple links to the Power Automate approval taskMarch 15, 2023

Power Automate blogs worth visiting

Damien Bird
Dennis (Expiscornovus)
Paul Murana

©2023 Let's POWER Automate | Theme by SuperbThemes