1
00:00:00,000 --> 00:00:04,880
Hello everyone and welcome to another episode of Microsoft Knowledge Nuggets here on M365.

2
00:00:04,880 --> 00:00:06,720
FM, I'm your host, Mirko Peters.

3
00:00:06,720 --> 00:00:10,360
Today's topic is one that almost everyone has heard of, but few really understand.

4
00:00:10,360 --> 00:00:11,600
Microsoft Power Platform.

5
00:00:11,600 --> 00:00:12,640
So imagine this.

6
00:00:12,640 --> 00:00:15,200
You're sitting at your desk with four browser tabs open.

7
00:00:15,200 --> 00:00:17,840
One Excel spreadsheet you update by hand every morning,

8
00:00:17,840 --> 00:00:20,200
one outlook with approval requests piling up,

9
00:00:20,200 --> 00:00:22,680
a SharePoint list from three years ago that nobody trusts,

10
00:00:22,680 --> 00:00:25,760
and somewhere in that mess you're copying data from one system to another,

11
00:00:25,760 --> 00:00:27,360
hoping not to make a typo.

12
00:00:27,360 --> 00:00:28,200
Sound familiar?

13
00:00:28,200 --> 00:00:29,720
That's how most companies run.

14
00:00:30,040 --> 00:00:34,920
A patchwork of tools that don't talk to each other held together by people doing repetitive work.

15
00:00:34,920 --> 00:00:39,120
But what if you could connect all of that into one system without writing a single line of code?

16
00:00:39,120 --> 00:00:40,680
That's what Microsoft Power Platform is.

17
00:00:40,680 --> 00:00:42,120
Here's the simplest definition.

18
00:00:42,120 --> 00:00:45,600
It's a connected layer on top of your existing Microsoft 365 tools,

19
00:00:45,600 --> 00:00:47,200
your email, Teams, SharePoint,

20
00:00:47,200 --> 00:00:49,200
and it lets anyone in your company build apps,

21
00:00:49,200 --> 00:00:51,320
automate workflows and analyze data,

22
00:00:51,320 --> 00:00:53,040
all without needing a developer.

23
00:00:53,040 --> 00:00:55,960
By the end of this episode, you'll understand what each piece does

24
00:00:55,960 --> 00:00:57,800
and how they all snap together.

25
00:00:57,800 --> 00:00:59,800
Grab your coffee and let's dive in.

26
00:00:59,800 --> 00:01:02,400
The problem, why Power Platform exists?

27
00:01:02,400 --> 00:01:03,400
Here's the thing.

28
00:01:03,400 --> 00:01:06,200
Most organizations run on a patchwork of Excel spreadsheets,

29
00:01:06,200 --> 00:01:07,800
email chains and paper forms.

30
00:01:07,800 --> 00:01:10,600
Someone fills out a Word document, emails it to their manager,

31
00:01:10,600 --> 00:01:13,400
the manager prints it, signs it, scans it and emails it back.

32
00:01:13,400 --> 00:01:14,400
That's not an exaggeration.

33
00:01:14,400 --> 00:01:16,400
That's how a lot of businesses still work.

34
00:01:16,400 --> 00:01:18,600
Off the shelf software was supposed to fix this,

35
00:01:18,600 --> 00:01:21,600
but either it costs a fortune, or it doesn't fit your process,

36
00:01:21,600 --> 00:01:25,600
so you end up bending your workflow to match the software instead of the other way around.

37
00:01:25,600 --> 00:01:27,400
And that never works well.

38
00:01:27,400 --> 00:01:30,200
The traditional alternative was to build custom software,

39
00:01:30,200 --> 00:01:32,800
but that meant hiring developers for months or years

40
00:01:32,800 --> 00:01:35,600
and a simple app could cost tens of thousands of dollars.

41
00:01:35,600 --> 00:01:39,200
And by the time it was finished, your business needs had already changed.

42
00:01:39,200 --> 00:01:42,200
So you end up with separate silos, your data lives in SharePoint,

43
00:01:42,200 --> 00:01:43,600
your approvals happen over email,

44
00:01:43,600 --> 00:01:46,000
your reporting is in Power BI, but disconnected,

45
00:01:46,000 --> 00:01:47,600
and nothing talks to each other.

