#powerautomate flow

[kailashr2k]

Power Automate useful Array and String Manipulations

🚀 New Blog Alert: "Power Automate Useful Array and String Manipulations" 🌟 Dive into essential tips for handling arrays and strings in Power Automate. Learn how to streamline your flows with practical examples and powerful expressions! #PowerAutomate

Power Automate is an incredibly powerful tool for automating workflows, but to truly harness its full potential, you need to be familiar with some key expressions and functionalities that can make your life as a developer easier. Below are some commonly useful Power Automate expressions and techniques that you can incorporate into your workflows. 1. Create a Unique Array When dealing with…

[jakubhomola]

Flow version history

Flow version history is a great feature that makes working with Cloud Flows easier. You don't necessarily have to restore your Flow, but with this feature, you can also just view previous versions that you've created. Remember, to use this feature, your Cloud Flow needs to be created within a solution.

Create cloud flow in a solution: https://www.linkedin.com/posts/jakubhomola_dataverse-powerplatform-powerautomate-activity-7179938628834316288-FCn8?utm_source=share&utm_medium=member_desktop

#dataverse #powerplatform #powerapps #powerautomate

[christianbtcinternship]

A month of entries 😅

May 13th + 21st: I was asked if I could figure out how to configure Sharepoint to act in specific ways based on the metadata of files placed in specific folders. I spent a lot of time researching if this was possible and ended up settling on creating logic-based flows through powerautomate. I spent these two days researching and testing through trial and error. May 23rd: I continued to work on the Sharepoint flows and I also helped some people with email/password issues as well as setting up MFA.

May 28th: I attended a meeting with a 3rd party firm, that's been hired to audit the security of our network. I helped log our network hardware between both sites. I then helped mount and wire a switch in the production area. May 29th: I continued my work on the Sharepoint flows and also started researching which password manager would be best for the company's needs.

June 3rd: I spent the day working on setting up security cameras and getting them to connect to the DVR that we're using.

[elbrunoc]

#PowerAutomate - Using OpenAI APIs, like ChatGPT, Dall-E and more. Also in Azure!

Hi! Back in March we hosted 3 sessions, and we showed how to use OpenAI models and features in Power Apps, Power Automate and Power Virtual Agents. You can check the recordings here: https://aka.ms/OpenAIPowerPlatformSeries These AI models are available in several places, like OpenAI APIs and Azure OpenAI Services. Scenario Let’s learn how to use one of these models in a Power Automate Flow…

[mtgomes]

Power Automate: SharePoint - When an item is deleted Trigger

How to use SharePoint’s “When an item is deleted“ trigger in #PowerAutomate? Check out how to use it efficiently, the basics and how it works, tips, and limitations. #Reference

SharePoint’s lists are excellent for keeping data, but one accidental delete could generate a lot of headaches, especially if you don’t notice it. That’s why Microsoft developed the “When an item is deleted” trigger, where you can define Flows that do actions when an item is deleted, like a notification to someone to check the “Recycle bin” and see if the item should have been deleted or…

[jford]

Leveraging Microsoft’s Graph API with Power Automate

Recently, Microsoft broke many of their customers’ production workflows they had built in Power Automate (formerly Flow) using mail arriving into Shared Mailboxes as the trigger. 

After mail had arrived, subsequent actions from a mail action would fail with the error of “Item Id doesn't belong to the current mailbox.” Microsoft’s official workaround was to use the Graph API but a savvy user on the Power Automate message board on Microsoft.com suggested to change the password of the user of the shared mailbox (not the delegate, the actual user created alongside the mailbox); i.e. mailbox name: “Shared Mailbox” username: shared.mailbox@domain.com.

If Microsoft did not suggest that workaround, and they didn’t, it leads you to believe if this method breaks they won’t care either. 

Enter: Graph API via the HTTP action. 

Before we get in weeds, the HTTP action is a Premium action. So, if you do not have the Premium license for Power Automate you cannot use it. 

The first step is to get a custom connector created into Azure AD to leverage the API. This allows you to build your actions once and apply them to multiple Flows. 

The guide I used to get the Custom Connector created was this one from Microsoft. https://docs.microsoft.com/en-us/graph/tutorials/flow

Once that is created, you can create different actions inside the connector then access them from your Flows under Custom when adding an action. I’ll go into detail about the actions I use later in this post.

In order for the Custom Connector to have the correct token, you need to get a token from the API. Below is a screenshot of what the action looks like using the HTTP connector. The action under the HTTP connector will be the “Parse JSON” action. 

In the above screenshot, you’ll notice I stored the Tenant ID, Client ID and Client Secret from the Azure AD App Registration as variables. 

In this action, you can generate the JSON Schema using the below sample. Click “Generate from sample” and paste the below text. NOTE: after every HTTP action (including those with the Custom Connector) use the Parse JSON action in order to know the schema of the JSON. 

