Skip to content
June 4, 2023

Manuel T. Gomes

Making your life easier with automation

  • Power Automate
    • Articles
    • Function Reference
    • Trigger Reference
    • Action Reference
    • Expressions
    • Templates
  • Power App
    • Articles
    • Function Reference
    • Delegable Functions Reference
  • SharePoint
    • Articles
    • List Function Reference
  • More
    • OData Reference
    • Planner
    • Teams
    • Forms
    • Lists
    • Excel
    • Outlook
    • OneDrive
    • OneDrive for Business
    • Shifts
    • OneNote
    • To Do
    • PowerShell
  • About
  • Hire Me!
  • |
  • Log In / Register
  • Power Automate
    • Articles
    • Function Reference
    • Trigger Reference
    • Action Reference
    • Expressions
    • Templates
  • Power App
    • Articles
    • Function Reference
    • Delegable Functions Reference
  • SharePoint
    • Articles
    • List Function Reference
  • More
    • OData Reference
    • Planner
    • Teams
    • Forms
    • Lists
    • Excel
    • Outlook
    • OneDrive
    • OneDrive for Business
    • Shifts
    • OneNote
    • To Do
    • PowerShell
  • About
  • Hire Me!
  • |
  • Log In / Register

Tag: Problem Solved

Problem Solved is one of my favorite sections, or at least the articles I have the most fun writing. Here is where I solve a problem that bugged me for a while and shared the solution to you, so you don’t have to spend time looking for it. All posts will be within the theme of the website, so don’t expect programming solutions, for example.

I call it “Problem Solved” since it’s my way of saying “Fixed, let’s move ahead.”

These posts will be somewhat sporadic since there’s not always things to publish. Depending on the subject I’ll either post them on the Tuesday and Friday schedule if they fit the theme or, I’ll give you an extra article(s) that week for your enjoyment. There’s no defined schedule or plans to write new posts, so I’ll write as soon as I have current information to share.

Power Automate: How to convert a string to formatted currency?
Microsoft / Power Automate / Power Platform

Power Automate: How to convert a string to formatted currency?

Manuel Gomesby Manuel GomesJuly 12, 2022July 21, 20220

Not all numbers (or strings that are numbers) are the same so we should not treat them as such. Some could be a simple number …

Power Automate: How to convert a string to formatted currency? Read More
SharePoint: How to create hyperlink column with more than 255 characters?
Microsoft / SharePoint

SharePoint: How to create hyperlink column with more than 255 characters?

Manuel Gomesby Manuel GomesJuly 11, 2022July 11, 20228

The short answer is you can’t, but that wouldn’t make a very useful article, wouldn’t it? First, let’s identify the issue. You have a SharePoint …

SharePoint: How to create hyperlink column with more than 255 characters? Read More
PowerShell: How to replace accents in strings?
Microsoft / PowerShell

PowerShell: How to replace accents in strings?

Manuel Gomesby Manuel GomesJuly 8, 2022July 8, 20220

Working with text is quite hard, especially when you need “clean” text to create a resource or something that doesn’t support special characters. Let’s think, for …

PowerShell: How to replace accents in strings? Read More
Excel: Import data from any website
Excel / Microsoft

Excel: Import data from any website

Manuel Gomesby Manuel GomesJuly 4, 2022November 14, 20220

Have you found a site with a lot of data and want to parse it in Excel? Simple enough, we can copy and paste it, …

Excel: Import data from any website Read More
Power Automate: How to generate an URL to an email?
Microsoft / Power Automate / Power Platform

Power Automate: How to generate an URL to an email?

Manuel Gomesby Manuel GomesMarch 1, 2022June 8, 202211

I got this question on my “Microsoft Planner: Send an email and create task” from Kristen McCarty (thanks for the excellent question) regarding how to …

Power Automate: How to generate an URL to an email? Read More
Power Automate: Long-running Flows
Microsoft / Power Automate / Power Platform

Power Automate: Long-running Flows

Manuel Gomesby Manuel GomesFebruary 28, 2022May 27, 20226