46
00:01:47,600 --> 00:01:50,800
Power Platform solves this by giving non-developers the power to build,

47
00:01:50,800 --> 00:01:53,200
automate and analyze, all in one place.

48
00:01:53,200 --> 00:01:56,000
Most people think Power Platform is only for IT professionals.

49
00:01:56,000 --> 00:01:56,800
It isn't.

50
00:01:56,800 --> 00:01:58,600
It's designed for anyone in your company,

51
00:01:58,600 --> 00:02:00,600
from sales to HR to operations,

52
00:02:00,600 --> 00:02:02,600
to create solutions without writing code.

53
00:02:02,600 --> 00:02:05,400
And it's already part of the Microsoft tools you're using.

54
00:02:05,400 --> 00:02:07,200
Next up, the first building block,

55
00:02:07,200 --> 00:02:09,200
the one that helps you see your data.

56
00:02:09,200 --> 00:02:11,400
Power BI, see what's happening.

57
00:02:11,400 --> 00:02:13,000
Most people have heard of Power BI,

58
00:02:13,000 --> 00:02:14,000
but what does it actually do?

59
00:02:14,000 --> 00:02:16,200
In plain English, it takes your raw data,

60
00:02:16,200 --> 00:02:17,400
rows and columns,

61
00:02:17,400 --> 00:02:19,200
and turns it into charts and dashboards.

62
00:02:19,200 --> 00:02:20,400
You can read it at glance,

63
00:02:20,400 --> 00:02:24,200
connect it to Excel, SQL, dataverse, or even Salesforce,

64
00:02:24,200 --> 00:02:26,400
and it creates visuals that actually mean something.

65
00:02:26,400 --> 00:02:27,800
Here's a concrete example.

66
00:02:27,800 --> 00:02:29,800
Say you're a manager who needs to know

67
00:02:29,800 --> 00:02:32,000
which products are selling fastest this week.

68
00:02:32,000 --> 00:02:34,200
In the old way, you'd ask someone to pull a report,

69
00:02:34,200 --> 00:02:36,800
wait a day, get a spreadsheet, and try to make sense of it.

70
00:02:36,800 --> 00:02:39,200
With Power BI, that dashboard updates automatically,

71
00:02:39,200 --> 00:02:41,200
so when you open it, the numbers are right there.

72
00:02:41,200 --> 00:02:43,400
No manual work required, but here's the thing.

73
00:02:43,400 --> 00:02:45,800
Power BI is more than just a reporting tool.

74
00:02:45,800 --> 00:02:47,200
It's the eyes of the platform.

75
00:02:47,200 --> 00:02:48,400
It shows you what's happening

76
00:02:48,400 --> 00:02:50,200
across your entire business in real time.

77
00:02:50,200 --> 00:02:53,200
And those dashboards don't have to live inside Power BI alone.

78
00:02:53,200 --> 00:02:55,200
You can embed them in Teams, in Power Apps,

79
00:02:55,200 --> 00:02:56,600
even in SharePoint.

80
00:02:56,600 --> 00:02:59,400
Your data is visible wherever you're already working.

81
00:02:59,400 --> 00:03:01,400
Seeing the problem is only half the battle.

82
00:03:01,400 --> 00:03:03,000
What if you could automate the fix?

83
00:03:03,000 --> 00:03:05,000
That's where the next tool comes in.

84
00:03:05,000 --> 00:03:07,800
Power Automate, make work happen automatically.

85
00:03:07,800 --> 00:03:10,000
Power BI shows you what's happening, and that's useful,

86
00:03:10,000 --> 00:03:12,000
but it still leaves you with the actual work.

87
00:03:12,000 --> 00:03:14,600
Someone still has to send emails, update spreadsheets,

88
00:03:14,600 --> 00:03:15,600
and chase down approvals.

89
00:03:15,600 --> 00:03:17,000
And that's where Power Automate comes in.

90
00:03:17,000 --> 00:03:20,000
If Power BI is the eyes, Power Automate is the muscles.

91
00:03:20,000 --> 00:03:21,000
It does the heavy lifting,

92
00:03:21,000 --> 00:03:22,000
so you don't have to.

93
00:03:22,000 --> 00:03:23,000
Here's how it works.

