Posted on

Power Automate: Send daily bugs report in Microsoft Teams from Azure DevOps Boards

You can simply change same to send a mail notification too, instead of Teams.

Sample output on Teams:

image

Development Steps:

Step 01 – Create query in Azure DevOps board for Bugs

I would start with a Recurrence Trigger (schedule). Check always the Time zone of the trigger will happen on GMT.

Step 01 – Schedule

I would start with a Recurrence Trigger (schedule). Check always the Time zone of the trigger will happen on GMT.

image_thumb[2]

Step 02 – Initialize Azure DevOps URL (optional)

I am using this url for hyper linking in the output, which can be considered optional.

image

Step 03– Get bug list from DevOps boards

I suggest you to create a ‘query’ first which returns filtered ‘bug’ results. Below is the query have created and saved for this example blog.

image

Next, get the results from this query:

image

Step 04 – HTML’ize

I wanted to format the Bugs list content as a table and, MS Teams message supports HTML. So I will create a header and assign it to a new variable.

image

Step 05– Convert rows to HTML rows

Next step creates each row from DevOps boards query to corresponding <TR>s. You can choose to omit or add any columns as per your requirement.

image

Step 06 – Close HTML table

Once the rows are added to HTML table, I would close it and add also any footer notes.

image

Step 07– Post message in Teams

Finally, send the message to Teams. I have used a group chat in my case. Additionally I am using a ‘condition’ component also to check if the list is empty so it can directly ‘terminate’ the flow instead of posting an empty table in Teams.

image

Flow view:

This is what my simple Power Automate flow looks like:

image

Posted on

Power Automate: Send daily status post in Microsoft Teams from a SharePoint List

Assuming you have a “List” in SharePoint and you want to post a summary/or list as-it-is to a chat group in Microsoft Teams. You can simply change same to send a mail notification too, instead of Teams.

Output in Teams:

image

Development Steps:

Step 01 – Schedule

I would start with a Recurrence Trigger (schedule). Check always the Time zone of the trigger will happen on GMT.

image

Step 02 – Get list items from SharePoint

Choose the site address and list name

image

Step 03 – HTML’ize

I wanted to format the SharePoint List content as a table and, MS Teams message supports HTML. So I will create a header and assign it to a new variable.

image

Step 04 – Convert SharePoint rows to HTML rows

Next step creates each row from SharePoint to corresponding <TR>s. You can choose to omit or add any columns as per your requirement.

image

Step 05 – Close HTML table

Once the rows are added to HTML table, I would close it and add also any footer notes.

image

Step 06 – Post message in Teams

Finally, send the message to Teams. I have used a group chat in my case.

image

Flow view:

This is what my simple Power Automate flow looks like:

image

Posted on

Web 3.0 is here…

While reading about Web3, it initially reminded me for no reason the decentralized internet concept discussed in the famous Silicon Valley television series. Well, I thought to write about my learning on the reading of this buzz topic. I started my love for internet with the sound of dial-up internet so I was lucky enough to experience different browsers, sockets, chat apps, HTML, compatibilities and incompatibilities, and various phases of web standards. Initially it was purely technology focused but it has turned to human focused now. Thanks to the evolving Customer Experience (CX) and design thinkers’ priorities and involuntary digital revolution.

Web3 is based on Blockchain

Specifically, the decentralization and, that is the major upgrade we have from Web 2.0. Data volumes, importance and complexities has raised to uncontrollable states now and it has become a need of the hour for the enterprises to keep a log book of what is happening with data. Systems are forced today to check whether you are a human being and not a bot, before allowing you to do any transactions. Captcha, Multi-Factor-Authentication (MFA), Single Sign On, Face Recognition, and what not. Companies are investing hugely to protect their data by securing the systems and we were limited to traditional authentication and role based security based authorizations as enterprise standard. For many years sensitive industries such as Banking sector were reluctant to use Cloud systems because of trust issues and Cloud vendors such as Microsoft Azure and Amazon Web Services had hard time selling their products to enterprises. Consumer sector is still feared about Alexa being listening to their conversations, and industries are concerned about the data leakage of their IoT devices. With Web 3.0, and the proven architecture of crypto designs such as blockchain is going to significantly change the outlook and the on-premise systems will soon completely move to a decentralized mode.

It’s intelligent

Web 3.0 is expected to be intelligent than the previous generations because now we have figured out what internet can do, and what we want. We have advanced (but still immature in many area) much in data science, analytics and predictions so it is time to have the systems we build also have these learnings available ‘by design’.

Is it just a hype?

No, it cannot be. The concepts doesn’t talk anything unrealistic, but it vouch for the need of the hour.

More reading

Visit https://web3.foundation/ to read more. The technology stack page is very interesting.