Agnius Bartninkas' Blend of Automation Insights and Mixology Magic

Today's guest is from Lithuania . He's the Chief Operating Officer at Definra . He was first awarded as MVP in 2024 . His main hobbies are traveling , reading books , playing board games and making cocktails A man after my own heart when it comes to making cocktails , we'll be able to talk about his bar and my bar .

He makes them for his family , friends and I bet she samples one or two himself . He is also a top-time solution author and top all-time most kudos to author in the Microsoftrosoft power platform community forum for pad um let's uh . If you .

If you want to check out his social media his content he's got everything from discord channels to to blogs , to um uh social media . You can check him out . He's on quora as well . Even so , there's plenty of content out there about what he does .

I've had the pleasure of seeing him speak live recently in London , at the Microsoft office in London , and I even stole some of his cartoons that he had representing databases and the relationship between Excel and SharePoint , as if they're a database or not . So with that , Agnius , welcome to the show .

Then I kind of switched to whiskey and then , you know , a couple of years ago I switched to gin tonic , which was a lighter drink , you know , especially in summers . And then I was in the European Power Platform Conference in Dublin last year and I was introduced to a shot called Baby Guinness . Not sure if you've heard of that .

It looks like a tiny pint of Guinness and it's basically a mix of coffee liquor and with a float of Bailey's Irish cream on top . So it's very sweet kind of a thing . It's kind of strong , but it goes very well when it's chilled and in a small batch .

I went back home and I introduced my wife to that because she likes these sweet liquors I don't really , but she does and that kind of got me into just experimenting with stuff , and initially with these sweet liquors for her , but then kind of switched to more stuff , these sweet liquors for her , but then kind of switched to more stuff that I actually my team

in the office actually gave me a gift of uh , you know the whole cocktail maker set thing and that got me hooked . Uh , and the . My favorite cocktail right now is a mai tai uh , but but the with a traditional might I would know pineapple juice , it's , it's very strong when you make it the right way .

So you can't really do a lot of those , you know , but maybe a couple of them a night is usually enough .

I went back and because I tasted a few mai tais that I made myself and I'm like man , none of these taste like that mai tai that I had at that bar , and so I went to their website and , lo and behold , they had the recipe for the way they make it on the website and it has about three different rums in it and it's just .

Every time I serve it up to folks they're just like this is amazing , this is incredible . So that's the Mai Tai version I've settled on .

I said , because always when someone comes to my place , I'm like there's the bar , let's create your signature drink . What is it ? And you know , especially if I've no people have been mixologists in their past . And he made this spiced rum cocktail so simple .

But boy , everybody that tastes it just cannot believe how smooth , how easy it is to drink and how tasty it is .

I learned I don't like it after working for a couple of years in finance and accounting couple of years in finance and accounting and I kind of just , you know , my main passion at that point was just trying to make my work as simple as possible by , you know , building simple tools that would at least make it you know , make me have to do manual work as

little as possible . And I usually started out with just building some fancy Excel files with macros and funky formulas and so on , or just maybe revisiting the processes themselves and trying to find some ways to make them simpler .

And my boss at that time kind of noticed that my bit of a knack for this improvement and I was actually starting to reskill myself on my own . I just had been taking online courses , trying to learn Python , programming and so on .

So I had a bit of a background in programming , but it was very minimal and I had started and then basically they noticed this and this was an international company with headquarters in Denmark actually , and we just had a service center in Lithuania and there was a decision made in the headquarters that we need to start using RPA to automate some of our processes ,

initially in the service center , then maybe globally as well . And I was just kind of selected to do this as a POC and he basically approached me and said , would you like to do robotics ? And I'm like no , I have no idea what that is .

My initial thought was that they are talking about actual industrial robots , the physical stuff , because that was a manufacturing company . We were actually assembling stuff , it was manufacturing beer dispensing equipment and I was like no , I have no idea what that is and I don't think that's my kind of thing . I don't think that's my kind of thing .

But then they kind of explained it to me what they meant with the word robotics , that it was actually robotic process automation and that it was actually software robots . And it got me interested . So I participated in a few demos in the vendor selection process of who to work with .

We then actually selected a company called Softomotive , which doesn't exist anymore because they were acquired by Microsoft in 2020 .

That was like a maybe two to three-hour session where I basically had selected a process I would like to automate . They showed me how to start working on it the next day . I continued working on it on my own and basically finished it off and just kind of was a one man show for for a few years in there .

Just , you know , basically discovering stuff to automate and then automating it , initially my former tasks that I had been working on and then , you know , tasks for my colleagues and people in the other branches of the organization , and that worked out quite OK , except for the fact that , you know , I was self-taught mostly .

There was no community , almost no community when it comes to soft emotive tools available . You know there were very few resources available and obviously I made lots of mistakes . I built stuff that were not best practice things because I did not have any peers to learn from . But it works , it was okay .

And then I started freelancing a bit on the side , because someone approached me and asked me if I could help them build up a few things and that kind of grew into my own company . Then I quit the former organization and opened up an agency where initially I was the only one doing it and then also hired a few more people .