94
00:03:23,000 --> 00:03:24,400
You set up a trigger.

95
00:03:24,400 --> 00:03:25,800
Something that happens in your system,

96
00:03:25,800 --> 00:03:28,200
like an email arriving, a row getting added to a list,

97
00:03:28,200 --> 00:03:29,400
or a date passing.

98
00:03:29,400 --> 00:03:33,200
When that trigger fires, Power Automate runs a series of actions automatically.

99
00:03:33,200 --> 00:03:35,200
All drag and drop, no code required.

100
00:03:35,200 --> 00:03:36,600
Let me give you a concrete example.

101
00:03:36,600 --> 00:03:39,000
Say a new sales lead gets added in Dynamics 365.

102
00:03:39,000 --> 00:03:41,800
In the old way, a sales rep would need to notice that lead,

103
00:03:41,800 --> 00:03:43,200
manually create a task,

104
00:03:43,200 --> 00:03:45,600
write a follow-up email, and add it to their calendar.

105
00:03:45,600 --> 00:03:48,000
With Power Automate, it all happens instantly.

106
00:03:48,000 --> 00:03:50,000
The lead appears, a task is created,

107
00:03:50,000 --> 00:03:53,000
and email is sent, and the rep gets a notification in Teams.

108
00:03:53,000 --> 00:03:54,200
No one lifted a finger.

109
00:03:54,200 --> 00:03:56,400
Here's another one almost every company deals with.

110
00:03:56,400 --> 00:03:57,800
Expense approvals.

111
00:03:57,800 --> 00:04:01,000
An employee submits an expense report over $500.

112
00:04:01,000 --> 00:04:03,400
Power Automate catches that, sends an email to the manager

113
00:04:03,400 --> 00:04:04,600
with an approval request,

114
00:04:04,600 --> 00:04:06,000
and when the manager clicks approve,

115
00:04:06,000 --> 00:04:08,000
it updates the spreadsheet automatically.

116
00:04:08,000 --> 00:04:10,200
No back and forth, no, did you see my email?

117
00:04:10,200 --> 00:04:12,400
And no chasing people down in the hallway.

118
00:04:12,400 --> 00:04:14,000
And this isn't limited to Microsoft tools.

119
00:04:14,000 --> 00:04:17,200
Power Automate has over one 400 pre-built connectors.

120
00:04:17,200 --> 00:04:19,000
Outlook, Teams, SharePoint, Sure,

121
00:04:19,000 --> 00:04:22,600
but also Slack, Twitter, Dropbox, SalesForce, and DocuSign.

122
00:04:22,600 --> 00:04:24,400
You can connect pretty much anything to anything,

123
00:04:24,400 --> 00:04:27,000
so now you can see your data and automate your workflows,

124
00:04:27,000 --> 00:04:28,400
but there's still a missing piece,

125
00:04:28,400 --> 00:04:31,200
a place where people can actually interact with the process.

126
00:04:31,200 --> 00:04:32,400
That's what comes next.

127
00:04:32,400 --> 00:04:33,600
Power Apps.

128
00:04:33,600 --> 00:04:34,800
Build the interface.

129
00:04:34,800 --> 00:04:36,400
Power BI shows you the data,

130
00:04:36,400 --> 00:04:38,200
and Power Automate does the work,

131
00:04:38,200 --> 00:04:40,800
but people still need a way to interact with the system,

132
00:04:40,800 --> 00:04:44,200
to submit something, to check something, to update something.

133
00:04:44,200 --> 00:04:46,400
That's exactly what Power Apps is built for.

134
00:04:46,400 --> 00:04:49,600
Power Apps is where you create the user-facing part of your solution,

135
00:04:49,600 --> 00:04:53,000
mobile apps, web apps, tablet apps, whatever your people need,

136
00:04:53,000 --> 00:04:55,000
and you build them without writing traditional code.

137
00:04:55,000 --> 00:04:56,000
There are two main types.

138
00:04:56,000 --> 00:04:58,800
Canvas Apps give you complete control over the design.

139
00:04:58,800 --> 00:05:02,600
You drag and drop buttons, text boxes, images, and data fields

140
00:05:02,600 --> 00:05:04,600
onto a screen exactly where you want them.

141
00:05:04,600 --> 00:05:06,000
It's like designing a poster.

