Posts

Showing posts with the label power automation

Integrate Monday with SharePoint and Office365 Power Automate

Image
 I must say it was fairly simple. Step 1 - Buy Premium Power Automate Account BTW you can try the Trial and get 25 licenses for free for 1 month. You need to go to your admin center to the marketplace (or ask IT) for the Power Automate Premiun license, and assign it to the user that is going to create the automation.  He also must be board admin in the Monday. link is like this  https://admin.microsoft.com/?source=applauncher#/catalog Step 2 - Install app on Monday This app just create some webhooks for Power Automate and the connection ect. IMPORTANT  this is not an official MS app, just some 3rd party.  You could develop hooks if you have restrictions. This is what you need to see PER BOARD to know its working. Again you must have Board Admin  role. Step 3 - Start a Monday Automation Create a flow and search monday or user the main search bar to get suggestion IMPORTANT - when you start he will open a popup with 2 buttons to complete the connector. You ne...

BadGateway (502) CreateSiteScript Power Automate

 using endpoint  /_api/Microsoft.SharePoint.Utilities.WebTemplateExtensions.SiteScriptUtility.CreateSiteScript(Title=@title)?@title='DemoSiteScript' we got error  BadGateway solution - user must be SharePoint Admin

microsoft flow (power automation) test if lookup is empty

 You need to use "empty" expression on the Lookup Value and Condition equals to expression "true" (of false or not equal ect.)

Power Automation (Flow) send email with Image from Picture Field (Sharepoint list)

Image
 The Scenario - When item is created in list B, and list B has the ID for item in list A, go get list A item by id, where there are some details including a Picture field, and send all that via email. The main thing to remember is that MS did not develop the api needed for the flow to get the picture field, so we cant read nor update it, only via HTTP. Steps: trigger when item created in list B parse listItemB_ID field from float to integer get item from list A via flow get item from list A via HTTP request to SharePoint (*not premium) get the Picture field value, it's a JSON parse that json give a schema for the parser where do we find the sample for the schema build the Picture url send email 1. trigger when item created in list B   2. parse listItemB_ID field from float to integer the item A id field, although set to be integet, is eventually a float for the flow. we must parse it using the `int` function, using  int(triggerOutputs()?['body/CouponID']) 3.  ge...