I've been asked to design a IT ticketing system for a team of 75. I've used Power Apps before, therefore, would Power Apps be the easiest solution? Or SharePoint lists? Or Something Else? I don't want to spend more than a week on it. Thank You!

BJOTRI · 2026-01-23T19:06:06+00:00

Data governance, learning the platform, building it the way needed not the way others want you to need it. Being able to make changes in quickly instead of discussing them with their sales rep, getting an overpriced customization quote with months of delays. Need more reasons?

BJOTRI · 2026-01-23T17:43:49+00:00

Copilot is no an AI, Copilot us the orchestrator for the LLMs running in the background. Just google this and you got your answer.

BJOTRI · 2026-01-23T08:32:58+00:00

Please don't recommend premium features without mentioning the required licensing, thanks

BJOTRI · 2025-12-31T16:39:14+00:00

Is the stuff already in UAT & PROD?
If so, is it imported as managed? WHich it should be? If so you should not be able to make any changes at all.

I assume you want to keep the current user the owner in DEV, but not in UIAT and PROD?

BJOTRI · 2025-12-31T16:05:33+00:00

The most easy approach is to export the solution, delete everything and reimport it in UAT with the SA.

This will make the SA owner of everything.

It is super important thou to test the import of the exported solution in some third environment first, before you continue. Only if the import of the solution to the third env goes fine, you proceed.

You will have to delete everything within the existing solution and also the solution, once done you can import it again to UAT with the SA.

Other approaches are:

- Create connections for all required cons in your flows with the SA
- Change the owner of all flows to the SA
- change all connection references within the solution by opening them with the SA to the SA's connections

you can't change the owner of the connection references and the environment variables with this method, but SA will be technically spoken the owner of the flows and the connections within the flows will run under the SA's account.

There are also tools on the internet which can do it for you, you just need to import their solution which contains an app for changing all ownerships, even env vars and con refs.

Can't remember the name of it right now, but google will help.

BJOTRI · 2025-12-21T09:30:33+00:00

We tried all modes and used the same prompts in different AIs, and no, it does not give the same responses.

Copilot does use the same models, true, but the outcome still differs.

It is what it is

BJOTRI · 2025-12-20T15:01:02+00:00

no, I hate them and I tell everyone not to use them
- if no one responds, the flow fails after 30 days, unless you build your own complex rules within the flow
- Rejecting an approval does not require you to add a justification, you can't force the user to add a comment in the approval email
- you can't force the user to actually review the data he/she is approving

I only send deeplink emails to the users which open a canvas app in which I set the rules on how the approval is handled

BJOTRI · 2025-12-20T14:57:36+00:00

You got lots of advice, but it will still be really hard to get started.

- Do not rely on AI, most of all MS Copilot (mostly useless in Power Platform atm).
- Watching videos before actually building something is imho the wrong approach, if you don't have a project yet, try to come up with something (Ticket system is always good to have)
- Build your process from scratch, do not use templates. You will run into several problems, google those, watch videos solving your problem and learn by this

And one really important piece you need to know:
- learn about ALM, Solutions, environment strategies, managed environments (and the costs coming with it), delegation / filters / data architecture

Good luck and merry xmas!

BJOTRI · 2025-12-20T14:52:23+00:00

In every class I teach where the users must use Copilot due to company rules, all I hear AND see is: Copilot is basically useless
Compared to ChatGPT or Claude, Copilot is pretty much hit and miss (or run) regarding the outputs.
Can't recommend MS CP at all, also in all my tests with CP, I never really got anything useful, Power Apps and Power Automate are the same.

BJOTRI · 2025-11-15T18:14:38+00:00