142
00:05:06,000 --> 00:05:07,800
Every element goes where you decide.

143
00:05:07,800 --> 00:05:10,000
If you want a green button in the top-right corner,

144
00:05:10,000 --> 00:05:11,000
you put it there.

145
00:05:11,000 --> 00:05:12,800
Model-driven apps work differently.

146
00:05:12,800 --> 00:05:14,400
They're built around your data structure.

147
00:05:14,400 --> 00:05:17,000
You define your tables and relationships in dataverse

148
00:05:17,000 --> 00:05:19,200
and the app generates the interface automatically.

149
00:05:19,200 --> 00:05:21,000
Visually, it's less flexible,

150
00:05:21,000 --> 00:05:23,600
but for complex data operations, it's much better.

151
00:05:23,600 --> 00:05:27,000
Things like guided data entry, business rules, and process flows.

152
00:05:27,000 --> 00:05:28,000
Here's a real example.

153
00:05:28,000 --> 00:05:30,600
Say you have field workers who need to inspect

154
00:05:30,600 --> 00:05:32,200
safety equipment at job sites.

155
00:05:32,200 --> 00:05:35,200
You build a simple Canvas app that runs on their phone.

156
00:05:35,200 --> 00:05:37,200
They open it, check off items on a list,

157
00:05:37,200 --> 00:05:39,400
take a photo of something's broken, and submit.

158
00:05:39,400 --> 00:05:41,200
The data goes straight into your system.

159
00:05:41,200 --> 00:05:44,000
No paper forms, no typing up notes at the end of the day.

160
00:05:44,000 --> 00:05:46,200
Power Apps uses something called PowerFX.

161
00:05:46,200 --> 00:05:48,400
It's a formula language that looks a lot like Excel.

162
00:05:48,400 --> 00:05:51,400
So if you know how to write XS-S-S-M in a spreadsheet,

163
00:05:51,400 --> 00:05:52,600
you already have a head start.

164
00:05:52,600 --> 00:05:54,600
You can use it to build logic into your app.

165
00:05:54,600 --> 00:05:56,800
Show this field when that checkbox is checked.

166
00:05:56,800 --> 00:05:58,600
Calculate this total from those inputs.

167
00:05:58,600 --> 00:06:01,200
Think of Power Apps like building a Lego house.

168
00:06:01,200 --> 00:06:03,200
You snap together pre-built blocks,

169
00:06:03,200 --> 00:06:06,400
buttons, forms, galleries, data connections,

170
00:06:06,400 --> 00:06:08,000
and you get exactly what you need.

171
00:06:08,000 --> 00:06:09,400
No soldering required.

172
00:06:09,400 --> 00:06:10,800
So we've got three tools so far.

173
00:06:10,800 --> 00:06:13,200
See the data, automate the work, build the interface,

174
00:06:13,200 --> 00:06:16,400
but in 2026, there's a fourth piece that changes everything.

175
00:06:16,400 --> 00:06:18,800
Co-pilot Studio, add AI agents.

176
00:06:18,800 --> 00:06:20,600
Now let's talk about a new piece.

177
00:06:20,600 --> 00:06:21,800
Co-pilot Studio.

178
00:06:21,800 --> 00:06:23,800
It used to be called Power Virtual Agents.

179
00:06:23,800 --> 00:06:26,800
This is where you create AI-powered chatbots and agents.

180
00:06:26,800 --> 00:06:29,400
Not the clunky kind that can only answer three questions.

181
00:06:29,400 --> 00:06:31,600
Real agents that understand what someone needs,

182
00:06:31,600 --> 00:06:33,600
take action, and even talk to other agents.

183
00:06:33,600 --> 00:06:36,200
These agents can live inside teams on your website

184
00:06:36,200 --> 00:06:38,600
or in a mobile app, and employee asks a question

185
00:06:38,600 --> 00:06:39,600
and the agent answers it.

186
00:06:39,600 --> 00:06:41,200
But it goes further than that.

187
00:06:41,200 --> 00:06:43,000
The agent can start a power automate flow.

188
00:06:43,000 --> 00:06:44,800
So a conversation becomes an action.

189
00:06:44,800 --> 00:06:46,200
Here's a practical example.

