See, I also love the idea of GUI-assisted programming, but there's more that they do wrong than what they do right. I'm a pretty seasoned programmer myself and when Power Automate Desktop became free to use for personal usage I was all over it only to be extremely frustrated with the interface and how I couldn't write out code myself without going to ridiculous lengths. A simple 80-step function that scraped a website and changed some values in textboxes took me over a day to do because of the clunky and unhelpful interface. (It did some other things too with sanitizing strings, hence the large number of steps)
Esiste un intero settore di servizi/software dedicati a questo scopo chiamato Robotic Process Automation. Il più famoso esempio è UiPath. Molti di questi sono software enterprise, ma dovrebbero essercene anche per piccole aziende.
Potresti iniziare a vedere con Power Automate, un software che Microsoft sta promuovendo con il rilascio di Windows 11.
Windows Task Scheduler, or MS Flow or some 3rd party solution
Hey! Have to tried implementing the approval for leave template? Give it a shot, then spend time taking it apart and tailoring it to your needs.
Have you tried using the ServiceNow connector for Flow? It's both in preview and requires premium licensing - but wouldn't be overly complicated to connect the two.
If your Office 365 subscription includes Microsoft Flow, you could try creating a scheduled flow to do this.
Create a new Flow with a "Schedule" trigger.
Show advanced options for the trigger.
Type Monthly
as the Frequency; 1
for the Interval; select your desired time zone; type the start date for the recurrence. For example, 2017-07-26T00:00:00Z
would start at midnight UTC on the 26th day of every month.
For the Action, select "Office 365 / Send an email". Show advanced options if needed, and fill in whatever fields you need to populate.
Give your flow a name if you didn't already do that, and save it.
On the saved flow page, you can click the "... More" button and choose to run the flow now rather than waiting until the next scheduled interval, if you want to test its functionality.
That would be MS Flow- that's similar to IFTTT. I'm not sure if there's app on I'm W10M but there's one for your iOS device:
https://itunes.apple.com/ca/app/microsoft-flow/id1094928825?mt=8
Have a look at Power Automate (fka Flows). It’s pretty far reaching and you can go fairly deep on it. That said there are a lot of templates there and you will probably find something there that fits your requirements.
You could use power automate to link the creation on the task or calendar event in Outlook to a Planner for example which you can pin in a channel.
Do you have access to Flow/power automate in 365, if so perhaps you can tweak something like this:
(There's a save to OneDrive too)
I'm assuming the flow fails on the create item step in the flow? You can put alternate steps after that if the step fails using "Configure run after". Usually if you don't have this and the step fails, the whole flow will fail.
I will try to answer you question, but there is no quick answer.
I have a decade and half experience in SharePoint intranets. Those department sites have been present in all company intranets I created/maintained. They are usually managed following guidelines like the ones that can be seen here:
https://docs.microsoft.com/en-us/sharepoint/governance-overview
As for the workflows that you mentioned, not all companies follow the same procedures. You need to define first what kind of approval processes do you need. Examples can be seen here:
https://flow.microsoft.com/en-us/templates/
You might need other sites, it depends on the departments/teams present in your company.
I do not know if those sites will suit your company needs. I would require more information about how your company functions before I could answer to that.
I do not know either if those departments would suffice to help your company grow up to 200 employees. I have never run a software company. You might need to post this particular question in other sub, if it is a question, I mean.
If you need more information or clarification of any of the points above you can PM me.
Edit:typos
Yes. You will need a per user or per app license to do so. It can be accomplished with a rest api call or an action called "Call child Flow". Call child flow action is only available on PowerPlatform solutions. Some references:
https://flow.microsoft.com/en-us/blog/call-flow-restapi/ https://docs.microsoft.com/en-us/power-automate/create-child-flows
I know there is data portability between Sheets and Excel using Microsoft Flow (Power Automate). It is included in most versions of office suite and many people have access without realizing it. You can write a "flow" to automate a command on a certain trigger. In your case the trigger would be "When a column in Excel is selected", and upon that the flow would push data from your excel document into your google sheets. if you need assistance with the flow, let me know and ill post a little how-to.
The link below shows you the sort of things power automate can do. There are multiple resources to learn, and you can achieve some crazy things without writing a single line of code. Power automate/Flow is worth a look, and I know that sheets and excel can be linked for a fact. I personally have saved myself hundreds of hours of work with this tool.
Good luck.
https://flow.microsoft.com/en-us/templates/
Edit: Search for Excel/Sheets based flows in above link
Setting up Microsoft Flow... flows.... against the backing SharePoint Online libraries is probably your best bet. There's a bunch of templates for turning a SPO event -> Teams message. Something like this might be pretty close.
The documentation has an example of an approval workflow, though it's very, very basic, and it seems to me that the author of that doc hasn't actually built workflows in SharePoint, as the end result is an email, not an approved doc.
One of the big changes in 2013 workflow was the addition of state machine workflow, ie, the ability to go to different stages based on a condition. This was possible in 2010, but only through complicated workarounds. And, it seems like we're back in that territory for flow, as flow doesn't support state machine workflows. But if you don't need anything too complicated, perhaps the above doc will help, you'd likely just need to modify it to update the doc to set the approval status in addition to sending the approval email.
I got that much, but you said the list is in another digital system? does that system not allow for this level of interaction? have you looked at automating the generation of the lists? Could you copy/paste out of the other system into something like excel and let people check/highlight/cross off? can you make planner tasks? or use the Lists tool? can you automate it using flow.microsoft.com?
either this or use microsoft's task scheduler
Do you mean a SharePoint list? If so, you can definitely do that. You are using a column modification as the trigger.
https://flow.microsoft.com/en-us/blog/run-a-flow-when-a-sharepoint-column-is-modified/
Do you have an 0365 subscription? Flow has a template available for that.
>The biggest one is: find a platform/ecosystem that plays well together and does everything Atlassian does for the price it does it.
There's always Microsoft. MS has always been "our products kinda suck but at they're ubiquitous and well integrated". Sound like another company we know?
Actually, Microsoft 365 now has an app called Microsoft Lists which (if MS don't fumble it) should make Atlassian afraid. It looks like a better Jira Cloud than Jira Cloud, letting you design nice looking fields and views (multiple columns! conditional formatting!). There's a dedicated rules engine (flow.microsoft.com) for workflow, and appears to provide ScriptRunner-like flexibility. There's deep integration with MS Teams, email and other MS data sources. Finally it comes with an Office 365 subscription many companies already have.
I like software that is flexible / programmable enough to not feel like a strait-jacket, and isn't trying to lock me in. Historically that was Atlassian Server products. Nowadays, I don't know. I started goodbyeserver.org to explore this question.
Though I've not done this, I think this could potentially be doable in Power Automate. You could trigger the flow based on the mentioning of a particular user, combined with (3) Integrating Power Automate with ConnectWise - YouTube or at least a modified version of that to update an existing ticket. Then you could do something like this in their teams message to anyone
@ ConnectWiseTicket #982020 note here
EDIT: An alternative would be to use a flow like this: Trigger flows from any message in Microsoft Teams | Power Automate Blog
Then people can select an existing message and pop up an adaptive card that asks for ticket number etc to add to it.
https://flow.microsoft.com/en-us/blog/best-practices-for-production-flows/
https://docs.microsoft.com/en-us/power-automate/overview-solution-flows
These should be a good start. Solution aware flows have their own caveats, but if you're looking to manage multiple environment spanning deployments they're really the only way.
Your trigger is Outlook, when new email arrives. Set it so it runs only with attachments. Also apply a filter on it to only find your Excel doc using xlxs
You can then save it where you need to in OneDrive.
Follow this template to start
So looking into this, I found this page (link below) from Microsoft related to Flow, and Power Automate Free.
Send an Office 365 Outlook email from a shared mailbox on a recurring basis
When accessing the link, I needed to sign in/up for Microsoft Power Automate Free
Received an error. Sorry... We can't finish signing you up.
Your IT department has turned off signup for Microsoft Power Automate Free. Contact them to complete signup.
Gave myself the "Microsoft Power Automate Free" license -- It's at the root level of licenses, vs digging under A5 (or what you have) and the subcomponents. -- Office.com > Admin account > Admin "application" > search for user > Licenses
Then the error changed to:
No need to sign up You already have a license for Microsoft Power Automate Free.
Proceeding further I see an entry for my personal account (which is what I used to sign in with and applied the license). I think I would need to link the shared account with mine and possibly apply the license to it. I don't want to fire off daily emails or modify our shared accounts right now.
The fields make sense for sending an email such as the Interval and Frequency as well as Name, CC, Subject, Body, Attachments.
I don't know enough about Reddit on whether I can post screenshots, but this should get you farther. I look forward to hearing what becomes of it. Time permitting (which I have none of), I'll make a group account next week and test this out.
I've used Microsoft Flow (aka Power Automate) for this and it's pretty reliable. I don't know how often they check but it's quick: https://flow.microsoft.com/en-us/
You don't need a server. Just sign into the site, and create an "Automated flow". Search for "RSS" as the trigger. For the thing you want it to do, you'll probably want Email. But you can also have it do something like message you on Slack or some other IM service if you're into that.
Protip: You can create an RSS from a search query.
So posts to "new" with "laptop" in the title would look like this: https://www.reddit.com/r/buildapcsales/search/.rss?q=laptop&sort=new&restrict_sr=on&t=day
Your question on scaling gave me an idea: you could try this or this alternative.
This is based on me combining a hunch of something having to exist with some googling though - I haven't tried it.
Only real other option I see is tabula + Python. Making it is not that hard if you've got some programming experience, or one of your colleagues has.
Not sure about Python, but you might be able to set up a Flow to append a SQL Server but it depends on what systems you currently use.
You can also look through the other SQL Server Flow templates to see if one fits your needs better: https://flow.microsoft.com/en-us/connectors/shared_sql/sql-server/
it's called power automate now but this should work yes :)
I would use an integration with Microsoft flow, or potentially a macro which sends an email that triggers a flow or updates a SharePoint list, or something similar.
​
https://flow.microsoft.com/en-us/blog/microsoft-flow-in-microsoft-teams/
​
​
Flow is built for use cases like OPs. It's like Zapier with connectors for sharepoint (e.g. lists, excel, etc). You can set up a trigger (webhook) when a row is added to an excel spreadsheet, pipe it into a flow function and have flow post a message to your slack channel using its built in slack connector.
Below is a similar use case I found online.
https://flow.microsoft.com/en-us/blog/introducing-microsoft-flow-integration-in-excel/
I'm sure there are many other ways to do this, sans flow, just what came to mind as the easiest solution, not requiring serious dev skills.
You didn't mention what SharePoint environment you have. You can do this with a document template if you have SharePoint Online and Flow. It may be exponentially more difficult on existing documents.
https://flow.microsoft.com/en-us/blog/generate-word-documents-in-your-flows/
I think the only way I could think of doing this would be an Apex trigger with an asynchronous outbound call to microsoft flow/sharepoint directly. Unfortunately that would be pretty difficult to implement.
Your trigger would fire on change of opportunity status, at which point it would call a future method that would make a rest connection to Microsoft flow (https://flow.microsoft.com/en-us/blog/call-flow-restapi/) with all the attachments in the body of the http request.
The easier solution might be to actually store the pdf in sharepoint and add a note with the sharepoint file link to each opportunity record in SF.
Previously, i have used wappwolf (an alternative app) to solve this, but it closed down in the last couple of days. https://twitter.com/WAPPWOLF/status/983629320697491457
I discovered a new solution today, using "microsoft flow" (which i had never heard of before). https://flow.microsoft.com
When i automate a dropbox to email/google drive using it's service, the filename and extension are retained. Give that a go. That might work for you until IFTTT adjust their protocol.
You could try Microsoft Flow and planner - Flow could have the checklist and assign each subtask as a planner object. I am not certain how well it would work, I can try tonight and create a rough template. They just added a connector for it a few months ago, https://flow.microsoft.com/en-us/blog/planner-community-and-licenses/
No problem.
I'd also look into the new site layouts, there are some that are "Modern UI", like Communication and Group sites, and they are better in terms of performance, responsiveness and are generally where MS channels most of their new functionality. You could create an Office 365 group to have a look at it?
These also support the new development framework (SPFx), and if you f.ex. need an image rotator with some bells and whistles there are quite a few available from Github (requires npm/gulp to compile and deploy).
The only issue would be that 90% of the videos you find are made on classic sites, but that is bound to change as Modern UI increases in popularity.
In the same vein, you might want to look at Flow rather than SP Workflows for automation needs, these are much easier for an absolute beginner and also lets you tie in other systems.
I don't know anything about Microsoft Flow, but someone on another forum suggested that this template for Flow does what you want.
Does it make sense to you more than it does to me? ha ha ha
Something like this?
And then do something on a sever that you manage or have a process to create a user's STS key to mount a network share to the Azure files storage instance.
https://docs.microsoft.com/en-us/azure/storage/storage-file-how-to-use-files-windows
If i understand it all correctly...This could be achieved now.
Its a little bit of a work around instead of a direct trigger but... Since the Excel survey drops into a workbook hosted on OneDrive as long as that workbook had a table in it, you could use the recurrence trigger to check for new rows in that Excel file every 10 minutes, every hour, daily... whatever was needed, and then take further action from there.
For an example of this you could check out this blog post https://flow.microsoft.com/en-us/blog/flow-of-the-week-creating-appointments-from-excel-table/ as i do something really similar here...
to understand it in the sense of your scenario, imagine that the survey is populating the excel file I use as a sample, and then my action off of the rows is to create appointments. Yours could be whatever next place you need the data to go.
Am i on track with this?
https://flow.microsoft.com/templates/
It has recently been opened to the public (instead of only Enterprise/education customers).
Flow is an online tool that allows creation of "flows" based on Triggers, conditions and Action in a variety of other online Services, such as Outlook.com, OneDrive or DropBox.
To be honest, I have not done that much with it yet (I wanted to set up a sync relationship between Dropbox and one OneDrive Folder, but have not found out how), but for your case, it seems ideal.
I can't find it as a template right now, but you could, for example, send yourself an E-Mail with date, time and Topic of any newly added calendar Event by Setting up your own "flow".
For the sake of actually trying to answer the question:
Large companies may have the resources to produce more comprehensive solutions whereas smaller companies may have to make more tradeoffs.
That said, they don't always utilize those resources very well, for instance this is actually the third independent product[1][2] from microsoft for this use case.
this is not the purpose of power automate desktop. for what you are describing, you would want to use flow.microsoft.com to create anything that uses the sharepoint connector.
I am sorry for being a novice but not sure exactly what you mean.
You want me to go to flow.microsoft.com then to create a new PVA flow?
Power Virtual Agent --> Compose --> Initialize variable ---> Get files (properties only)---Apply to each--->Return values to Power virtual Agents?
​
It doesnt seem I can post a screenshot in this environment. If you can provide an example as I am just starting out and anything you can do would be severly beneficial to my learning path.
It looks good but I’m wondering if there is a character in the link it doesn’t like. As a test why not create a compose, add the following:
And send that back to PVA? That will first prove that you can send a link back to PVA. You can keep the apply to each etc as it won’t cause any harm. The compose can come before or after all those actions and can be deleted later. Then, once you have the compose working, we need to sort out what is up with the apply to each and append to string.
Looks like the built-in functionality for cell-value was actually a Sharepoint List feature not an Excel feature. There's an Excel idea in the forums many people had voted on previously, but no actual feature for Excel specifically. Sorry!
I did see that there is Microsoft Flow integration via an Excel Add-in here that would help: https://flow.microsoft.com/en-us/blog/introducing-microsoft-flow-integration-in-excel/
​
Looks like some people are using the "List rows present in a table" action and set the filter to whatever the task ID you're looking for. I think it's more of a work-around, but it could be possible for your use case.
After looking at your explanations, it does not look like micro-management. Instead they are telling you it's time to stop working when your shift is over and you are still connected to the work computers which sounds like something good. They are trying to prevent people from overworking because this is a serious WFH problem that many people have: I know that sometimes I wirk 14h/daybjust because I have work to do and it's possible when work and home are too close from each other.
Add alarms to remind you to logoff? Or even better, create a script that will auto-logout at the expected times https://flow.microsoft.com/en-us/blog/microsoft-flow-in-microsoft-teams/
Never tried it but what about something like this
There is no out of the box way to create tasks automatically in Azure DevOps. You could use Power Automate to create an automated cloud flow to do this. For detailed steps, refer to this blog.
In addition, there is a 1-Click Child-Links extension, with this extension we can create multiple work items as children via single click, where each work item is based on a single pre-defined template.
Power Automate might be a better option for managing this kind of workflow. There are well supported connectors for both Power BI and SharePoint Online, given they're both Microsoft products. For example:
You should be able to build this form in either Forms (forms.office.com) or PowerApps (make.powerapps.com). The iteration aspect of your form can be accomplished using the bridging function built into Forms. Alternatively, PowerApps allows you to build a direct list edit Form, but the level of effort to make it work is higher.
If you use Forms, once the form is completed, you can use Power Automate/Flow (flow.microsoft.com) to build an automation linking the form to the list.
Yes, I tried it! It works! I have storage over 100 GB worth of old photos I need to rid from my phone and you can search up from the official Microsoft website, they offer an online site that transfers your files from one account to another for free! Of course, don’t worry about privacy since it’s your account, pretty sure the admins don’t search through such things over thousands of students, otherwise that’d be invasion of privacy.
Anyways…
I think it’s this website, try it out: https://flow.microsoft.com/en-us/galleries/public/templates/02f86638b67b464f913f282c3dc5a459/copy-files-from-one-onedrive-account-or-folder-to-another/
It's doable but not really entry level... Well kinda.
You'd want to create a Word "template" file using the Developer tab. It's a whole thing that's not super user-friendly. Here's Microsoft's doc on that. You won't be doing any "mail merge" like the olden days. Create a Word doc from a template
So to answer your steps
My initial question is, does it have to be in Word? Do they have to get a file, or would an email suffice?
Ok cool. Maybe take a look at Microsoft Power Platform. You could use Power Apps to capture the data and then Power Automate to create the folders and files all ready for the engineers to do the work. It's all no code / low code and there is lots of free training available to help you get started.
You can easily save all of your email attachments with Power Automate. For this, do the following:
Now, all of the attachments sent to your inbox will go automatically to a folder Email Attachments from Power Automate in Google Drive.
Thank you very much u/SPDaveDrever.
I thought all along Office 365 E3 had this covered. SO I suppose I would have to get one of these plans below in order to have the action ' Call child flow"?
https://flow.microsoft.com/en-us/pricing/
Maybe can try Power Automate Desktop.
We actively discourage subfolders in the "inbox" and use mail folders 1 level down.
After you fill in everything, you just have to update the last step with your dynamic content logic
A couple of options, you could either integrate with a third-party off-the-shelf app (https://appsource.microsoft.com/en-gb/marketplace/apps?src=wnblogmar2018&product=teams) or use/modify an existing app template (https://docs.microsoft.com/en-us/microsoftteams/platform/samples/app-templates).
Dependent on your workflow a simple Power Automate may suffice (https://flow.microsoft.com).
Can you access this external data connection directly in python? What is it?
Alternatively if your have office365 you should have access to Microsoft Flow
Yeah, it is possible. Basically, someone would develop a very small piece of software, probably one or two days of work, which you would then run on your desktop computer with the particular parameters for that day's or week's run, and which would then read information from your Postgres database, save that information to your computer, process that information a little bit, and send that information to the SalesForce API.
Another alternative would be to look at a program which Microsoft recently acquired and released for free, Microsoft Power Automate Desktop which is meant as a tool for people such as yourself to accomplish these sorts of automation tasks without having to make it into a big production involving a bunch of departments and people such as software developers.
it’s pretty darn expensive. The way Microsoft’s Powerautomate goes, I doubt they want to buy them just to take out the competition. Their approach is a bit different with their connectors: https://flow.microsoft.com/en-us/connectors/
Having tried both, I think UiPath’s marketplace is more versatile. Expect functionality around microsoft products to be good with M’s Powerautomate, but Another big thing for uipath is their ability to automate on web browsers and deal with UI elements. UiPath’s Uiexplorer is easier to use in my experience and crucial for anyone who wants to automate things on a web app where a lot of company internal apps reside without a dedicated api.
Try this Power Automate template, this creates an Azure DevOps work item when email arrives with a specified keyword such as 'Bug' in subject.
Check the Azure Boards documentation to learn more.
Check this out, I haven't used it before: https://flow.microsoft.com/en-us/blog/run-a-flow-when-a-sharepoint-column-is-modified/ (see the section called: New “Get changes to an item or file (properties only)” action)
Are you already in the MS ecosystem? Power Automate and their flow templates are probably the easiest big box solution that will be HIPAA compliant
https://flow.microsoft.com/en-us/galleries/public/templates/65ceb79430ef4956a0855fbe09249cdf/save-office-365-email-attachments-to-onedrive-for-business/ Probably that, youd' have to add another flow to remove the attachment, or maybe that would be enough to get them to let you archive.
PowerShell may not be your best option. It can do lots of things, but it would take a lot of work to build something that could parse a website to put data into Excel
This may be OT, but Power Automate Desktop (Formerly Flow) is now free for Windows 10 users. You record the actions you want to do, like copying data from a website into Excel, or moving files into specific locations, and then it can do it for you in the future.
Talk to your IT folks and see if you can get installed.
Also you should look into Microsoft flow for downloading the email automatically. You can modify the below so that it only downloads certain email attachments.
Power Automate Desktop (PA-D) is the tool formerly known as Microsoft Flow. This is the flow engine from the MSFT platfrom & it works as a way to build workflows between apps & services, mainly using pre-built APIs. That being said, PA-D is also going to be fully integrated into Windows 10 in the near future.
Power Automate Attended (PA-A) is the front-office facing RPA solution (RDA). This product was formerly called Win Automation, and is based on Microsoft’s acquisition of Softomotive.
Power Automate Unattended (PA-U) is the RPA solution. This product is a combination of Power Automate’s initial RPA product and Process Robot, Softomotive’s RPA solution. This product is still not fully mature, but an early release has been deployed to a few customers.
Pricing – List prices can be found here:prices
PA-D is now free and will be fully integrated into the Windows 10 operative system.
PA-A is $40 pr user pr month & there is an offer at the moment for $15 pr user pr month if you buy 5,000 licenses. Even at this reduced price point, 5,000 users equates to $75,000 per month, or $900,000 annually. All users of PA-A need a license (e.g. end-users, developers, admins etc.).
PA-U is an add-on service to the PA-A license. Which means you need a PA-A licence. The addition is $150 pr bot pr month totalling at $190 pr month or $2,280 for the year. In this price, there is also 5,000 credits for AI Builder included. There is also a separate option of using a “Flow Plan” which means instead of buying a bot license, you buy an addon of 5 Flows for $500 a month.
I've been meaning to give it a go (I've gotten to downloading and installing it), but Power Automate Desktop might do the job for you?
Apparently it's free for everyone with Windows 10 now, so might be worth a shot.
Microsoft has comparable things which you can use for free
https://www.microsoft.com/en-gb/microsoft-365/microsoft-to-do-list-app
And even better when you combine with....
Just a head up : the features u are getting depend on the flavor of Windows u have (Home/Pro/Enterprise) , type of account (Microsoft/Work/School/Organization) witch by the way is mandatory to open the app and off course the type of subscription u have (Free/User/RRA/Flow)
https://flow.microsoft.com/en-us/pricing/
https://docs.microsoft.com/en-us/power-automate/desktop-flows/setup
Are you asking if the 'Power' Family is compatible with itself.
Power Automate, Power Apps, Power BI and Power Query... Yes. Yes they are if you want to program an automated process from a button press in power apps button you can do that
If you are on Office 365, then you can connect mail with planner and to-do. https://flow.microsoft.com/en-us/galleries/public/templates/67477f30373611e7870df906aa521b7a/create-planner-tasks-for-flagged-emails-in-office-365/
There’s templates that get you that will get you an excel file Log new tasks created in Planner in Excel Online (Business)". and update excel when task completed
It depends on what ticket system/service desk software you have, but I really I wouldn't say SolarWinds has anything specifically for this.
My recommendation would be Microsoft Flow:
You can also replace the last step with:
There's some great use cases for Forms/Flow here:
https://flow.microsoft.com/en-us/connectors/shared_microsoftforms/microsoft-forms/
You can rely on Microsoft Flow (or Power Automate) to create a task for this. Check out what they already have to see if one fits your needs, if not you can always create a flow from scratch. I would start with something like this and adjust it to what you need.
well. Geez. I guess I'm curious what you've tried. That isn't an email I can really try and just construct.
I was going to try tactics like these:
https://flow.microsoft.com/en-us/connectors/shared_mailparser/mailparser/
To do this via an email, you'd build a regular (cloud) flow with the trigger being when a mailbox (you have access to) gets an email, and you can specify parameters of the email as well - certain subject and/or from a certain sender for example.
Then the cloud flow will call the desktop flow.
You need the "Per user plan with attended RPA" license to do this -
https://flow.microsoft.com/en-us/pricing
yeah, quick search I just found a template!! Check out this Power Automate template - "Save my email attachments to a SharePoint document library". https://flow.microsoft.com/galleries/public/templates/f7a46809e53c42108034e56acf83bb79
Quick edit: If it wasn't obvious, for approval steps make custom drop down columns for each step that needs to be approved with what the steps will be (not started, started, complete... whatever you want) and have the do until loop go until the variable has the final value you're looking for.
reads Promisong but is only MS Power Automate. If your procceses contsin Mail you have a good starting point for event monitoring / reaction based in Power Automate.
You could theoretically write your own connector for MS Flow/Power Automate using HTTP queries, but it's no easy task and would involve a lot of scripting. Apart from that I unfortunately don't see any ways.
They have a free community edition, but technically you cannot use that for commercial production purposes.
Maybe look into Power Automate desktop instead? https://flow.microsoft.com/en-us/pricing/
Still not free, but quite cheap.
Sweet. You'll want to have Flow check the Excel document that contains the Form responses. Or, you can store the responses in SharePoint (my preferred method).
This blog goes over a process similar to yours. There are a lot of great video tutorials you can find just by googling what you want to do (i.e. "Microsoft flow do until reminders) .
I'd also recommend you check out some of the premade templates and edit them a little just to get an idea of how things work.
https://flow.microsoft.com/en-us/blog/approval-reminders-using-parallel-branches/
Really strange. In the grand scheme of things, Teams doesn't have a calendar. It just leverages the calendar that outlook/exchange uses. Syncing that calendar to Google should be the easy fix.
So do you use the same email address for both Gmail and office 365? Do your accounts have any kind of alias on Google that you could invite instead?
Do you have licenses for Flow/Power Automate? This might help, if so: https://flow.microsoft.com/en-us/galleries/public/templates/10c5a140c24811e6b5549975d228694f/create-new-events-on-google-calendar-from-office-365/
I think u/RemcoE33 suggestion is good. To use Google Drive Sync if you are looking for a slightly more customized solution an the sync option does not work for you, then if you're on a Windows machine with OneDrive you can have Power Automate / Flow update the file on your drive.
I typically use trigger conditions when i use sharepoint triggers. Go into the settings of the trigger and conditions are at the bottom. https://powerofpowerplatform.com/tip-using-trigger-conditions-in-power-automate/
In this case however I would use "when an item or file is modified" trigger and then the get changes action. https://flow.microsoft.com/en-us/blog/run-a-flow-when-a-sharepoint-column-is-modified/ to see whats been changed.
Otherwise whats likely causing a double trigger is if the flow is updating the item that triggered it. This would kick of another instance of the Flow as the version number is updated by the edit when the flow makes that update
Microsoft has a PowerAutomate flow for this. You can even use a shared mailbox. Just, please, use a documented/dedicated service account for the workflow creation so it doesn't break if a user leaves.
There are a few good step by step blog posts out there if you need help setting things up.
I don't think this feature exists yet. Flow is a service that is external to sharepoint, and there is nowhere in either sharepoint or flow that will list which flows connect to a given sharepoint site or library.
It is possible to get around this shortcoming in the UI using flow itself. In a new flow, check out the actions in the "power automate management" section. You could create a flow using "list flows as admin" to get all flows, and then inside of a loop you could use get-flow and output each flow definition to a file. You could then search through the files for any mention of the site url. This is painful, but the end result would be a list of flows that had a trigger or any action that touched the sharepoint site.
There is also a set of similar PowerShell cmdlets, however these do not yet have the ability to get the flow definition, that I know of, but this space is certainly something to keep an eye on.
I ended up setting up a Microsoft flow that syncs my outlook appointments to my Google account as there's no way to just add the account. Pretty terrible as Alexa has no problems with outlook calendars https://flow.microsoft.com/en-us/galleries/public/templates/f33ecb04e20f468ba284e6b413f6e4c2/outlookcom-calendar-to-google-calendar/
> Microsoft is well positioned with Teams and GitHub to destroy them.
All that's left is for Power Automate to be a stronger integration/workflow engine within Teams. This would replace most of the integration function a lot of folks are leaning on in Slack (GitOps, ChatOps, and the like).
Depending on how real time you want it, my approach would be to ETL the Jira data to a SQL DB with versioning and let it be consumed across the org from there. It seems there are plenty of Jira flows in PowerAutomate
This is easily done in Power Automate. I have a Flow that strips all my email attachments and adds them to OneDrive. Here is a link to the flow!
You’ll need something to sync changes between O365 and your wife’s Google Calendar. I’d suggest looking into this Microsoft Flow: https://flow.microsoft.com/en-us/galleries/public/templates/10c5a140c24811e6b5549975d228694f/create-new-events-on-google-calendar-from-office-365/
IFTTT could probably accomplish this as well.
Not at my desktop, but this template looks like it should get you there.
Printers I handle with PrinterLogic, although I am eagerly awaiting Microsoft's version of Printer Management to come out of Preview.
For scanning from old scanners, you can scan to email and use Power Apps to get it into Sharepoint: https://flow.microsoft.com/en-us/galleries/public/templates/f7a46809e53c42108034e56acf83bb79/save-my-email-attachments-to-a-sharepoint-document-library/
For newer scanners, a lot of them have the feature to scan to Sharepoint baked in.
Okay, wow. I got it to work, but I don't know how.
So I tried to create a flow following your workflow, but I got the same result as you did. I received the attachments, but they wouldn't open. I could open the files in SharePoint just fine as well.
I tried everything. I found this post and and tried both Vytenis' and James' solutions in the comments, but neither worked.
I finally tried to just manually enter in the expression:
outputs('Get_attachment_content')?['body']
in the content section of append to array, instead of selecting the "Attachment Content" under Dynamic content even though they are the same thing. And it worked. Even weirder, it now works if I just select the dynamic content, "Attachment Content". I swear I did that earlier and it came through corrupted.
Here's the relevant part that works now. https://i.imgur.com/8qyARLf.png
https://flow.microsoft.com/en-us/blog/introducing-microsoft-flow-integration-in-excel/
Microsoft Flow should work as described in this link. They're doing something really similar to what you requested and has many options.
For security consider a method that doesn't put the SQL server password in code on the user's PC. Flow is cloud-based and uses modern security.