cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JonL
Power Participant
Power Participant

How do you use Microsoft Power Automate in your work?

Hey Power Automate Community!

We are wondering, Do you use Power Automate at work? In production? 

If so, tell us a bit about it! Tell us how you use the flows, what they help achieve, and if they help make life easier!

 

Thanks!

 

- Jon

2 ACCEPTED SOLUTIONS

Accepted Solutions

Hey Jon,

Sure thing, I’m limited to my phone only until tomorrow which from then I can provide some more information about these. (I’ve started writing a blog community blog also, which I hope to finish in the immediate future)

But for the moment here is a link to a blog for flow setup to get email alerts about unused 365 emails. This is what we use in house, written and documented by my colleague Elliot.

https://gcits.com.au/knowledge-base/get-email-alerts-unused-office-365-licenses-azure-functions-azur...

Thanks,

Dion

View solution in original post

Hi Jon, This is a little bit of a hack, but I just used a flow to translate Sharepoint cloud list data keys (a people picker into a simple text name field on the same row.) This way PowerApps filter delegation will not be broken. Without a "plain text" of the current user's name, I can't use the filter verbs without breaking delegation, and ending up with the default top 500 rows in my app. It's like a "Flow spatula" for flipping SharePoint list pancakes into a plain text index. Ugly, but funcitonal.  

View solution in original post

131 REPLIES 131

We have been using Flow for all the automation needs that we always had, but never figured out a way to manage. From rich approval's process, to simply Sharepoint folder monitoring.

 

Recently, we managed put in place a simple PowerApp for sendng SMS text message to multiple recipients using Twilio, and it works incredibly fine! 3-4 steps, about 20 mins to set it up and test, and it was good to go.

 

Have more things to put in place, looking forward what else we could do with it.

We use flow to manage our 365 tenants allowing ease of tenant onboard, user onboard, user offboard through delegated admin all with approvals.

Also generated alerts around applied licences and management of admin users.

Away from that we use flow to monitor for backup alert failures (failures of the alerts themselves).

Much more to be added!

Dion,

Would you be willing to show me these flows in depth? This sounds like a great use of Flow and I would love to learn more about it.

 

Thanks!

- Jon

Hey Jon,

Sure thing, I’m limited to my phone only until tomorrow which from then I can provide some more information about these. (I’ve started writing a blog community blog also, which I hope to finish in the immediate future)

But for the moment here is a link to a blog for flow setup to get email alerts about unused 365 emails. This is what we use in house, written and documented by my colleague Elliot.

https://gcits.com.au/knowledge-base/get-email-alerts-unused-office-365-licenses-azure-functions-azur...

Thanks,

Dion

Hi Jon, This is a little bit of a hack, but I just used a flow to translate Sharepoint cloud list data keys (a people picker into a simple text name field on the same row.) This way PowerApps filter delegation will not be broken. Without a "plain text" of the current user's name, I can't use the filter verbs without breaking delegation, and ending up with the default top 500 rows in my app. It's like a "Flow spatula" for flipping SharePoint list pancakes into a plain text index. Ugly, but funcitonal.  

Do you have any sort of securely verifiable log of approvals and denials in your approval process? If so, how did you acomplish that?