190
00:06:46,200 --> 00:06:49,600
A company builds an HR agent and employee types in teams.

191
00:06:49,600 --> 00:06:51,600
How many sick days do I have left?

192
00:06:51,600 --> 00:06:54,200
The agent checks the HR system, pulls up the employee's record

193
00:06:54,200 --> 00:06:55,400
and answers instantly.

194
00:06:55,400 --> 00:06:58,600
Then the employee asks, "I need to take next Friday off."

195
00:06:58,600 --> 00:07:00,600
The agent creates a time off request,

196
00:07:00,600 --> 00:07:03,600
roots it to the manager for approval, and sends a confirmation.

197
00:07:03,600 --> 00:07:06,800
All in one chat conversation, no forms, no emails, no back and forth.

198
00:07:06,800 --> 00:07:09,000
And here's the powerful part for 2026.

199
00:07:09,000 --> 00:07:10,600
Agents can now talk to each other.

200
00:07:10,600 --> 00:07:12,800
Microsoft calls it agent-to-agent communication.

201
00:07:12,800 --> 00:07:14,400
One agent handles HR questions.

202
00:07:14,400 --> 00:07:16,000
Another handles IT support.

203
00:07:16,000 --> 00:07:17,800
Another handles expense approvals.

204
00:07:17,800 --> 00:07:20,600
If an employee asks a question that crosses departments,

205
00:07:20,600 --> 00:07:22,600
the agents coordinate behind the scenes.

206
00:07:22,600 --> 00:07:25,200
The user doesn't see any of it, and they just get their answer.

207
00:07:25,200 --> 00:07:26,600
So now we have four tools.

208
00:07:26,600 --> 00:07:28,600
See, automate, build, talk.

209
00:07:28,600 --> 00:07:30,200
But all of them need one thing in common.

210
00:07:30,200 --> 00:07:32,200
They need a place to store their data.

211
00:07:32,200 --> 00:07:34,200
Dataverse, the engine underneath.

212
00:07:34,200 --> 00:07:35,600
So we covered the four tools.

213
00:07:35,600 --> 00:07:37,200
Power BI shows you what's happening.

214
00:07:37,200 --> 00:07:38,600
Power automate does the work.

215
00:07:38,600 --> 00:07:40,800
Power apps gives people a way to interact.

216
00:07:40,800 --> 00:07:44,600
And co-pilot studio adds AI agents that can converse and take action.

217
00:07:44,600 --> 00:07:48,000
But they all need one thing in common, a place to store their data.

218
00:07:48,000 --> 00:07:49,200
That's where dataverse comes in.

219
00:07:49,200 --> 00:07:50,800
And this is the piece most people never see,

220
00:07:50,800 --> 00:07:52,800
because it works quietly behind the scenes.

221
00:07:52,800 --> 00:07:55,400
Dataverse is the secure, cloud-based database

222
00:07:55,400 --> 00:07:59,400
that sits behind Power Apps, Power Automate, and even Dynamics 365.

223
00:07:59,400 --> 00:08:02,400
Think of it as the single source of truth for your business data.

224
00:08:02,400 --> 00:08:07,200
No more information scattered across 20 Excel files and six SharePoint lists.

225
00:08:07,200 --> 00:08:10,600
It all lives in one place, structured, secure, and ready to use.

226
00:08:10,600 --> 00:08:14,000
Here's what makes it different from just throwing everything into a shared spreadsheet.

227
00:08:14,000 --> 00:08:15,800
Dataverse has built-in security.

228
00:08:15,800 --> 00:08:18,800
Roll-based access means you control exactly who can see what.

229
00:08:18,800 --> 00:08:20,200
A manager can view salary data.

230
00:08:20,200 --> 00:08:21,200
A team member can't.

231
00:08:21,200 --> 00:08:24,200
That's handled at the database level, not in your app code.

232
00:08:24,200 --> 00:08:26,200
It also has business rules built right in.

233
00:08:26,200 --> 00:08:28,600
You can say, if this field is over a certain value,

234
00:08:28,600 --> 00:08:30,200
make this other field required.

235
00:08:30,200 --> 00:08:32,400
Or whenever a new order is created,

236
00:08:32,400 --> 00:08:35,600
automatically calculate the total based on the line items.

