Microsoft Flow - Automation Tool Released by Microsoft

procoder Level X³

September 13, 2016, 5:44 pm

11

Write the reason you're deleting this FAQ

Microsoft Flow - Automation Tool Released by Microsoft

Recently Microsoft has launched its own automation tool called Microsoft Flow, which is a service completely free for all, even though it’s still in preview mode , and as it seems , they will add free, and paid version in the near future. Microsoft Flow is an automation tool which allows you to automate your task, there are +120 different flow templates that you can use, furthermore you can create your own flow from scratch, where you can create up to 25 flows. To use Microsoft Flow you need only an email account at Microsoft.

Basically Microsoft Flow is almost the same thing with IFTTT and Zappier, but would be interesting to see if Microsoft will succeed with this.

What do you think about Microsoft Flow?

Comments

Please login or sign up to leave a comment

Join

Everett

A lot of animation is currently being done by top websites, we have Google, and now Microsoft launching automated applications. I wonder what the future of the internet is? Perhaps everything, or most things will be done automatically? It's very interesting to see this trend, and more interesting to see how exactly this trend plays out.

At what point do we as Internet users say we want either more or less automation? I'm so glad that things are being automated, I try to automate everything I do so I don't have to spend time doing it. Lol.

10 years ago

Are you sure you want to delete this post?

procoder

Yeah, I'm trying to do the same thing, because doing many things in the same time it's not easy, so using automation tools like Microsoft Flow is the only way to do that. I just joined there, and I have a lot of templates to explore before creating something myself. They are still in preview mode, so hope we'll see new thing very soon.

10 years ago

Are you sure you want to delete this post?

Lynne

Oh this sure looks interesting. I am in agreement here, anything that can automate the things I do and make things easier for me is amazing.

I have a policy where I try and make the most amount of money in the least amount of time with me doing as little as possible. And no I am not lazy by any means.I will work all day and night to achieve my goals. I just mean that I don't see the point in doing things that can be done for me.

I'm going to check this out, I am not familiar with IFTT or Zappier.

10 years ago

Are you sure you want to delete this post?

Webguy2024

This looks promising at first glance. There is a big list of services being offered, see below. It is going to take a lot of time to figure out how use and implement each one.

It will be interesting to see what developers will do for custom application via the API. Any ideas?
I am also wondering what service(s) below would everyone want to automate? What would be your favorites? How would you want them to work to increase your efficiency?

Services:
SharePoint
OneDrive for Business
Dynamics CRM Online
Salesforce
OneDrive
SQL Server
Dropbox
AzureBlobStorage
Box
Excel
Facebook
Push notification
FTP
GitHub
Google Calendar
Google Drive
Google Sheets
Google Tasks
Instagram
MailChimp
Mandrill
Microsoft Translator
Office 365 Outlook
Office 365 Users
Office 365 Video
Outlook.com
Project Online
RSS
Common Data Model
SendGrid
Mail
Service Bus
SFTP
Slack
Smartsheet
SMTP
SparkPost
Todoist
Trello
Twilio
Twitter
Visual Studio Team Services
Wunderlist
Yammer
Yammer
YouTube

10 years ago

Are you sure you want to delete this post?

procoder

Yeah they have a lot of services to choose, and it's not hard to implement them, you need only to choose the right template that you want to use.

I think that depends, because there are a lot of possibilities to built anything you want from scratch, the most important thing is that whenever a new flow is created it will go under review by the Microsoft, and it will be published once they review them. This is a good idea because people will have options to use high quality flow templates.

That depend in your needs, for instance, as a programmer I'll need to test all of those services and see if i can create something that people need.

10 years ago

Are you sure you want to delete this post?

Lynne

Oh wow that is a long list Webguy2024! I would need some time to figure out what all of those are before I could choose. A lot of them I have never even heard of.

10 years ago

Are you sure you want to delete this post?

Webguy2024

There is always something new coming out. It is getting quite hard to try and keep up with everything.

10 years ago

Are you sure you want to delete this post?

Lynne

I couldn't agree with you more on that one Webguy2024. It is awesome that there is so much to use and check out but on the other hand I often feel quite bombarded with all the tools, social networks and other nifty things to make use of online!

10 years ago

Are you sure you want to delete this post?

idealmike