I am also starting to use it extensively, especially around empowering PowerApps. One powerful example is using Flow (via a custom connector and OpenAPI file) in PowerApps to handle photo uploads into SharePoint with metadata. This is something that the PowerApps community has been waiting a long time for, so being able to use Flow to work around limitations is very empowering... (video here: https://www.youtube.com/watch?v=mp-8B1fLrqs).

 

I also did the same thing for using Microsoft cognitive services. At that time PowerApps couldn't call the OCR functions from the computer vision API and Flow was used as my glue...  https://www.youtube.com/watch?v=O0vstZ1EBaI

 

I am using Flow also to get around PowerApps limitations with Managed Metadata support. Instead of using the native PowerApps connector, I send data to Flow and then usde the HTTP action to talk to the SharePoint lists webservice to update managed metadata columns. Interestingly, flow cannot do this natively with the SharePoint connector, but the HTTP action is a godsend...

 

I am also using it for file sync scenarios (although this scenario is actually probably better served via an Azure function and PowerShell PnP. 

 

 

 

Anonymous
Not applicable

Hello Jon!

We are just going to use.

Can I use MS Flow between 2 separate Organizations? i have tried to add a connection to a second organization but it wouldn't allow me to pick an entity. 
What i am trying to accomplish is: When a field is updated in Organization A, go and create a record in Organization B. Is this even possible?

Thank you, Violab

 

Hiya

 

No you cannot do this in the way you might be imagining it, except in limited circumstances. It is possible to use Request/Response triggered flows and the HTTP action for a flow in one tenant to talk to another tenant...

 

A few people are doing this approach. eg: https://sergeluca.wordpress.com/2017/03/16/invoke-a-flow-from-another-sharepoint-flow-step-12-tutori...

 

Paul

Anonymous
Not applicable

I used to be a SP Designer guy with all the workflows and made some pretty elaborate workflows in the past. It took me a few tries to get used to this but have already sttarted to get a little silly.

  1. I am currently using Flow to send out User alerts to all users in the company of different things, HR Alerts, Communications, IT User alerts... things like that. So the user only has to go to a list and fill in these fields and I have used the HTML function in the flow emails to send out notification alerts to all users.
  2. I also am using Flow to manage an approval process for something internal. So users fill in a form (created using InfoPath still) and when they send it, it goes to a 3 step approval process with HTML emails. Its pretty cool.
  3. Lastly, I am going to start designing flow to do approvals using DocuSign to incorporate our HR forms into a workflow setting. Still in the conceptualization stage in Visio, but looking good.
Anonymous
Not applicable

Hi!

 

I am here cause I am not a developer and I want to have a workflow to send out SMS to agents yet I cannot for the life of me figure out how to make it happen. I feel as if I am missing something because everytime I think I have it I don't. Please help if you can!

Create Outlook tasks from emails tagged with "#project".

 

I use mostly the Outlook web client, so I have no way of dragging an email over the tasks folder like one can in the Office Outlook desktop application. Instead I forward the email to myself, edited and with the subject "New #project: ...". It's a small price to pay to avoid using Outlook on the desktop.

 

I'm updating the flow to use the new Office 365 Outlook webhook trigger (read: building a second Flow, as you can't really change out the trigger that starts a Flow).

Anonymous
Not applicable

I use it to monitor competitor SEC filings. It monitors an RSS feed from the SEC and if a competitor files a filing it automatically creates a pdf and inserts it into a sharepoint document library. It then notifies me of the filing. 

bestay
New Member

I use it extensively for personal automation, for example, sending an email reminder to pay my bills or pay rent, notifications for different channels like twitter etc. However, I can't say it would be very useful for my company, which is very entrenched in Microsoft software from Sharepoint to Lync to Office. For companies like mine, I can see this replacing a lot of internal tooling, especially with integration to software like Salesforce, Yammer and intranet options.

 

Kind regards,Bestazy

Currently we are not using Microsoft Flow but looking at the power of Microsoft Flow with automating simple processes we are going to be looking at automating some of our ISO requirements and daily reporting functions.

Our business uses around 30 or so flows setup to run various tasks, mostly from within PowerApps.

 

Most of our Flows are designed to run On-Premise SQL procedures or send email notifications or reminders. The most recent flow we added allows us to send a Skype message to a specific department when a file they've been waiting for is uploaded (with the file name included in the message)

 

We also have a few flows that are used to fill the gaps in image capture and conversion from within PowerApps. Specifically we have a flow that allows us to use the Upload Image feature in PowerApps and convert, save a copy, and attach info to a SQL database about the file for future reference.

 

Much more Flow usage to come from us as we dig into how we can automate and simplify business procedures!

 

 

Anonymous
Not applicable

Hi Community,

 

We've just started using flow and for the moment utilise it for documents approval and publishing. So we have only one flow running in production.

 

What the flow is doing:

1. Controls QA check and approvals. Users are happy to respond right from the emails.

2. Publishes approved documents with PDF conversion as an option.

3. Logs each step in SharePoint list. The list is connected to the document library, making it available to see history for each document.

 

Flow contains about 60 different blocks.

Do you have any sort of securely verifiable log of approvals and denials in your approval process? If so, how did you acomplish that?
Anonymous
Not applicable

Hi @vinhta,

 

Yes, we have.

 

1. Each approval/rejecting response is writing into a SharePoint list with the following info:

- Document ID

- User full name

- Response (Approved or Rejected)

- Timestamp (just a standard Create date)

 

2. We created a classical page with query string and filtered Log list web-parts and added an extra column called 'History details' to the document library with the following JSON formatting:

{
  "elmType": "a",
  "txtContent": {
    "operator": "?",
    "operands": [
      {
        "operator": "==",
        "operands": [
          {
            "operator": "toString()",
            "operands": [
              "[$ContentType]"
            ]
          },
          "Folder"
        ]
      },
      "",
      "History details"
    ]
  },
  "attributes": {
    "target": "_blank",
    "href": {
      "operator": "+",
      "operands": [
        "pageURL?",
        "DocID=",
        {
          "operator": "toString()",
          "operands": [
            "[$ID]"
          ]
        }
      ]
    }
  }
}

When users click this column, it redirects to the page with filtered log details.

 

I am happy if it does make sense.

Feel free to ask if you have any questions.

 

Cheers.

Helpful resources

Announcements

Community will be READ ONLY July 16th, 5p PDT -July 22nd

Dear Community Members,   We'd like to let you know of an upcoming change to the community platform: starting July 16th, the platform will transition to a READ ONLY mode until July 22nd.   During this period, members will not be able to Kudo, Comment, or Reply to any posts.   On July 22nd, please be on the lookout for a message sent to the email address registered on your community profile. This email is crucial as it will contain your unique code and link to register for the new platform encompassing all of the communities.   What to Expect in the New Community: A more unified experience where all products, including Power Apps, Power Automate, Copilot Studio, and Power Pages, will be accessible from one community.Community Blogs that you can syndicate and link to for automatic updates. We appreciate your understanding and cooperation during this transition. Stay tuned for the exciting new features and a seamless community experience ahead!

Summer of Solutions | Week 4 Results | Winners will be posted on July 24th

We are excited to announce the Summer of Solutions Challenge!    This challenge is kicking off on Monday, June 17th and will run for (4) weeks.  The challenge is open to all Power Platform (Power Apps, Power Automate, Copilot Studio & Power Pages) community members. We invite you to participate in a quest to provide solutions to as many questions as you can. Answers can be provided in all the communities.    Entry Period: This Challenge will consist of four weekly Entry Periods as follows (each an “Entry Period”)   - 12:00 a.m. PT on June 17, 2024 – 11:59 p.m. PT on June 23, 2024 - 12:00 a.m. PT on June 24, 2024 – 11:59 p.m. PT on June 30, 2024 - 12:00 a.m. PT on July 1, 2024 – 11:59 p.m. PT on July 7, 2024 - 12:00 a.m. PT on July 8, 2024 – 11:59 p.m. PT on July 14, 2024   Entries will be eligible for the Entry Period in which they are received and will not carryover to subsequent weekly entry periods.  You must enter into each weekly Entry Period separately.   How to Enter: We invite you to participate in a quest to provide "Accepted Solutions" to as many questions as you can. Answers can be provided in all the communities. Users must provide a solution which can be an “Accepted Solution” in the Forums in all of the communities and there are no limits to the number of “Accepted Solutions” that a member can provide for entries in this challenge, but each entry must be substantially unique and different.    Winner Selection and Prizes: At the end of each week, we will list the top ten (10) Community users which will consist of: 5 Community Members & 5 Super Users and they will advance to the final drawing. We will post each week in the News & Announcements the top 10 Solution providers.  At the end of the challenge, we will add all of the top 10 weekly names and enter them into a random drawing.  Then we will randomly select ten (10) winners (5 Community Members & 5 Super Users) from among all eligible entrants received across all weekly Entry Periods to receive the prize listed below. If a winner declines, we will draw again at random for the next winner.  A user will only be able to win once overall. If they are drawn multiple times, another user will be drawn at random.  Individuals will be contacted before the announcement with the opportunity to claim or deny the prize.  Once all of the winners have been notified, we will post in the News & Announcements of each community with the list of winners.   Each winner will receive one (1) Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 ($1800 value). NOTE: Prize is for conference attendance only and any other costs such as airfare, lodging, transportation, and food are the sole responsibility of the winner. Tickets are not transferable to any other party or to next year’s event.   ** PLEASE SEE THE ATTACHED RULES for this CHALLENGE**   Week 1 Results: Congratulations to the Week 1 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.   Community MembersNumber SolutionsSuper UsersNumber Solutions Deenuji 9 @NathanAlvares24  17 @Anil_g  7 @ManishSolanki  13 @eetuRobo  5 @David_MA  10 @VishnuReddy1997  5 @SpongYe  9JhonatanOB19932 (tie) @Nived_Nambiar  8 @maltie  2 (tie)   @PA-Noob  2 (tie)   @LukeMcG  2 (tie)   @tgut03  2 (tie)       Week 2 Results: Congratulations to the Week 2 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 2: Community MembersSolutionsSuper UsersSolutionsPower Automate  @Deenuji  12@ManishSolanki 19 @Anil_g  10 @NathanAlvares24  17 @VishnuReddy1997  6 @Expiscornovus  10 @Tjan  5 @Nived_Nambiar  10 @eetuRobo  3 @SudeepGhatakNZ 8     Week 3 Results: Congratulations to the Week 3 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 3:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji32ManishSolanki55VishnuReddy199724NathanAlvares2444Anil_g22SudeepGhatakNZ40eetuRobo18Nived_Nambiar28Tjan8David_MA22   Week 4 Results: Congratulations to the Week 4 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 4:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji11FLMike31Sayan11ManishSolanki16VishnuReddy199710creativeopinion14Akshansh-Sharma3SudeepGhatakNZ7claudiovc2CFernandes5 misc2Nived_Nambiar5 Usernametwice232rzaneti5 eetuRobo2   Anil_g2   SharonS2  

Check Out | 2024 Release Wave 2 Plans for Microsoft Dynamics 365 and Microsoft Power Platform

On July 16, 2024, we published the 2024 release wave 2 plans for Microsoft Dynamics 365 and Microsoft Power Platform. These plans are a compilation of the new capabilities planned to be released between October 2024 to March 2025. This release introduces a wealth of new features designed to enhance customer understanding and improve overall user experience, showcasing our dedication to driving digital transformation for our customers and partners.    The upcoming wave is centered around utilizing advanced AI and Microsoft Copilot technologies to enhance user productivity and streamline operations across diverse business applications. These enhancements include intelligent automation, AI-powered insights, and immersive user experiences that are designed to break down barriers between data, insights, and individuals. Watch a summary of the release highlights.    Discover the latest features that empower organizations to operate more efficiently and adaptively. From AI-driven sales insights and customer service enhancements to predictive analytics in supply chain management and autonomous financial processes, the new capabilities enable businesses to proactively address challenges and capitalize on opportunities.    

Updates to Transitions in the Power Platform Communities

We're embarking on a journey to enhance your experience by transitioning to a new community platform. Our team has been diligently working to create a fresh community site, leveraging the very Dynamics 365 and Power Platform tools our community advocates for.  We started this journey with transitioning Copilot Studio forums and blogs in June. The move marks the beginning of a new chapter, and we're eager for you to be a part of it. The rest of the Power Platform product sites will be moving over this summer.   Stay tuned for more updates as we get closer to the launch. We can't wait to welcome you to our new community space, designed with you in mind. Let's connect, learn, and grow together.   Here's to new beginnings and endless possibilities!   If you have any questions, observations or concerns throughout this process please go to https://aka.ms/PPCommSupport.   To stay up to date on the latest details of this migration and other important Community updates subscribe to our News and Announcements forums: Copilot Studio, Power Apps, Power Automate, Power Pages

Users online (5,773)