237
00:08:35,600 --> 00:08:37,800
That logic lives inside Dataverse,

238
00:08:37,800 --> 00:08:39,600
not inside each individual app.

239
00:08:39,600 --> 00:08:42,800
So every app that uses that data follows the same rules.

240
00:08:42,800 --> 00:08:44,600
And it handles relationships between data.

241
00:08:44,600 --> 00:08:47,200
This is where a shared Excel file falls apart.

242
00:08:47,200 --> 00:08:50,200
In Excel, you have one sheet for customers and another for orders.

243
00:08:50,200 --> 00:08:52,200
But there's no real connection between them.

244
00:08:52,200 --> 00:08:54,400
Someone has to manually keep them in sync.

245
00:08:54,400 --> 00:08:56,400
In Dataverse, you define a relationship.

246
00:08:56,400 --> 00:08:58,000
A customer has many orders.

247
00:08:58,000 --> 00:08:59,600
An order belongs to one customer.

248
00:08:59,600 --> 00:09:01,000
The database enforces that.

249
00:09:01,000 --> 00:09:02,000
If you delete a customer,

250
00:09:02,000 --> 00:09:05,000
you can choose whether to also delete their orders or block the deletion.

251
00:09:05,000 --> 00:09:07,000
The data stays clean automatically.

252
00:09:07,000 --> 00:09:08,200
Here's a concrete example.

253
00:09:08,200 --> 00:09:09,400
You have a table for customers.

254
00:09:09,400 --> 00:09:10,800
A table for orders.

255
00:09:10,800 --> 00:09:12,200
And a relationship between them.

256
00:09:12,200 --> 00:09:15,600
Power apps reads from both tables to show a customer's order history.

257
00:09:15,600 --> 00:09:18,800
Power automate writes to the orders table when a new sale comes in.

258
00:09:18,800 --> 00:09:22,400
Power BI reads from both to build a report showing revenue by customer.

259
00:09:22,400 --> 00:09:25,800
Everyone uses the same data in the same structure with the same security rules.

260
00:09:25,800 --> 00:09:28,000
No copies, no sync issues, no one asking.

261
00:09:28,000 --> 00:09:30,000
Which version of the spreadsheet is the right one?

262
00:09:30,000 --> 00:09:31,800
That's the real value of Dataverse.

263
00:09:31,800 --> 00:09:34,800
It's what makes the whole platform work together seamlessly.

264
00:09:34,800 --> 00:09:37,200
Without it, you'd be back to the same old problem.

265
00:09:37,200 --> 00:09:39,600
Tools that don't talk to each other.

266
00:09:39,600 --> 00:09:42,600
Now, let's put it all together with a real-world scenario

267
00:09:42,600 --> 00:09:45,600
that shows the full system in action.

268
00:09:45,600 --> 00:09:47,600
How they all connect the full system.

269
00:09:47,600 --> 00:09:49,800
Let me walk you through one complete process.

270
00:09:49,800 --> 00:09:51,000
An expensive, proven workflow.

271
00:09:51,000 --> 00:09:54,200
And I want you to pay attention to how many tools touch the single process

272
00:09:54,200 --> 00:09:56,400
and how seamlessly they hand off to each other.

273
00:09:56,400 --> 00:09:57,400
Step one.

274
00:09:57,400 --> 00:09:59,400
An employee is out on a business trip.

275
00:09:59,400 --> 00:10:01,600
They pay for a hotel and a client dinner.

276
00:10:01,600 --> 00:10:02,800
They pull out their phone,

277
00:10:02,800 --> 00:10:05,200
open a power app and submit an expense report.

278
00:10:05,200 --> 00:10:09,400
They snap a photo of the receipt, enter the amount, select the category and hit submit.

279
00:10:09,400 --> 00:10:10,800
Took them about 30 seconds.

280
00:10:10,800 --> 00:10:11,400
Step two.

281
00:10:11,400 --> 00:10:12,800
That data lands in Dataverse.

282
00:10:12,800 --> 00:10:14,400
It's structured, it's secure.

283
00:10:14,400 --> 00:10:17,600
The employee can see their own submissions, but not anyone else's.

284
00:10:17,600 --> 00:10:20,000
The receipt image is stored, the amount is recorded.

