YouTube2Text

Claude end-to-end for Power Apps & Azure DevOps MCP, & Playwright — Transcript

by Sean Astrakhan · 1,849 words · 252 segments · language en · Watch on YouTube

Full transcript

  1. 0:00You've already seen vibe coded power
  2. 0:02apps. But what I'm going to show you is
  3. 0:04AI architecting my solutions before I
  4. 0:07even gave it all the details. It's
  5. 0:09incredible. How could it possibly do
  6. 0:11that? I'm going to use Azure DevOps MCP
  7. 0:14with Dataverse MCP to architect my
  8. 0:17solution, code my solution, deploy my
  9. 0:20solution, and in case you're not
  10. 0:21impressed enough, we're going to use
  11. 0:23Playwright to do all the clicking and QA
  12. 0:26verification for me without me even
  13. 0:28having to use my hands. I'm Shawn, a
  14. 0:31trainer at Untethered 365, and let's go.
  15. 0:34I have a Dataverse environment that
  16. 0:36stores vehicles and the makes, as in the
  17. 0:39companies that made them, and I have a
  18. 0:42new ticket that says, "As a salesperson,
  19. 0:45I want to know what year the maker
  20. 0:47company was founded, and if it's older
  21. 0:49than 20 years, I want some flag that
  22. 0:51says it's legacy." Now, you might be
  23. 0:53thinking, "I know exactly how to do
  24. 0:55this. I'll make this type of field or
  25. 0:56this type of business rule and did it
  26. 0:58did it did it." It's 2026.
  27. 1:00The biggest mistake you can make is use
  28. 1:03AI to do things for you. No, it should
  29. 1:06be helping you think of solutions. So,
  30. 1:08here I have VS Code, and I've connected
  31. 1:11it to the Azure DevOps MCP server. There
  32. 1:14is a link to the documentation in the
  33. 1:17description. So, I'm going to say, "What
  34. 1:19is task four about?" And then, "Task
  35. 1:23four,
  36. 1:24uh year
  37. 1:25car was founded as a salesperson, blah
  38. 1:28blah blah. What's needed what?" It tells
  39. 1:30me about it. Perfect. Now, GitHub
  40. 1:32Copilot knows what the problem is. I
  41. 1:35need to talk to my Dataverse to help me,
  42. 1:37which is my MCP server here. I have a
  43. 1:40video on that if you want to check that
  44. 1:41out. So, I'll ask, "What tables do you
  45. 1:45need to solve this problem?" Just one
  46. 1:49two two minutes. That's the main
  47. 1:49variable. We need to add did it did it
  48. 1:51did it did it did it did it. Cool. It
  49. 1:52gave me an architecture, which said, "Go
  50. 1:54make this whole number field and go make
  51. 1:56this is legacy field. Now, this is a
  52. 1:58simple example, but it's already
  53. 2:00thinking of an architecture for me so I
  54. 2:02can play around with this such as what
  55. 2:05other ways can we solve this problem?
  56. 2:09It's talking about JavaScript, talking
  57. 2:11about plugins, power effects, all of
  58. 2:13these it starts to give me the best
  59. 2:14options. I'm going to say create a read
  60. 2:18me for the problem we're trying to
  61. 2:21solve. Cool. Now it's created a read me
  62. 2:24in this directory which is nice because
  63. 2:27now I can use other models without
  64. 2:30having to use the DevOps server and have
  65. 2:32them poke apart this architecture. Let's
  66. 2:34ask Claude, what do you think of the
  67. 2:37solution? Any other ideas? It likes the
  68. 2:41idea, but it found one issue for with
  69. 2:43the formula. Instead, we should be using
  70. 2:45it this way. Um it found edge cases for
  71. 2:49me. I'm going to say update the read me
  72. 2:51with this alternative approach. Perfect.
  73. 2:54So now I have two models kind of working
  74. 2:56together to solve my problems. So I'm
  75. 2:58going to say go create that new column
  76. 3:03in step one and add it to the the
  77. 3:06vehicles solutions because I want to add
  78. 3:10it specifically to this unmanaged
  79. 3:13solution right here. It said it finished
  80. 3:15so let's go check. So if we hop into
  81. 3:17vehicles and then we go into make, we go
  82. 3:20into columns, boom right there year
  83. 3:22founded. Now I say can you add this
  84. 3:25column to the forms and views? It can't
  85. 3:27do that. So instead, I it's telling me
  86. 3:31to do it manually but this is where we
  87. 3:33all kind of still have a job because I
  88. 3:35know can you do it with the CLI? And it
  89. 3:41requires something a little risky. So in
  90. 3:42this case, it wants to export the
  91. 3:44solution. Once I have the solution in
  92. 3:46here as code, I can mess with it.
  93. 3:49It's going to uh you're going to have to
  94. 3:50authenticate. And if you're thinking,
  95. 3:52"Oh, this is like a bit overwhelming
  96. 3:55having the terminal do this. I haven't
  97. 3:56seen this before." I would suggest
  98. 3:59getting very comfortable with this
  99. 4:00because AI is really good at the
  100. 4:02terminal. It is not very good at
  101. 4:04clicking things in the UI. Yes, you can
  102. 4:07do that. Go watch my Claude video on
  103. 4:09that. And then boom, we have our
  104. 4:11solution here. It's opening our
  105. 4:13entities, all of our tables. It's
  106. 4:16telling me where everything lives. And
  107. 4:18it's going to try to modify the XML.
  108. 4:20This is risky, so keep Make sure you
  109. 4:22keep a backup of this uh solution. And
  110. 4:26boom, here is exactly the changes it
  111. 4:28made. Now, if you're looking at all this
  112. 4:29XML and you're like, "Okay, this is a
  113. 4:31bit overwhelming. I know this is
  114. 4:33connected to using repositories
  115. 4:36and source control. I've wanted to learn
  116. 4:39this, but but it's been overwhelming."
  117. 4:41Don't worry. We have a free live crash
  118. 4:43course that we do every couple months on
  119. 4:45this topic. It's in the link below. And
  120. 4:47of course, we have a full paid course,
  121. 4:49but you can also just check out the
  122. 4:50crash course for free. So, see that
  123. 4:52below. Now that it finished making my
  124. 4:54column, I'm going to say, "Go ahead and
  125. 4:57publish the unmanaged solution." Okay,
  126. 5:01good. It says done. It took a little
  127. 5:03while and it finished importing that.
  128. 5:05So, now I want to make sure that it
  129. 5:06actually did that. Let's see if that
  130. 5:08crashed everything. Let's open this up
  131. 5:10and go in here under make and then under
  132. 5:13forms, go in here. Boom, year founded
  133. 5:16right there. I'm going to use the MCP
  134. 5:18server to create form or dummy records
  135. 5:21for make and populate the year founded
  136. 5:22field. It made these for me. Great. I
  137. 5:25have the makes and the year founded in
  138. 5:27here. Now, remember that legacy field?
  139. 5:30Well, I went ahead and made it manually
  140. 5:34by going through the solution. But I
  141. 5:36noticed it kept getting this formula
  142. 5:38wrong. But there's a big lesson here.
  143. 5:40Certain languages like Power Fx, large
  144. 5:44language models are much less trained on
  145. 5:46because there's less data around. Oh,
  146. 5:48should you just have to do stuff manual
  147. 5:50lot? No, you should be thinking should I
  148. 5:53even be using some of this technology to
  149. 5:55begin with if it doesn't have a lot of
  150. 5:57AI support. That's a really tricky
  151. 5:59question. It's one of those things again
  152. 6:02in our crash courses, we unpack this
  153. 6:04stuff because we need to make sure that
  154. 6:06everything we build is AI friendly cuz
  155. 6:09it's going to make us go so much faster
  156. 6:11in the long term and give us a
  157. 6:13competitive edge over everybody else. So
  158. 6:15it seems like our work is done, but it's
  159. 6:18not. We still have to go and update this
  160. 6:21task. We can update the state here. We
  161. 6:23can leave a discussion, but ideally we
  162. 6:25have proof that this was finished.
  163. 6:28Here's where we can use playwright to
  164. 6:30click through our browser for us and
  165. 6:32prove that this work is done. So I'm
  166. 6:34going to ask GitHub Copilot go use
  167. 6:37playwright and the ADOMCP to create a
  168. 6:40test suite for task four. Now what
  169. 6:43happens next is insane. It's wrote the
  170. 6:45test for me, but it still needs to open
  171. 6:48my browser and click all the right
  172. 6:50places and make sure that everything was
  173. 6:52built properly. So how it figures that
  174. 6:55out is incredible. So here it is has all
  175. 6:59my test for me. I am not touching the
  176. 7:01mouse. This is right now going in trying
  177. 7:04to log in and figure out where it's
  178. 7:06supposed to go. This is truly
  179. 7:08incredible. And this is crazy. I told it
  180. 7:11that the app is called vehicles and it
  181. 7:14figured out Wait, no it's not. It's
  182. 7:16called car purchases. So it realizes
  183. 7:19when I'm even giving the wrong
  184. 7:20instruction. Like boom, car purchases,
  185. 7:22not vehicles. Now it needs to figure out
  186. 7:24how to click on this and continue the
  187. 7:26process. So now it knows what app to go
  188. 7:29to. Now it needs to click one of these
  189. 7:31records and actually see the data. So
  190. 7:33it's failing cuz it hasn't gotten the
  191. 7:36HTML yet, but now it's getting closer.
  192. 7:38All right, I think we're about there.
  193. 7:40It's going to go in here. It's checking
  194. 7:43that the year founded and this is
  195. 7:45incredible. It is now opening the views,
  196. 7:49opening up the forms, confirming
  197. 7:50everything exists where it's supposed to
  198. 7:53and only then does it say that the test
  199. 7:55passed. Now, it looks like I'm about
  200. 7:57done, so I'm going to say output a
  201. 7:59report and put that in the discussion on
  202. 8:03task four. All right, it's running my
  203. 8:06test. It's going to click it ran the
  204. 8:09first test to confirm it's on the views.
  205. 8:11Now, it should be running the test soon
  206. 8:13of clicking into the form and making
  207. 8:16sure that the values are actually on the
  208. 8:18form itself. There it is, confirmed
  209. 8:20that. Again, no hands. I'm not doing
  210. 8:22anything. It's doing it all for me. Says
  211. 8:25all four tests passed and there was
  212. 8:27report was added to task four. Let's see
  213. 8:29that. So, here is task four.
  214. 8:33Uh let's Let me refresh that. I just
  215. 8:35refreshed this. It marked it as done as
  216. 8:38I asked it to and then if we zoom in,
  217. 8:40what do we got? We got playwright test
  218. 8:43passed, API year founded column exists
  219. 8:45on the table.
  220. 8:46Uh is legacy is true, is legacy is
  221. 8:49false. That was confirmed. Year found
  222. 8:51exists on the form, exists like Does it
  223. 8:54get any better? But, let's say uh one of
  224. 8:56your co-workers comes in here and
  225. 8:58removes the year founded field from the
  226. 9:01form, which is a problem. They did it on
  227. 9:03accident and now it doesn't appear here.
  228. 9:06And if I type in run the tests again,
  229. 9:10it's going to go through and then once
  230. 9:12it gets to the form, it should see it's
  231. 9:15not there and it should crash because
  232. 9:17look, where is it? I already see it's
  233. 9:19crashing just like I expected. Amazing.
  234. 9:22Here are my results and this is awesome
  235. 9:24because as we build new things, we can
  236. 9:26run these old tests and make sure our
  237. 9:28new code didn't break other stuff. Now,
  238. 9:31you should be thinking, "Okay, I don't
  239. 9:33want to keep running this from my
  240. 9:35computer every time." Like, can I use
  241. 9:37the test plans inside of Azure DevOps?
  242. 9:42How about every time I deploy to UAT in
  243. 9:44production, can I auto run some of this?
  244. 9:46Absolutely. Take our ALM and AI course
  245. 9:49that's below. We got the free one, then
  246. 9:51we got the full-length one. It shows how
  247. 9:53to do all of this and most importantly,
  248. 9:55how to do it safely, reusably. Cuz you
  249. 9:58don't want to be spending a bunch of
  250. 10:00late hours trying to get AI to do what
  251. 10:02you want when there's a specific way you
  252. 10:04should be working with AI. See you soon.

About this transcript

This page contains the full transcript of Claude end-to-end for Power Apps & Azure DevOps MCP, & Playwright by Sean Astrakhan, generated from the public captions YouTube serves with the video. The transcript has 1,849 words across 252 segments, with the original timestamps preserved so you can click any line to jump to that moment in the embedded player.

What you can do with it

Use the transcript to take notes, quote the speaker, build a study guide, generate a summary with ChatGPT or Claude via the YouTube Summary tool, or export it as a timed subtitle file with YouTube to SRT. You can also re-open it in the transcriber to choose a caption track available on the video.

Free YouTube transcript tool

YouTube2Text is a free YouTube transcript generator — no signup, no daily limit. Paste any YouTube link and get the full transcript instantly, with timestamps, click-to-jump, caption language selection, AI prompts for ChatGPT, Claude, and Gemini, and exports to TXT, SRT, VTT, or Markdown.