tubeshowcase●1,669,816 videosβ™‘ My collection 0
← Learn to Code

Learn to Code09:02

How to Create a Scheduled Azure Boards Status Email w/ Azure Logic Apps No Code Micro Workshop Pt 3

Microsoft Developer β†—

From the creator

[3 of 4 - #NoCode Micro Workshop] 🚩 The Problem We want to track my work, impact, and long-term planning better, but there are so many project and work items floating around, it’s hard to stay on top of things. ✏️ Step 1: Modify Azure Boards Query Fields 00:00 - Beginning 00:18 - Open the "Work Items Assigned To Me" Query in Azure Boards Made in Previous Part 00:26 - Add "Assigned To" field to the query by editing the Column Options ✏️ Step 2: Create New Logic App that Retrieves Query Results on a Timer 00:58 - Create a new Consumption Logic App Resource in the #Azure Portal 02:13 - Trigger the Logic App Using a Recurrence (Timer) Set to Once Per Day 02:40 - Set the Second step to Get Query Results from Azure 03:00 - Copy Query GUID 03:42 - Create a String Variable for the Query Results ✏️ Step 3: Design Logic App to Loop Through Results and Append to a String 04:27 - Add a For Each Loop to the Logic App That Steps Through Query Results Value πŸ“Œ NOTE πŸ“Œ: Be sure to set the parallelism to 1 and concurrency to "on" 04:45 - Add step to Append to the Query Results String Variable 04:55 - Add HTML link to Query Results Including ID, Title, and String πŸ“Œ NOTE πŸ“Œ: Replace jasonhand AND ChangeMe in the above URL with what matches your own project URL ✏️ Step 4: Design Logic App to Send an Email with Custom Formatted Query Results 06:44 - Add a New Step to Send an Email (V2) using the Outlook 365 Connector 07:35 - Add Query Results to the Body 07:48 - Change the For Loop settings

Published 2022-08-17 Β· Watch on YouTube β†—
Availability and playback restrictions are controlled by the original channel.

Keep exploring Learn to Code