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

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, 2021July 9, 2023 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, 2021August 23, 2022 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

Format HTML table with SharePoint items in a readable way (Power Automate)

Posted on March 28, 2021January 6, 2022 by Tom

“The HTML table in an email from Power Automate is a mess, its format makes the SharePoint items I’m trying to show hard to understand.”

Read more

How to add ‘missing’ SharePoint column to expression in Power Automate

Posted on February 28, 2021April 14, 2021 by Tom

“After starting with my expression and going to the dynamic content section, Power Automate doesn’t show any column that is in my SharePoint list other than body and value.”

Read more

Get data from HTTP response without ‘Parse JSON’ in Power Automate

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

“‘Parse JSON’ gives me a lot of useless dynamic contents, is there another way to parse the response from an HTTP request in Power Automate?”

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.

Didn't find what you were looking for?
Need to adjust a solution to fit your needs?
Or would you just like to get an assistance from somebody with 1000s of hours of experience with Power Automate?

Power Automate blogs worth visiting

Damien Bird
Dennis (Expiscornovus)
Paul Murana

©2023 Let's POWER Automate | Theme by SuperbThemes