Ohh this is sort of M$'s version of IFTTT then in a way. Which is an automation tool in and of itself. But with a twist in its own unique way. I would imagine that this has as much practical use to using it as using an IFTTT recipe can have as well. It basically works exactly the same way in that you can have things done for you based on things that happen. Such as make a tweet if a keyword is found on some website or whatever. I've looked through their current existing templates and actually they don't have that many. I wanted to try and find something for Pinterest so it could pin something to a certain board for me when a tweet or something is found but sadly it doesn't have anything for automating Pinterest. I would imagine though in the future, more templates and services are added. I hope!

10 years ago

Are you sure you want to delete this post?

procoder

Yeah I'm sure that they will add more templates and services soon, because currently their service is in preview mode, which means that they have a lot to fix or to implement. Hope that the official release will be something good.

10 years ago

Are you sure you want to delete this post?

overcast

I checked out the service. And I find it really good. I think microsoft is doing really good in this direction. Considering how the tool is going to work same as the IFTTT and Zapier. You can see that some of such services are not completely free. And microsoft offering those options are same price can be something worth going forward to. I'd definitely consider that as an option.

9 years ago

Are you sure you want to delete this post?

Process Time: 0.19536304473877

Possible Duplicate queries found!

Match	Count	SQL	Script
SELECT * FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='19590'	1	SELECT q.*, c.seo as CatSEO, c.name as CatName, c.parentid FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='19590'	/opt/clerks-staging/docroot/viewfaq.php 496 () ()
SELECT * FROM seoclerks.members WHERE USERID='377074'	1	SELECT * FROM seoclerks.members WHERE USERID='377074'	/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
SELECT * FROM categories_faq WHERE CATID='55'	1	SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='55'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType()
SELECT * FROM seoclerks.members WHERE USERID=377074	1	SELECT googleplus_profile FROM seoclerks.members WHERE USERID=377074	/opt/clerks-staging/docroot/include/functions/main.php 16914 GetGooglePlusProfileFromId() ()
SELECT * FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=19590 LIMIT 5	1	SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=19590 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='19590' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc	1	SELECT a.answer, a.USERID, a.upvotes, a.downvotes, a.ansid, a.parentid, a.combined_votes, a.date_answered, b.username, b.userlevel, b.profilepicture FROM answers a, seoclerks.members b WHERE a.quesid='19590' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc	/opt/clerks-staging/docroot/viewfaq.php 1245 () ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107199 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107199 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107255 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107255 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107287 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107287 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107202 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107202 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107256 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107256 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107313 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107313 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107326 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107326 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107350 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107350 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107210 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107210 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107257 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=107257 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=120215 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=120215 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
UPDATE questions SET total_views = total_views + 1 WHERE quesid='19590'	1	UPDATE questions SET total_views = total_views + 1 WHERE quesid='19590'	/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
SELECT * FROM questions WHERE quesid!='19590' AND status='1' AND (question like '%Microsoft Flow - Automation Tool Released Microsoft%' OR question like '%Microsoft%' OR question like '%Flow%' OR question like '%Automation%' OR question like '%Tool%' OR question like '%Released%' OR question like '%Microsoft%') -- ORDER BY RAND() LIMIT 15	1	SELECT quesid, question, seo, userid FROM questions WHERE quesid!='19590' AND status='1' AND (question like '%Microsoft Flow - Automation Tool Released Microsoft%' OR question like '%Microsoft%' OR question like '%Flow%' OR question like '%Automation%' OR question like '%Tool%' OR question like '%Released%' OR question like '%Microsoft%') -- ORDER BY RAND() LIMIT 15	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM seoclerks.members WHERE USERID='16580' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='16580' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='1323' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='1323' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='17031' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='17031' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='8619' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='8619' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='4136' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='4136' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=19590%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID	1	SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=19590%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM categories	1	SELECT * FROM categories	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()
select * from categories_software order by name asc	1	select * from categories_software order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories()
select * from categories_wanttobuy order by name asc	1	select * from categories_wanttobuy order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories()
select * from categories_wanttotrade order by name asc	1	select * from categories_wanttotrade order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories()
SELECT * FROM seoclerks.members WHERE USERID='2951.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='2951.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='377074.png'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='377074.png'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='306632.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='306632.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='29365.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='29365.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='272.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='272.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='589438.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='589438.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
select * from categories_faq order by name asc	1	select * from categories_faq order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()

Invalid SQL

count(*)	sql1	error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially

Load

Count

SQL

Max

Min

Suspicious SQL

The following SQL have high average execution times

Avg Time	Count	SQL	Max	Min
0.207322	1	SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (75) AND type !=99 order by A.lastgigedit desc limit 160, 40	0.207322	0.207322