285
00:10:20,000 --> 00:10:21,800
The status is set to pending.

286
00:10:21,800 --> 00:10:22,400
Step three.

287
00:10:22,400 --> 00:10:24,000
Power Automate picks up the event.

288
00:10:24,000 --> 00:10:25,200
A new expense was added.

289
00:10:25,200 --> 00:10:26,400
It checks the amount.

290
00:10:26,400 --> 00:10:30,000
Over $500, then it roots it to the employee's manager for approval.

291
00:10:30,000 --> 00:10:32,800
It sends an adaptive card to the manager's team's channel.

292
00:10:32,800 --> 00:10:36,600
The card shows the amount, the category and a button to approve or reject.

293
00:10:36,600 --> 00:10:38,600
The manager doesn't need to open a separate app.

294
00:10:38,600 --> 00:10:40,400
It's right there in their chat.

295
00:10:40,400 --> 00:10:41,400
Step four.

296
00:10:41,400 --> 00:10:43,200
Before the manager decides, they want context.

297
00:10:43,200 --> 00:10:45,000
How much has this team spent this month?

298
00:10:45,000 --> 00:10:47,600
They open a Power BI dashboard embedded right in Teams.

299
00:10:47,600 --> 00:10:49,600
It shows monthly expense trends by department.

300
00:10:49,600 --> 00:10:53,200
They can see that this team is within budget and this expense is reasonable.

301
00:10:53,200 --> 00:10:56,200
That context helps them make a faster decision.

302
00:10:56,200 --> 00:10:57,200
Step five.

303
00:10:57,200 --> 00:10:59,200
Now here's where Copilot Studio comes in.

304
00:10:59,200 --> 00:11:00,800
Instead of just clicking approve,

305
00:11:00,800 --> 00:11:03,600
the manager gets a message from an AI agent in Teams.

306
00:11:03,600 --> 00:11:04,600
The agent says,

307
00:11:04,600 --> 00:11:08,000
"I see you have a pending expense approval from Sarah for $750.

308
00:11:08,000 --> 00:11:09,200
So I've checked the budget.

309
00:11:09,200 --> 00:11:10,200
You're within limits.

310
00:11:10,200 --> 00:11:12,000
Do you want me to process this?"

311
00:11:12,000 --> 00:11:13,000
The manager says yes.

312
00:11:13,000 --> 00:11:14,200
The agent handles it.

313
00:11:14,200 --> 00:11:15,000
Step six.

314
00:11:15,000 --> 00:11:17,600
Once approved, Power Automate kicks off another flow.

315
00:11:17,600 --> 00:11:19,800
It updates the expense status and dataverse.

316
00:11:19,800 --> 00:11:22,000
It sends a confirmation email to the employee.

317
00:11:22,000 --> 00:11:25,800
It pushes the data to the company's ERP system through a connector.

318
00:11:25,800 --> 00:11:27,600
And it logs the approval in the audit trail.

319
00:11:27,600 --> 00:11:29,200
One unified flow.

320
00:11:29,200 --> 00:11:30,200
Six steps.

321
00:11:30,200 --> 00:11:31,200
Five tools.

322
00:11:31,200 --> 00:11:33,000
Zero manual handoffs.

323
00:11:33,000 --> 00:11:34,400
No one forwarded an email.

324
00:11:34,400 --> 00:11:36,600
No one copied data from one system into another.

325
00:11:36,600 --> 00:11:37,400
No one asked,

326
00:11:37,400 --> 00:11:39,400
"Did you approve this yet?"

327
00:11:39,400 --> 00:11:40,800
The whole thing happened automatically

328
00:11:40,800 --> 00:11:43,200
with the right human oversight at the right moments.

329
00:11:43,200 --> 00:11:44,800
The magic isn't any single tool.

330
00:11:44,800 --> 00:11:46,000
It's how they snap together.

331
00:11:46,000 --> 00:11:47,400
Power BI shows the context.

332
00:11:47,400 --> 00:11:48,800
Power Automate does the rooting.

333
00:11:48,800 --> 00:11:50,800
Power Apps provides the submission form.

334
00:11:50,800 --> 00:11:52,800
Copilot Studio adds the conversational layer.

335
00:11:52,800 --> 00:11:54,400
And dataverse holds it all together.