Today I want to answer the common question about long-running Flows. “How can I configure Flow to run for more than 30 days”. But as …

Power Automate: Long-running Flows Read More
Power Automate: SharePoint – Add attachment action
Microsoft / Office 365 / Power Automate / Power Automate Action Reference / Power Platform / Reference / SharePoint

Power Automate: SharePoint – Add attachment action

Manuel Gomesby Manuel GomesFebruary 16, 2022November 10, 20221

Many people don’t know this, but you can add attachments to a SharePoint list row. It’s convenient and much better than having a folder with …

Power Automate: SharePoint – Add attachment action Read More
Power Automate: How to get the response date of any action?
Featured / Microsoft / Power Automate / Power Platform

Power Automate: How to get the response date of any action?

Manuel Gomesby Manuel GomesFebruary 15, 2022May 25, 20220

Most actions don’t provide a response date for a good reason. We don’t need it. They run as fast as possible, and the difference between …

Power Automate: How to get the response date of any action? Read More
SharePoint: Check if a Document Library Exists
Featured / Microsoft / Office 365 / Power Automate / Power Platform / SharePoint

SharePoint: Check if a Document Library Exists

Manuel Gomesby Manuel GomesFebruary 14, 2022May 25, 20221

Document Libraries are an integral part of SharePoint sites and are super helpful, so today, we will explore how to check if a document library …

SharePoint: Check if a Document Library Exists Read More
Power Automate: When Excel can make things easier
Microsoft / Power Automate / Power Platform

Power Automate: When Excel can make things easier

Manuel Gomesby Manuel GomesJanuary 31, 2022May 25, 20221

The idea for this article came from a comment posted on the website where we were trying to figure out the solution to filter an …

Power Automate: When Excel can make things easier Read More

Posts navigation

Previous 1 2 3 4 … 7 Next

Power Automate: How to parse a CSV file

August 3, 2020May 30, 2022
Power Automate: How to access Excel with a dynamic path

Power Automate: Access an Excel with a dynamic path

January 21, 2020April 20, 2023

Power Automate: Save multi-choice Microsoft Forms

February 11, 2020April 26, 2021

Power Automate: Sync Excel to a SharePoint list

September 27, 2021January 9, 2022

Power Automate: SharePoint Get file content using path action

May 11, 2023May 11, 2023

Power Automate: rand function

May 10, 2023May 10, 2023

Power Automate: How to download a file from a safe link?

May 9, 2023May 8, 2023

How to fix when images don’t show in a Gallery View in SharePoint?

May 8, 2023May 8, 2023
Ekta - Power Automate: Access Excel with a dynamic path II

Hi Manuel, I was looking for same thing and here it is..Thank you so much! Is there any recent update…

Sean Crain - How to create tasks automatically in DevOps using Power Automate?

This is working splendidly, thanks for the detail! I was wondering, is there a way to pull the Work Item…

Rick Howard - Power Automate: Try, Catch, Finally

Great info. Thanks!

M - How to auto-layout your elements in Power Apps?

Just use containers...

Automatic Documentation Automation Best Practices Comedy Corporate Champion Design Development Fiction Function Day Fundamentals Ignite Into The Weeds Investigative journalism Music New Feature New Habit News Overview Personal Development Privacy Problem Solved Productivity Security Single Source of Truth Technology Templates Tiny Tip Tutorial Writing

Want more time?

We all do.

The solution is automation.
I can help you and your company
 get back precious time.

Let's Work Together

Tags

Automatic Documentation Automation Best Practices Comedy Corporate Champion Design Development Fiction Function Day Fundamentals Ignite Into The Weeds Investigative journalism Music New Feature New Habit News Overview Personal Development Privacy Problem Solved Productivity Security Single Source of Truth Technology Templates Tiny Tip Tutorial Writing
Copyright © 2019-2022 SKILLFUL SARDINE - UNIPESSOAL LDA.
  • Contact
  • About
  • Privacy Policy
  • Cookie Policy
  • Login
  • Sign Up
Forgot Password?
Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.AcceptPrivacy Policy