{    "type": "object",    "properties": {        "token_type": {            "type": "string"        },        "expires_in": {            "type": "string"        },        "ext_expires_in": {            "type": "string"        },        "expires_on": {            "type": "string"        },        "not_before": {            "type": "string"        },        "resource": {            "type": "string"        },        "access_token": {            "type": "string"        }    }} 

Now to the Graph API Custom Connector actions. 

The below action gets all the attachments on a given email. Later, we’ll select the attachment we want to work with.  The URL is truncated but is “https://graph.microsoft.com/v1.0/users/shared.mailbox@domain.com/mailfolders('Inbox')/messages/{id_message}/attachments”. The text inside the brackets in the URL becomes a parameter. NOTE: actions cannot share parameters so if you have multiple actions with the same parameter they’ll need to be named uniquely. When you create the request, you will see a section for header enter the below be sure to put a space after “Bearer”, you’ll use the token from the above JSON behind Bearer after a space.

Authentication Bearer 

Much like the above action, I have an action that selects an attachment. To do this, change the URL to “https://graph.microsoft.com/v1.0/users/shared.mailbox@domain.com/mailfolders('Inbox')/messages/{id_message}/attachments/{id_attach}”; you’ll use the attachment ID found in the JSON of the above action. 

I also mark the message as read. This is done with the “PATCH” verb in the Request section. I’ll discuss that in a later guide.

[powerappsguru]

In this video, you will learn how to create Create a PDF Document, place a digital signature, and upload it into one drive with PowerApps and PowerAutomate. We walk through everything from generating the HTML, to filling in the variables, adding Flow actions, creating a signature, and finally sending content from PowerApps to the PDF, and storing it in SharePoint. Very cool.

[phungthaihy]

Using Microsoft Teams, Flow, Ideation and Project Online for Project Intake http://ehelpdesk.tk/wp-content/uploads/2020/02/logo-header.png [ad_1] In this video we use Microsoft T... #dataanalysis #datamodeling #datavisualization #excel #exceldashboard #excelformulas #excelfunctions #excelmacros #excelvba #ideation #microsoftaccess #microsoftflow #microsoftoffice #microsoftoffice365 #microsoftpowerbi #microsoftproject #microsoftprojectonline #microsoftteams #microsoftword #officeproductivity #pivottables #powerautomate #powerpivot #powerpoint #projectintake #sap

[elbrunoc]

#PowerAutomate – Flow to use Open Trivia Database questions in a Microsoft Teams bot 🤖 6/N

PowerAutomate – Flow to use Open Trivia Database questions in a Microsoft Teams bot 🤖 Series Intro to Open Trivia Database API How to process the API Response and send a question to Teams How to validate the user response in teams with the Trivia Question correct answer Sort and mix the possible answers to the question Trigger the flow from a new message in a Teams channel, and validate the…

[mtgomes]

Power Automate: What is a Scope?

What is a Scope in Power Automate? I’ll explain what it is, how to use it, and some hidden features that can make your life easier. #powerautomate #tuturial

As Flows grow more and more in complexity, managing one becomes important for fixing issues, testing, and maintenance. Power Automate provides a wonderful tool for us to do that called “Scope.” A Scope is an action that “groups” other actions inside it. You can consider it as a box that encompasses all actions under it and can be collapsed better to display the “sections” of your Flow. How to…

[indiancareers]

#Microsoft #Microsoftflow #Microsoftpowerautomate #powerautomate #RPA Microsoft Power Automate Tutorials || Module 4 : Build a first FLOW in Power Automate https://youtu.be/pPY3UK9XhAA Learn, Subscribe and share youtube channel and get updates on Microsoft Power Automate/Blue Prism /Automation Anywhere/Uipath. #RPALearningVideos #RPADeveloper #RPA #BluePrism #UiPath #AutomationAnywhere #python #Automation #learnRPAforfree

[kinuasa]

[Power Automate Desktop]カメラ撮影して写真をOneDriveにアップするフロー

[[Power Automate Desktop]カメラ撮影して写真をOneDriveにアップするフロー]

1年半ほど前、まだPower AutomateのRPA機能がUI flowsだった頃、Power Appsからフローを実行してローカル端末で写真撮影、撮った写真をメール送信する、なんてことをやっていました。 UIフローを使ってスマホからPCのカメラを操作、撮った写真をメール送信する #PowerApps アプリが完成。もちろんノーコード！ #PowerAutomate の実例として中々エモくない？😉これが #UIflows の実力っ！もっと流行れ～😆✨ #PowerPlatform #PowerAddicts pic.twitter.com/sV04fw2HDO — きぬあさ (@kinuasa) December 29, 2019 Power Automate…