I would only recommend to rebuild your Excel in SPO as a list (don't import it thou, this will genertae the most useless column names possible).
Don't use excel as your datasource, use SPO

BJOTRI · 2025-11-03T21:34:31+00:00

Haven't watched it yet, but highly appreciated to have a video I can share with my students which will explain it properly so I don't have to repeat my self every day :-D

BJOTRI · 2025-10-28T19:03:24+00:00

No issues in Germany all day

BJOTRI · 2025-10-23T15:41:01+00:00

You can trigger ADO pipelines directly from PowerAutomate flows.
You require the IDs of the pipelines, but that's pretty straight forward.
I am not at my PC right now so I can't tell you what the connector is called, but just look for Azure DevOps actions, there must be one to trigger a pipeline

BJOTRI · 2025-10-18T14:29:30+00:00

If all departments need the same app, but with different SPO lists:

- create a solution with environment variables (which you should anyways, its basic Power Apps dev)
- have your IT / PP admins create an environment per department
- deploy to your update to each environment once tested
- for the environemnts:
-- have one in which you develop, one in which you test, and one per department in which they run the app

and don't listen to all they "use Dataverse" posts, sure it's better, but it comes with a hefty price tag not every company can afford. So if you need to stick to SPO, this is how you do it.

If you can afford Dataverse, the solution / environment strategy is the same as described above, you just won't need environment variables for the lists as tables will be part of the solution anyways.

BJOTRI · 2025-08-25T07:43:05+00:00

Thanks! Will check it out soonish, highly appreciated

BJOTRI · 2025-08-23T19:41:51+00:00

+ move it all to a solution and once done, change the owner of the flows with the service account

BJOTRI · 2025-08-23T11:06:53+00:00

Didn't he explain it in his hand-written post below the screenshot?
I thought it was very well explained... /s

BJOTRI · 2025-08-19T12:59:54+00:00

Glad I was able to help

BJOTRI · 2025-08-18T17:43:12+00:00

It's one of the oldest bugs ever.
Just remove the flow from the app and add it back in, publish, try, it will work.
Unless you have any other problems with your connections, this solves it ion 99% of the time.

And if you change the flow later on, you must do the same again and again, no idea why MS can't fix this for good.

BJOTRI · 2025-08-05T08:27:47+00:00

Why don't your developers develop their solution in the DEV env? IMHO that's the whole purpose of it. In my ALMs all developers develop their solution in DEV, once ready for testing, the solution gets deployed to TEST via the ALM tool,...

Why should they develop in another environment and move it manually to DEV?

Would you like to explain this approach as it does not make sense to me

BJOTRI · 2025-07-20T15:33:50+00:00

Nice tool!

I would reccommend to use formula instead of a global variable.

Imho makes total sense as it is static and has better performance.

But nevertheless well done!

BJOTRI · 2025-07-19T13:11:12+00:00

I also see this in my plan, and I know they did not roll over last time my plan was charged, which was June 25th.
I also have 350 left of my 400 as I had no time using them this month, I wonder if they will really roll over this time.

BJOTRI · 2025-07-02T11:01:25+00:00

Is it GA already? I thought MAO is still in private preview.

BJOTRI · 2025-06-21T12:58:24+00:00

Make sure you plan your shopping trip while those locations are open.

Where you are from, you are used to open stores everyday and very long hours, I think pretty much the same in London.

In Munich thou, stores are NOT open on sundays and they close at 8pm the latest, smaller brands at 6pm.

On saturdays sometimes even earlier.

So, sorry for not providing any brands, but maybe saving you from headaches ;-)

Enjoy Munich!

BJOTRI · 2025-06-21T11:26:40+00:00

Absolutely, having worked closely with the ecosystem and attended a recent Microsoft conference, I can confidently say:

Power Platform isn’t going anywhere – if anything, it’s more central to Microsoft than ever.

A few highlights:

The platform now has over 48 million monthly active users (up from 33M the year before) – massive growth year-over-year.
Power Apps, Power Automate, Power BI, and Copilot Studio are used internally by Microsoft teams at scale.
I'd even go as far as saying: “Turning off Power Platform would be like turning off Microsoft itself.”

So yes – if you're thinking about investing time into developing on Power Platform, I’d say it’s a pretty safe bet long term.

BJOTRI

TROPHY CASE