336
00:11:54,400 --> 00:11:55,600
This isn't theoretical.

337
00:11:55,600 --> 00:11:57,800
Organizations around the world are already doing this.

338
00:11:57,800 --> 00:12:00,400
The Singapore Civil Defence Force used power platform

339
00:12:00,400 --> 00:12:03,400
to transform manual processes into automated solutions,

340
00:12:03,400 --> 00:12:05,400
saving millions of dollars.

341
00:12:05,400 --> 00:12:08,400
Deutsche Bahn empowered their employees to build low-code apps

342
00:12:08,400 --> 00:12:11,000
accelerating innovation across the entire organization.

343
00:12:11,000 --> 00:12:12,000
These are real companies,

344
00:12:12,000 --> 00:12:15,600
solving real problems with the same tools we just walked through.

345
00:12:15,600 --> 00:12:17,000
Actionable takeaways.

346
00:12:17,000 --> 00:12:18,000
Where to start?

347
00:12:18,000 --> 00:12:19,800
So where do you actually begin?

348
00:12:19,800 --> 00:12:22,600
Most people jump in and try to learn all five tools at once.

349
00:12:22,600 --> 00:12:23,600
Don't do that.

350
00:12:23,600 --> 00:12:26,600
Instead pick the one tool that solves your biggest pain point today.

351
00:12:26,600 --> 00:12:29,200
If your biggest headache is not knowing what's happening in your business,

352
00:12:29,200 --> 00:12:30,800
start with Power BI.

353
00:12:30,800 --> 00:12:34,200
If you're drowning in repetitive manual work, start with power automate.

354
00:12:34,200 --> 00:12:38,000
And if you need a mobile form that replaces paper, start with power apps.

355
00:12:38,000 --> 00:12:40,400
One tool, one problem, solve that first.

356
00:12:40,400 --> 00:12:41,400
Here's the good news.

357
00:12:41,400 --> 00:12:43,000
You can try all of this for free.

358
00:12:43,000 --> 00:12:46,400
Just go to make power apps.com and sign up for a developer plan.

359
00:12:46,400 --> 00:12:48,800
It gives you a dataverse environment at no cost.

360
00:12:48,800 --> 00:12:51,400
You can build, test and learn without spending a dime.

361
00:12:51,400 --> 00:12:54,000
Once you've chosen your tool, the next step is simple.

362
00:12:54,000 --> 00:12:56,600
Pick one repetitive process at work and automate it.

363
00:12:56,600 --> 00:12:59,800
Maybe it's saving email attachments to SharePoint automatically

364
00:12:59,800 --> 00:13:03,200
or routing approval requests through teams instead of endless email chains.

365
00:13:03,200 --> 00:13:05,600
Starts more, get a win and then build from there.

366
00:13:05,600 --> 00:13:09,400
If you want to go deeper, Microsoft Learn has a free learning path

367
00:13:09,400 --> 00:13:11,400
for the PL900 certification.

368
00:13:11,400 --> 00:13:13,400
It walks you through everything we just covered

369
00:13:13,400 --> 00:13:15,200
or join the Power Platform community.

370
00:13:15,200 --> 00:13:19,400
Thousands of people share templates, answer questions and help each other build.

371
00:13:19,400 --> 00:13:20,800
That's the system in a nutshell.

372
00:13:20,800 --> 00:13:23,000
And here's the one sentence that sums it up.

373
00:13:23,000 --> 00:13:25,000
Power Platform isn't four separate apps.

374
00:13:25,000 --> 00:13:28,600
It's one connected layer that lets anyone build, automate and analyze

375
00:13:28,600 --> 00:13:30,000
without needing a developer.

376
00:13:30,000 --> 00:13:32,200
Start with the tool that solves your worst headache.

377
00:13:32,200 --> 00:13:34,000
Once you see how they click together,

378
00:13:34,000 --> 00:13:36,600
you'll never go back to spreadsheets and email approvals.

379
00:13:36,600 --> 00:13:40,000
Subscribe and share this with a colleague who's drowning in manual work.

380
00:13:40,000 --> 00:13:43,000
Drop a comment and tell me one process you want to automate.

381
00:13:43,000 --> 00:13:45,000
I'll see you in the next episode.