[nicolasvelasquezespinel]

Compartir un Flow de #PowerAutomate con compañer#s de tu organización es sencillísimo! Pero hay 3 reglas que l#s PowerNautas no debéis romper 📌haberlo ejecutado al menos 1 vez 📌haber coronado con éxito la última ejecución 📌NUNCA, NUNCA te saltes pasos de nuestras infografías😋 https://t.co/YCMBMfPS7O

[ibarrau]

[PowerBi][PowerAutomate] Programar aviso a tus compañeros de una alerta

Dentro del servicio de Power Bi existe una muy interesante funcionalidad para alertar a usuarios finales sobre algún movimiento numérico deseado o indeseado sobre sus datos. La idea pasa por darle a conocer de forma temprana algo que desencadenaría un suceso según el proceso de negocios o, simplemente, para estar informado al instante que suceda.

Lo cierto es que las alertas son muy cómodas para la app del celular. Podemos recibir información al instante como una notificación del sistema operativo en lugar de ser avisados por mail. Los mails no se ven con la frecuencia de una notificación móvil aun pensando que podríamos tener alertas al recibir un mail. Muchos de nosotros ignoramos los mails y tenemos un horario para revisarlos.

Todas estas configuraciones suelen ser para quien las configura. Sin embargo, ¿que sucede cuando queremos que esa alerta avise a un conjunto de personas y no solo al usuario final? Power Bi por si mismo no te deja configurar otro destinatario de la alerta. Para ello vamos a usar Power Automate (antes llamado Flow).

Recientemente vi que muchos consultaban en el foro oficial de Power Bi sobre enviar alertas de sus KPI a compañeros. Me interesé en comprobar que no es posible hacerlo “solo” con Power Bi. Veamos como se hace el proceso.

Lo primero que necesitamos es un tile de una visualización de un informe en el cual podamos configurar una alerta. Recordemos que únicamente las medidores, KPI y tarjetas (gauges, kpi, cards) permiten la configuración de una alerta. Para ello vamos a pinnear un tarjeta de un informe y llevarla al panel.

A partir de este momento podremos configurar una alerta en nuestra tarjeta. Sigamos la siguiente imagen para ver como se hace.

Luego en “Agregar regla de Alerta”.

Configuramos el umbral y guardamos nuestra alerta. Cuando volvemos a entrar a nuestra alerta para revisarla. Fíjense que al fondo de la configuración Microsoft ya nos avisaba la posibilidad de desencadenar una acción con la alerta. Para comenzar nuestro Power Automate vamos a dar click en esa opción:

Esto nos redirige a Power Automate con una plantilla por defecto para nuestra alerta a la cual le damos continuar:

De ahora en adelante todo nuestro trabajo se encuentra en Power Automate. El flujo inicia con nuestro conector a Power Bi donde seleccionamos la alerta creada anteriormente. En mi caso se llama “Alerta de Alerta”

Luego podemos dar en el signo “+ Nuevo paso” para desencadenar nuestra acción siguiente y elegir como vamos a informar a nuestros compañeros sobre esto.

Para esto recomiendo dos principales salidas:

Teams: podemos enviar un chat a un equipo y canal personalizado por nosotros.

Correo: enviar un correo personalizado a las direcciones deseadas.

En el caso del correo existen 5 modos de envío que podemos utilizar. Según el método utilizado será el emisor del correo.

Envío por nuestra cuenta de office 365 con licencia exchange.

Envío por una cuenta outlook.

Envío por una cuenta gmail

Envío por un smtp personalizado

Envío por Power Automate. Enviado por Microsoft Power Apps and Power Automate <microsoft@powerapps.com>

La configuración es muy sencilla excepto para smtp. Pueden elegir uno de ellos y completar los datos correspondientes. Para finalizar guarden el flujo. El ejemplo final del flujo con el correo enviado por Automate se vería así:

Hemos concluido y es importante mencionar que todos los conectores que utilizamos para este flujo son gratis por el momento. Espero que ahora puedan informar de sus alertas a sus colegas con mayor velocidad y comodidad.

NOTA: No necesitamos un pago adicional por usar Automate con nuestra cuenta de office 365 que tiene Power Bi. En caso que tengan inconvenientes para conseguirlo, puede comunicarse con el administrador de office del departamento de tecnología.

[elbrunoc]

#PowerAutomate – Flow to use Open Trivia Database questions in a Microsoft Teams bot 🤖 5/N

PowerAutomate – Flow to use Open Trivia Database questions in a Microsoft Teams bot 🤖 Series Intro to Open Trivia Database API How to process the API Response and send a question to Teams How to validate the user response in teams with the Trivia Question correct answer Sort and mix the possible answers to the question Trigger the flow from a new message in a Teams channel, and validate the…