Latest / Microsoft Cloud IT Pro Podcast / Episode 301 – Git comes to Power Apps
Transcript
- 0:03Welcome to episode 301 of the Microsoft Cloud IT Pro
- 0:08podcast. Recorded live on September 26th, 2022.
- 0:12This is a show about Microsoft 365 and Azure from the perspective of it pros and
- 0:17end users where we discuss the topic or recent news and how it relates to you.
- 0:21The power platform conference in Orlando has concluded and there were some
- 0:25announcements that came out of it today.
- 0:28Ben and Scott go over a couple of those as they discuss the new experimental
- 0:32feature of coauthoring power apps,
- 0:34as well as named functions coming to Power fx.
- 0:40Scott, I have a question for you in light of this week,
- 0:44and this comes via one of my kids,
- 0:48if an old man uses,
- 0:51a slow old man uses a walking
- 0:55stick or a walking cane, what does a fast old man use?
- 0:59A bigger walking stick. Oh,
- 1:03oh yeah. That's a good one. That's coming from the wee ones for sure.
- 1:07Yes. So that is how I'm.
- 1:11Florida's got a hurricane coming. I think we'll be just fine. I do.
- 1:14We're gonna have,
- 1:15we're we're gonna have just some strong winds and and rain and things at this
- 1:20point.
- 1:20That's what it looks like.
- 1:21Is the general consensus. But the, the west coast could get it a little bit.
- 1:25So if you're on the Gulf, hunker down and be.
- 1:29Safe. We're on the wrong side of it though. We're on the tornado side of it too.
- 1:32We could actually have a few tornadoes.
- 1:33We get tornadoes all the time.
- 1:35That's true. I did not learn this. So I moved down here though,
- 1:37like growing up up north, like tornadoes,
- 1:40you just get like random tornado warnings and it's just like a tornado.
- 1:45And then I moved down here and I'm like, wait a minute.
- 1:47We get hurricanes and then we get tornadoes with the hurricanes. Mm-hmm.
- 1:51. This is just not, I, I don't know that I'm okay with this.
- 1:54I've been down here 13 years I think,
- 1:57and I'm still not okay with tornadoes in the middle of hurricanes.
- 2:00Cause you don't get much morning either cuz you can't even see him coming cuz
- 2:04the hurricane radar is messing with all.
- 2:06Of 'em. Well, you should come out to the beach.
- 2:07There's water spouts and stuff all the time.
- 2:09You want a little mini tornado on the water. They're out there constantly.
- 2:13I can come watch 'em. I have never actually seen a water spout.
- 2:15I've never been out there when there's been one.
- 2:17It'd be kind of fun to come watch a water spout sometime. Yeah.
- 2:20They're down here. Or I mean you grew up in, you know, in the north. I,
- 2:24I grew up in the northeast of the United States,
- 2:26but we lived in Cleveland for a while. So on Lake Erie,
- 2:29same thing you would see,
- 2:30you would always get storms that would roll through and Yep. You,
- 2:33you would absolutely get water spouts all the time on the lake. See.
- 2:36We never got 'em. I don't know if it was where we were.
- 2:39So I was on the east side of Lake Michigan, I was in Michigan,
- 2:43so on the east side there,
- 2:45a lot of the storms broke up as they went across Lake Michigan.
- 2:50So we didn't get a lot of tornadoes like coming off of the Lake,
- 2:54Lake Michigan or water spouts there.
- 2:55I don't know if you tended to see more on the other side,
- 2:58like over in Wisconsin where like Wisconsin gets tornadoes all the time.
- 3:02Wisconsin gets way more tornadoes than Michigan does because like Michigan
- 3:07breaks up so much of those storms.
- 3:08Gotcha. Hi.
- 3:10I don't know. Yeah, I don't.
- 3:11Know. What are you gonna do? Uh, I.
- 3:13Mean am going to talk about Viva or don't we talk about Viva or the power
- 3:18platform conference? We have two topics we could talk about Scott.
- 3:21Well let's start with the power platform conference since that's new
- 3:26and kind of top of mind. Do.
- 3:28You mean the power platform conference at all?
- 3:30The Viva Announcements came out at.
- 3:31That's the.
- 3:32One that's still confused to me, but yeah,
- 3:34Power platform conference was last week down in Orlando.
- 3:38I tried to go to this Scott, I actually, I submitted a couple sessions,
- 3:42got rejected and then I did find out like a week before that
- 3:47there was a way I could have gotten down there for a reasonable
- 3:52cost cheap enough that I would've gone for it.
- 3:54But by that point in time it was too late to reschedule meetings and projects
- 3:59and all of that. So I was not able to go.
- 4:01But I watched vicariously through people on Twitter and
- 4:06followed blog posts and there were actually a couple
- 4:11interesting things that came out of the power platform conference that were not
- 4:16viva. There were some actual power platforming things. So one.
- 4:20Of them Imagine that. Yeah. What ,
- 4:22imagine that power platform things at the power.
- 4:26Platform. Power platform conference. I know, right?
- 4:28So this was an interesting blog post.
- 4:29There was a blog post that came out on the power apps blog.
- 4:32Power apps brings collaboration to center stage with three big announcements.
- 4:37I don't know that I would call this three big announcements.
- 4:39I would call those two big announcements and one announcement that I'm still not
- 4:43sure I I don't know that I would call the third one a big announcement.
- 4:48So the one big announcement,
- 4:51one of the big announcements that I'm interested to try and I'm curious to see
- 4:56how this all works,
- 4:58is co-authoring in power apps and they started off
- 5:03developing software, traditional single player experience,
- 5:06check out code to a local branch, blah, blah blah.
- 5:10Power apps has always been one of those single author
- 5:14experiences and even as a single author,
- 5:18the way power apps has worked at times I've ended up with a multiple tabs.
- 5:22I don't know if you've ever noticed Office 365 in general likes to open lots and
- 5:26lots and lots of tabs.
- 5:27So so many tabs, so many tabs. . So quick aside,
- 5:31I don't know if you've seen the new office bar that pops up if you use Microsoft
- 5:35Edge. So you know I'm, I'm a bit, Does.
- 5:38It pop up on a Mac? I do not have it on my Mac.
- 5:40Yes it does pop up on a Mac. My Mac is broken.
- 5:43It is it it is up in my browser right now just because I'm on a
- 5:48Microsoft site. I'm not even on office.com. Right. If I just browse.
- 5:52To not.
- 5:53On the site, you know like power users.microsoft.com. Yeah. Uh,
- 5:56any Microsoft site this bar pops up with like an office button.
- 6:01Let's see, what's it, It's got all sorts of just stuff in.
- 6:04It. Is this the one down the right side of the browser?
- 6:06It is. So you end up, if you do vertical tabs like I do Yep.
- 6:11I think you do vertical tabs as well and you leave them collapsed,
- 6:14you end up with just a bunch of icons on the left and now all of a sudden
- 6:18there's a bunch of icons on the right that I'm constantly clicking the little
- 6:21button and trying to just zoom, you know,
- 6:25zip that in and, and get it away as as I can. Do.
- 6:29You have to be on a Microsoft site for that to pop up.
- 6:31I thought that was at any website.
- 6:33I, I don't know. I must be like,
- 6:35I must be so vehemently closing it that it just goes away and then I only notice
- 6:38it when I open like a new browser window and go back to a Microsoft site.
- 6:42But it it is, it is there all the time and it is very annoying.
- 6:45Yeah, I had it there somewhere.
- 6:47I've seen it before and then it went away and then I saw the announcement that
- 6:51they added Outlook to it but I think it was only personal Outlook,
- 6:54network outlook.
- 6:55So I wanted to get it back to just play with it again but I can't get it back.
- 7:00Apparently I so ly closed it.
- 7:04That Edge has said you don't get this ever again.
- 7:09. That's great. It.
- 7:11Is. It's, I'm with you. I uh, so are we switching to this a minute?
- 7:15We can talk about this for a few minutes.
- 7:17I sort of get it in a way that I have very much had
- 7:22one of the scenarios where they talk about where I wanna just quickly pull up my
- 7:26email and having it on the right edge.
- 7:31Yeah maybe like I get the code, I wanna just pop up in an email.
- 7:35I have it right there. Maybe if I was only in the browser personally,
- 7:39I always have Outlook open on my desktop.
- 7:41I'm not just browser based and even if I was,
- 7:43I think I would have Outlook as a web app.
- 7:47I don't know that I necessarily see the need for this into your point.
- 7:51I feel like I start getting surrounded by toolbar.
- 7:54I have my browser tabs going down the left.
- 7:56I have my address bar and my extensions across the top.
- 7:59Now I have another bar down the right side and my browser window just keeps
- 8:03shrinking.
- 8:04Next thing you know I'm gonna have some type of toolbar popping up on the bottom
- 8:07and I'm gonna be like framed in my browser experience by toolbar.
- 8:11Yeah, I'll put link the show notes.
- 8:12But what we're talking about is the new sidebar in
- 8:17Microsoft Edge,
- 8:17which is supposedly supposed to help you multitask
- 8:22in a smarter way. So it's this bar that pops up,
- 8:26it's got a bunch of icons on it that kind of sort of makes sense.
- 8:29Like you mentioned Outlooks there, there's an office icon.
- 8:32It's for search discovery tools,
- 8:35game office and Outlooks. So Gabe is supposed still very.
- 8:39Help me multitask more.
- 8:41Yeah, Smarter multitask. Smarter. Smarter. Yes.
- 8:45So those are all things that kind come to get there.
- 8:50I, I don't know. So yeah,
- 8:52so now you can access office or the games menu right from your sidebar,
- 8:57you know, because that's what you wanna do without navigating away.
- 9:01If you're somebody who hasn't seen this before and you do want to go see it, uh,
- 9:06a couple of things.
- 9:06You have to make sure that your browser language is set to English or
- 9:11some variant of English. Either British English or US English.
- 9:16Like it's only available to English markets right now.
- 9:18Gotta be on the latest version of Edge.
- 9:21Interestingly the sidebar will show up automatically or some users,
- 9:26but not for all. I don't know what the logic is there behind it,
- 9:28but if for some reason you don't see it and you go like what are these,
- 9:31what are these people talking about? Like I'd,
- 9:34I'd really like to see how annoying this is myself.
- 9:37You can actually enable it like go into settings,
- 9:39go into more and then there's a show sidebar toggle and you click show
- 9:44sidebar on and it will pop up.
- 9:48Or in my case like on the latest version of Edge,
- 9:50it's actually just there like once it's turned on, uh,
- 9:54if you go to the little sis right below settings there's a show and hide
- 9:59sidebar that pops up right from there.
- 10:01Got it. Yeah. We'll have to see. I don't know,
- 10:05I'm not sure I'm a big fan of it,
- 10:07which is probably why I figured out a way to hide it a while ago and I don't see
- 10:10it anymore. I don't know what happened to mine cuz I'm definitely,
- 10:15it doesn't even show up in my Canary build.
- 10:17I have both the Canary Build and the normal production build of Edge and
- 10:22neither one of 'em have it for me anymore. So I don't know what I did. Well.
- 10:26You you're living your best life then.
- 10:27Yeah. I'm curious to see.
- 10:28Like, like I said, I'm, I'm always turning it off.
- 10:31Yeah what other people think. If anybody has an opinion on this,
- 10:35let us know. So now I've all back to power apps,
- 10:39Power apps back, back.
- 10:42To power apps from the side like yeah let's,
- 10:44let's get back to power apps collaboration. So just to reset,
- 10:48there was this conference,
- 10:49it was the power Apps Power platform conference down in Orlando, blah blah blah.
- 10:53Lots of new things announced there related to the
- 10:58power platform and I think in many cases not related to Power platform but hey
- 11:03it was Microsoft Conference so why not get those announcements out the door.
- 11:07So where do you wanna start?
- 11:09You wanna start with some of these new features like cards or Coauthoring?
- 11:12Coauthoring is interesting.
- 11:13Let's keep going cuz we've kind of started down coauthoring and then we got
- 11:17sidetracked by the sidebar that's supposed to help you multi-task,
- 11:21which I guess it just did.
- 11:22It helped us multi-task in our podcast and rapidly switch tasks between talking
- 11:27about power apps and sidebar but coauthoring. Yes.
- 11:34Do you feel overwhelmed by trying to manage your Office 365 environment?
- 11:39Are you facing unexpected issues that disrupt your company's productivity?
- 11:42Intelligent is here to help much like you take your car to the mechanic that has
- 11:46specialized knowledge on how to best keep your car running Intelligent helps you
- 11:51with your Microsoft Cloud environment because that's their expertise.
- 11:54Intelligent keeps up with the latest updates on the Microsoft Cloud to help keep
- 11:58your business running smoothly and ahead of the curve.
- 12:00Whether you are a small organization with just a few users up to an organization
- 12:05of several thousand employees they want to partner with you to implement and
- 12:09administer your Microsoft Cloud technology,
- 12:12visit them at intelligent.com/podcast.
- 12:16That's I N T E L L I G I N
- 12:21k.com/podcast for more information or to schedule a 30 minute
- 12:25call to get started with them today.
- 12:28Remember Intelligent focuses on the Microsoft cloud so you can focus on your
- 12:33business back to that.
- 12:36Oh cuz I started talking about tabs because I have locked myself out of
- 12:40authoring before.
- 12:41That's how I got on that topic because Office 365 opens lots of
- 12:46tabs and I've even run into it before with power apps where I haven't opened in
- 12:49one tab and somehow end up trying to open it in another tab and it says it's
- 12:54locked for editing by myself in another session. All of that.
- 12:58, I love when Excel does that.
- 13:00It's great that Power Apps is getting in on the same game. Oh.
- 13:02Yeah.
- 13:03So apparently now Power Apps is getting out of that game and if you go
- 13:08turn on, this is an experimental feature.
- 13:10So all of our typical do not do this in production
- 13:15stand up a dev environment of power apps cuz you do have environments in power
- 13:19apps. Go try turning this on.
- 13:23Maybe not on a production app that you use all the time,
- 13:26but when you want to test out all that stuff,
- 13:29you can now turn on this experimental
- 13:33co-authoring feature and as you are building the app and
- 13:38somebody else is building the app, you can chat with each other.
- 13:41Now you can tag people in comments.
- 13:44So just like if you're co-authoring an office document and you
- 13:49were tagging people there or commenting on an office
- 13:54document, you can do the same thing in power apps.
- 13:57You can see changes that others are making in real time.
- 14:02So now instead of sharing the screen and jumping at a meeting and one person
- 14:06driving and everybody watching it, everybody can add edit,
- 14:10remove various components and everybody sees the same thing.
- 14:14I kinda wanna get in here now and just mess with somebody making a power app and
- 14:18just randomly start moving stuff and deleting stuff. I don't know,
- 14:22I haven't had a chance to go try this yet.
- 14:25I think this one's a little weird. Yeah. Um,
- 14:27and mostly just because the way it's kind of, I, I think strapped in,
- 14:32so you mentioned get,
- 14:34and I I think it's important to call out that this works with
- 14:39any compatible source code repositories.
- 14:43So whether that's actually like gethub.com,
- 14:46it could be something like Azure DevOps,
- 14:48it could also be another kind of third party get thing that
- 14:53just implements, you know, get in a, in a, in a logical way. Like you're,
- 14:58you're all good there, you can turn this on for a,
- 15:02any new apps or any existing apps.
- 15:05So I think that's kind of cool like you mentioned,
- 15:07hey let's go maybe try it on something we've already done and see if it makes
- 15:11the workflow a little bit better.
- 15:12You can absolutely do that but I thought it was interesting that like the
- 15:17initial implementation of it doesn't support,
- 15:19it doesn't look like it supports OAuth for connectivity.
- 15:22So if you're doing maybe like federated identity to your GET provider,
- 15:26say you're doing like Azure DevOps and that's federated to Azure ad
- 15:31or you're doing get like GitHub and that's federated out to Okta or
- 15:35Azure AD or something else like that, it doesn't actually support OAuth.
- 15:39So you have to use personal access tokens, , you know,
- 15:44hopefully those are on within your organization.
- 15:46Like sometimes you know those are disabled, they're turned off.
- 15:50So that in mind like when you're signing into the repo you're like if you and I
- 15:54were going to collaborate on the same one, we'd both have to create uh,
- 15:59Pats personal access tokens and then be able to spin that all up too.
- 16:03So there's potentially a little bit of friction there just to kind of get it
- 16:07boots strapped and get it turned on like hey go turn on this experimental
- 16:10feature, make sure it's enabled for this app.
- 16:12It's not very clear what happens if I turn it on for an app and then all of a
- 16:16sudden we start sharing it.
- 16:17Like you have to go make a bunch of changes in power apps on your side.
- 16:21Does it just automatically show up? I think that part, you know,
- 16:25probably has some rough edges and it and it probably gets better over time.
- 16:29Right. I would think they would both show up. But yeah,
- 16:32your point because it requires the personal access token and it is coming from
- 16:35power apps too that Get repository does have to be an online version. It uh,
- 16:40web accessible with username and Pat,
- 16:42like you said on-Premises Get repository aren't gonna work for it.
- 16:46So the other thing that wasn't clear,
- 16:47I don't know if you if you like seen this is you from everything I saw in the
- 16:52announcements,
- 16:52it's a just like a single synchronization button that shows up
- 16:57in the power app like, like in the, in the studio itself.
- 17:02So in GI quite often you have these,
- 17:04like you just have these concepts that you're pretty used to like I might make a
- 17:08bunch of changes and wanna stage them,
- 17:10maybe I wanna push them to this branch or this branch.
- 17:13I wanna do things like I want to go and cherry pick changes at another branch
- 17:17that it didn't look like any of that was possible here either.
- 17:19It's almost like the get provider is just a remote storage
- 17:24instance which is just like one big sink, like a push and then one big pole.
- 17:29But you almost have to know on the other side like when to do the push and
- 17:34pull. Like if you and I are working on it together at the same time,
- 17:37then if there is a big merge the entire app needs to reload.
- 17:40Like that could take some time depending on how big it is and and what it takes
- 17:44for your studio to render it out and all that. I'm.
- 17:47A little confused about this as like you said it has the sync button and the
- 17:51sync button says I just had it there.
- 17:54It merges any current changes with what's in GI to bring the result into studio
- 17:59for further editing.
- 18:01But in the announcement they say it's real time synchronization so is there
- 18:05a little bit of real time sync going on but then if it gets out of sync you
- 18:10need to use this sync button.
- 18:13Like or is that synchronized button the very initial
- 18:17sync but then that wouldn't make sense with merging content change.
- 18:21It's like what's the difference between the sync button?
- 18:24No idea we, we'd have to play with that and I think it's weird.
- 18:27It seems like it's meant to be one of those auto magical features.
- 18:31So like when it comes to synchronization merging,
- 18:34there's actually no way to resolve merge conflicts right now.
- 18:39So everything is manual. Yep. And that can be a little bit weird.
- 18:44So like Power Apps studio is basically just,
- 18:47it's making an attempt to do this merge and fix any conflicts based
- 18:52on what it knows about how apps are authored and how you've structured your app.
- 18:57If you get a merge conflict you're actually gonna have to go back and
- 19:02try and sync to I guess an earlier branch or an earlier
- 19:06commit. I don't know,
- 19:08it's not very clear and and it starts to get strange because
- 19:13a lot of the power of get comes from having potentially that functionality
- 19:17surface directly up to you in the tool you're working.
- 19:19Like if I'm in VS code working on something,
- 19:21I just wanna be able to do like the maybe the get CLI or use an extension
- 19:25directly from VS code. Like I want it all there.
- 19:28And in power apps you're not getting that,
- 19:30you're kind of getting this connection plus a button.
- 19:33But if you want to do anything else,
- 19:36like say I wanna go work with another PR from somebody else,
- 19:40like I'm working with you on an app and you say hey I've got the PR in here,
- 19:43it is,
- 19:44it's over here if I wanna check that I need to hop out to the command line or
- 19:48some other type of, you know, tool. Like if you're,
- 19:52if you're not a command line person and you're only a gooey person,
- 19:55like well you gotta go find a goey for get,
- 19:58that's gonna get you to where you need to
- 20:03be.
- 20:04I think like yeah a little little bit of friction there we we'll see like
- 20:08what manifests in I guess maybe Power App studio to make that
- 20:13experience a little bit better.
- 20:14Yeah, we might have to go turn this on and play with it a little bit.
- 20:17Cause then the other thing people are also gonna have to be aware of is they do
- 20:22have this list of known limitations and one of these.
- 20:25The last edit made will win. Yeah.
- 20:27The whole last edit made.
- 20:28But it's to the same property on the same control that's not merged that one the
- 20:33last edit wins but other changes may merge.
- 20:36So depending on what you changed where and who else changed it,
- 20:40it may merge or it may be a last edit wins.
- 20:44This one in here sounds like it's only if you're gonna go change a property on a
- 20:49control.
- 20:49So if you have a text box and you're going and changing the hint text or the
- 20:54color of the text or the size, the position,
- 20:59any of those properties on a control and then somebody else does
- 21:04it years just could get wiped out. It's not gonna go try to resolve 'em.
- 21:08Which I guess it kinda makes sense because it's,
- 21:11that would be similar to both of you editing the same line
- 21:16of code or the same text in a traditional development experience if you're
- 21:21modifying the same property on the same control at the same time where you're
- 21:25going to essentially end up with a merge conflict in that type of scenario.
- 21:29I feel like I would tend to use this if I had an app
- 21:34that had multiple screens and each person needs to go
- 21:40work on a one of those screens versus multiple people trying to edit the
- 21:45same screen or the same controls on the same screen.
- 21:47Feel like if you put some of those types of limitations and hey you go work on
- 21:50the new items screen, someone else goes and works on edit,
- 21:53someone else goes and works on the view,
- 21:55you're probably going to set yourself up to have a
- 22:00less likely chance of causing one of those
- 22:06conflicts where something else could overwrite.
- 22:08Because position is a property if you just drag a control a little bit when
- 22:13you're working on the same screen,
- 22:14you could potentially come up with one of these conflicts I feel
- 22:19like pretty easily if you're working on the same screen.
- 22:22Yeah. Pretty, pretty quickly Or even, you know,
- 22:27I'm just clicking into one of your screens and I accidentally move something
- 22:30around and then you know, I go back to my screen and I hit save and oops,
- 22:35you know we,
- 22:35we went down a path that maybe wasn't the manifest
- 22:41for us. Yeah. You know, so we'll see. I also wonder what it does, you know,
- 22:45I just wonder, you know, like I said, like a get workflow,
- 22:48typically I'm going to want to make a logical set of changes all at the same
- 22:52time and stage them and then commit that and push it and,
- 22:57and or I may even wanna like commit it locally and not push it up.
- 23:00It just seems like this is taking like a bunch of steps for me
- 23:05that maybe you don't want to take. Like you said you,
- 23:07you move something on the campus and that changes the property of it,
- 23:11you go change some of the,
- 23:13some of the kind of backend properties on the code side.
- 23:16You might want to stage all that and push it up. But in this case it's,
- 23:20it looks like it's just every little thing kind of going.
- 23:24So I wonder what happens to,
- 23:26like what do those commits look like and then what is reverting look like?
- 23:30Yeah and there's a,
- 23:32they have a paragraph in here about pull request viewing history blaming and
- 23:36other GI features.
- 23:38I was trying to decipher what this actually means.
- 23:43Cause it says working with pull requests or other GI operations have to be done
- 23:47through get tools like the GI provider's website. That makes sense.
- 23:51We know that based on this there's no option to do some of that in power apps
- 23:56itself.
- 23:56Each synchronization includes a synchronization with changes
- 24:01will result in the commit.
- 24:03If other changes occur and get by other makers there will be
- 24:08additional commits.
- 24:09So every single change is a commit to merge results of all the changes.
- 24:15No changes will be lost even if a merge would
- 24:20override in edit.
- 24:23So I think what that's saying is you end up with a whole bunch of commit.
- 24:26So if there's a conflict instead of a merge conflict,
- 24:29it's just gonna create a commit that overrides the last commit.
- 24:32Yeah.
- 24:33So how do I know which commit to go back to if things get into a weird state
- 24:38or you know, I I just think like power app, right?
- 24:42Like take power out of it. Just think app, right? You know,
- 24:44usually you want like a v1 really CV 1.1, a 1.1 0.1,
- 24:49blah blah blah. Like whatever your kind of, you know, major minor patch,
- 24:52you know versioning scheme is for things and this kind of blows that out of the
- 24:57water. Especially if you and I are co-authoring on an application.
- 25:00Like how do I step back to version 1.1 cuz I wanna go take a look the way
- 25:05we did something in the past. You know,
- 25:07like maybe that was the better way to do it. Or like I said,
- 25:10just like cherry picking things, being able to say like,
- 25:13okay in this commit over here there's this set of changes that I wanna bring in
- 25:18or there's this PR over here that I only wanna bring in this subset of changes.
- 25:21Like it, it's weird pretty quick. Yeah, I don't know.
- 25:25I think it'll be interesting to see how it goes and, and you know,
- 25:28you talk through it like I just feel like you need to,
- 25:31no matter how much you wanna hide it,
- 25:33you need to start surfacing some of that functionality up in Power App Studio
- 25:37just to make life a little bit easier.
- 25:39Right. Or even on that synchronization,
- 25:41I'm even thinking of basic stuff like let's add a comment so I
- 25:46actually know what I did in this synchronization or the save that shows up
- 25:51as a comment to my get repo. So to your point I can go back and see,
- 25:55oh this was Ben that added this control or Scott updated this
- 26:00screen.
- 26:01It doesn't look like there's any way to add any
- 26:06type of context to these commits.
- 26:10No. So Power App Studio is not a full featured get client. I,
- 26:14I guess that's the big takeaway, right? It's just a,
- 26:17a dumb sync and commit mechanism up to you a GI repo
- 26:23and a lot of the, you know,
- 26:25I I'd argue like basic functionality that you want as a consumer of
- 26:30something from a get repo just isn't there today. Yeah.
- 26:34Your mileage may vary depending on how sophisticated you are with get all this
- 26:38kind things. If you've never heard of this before and you go like, Oh cool,
- 26:40it's coauthoring and it sinks and we're just gonna go play with it,
- 26:44then absolutely do that. But if you're thinking about this as, oh my gosh,
- 26:49I'm gonna be able to bring my power app developers over to a similar state
- 26:54as my developer developers, then yeah probably not. They're.
- 26:58Using a developer tool and trying to obfuscate it in a way that it
- 27:03aligns with low code power user type development.
- 27:08And I think any developer developer is gonna struggle with that significantly to
- 27:13what you just said.
- 27:14There was something else I was gonna say along these lines to get command
- 27:18synchronizations power apps. I have no idea it's gone off into the wind .
- 27:23Well it, it was, it was kind of sort of almost maybe there.
- 27:27Good publishing. Yeah. I don't know what else I was gonna say. All.
- 27:31Right, so that one's there. You wanna talk since you mentioned, well you know,
- 27:35we're talking about developer things in a non-developer tool.
- 27:38You wanna run down named formulas real quick and then we can kind of close out
- 27:41on that.
- 27:42Sure. So named Formulas was another one, Power.
- 27:45Fx.
- 27:46So somebody asked me a few months ago, Power FX has been out for a while.
- 27:50Power FX in and of itself is not new Power FX
- 27:55in summary is essentially the power platform development
- 28:01language. It was weird like they came out, they're like power effects,
- 28:04power effects. And I looked at it and I'm like,
- 28:06it's just what we've always been doing in power apps.
- 28:08So that's what power effects is.
- 28:10But they introduced named formulas
- 28:15in power effects,
- 28:16which essentially means you can go use these in power apps.
- 28:22I think technically this rolls into Power BI and Power Automate too,
- 28:27but I don't know where you'd really use these named formulas because this is
- 28:31what you would do on something like one of your apps that you're writing.
- 28:35And what this allows you to do is when you open
- 28:40your app or when you do like the app on start,
- 28:44I think that's probably where you'd use this the most.
- 28:48You can do things like define a
- 28:53variable with a aimed formula where you could do something like user email
- 28:58equals user open, close parenthesis.email,
- 29:01it goes and grabs the email of the currently logged in user or you wanna come up
- 29:06with a list of phone numbers,
- 29:10you want to go assemble some string from various user properties.
- 29:15You can go in and define these named formulas when your
- 29:20app starts and then the value of that formula
- 29:25will always be available.
- 29:26So now anytime I want to use the user email instead of having to go
- 29:31do user per email and go look that up from the connection
- 29:36I can just use user email or user title, user phone,
- 29:42whatever that might be. So you're kind of declaring this,
- 29:45it's a named formula to me it seems more like you're just defining a variable
- 29:49and this is.
- 29:49It's a global variable.
- 29:50Yeah. What goes with this variable,
- 29:53I have done this before by just doing like you can do a set instead of variable
- 29:57on app start and go do something very similar. This is just,
- 30:01I would say this simplifies it in terms of being able to define these different
- 30:06variables,
- 30:07these different properties that you'd want to use throughout your app as
- 30:11you're writing the app.
- 30:12I think the example they gave when they kind of talked about this and
- 30:16particularly comparing it to set Yep.
- 30:17Makes a good case for just where it makes life easier.
- 30:21So for something like a set, which you could have done the same thing,
- 30:24you know I have, you know,
- 30:26variable A and I wanna set that to a value like 10.
- 30:29So you'd have to do set variable a 10 and then you know,
- 30:34close your peren and do your semicolon and you're,
- 30:37you're out onto the next one now it just becomes variable A equals 10.
- 30:41So you've automatically,
- 30:43like you've just taken away the set function and you don't even need to worry
- 30:46that set is a thing like from a pure readability and understandability
- 30:50perspective, like that's just way easier, right? It's less parentes,
- 30:54less things to get confused about should be far,
- 30:58far more straightforward on that side.
- 31:00Yeah, and there are some other advantages to it too. So typically a set,
- 31:05you'd set it and then if something changed, username would be a bad example.
- 31:09Whoever signed in's always gonna have the same username.
- 31:11But if you're doing this based on some other control or some other value,
- 31:16the formulas value does automatically update.
- 31:20So it can perform a calculation dependent on some other properties and
- 31:25as those properties that are in this formula change,
- 31:30the formula's value will also automatically update.
- 31:33So you don't need to go in and always do,
- 31:36set the variable to a new value or update the variable or not the variable,
- 31:40but technically the formula's value that will automatically change.
- 31:44You also know that the definition of it is immutable.
- 31:48So if you define it in apps dot or app formulas is where you would
- 31:53define these. That will be the only place that value can be changed.
- 31:58So I know I've lost track of this before too,
- 32:00where you end up maybe using the same variable aim
- 32:05inadvertently,
- 32:06or you have sets on a whole bunch of different screens and you start losing
- 32:10track of what's getting updated, where by what controls and what buttons.
- 32:15This is gonna help you avoid some of that confusion and that it's only
- 32:20ever going to be defined,
- 32:22updated from that single spot within your app.
- 32:26That's gonna be an an advantage I think to this.
- 32:29It's something that just makes it easier overall when you start defining these,
- 32:34making sure they stay up to date. So they have,
- 32:36there's a quite a good length article on
- 32:41the introduction of these, how to start using 'em, some different implications.
- 32:46So there's also some implications where this comes in.
- 32:48They're changing some of the on display, on start, start screen.
- 32:54Some of those properties when a power app launches, I think it was,
- 32:58I think I saw it was to help with some of the speed,
- 33:00some of the pre-loading of stuff where things get loaded in the order.
- 33:05So there are some different implications that come into here and how you set
- 33:09some of the stuff up,
- 33:10some of the other examples further down too of like
- 33:15you said Scout, where you would use that in.
- 33:17You can use this and it just makes it a little bit easier to read,
- 33:20easier to take a lot of those set calls and translate 'em to these named
- 33:25formulas. Uh, so yeah, this one was kind of cool for me.
- 33:28This is one I'd like to go in and I feel like I'd use this before I use
- 33:32co-authoring. Maybe it's my use case, but I like this one.
- 33:35The next thing I wanna see in power apps as functions,
- 33:37like I wanna be able to define a function and call it from different places.
- 33:42So we got named formulas, maybe we'll get some named functions next,
- 33:46but I don't know, maybe that's getting too developers. Scott,
- 33:49if we start putting functions in power apps, it.
- 33:51Gets weird.
- 33:52So these are kind of like if you've played around with Lamb does and Excel,
- 33:57you end up with this world where you have user defined functions that you know
- 34:01basically have no inputs and you're doing the same thing over
- 34:06here. So a named formula is really just, it is a function,
- 34:10it's a user defined function, but it doesn't have any parameters on it.
- 34:15So really what you want is a function or method that you can call with
- 34:20your own parameters on top of it.
- 34:22Something like that.
- 34:23Or I have a perfect example and I found a workaround for this.
- 34:27I have a power app,
- 34:28I've built a couple power apps to create new users and when you
- 34:32create a new user via Power Automate in Azure ad
- 34:37you have to send the password.
- 34:39So I wanna function to generate a random password and I've come up with a whole
- 34:44series of steps to generate a random password.
- 34:46The only way I can kinda like automatically generate it is I
- 34:51use a button and I actually use code to call a button click and then I just make
- 34:56the button visible on the page so that every time you go do something,
- 35:00you're just silently clicking this button in the background to go generate a new
- 35:05password.
- 35:05I don't see how a named formula would fit into that model because there
- 35:10wouldn't be anything changing that would cause that named
- 35:15formula to generate a new value.
- 35:18Because I would set it at the beginning,
- 35:21but none of the arrays or anything that I'm passing into it would ever change.
- 35:25It's just on this event,
- 35:28go run these 10 lines of power effects code to
- 35:32go randomly select new letters and characters and numbers and all of that from
- 35:37these arrays.
- 35:37I wonder how many hidden buttons are in all these different various power
- 35:41things. Like, like you're talking through that. I go, I, you know,
- 35:44I do have that all the time in Power bi ,
- 35:46like hide hidden controls just for like bookmarking or things like that to,
- 35:50or this button's gonna call,
- 35:52this hidden thing is gonna do this hidden thing and yeah.
- 35:55Yes. Hidden buttons and power apps are my friend. Go look at my power apps.
- 35:59You may never know how many buttons are actually in a power app that are all
- 36:03just hidden to call functions.
- 36:06This is my function hack and power apps. It's.
- 36:09Like the old, the visual basic designer.
- 36:11Like I remember doing Visual Basic in the early days and you would just have a
- 36:15button, a bunch of buttons that were off the form,
- 36:17but they would still technically be part of the application. Yes.
- 36:22That you were rendering.
- 36:23We just aged ourselves. Got visual basic.
- 36:26Yep. Yeah,
- 36:27you ended up with one One by one pixel just for a single button and then you
- 36:31made it the same color as the background of the form. And I.
- 36:34Had a professor in college that loved Visual Basic.
- 36:37So Visual Basic Six was on its way out when I was in college and it was
- 36:42switching to, what was it like visual,
- 36:43what came after visual Basic visual.net or something.
- 36:46You had vb.net, like the whole.net kind of thing.
- 36:50And then you had to choose if you were doing basically like the desktop,
- 36:54like console app, Desktop app track, yeah.
- 36:57Versus like asp.net and starting to go down and, and alright,
- 37:01so I'm gonna get away from like ASP and Visual Basic Classic over vb.net. Yes.
- 37:06Like that.
- 37:06So college was when that transition was occurring and I had a professor that
- 37:10loved VB six.
- 37:11So we did a whole bunch of homework assignments in VB six and we're like,
- 37:15but this is college. We're supposed to be learning real world.
- 37:17Why can't you transition all this to vb.net and get us ready for the workforce?
- 37:22And now neither one of 'em are used anymore.
- 37:24But that's an entirely different story. .
- 37:27Oh, I bet, I bet. Visual basics still use someplace. Oh, I, you know, you,
- 37:31you can if if COBAL is kicking around, VB is to.
- 37:34Fortran. I never had to write Fortran. I just missed,
- 37:39I don't know that I ever wrote um, Cobalt either.
- 37:41I think there was maybe a one class when I was in college where they still had
- 37:45some of those old languages kicking around. But nope, never wrote either of.
- 37:50Those. You lucked.
- 37:51Out. I did. So with that, Scott, we did not talk about Viva.
- 37:55. Next time, next time we'll talk about.
- 37:57Viva. Next time we'll talk about Viva. Oh, can I talk about Viva?
- 38:00We will talk about Viva or we will rant about Viva or we will lament about
- 38:05Viva. I don't know which,
- 38:07but we will have to come back to Viva at some point in time in the future. Now.
- 38:11We gotta do.
- 38:11It. So with that, go enjoy the rest of your day,
- 38:15the rest of your week.
- 38:17Hopefully the hurricane stays away enough that you don't need to go pick up your
- 38:20entire backyard and anything that may blow away in the hurricane.
- 38:24And we will talk to you towards the end of.
- 38:26The week. All right, thanks Ben. Thanks.
- 38:27Scott. If you enjoyed the podcast,
- 38:31go leave us a five star rating in iTunes.
- 38:33It helps to get the word out so more it pros can learn about Office 365 and
- 38:38Azure.
- 38:39If you have any questions you want us to address on the show or feedback about
- 38:43the show, feel free to reach out via our website, Twitter, or Facebook.
- 38:48Thanks again for listening and have a great day.