We initially worked with partners that would help us make sales and also consult some clients , especially abroad , because they were physically closer to the clients , they could visit them and so on . I was traveling a lot to Denmark because that was where we have a lot of clients and our partners were there .

So before COVID hit , I was there on a monthly basis basically . But yeah , it's a bit different now . We switched to Microsoft in 2020 . In 2020 .

But I think that because of my background in software models , tools , and that you know how much I've worked with it one of the probably most experienced Power Automate desktop developers and because of how many projects I've built different types of projects for different organizations it's just you know lots and lots of things come naturally to me by now and I've

also had the pleasure of working with other developers that I've actually hired that would come from other organizations where RPA was more established and they brought best practices to me . I taught them how to use Power Automate Desktop because they were originally UiPath or Automation Anywhere developers or something like that , so I taught them how to use the tool .

They brought in some best practices , taught me how to do that and now that there's a huge community around Microsoft Power Automate a huge community around Microsoft Power Oats mate , I think we're you know , kind of setting the example of how to do it properly .

Now , even though I started as a one-man show doing lots of things wrong , so is it your company still . Yep , well , it's a family company actually , so I'm not the only owner . There's three of us owning it , but yeah's , it's a family company actually . So I'm not the only owner .

There's three , uh three of us owning it , but yeah , it's a family business nice , nice that , uh , and this is robo virgin .

There's another service that the other owners are responsible for , but one of the business services that we work with is specifically process improvement consultancy and then process automation solutions and also training and so on , and that's the business that I'm responsible for .

And I wonder at the moment , I think it sits there dormant on so many people's machines and they don't know what it's there or what it can do or what's enabled with it . Have you lit up for yourself personally , because of your passion in this area , any kind of personal automations around automating your life on the desktop ? Let's start with um , that um .

You've almost forgotten about them because they're just running all the time or doing what you want them to do .

So those are not things that you could actually automate easily , but I have a solution that can give me cocktail recommendations for what to make based on the ingredients that I've got .

But this whole interception of my email understanding everything about it's like this whole .

You know , you've I don't assume you've heard microsoft start to talk about this concept of agents becoming a more prevalent thing , and I think that this concept of a personal agent that really gets to know me it knows my schedule , um , it knows my my email , it know it could read my email , understand what I need to take like this is a critical email .

You need to do something about it . It's got a time limit on and not based on anybody putting that on it , but because it's read and interpreted and understood it and auto drafted a response and even categorization over time , rather than me creating my folders of categorization , it will understand and logically categorize things and train me on why it chose that .

Because it's full of wisdom , um , of knowing everything you know in the universe about best practice , productivity and things like that . Do we ? Do you see that being in the realms of reality with the next three years ?

Rpa is usually used for things that are where you either don't control the input system , where , know you need to interact with some third party things .

You know , have this agent actually build a desktop flow for you based on natural language , because you need something done automatically , like some data entry into some application or something like that that doesn't have an API and so on .

That would be awesome , but generally , you know , this sort of email handling agent could easily I think it could be a reality would probably not involve RPA , though .

Like I've demoed RPA from a web scraping perspective for a what was the use case that I showed a real estate agent that needed to get an environmental report on a property listing from a U S government agency and it would go out .

It would hand up the property address and do the query into the , the EPA tool I think it was on the on the U S gov website and then it would hand back if there was any filings or reference on it and allow that to be extracted back into the application that the real estate agent was using . And it's it's .

It works so effectively in that scraper type scenario . Have you done I know we're well over time already , but have you done anything in that scrape scenario where you've gone up and used it to enrich a data set with a data set that might be online ?

For example , we've got a client in Denmark that's not really a real estate agent , but like a company that provides services related to real estate like evaluations , damage reports , energy reports and all sorts of things and they usually provide these services to actual physical people not to business clients , but to actual people who want to maybe sell their property

or maybe have an insurance claim and so on , and when they have an order coming in for a certain service on a building , they create that in their CRM system and then we've built a solution that basically picks that up and then pulls all sorts of data and documents from these web resources local authorities , regional authorities within the country , or more like

actual national-level authorities . I think there's like 10 different web pages or something like that that we needed to scrape to build this . Some of them had APIs . That was cool and we built a direct integration , but some of them didn't because local authorities they don't usually build APIs . So they've got some very old legacy web pages and we got that .

You know , basically scraping that , downloading documents from there and , you know , saving all of that , you know basically kind of digesting it and pushing it back into this urm system awesome , obviously , like being that .

But apparently the stuff I did before that was already great enough , because I was doing lots of content on LinkedIn . I was doing all of the community stuff there is a Discord server where I'm the top user in there , specifically consulting people on Power Automate and so on and apparently that was enough . And I did not expect that .

I thought you have to do YouTube videos , blogs and lots of them on a weekly basis or something like that . But yeah , so apparently what I was doing was actually enough and it was exciting . And now I'm obviously being spammed a lot because there's plenty of information channels . Some of them are very useful . I had to filter out those that aren't .

But there is great content made available for me right now and I think it's also made me more attractive to event organizers to actually accept me to speak at their events . Now , because I'm an MVP , I've started getting accepted to lots and lots of events . I did not expect that to happen , so so that that was really because I love speaking .

I found a new you know love for , for speaking at these events you're good at it .