Skip to content
March 24, 2023
  • Like what I do? Click here and donate! Keep me writing quality content that saves you time 🎉🎉🎉

Manuel T. Gomes

  • 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 display the day of the week in your language?
Microsoft / Power Automate / Power Platform

Power Automate: How to display the day of the week in your language?

Manuel Gomesby Manuel GomesAugust 2, 2022August 16, 20221

Having correct data to show to your users is super important, so today, let’s look at how to display the day of the week in …

Power Automate: How to display the day of the week in your language? Read More
Power Automate: How to limit the Flow’s trigger?
Microsoft / Power Automate / Power Platform

Power Automate: How to limit the Flow’s trigger?

Manuel Gomesby Manuel GomesJuly 26, 2022August 11, 20220

Did you know that you can limit the Flow’s trigger based on any criteria? For example, let’s say that you’re catching a Microsoft Forms reply, …

Power Automate: How to limit the Flow’s trigger? Read More
Power Automate: When an Excel file is created update SharePoint
Microsoft / Power Automate / Power Platform / SharePoint

Power Automate: When an Excel file is created update SharePoint

Manuel Gomesby Manuel GomesJuly 25, 2022July 25, 20220

Today’s question comes from Echo and asks me the following: Problem Scenario: When file is created in SharePoint folder named “Attachment”, extract the file and …

Power Automate: When an Excel file is created update SharePoint Read More
Power Automate: Convert Excel Number to Date (to the second)
Microsoft / Power Automate / Power Platform

Power Automate: Convert Excel Number to Date (to the second)

Manuel Gomesby Manuel GomesJuly 19, 2022July 18, 20220

I already wrote about how to “Convert Excel Number to Date” in the past, but I got a good question. How about the minutes and …

Power Automate: Convert Excel Number to Date (to the second) Read More
Power Automate: How to send the Form’s answers by email?
Microsoft / Microsoft Forms / Power Automate / Power Platform

Power Automate: How to send the Form’s answers by email?

Manuel Gomesby Manuel GomesJuly 18, 2022November 14, 20223

I was contacted recently by Laura with the following question: I am using Forms to create an exam, and would like the responder’s answers to …

Power Automate: How to send the Form’s answers by email? Read More
PowerShell: How to create or associate a HubSite
Microsoft / PowerShell

PowerShell: How to create or associate a HubSite

Manuel Gomesby Manuel GomesJuly 15, 2022July 11, 20220

There are two ways to make a site a “HubSite”. The first is to go to the administration console in your tenant and create it. …

PowerShell: How to create or associate a HubSite Read More
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, 20222

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

Posts navigation

Previous 1 2 3 … 6 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, 2020May 25, 2022

Power Automate: Save multi-choice Microsoft Forms

February 11, 2020April 26, 2021

Power Automate: Add attachment to e-mail dynamically

September 22, 2020April 13, 2021

Power Automate: Office 365 Outlook – When a new email mentioning me arrives Trigger

December 23, 2022December 15, 2022

Power Automate: OneDrive for Business – For a selected file Trigger

December 16, 2022December 15, 2022

Power Automate: SharePoint – For a selected file Trigger

December 9, 2022December 1, 2022

Power Automate: Office 365 Excel – Update a Row action

December 8, 2022November 21, 2022
zidane - OData: Not Equals Operator

thank you for the article

Manuel Gomes - Power Automate: How to download a file from a link?

Hi Koen, Great job giving back. I'm happy you're doing it. Can you share some links so that everyone can…

Manuel Gomes - Power Automate: Long-running Flows

Hi Edison, Indeed a Flow can't call itself, but there's a way around it. You can use the "When a…

Koen - Power Automate: How to download a file from a link?

Dear Manuel, Thank you for your input in various articles, it has helped me a lot in my learning journey.…

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.
  • Sponsor
  • Blog
  • Help
  • 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