Microsoft 365 Community Power Platform Connectors, 9 Nov 2022

Previous Meeting Next Meeting

⏯

youtube image

►

From YouTube: SHRTCODE Independent Publisher Power Platform Connector

Description

In this developer-focused demo, Chandra Sekhar will guide you through the process of using the Power Platform Independent Publisher Connector with Power Automate. The connector requests information, such as the URL to be shortened, from the SHRTCODE API, which responds by passing back a JSON containing the shortened URL, original URL, and domain name. This data is then sent to SharePoint List and will be consolidated all the shortened URLs along with the original version. Chandra will also show you how to organize and manipulate the returned data. The connector currently has 2 actions available. This video was taken from the November 9, 2022 Power Platform Integrations / Connectors LABs Call.

Demo Presenter: Chandra Sekhar Malla | @ChandraSMalla, linkedin.com/in/chandramalla/

Supporting materials
https://learn.microsoft.com/en-us/connectors/shrtcodeip/
https://shrtco.de/
https://github.com/microsoft/PowerPlatformConnectors/tree/cf3d8f56718602fd7b3f4e9ce719001145f4900f/independent-publisher-connectors/SHRTCODE

Learn more about Power Platform Connectors
https://github.com/microsoft/PowerPlatformConnectors
https://learn.microsoft.com/en-us/connectors/

A

uh Hello: everyone, my name is Chandra so nice to meet you all. Let me share my screen. I have a couple of slides that I want to share yeah. So today the demo would be shortcode uh demo where uh build a collector connector during uh while I was waiting. For my you know a new office to join so that was like couple of days. I had and then I was like. Okay, why? To you know stay free I can build a connector, so I thought of building it. So this is my little introduction.

A

I'm from India uh I'm working at a damco Solutions company in the Dubai as a Power, Platform Tech specialist, recently have been promoted. ah I am also a independent, uh a Sim in a community user group leader I've been you know, maintaining monthly calls connecting with people and helping them with their problems in Power Platform. It can be power automate or it can be power apps and then making some demos and explaining new features in Power Platform. All sorts of things I've been doing, and also from past year, I've been working as, like.

A

You know contributing to Microsoft in in the way of independent publisher in in most of the time, I like to know, know about Technologies and I like to play with the data and like building visualizations and making data analysis and also I, like programming. I, always try to keep things and like and what is coming in the technology and what is the programming and all? So that's all about me and if we go next slide, this is where we have the short code connector that I built.

A

So it's simply like the title says: the Privacy friendly URL shorter many of uh people in the world like using websites and all they might know about a tiny URL, so which is a famous one, but this is has like specific uh features that he a shortcode has so today, I'd like to show them. So let's go to the demo.

A

So right now uh you can just go on to uh Power automatic.com like my make.power.com website and then go to connector section, and then you will be able to find a short code in independent web publisher section. So here we have currently only two. uh You know actions are available, which is even from the uh original API one is to create a shorter link and one is to get information about a short link, uh the link that you have created so today we are going to create a short links for URL.

A

So so, basically, what this requirement would come is where example, let's say in the organization you have: maybe a local on-premise applications with longer URLs or client applications are there that needs to access through web, and you need to always worry about URLs with longer URL, so I think either I just thought of okay. If this connector is there, everything can be stored, you know securely and then using a code only you will be able to get it uh that whatever the URL that you have provider.

A

So let's I'll show you right now here, I have list a SharePoint list with a few columns like website name, the code short link and everything. So we are going to use power automatic flow to create a new item there for a website. Right now, I have two websites for I want to build. uh You know uh short URL, for so let's just go there and create instant flow, let's name it.

A

Let's create that and let's go ahead and create manually.

A

So now we have one character so because it is manual flow. We need to give the URL, we need to pass the URL, so let's say URL, and then we can go to Next Step. This is where we will take the uh independent publisher connector, which is shortcode.

A

Let's give it a minute.

A

There it is so here we have like two actions that we explained a seen earlier, so we'll click on the shorter link and then it should pop up the URL. Basically you it will ask you for all the terms and conditions about the connector, because it is an independent publisher, connector, so uh I've been already tried. So that is why it's directly asking me to show the URL so now I'll be inputting the URL from the manual flow, so there it is so right now we have the URL now.

A

Our next step is to add that uh whatever the code and the website name and everything into the SharePoint list is our goal. So let's go and search for SharePoint.

A

So here we can go to SharePoint connector and look for create item that it is here because it's I created in my personal, my list instead of SharePoint list, so I I just need to copy the URL paste it and then I'll be able to see the lists are available in my list just give a minute there. It is a shortcode list which we have there so here right now, title is there, which is nothing but the website name at the back end. It's always stays as primary.

A

So right now, what we need to do is we need to use a formula to extract the domain name from The Domain, so that we can use that as a title, a little smart way. So ah recently format. Data by example, has been in on the preview. So, let's give it a try here we want to extract the main URL from the original URL uh domain name from the original URL, and we can give the example okay this. uh This is what we will be giving to you and we will be expecting Dot.

A

Right and we can have another example for power automatic Maybe, so that it will be concrete- and you know, works perfectly.

A

So we can that expression and there it is, we can give it a try so that it will know exactly what the expression is doing. Then it's working fine. Now, let's click on apply and it it is there.

A

So we'll just go ahead, and so uh another thing here this is where we need to give shortened link I just want to say that here uh the column that I created uh as a hyperlink, because we'll be directly coming here and accessing the link instead of copying it again, then opening the item and all so that is the reason we just need to add HTTP here, so that we can directly add the shortened code here and the code here, so that everything will be there.

A

Now, let's just verify that everything is in place and then you can save.

A

Once it is saved, we can go ahead and test it. A little heads up here there might be a bug about a manual. uh You know manual trigger right now, but no issue. If bug is there, there is a workaround for that.

A

Okay, everything looks cool for as of now, let's paste the Link Storage. So let's get the link from here and paste it and run.

A

Oh there it is, uh that is a bug, so no worries, let's just those simple workout is just add that delete the record manually and I. Add it again, so just I've already submitted about it. Let's see anything is missing from here. The URL is missing.

A

Put it here and everything looks, should look fine, okay, perfect now, let's go ahead and try it again and probably should work.

A

There it is so now. If we go here, you can see so the website name was extracted. The code is there, and here we have that little uh shortcode we can directly click it and then we can access it. So if right now we have only one so later on. If we might have a number of our list items, you can quickly see the name which one you want to access. I I know Microsoft in Azure people working on Azure developing they have like number of blades they have so they need to always remember so.

A

I think this will be a best solution for them to keep things everything interact. So that's the connector demo and here like little feedback. uh If anybody wants to join the community to you know, have conversations to share their experiences. We are all open to uh give you. You know, give you a platform for that and if you're having problems you can feel free to join and then you know we are. We are here to help each other and share share his uh caring sharing is caring, so yeah. That's all. Thank you.

A

Thank you, Jocelyn. Thank you. Everyone.

B

Thank you so much Chandra for sharing I also dropped the link to the documentation for your connector, as well as where um users can go, find it on power automates website to try to leverage it themselves, really appreciate you taking the time to demo for us today.

A