How to delete a Planner task with Power Automate using a custom connector If you're not new to Planner connector in Power Platform, you know that the connector is not exposing the Delete Task action. To overcome this issue, you can create your own action and delete Planner tasks. You may want to delete tasks when you run out of task quota and you get this error message: […]
How to send approval requests to groups in Microsoft Flow Context The Microsoft Flow Approvals connector does not support sending approval requests to groups today. If you want to send an approval request to an email address belonging to a group, as illustrated in the screenshot below: The following issue may occur: BadRequest. The request failed. Error code: 'InvalidApprovalCreateRequestAssignedToNoValidUsers'. Error Message: 'Required field 'assignedTo' contained […]
How to get more than 5000 items from SharePoint Online in Flow Scenario You have a large SharePoint list and you need to get all those items in Flow. By default, each request you send from Flow to SharePoint Online will return a response limited to 100 items. This limitation is not very obvious, even if you show the advanced options on the action and read the […]
How to add HTTP actions and custom connectors to a Data Loss Prevention (DLP) policy in PowerApps and Flow Custom Connector support for DLP In my last article I explained how to create a custom connector and in this article I will explain how to add a custom connector to a Data Loss Prevention (DLP) policy. I wrote about how Data Loss Prevention policies work in PowerApps and Flow in this article, if you […]
How to build a custom connector for Flow and PowerApps to connect to a web service Why build a custom connector? Microsoft offers connectivity through standard and premium connectors to more than 200 services today in PowerApps and Flow. Although there is a large selection of connectors, there are services today for which Microsoft doesn't provide a connector yet. For example, we don't have a connector for Yelp! If you want […]
How to get all messages in a Yammer group using Microsoft Flow Limitation If you are reading this article you are probably trying to get more than 20 messages from a Yammer group using the Get messages in a group action. To demonstrate this limitation I created a simple flow that gets the messages from a group and then counts the items in the Messages array. I […]
How to track the flows that created the items in your SharePoint list Scenario You might have asked yourself the following question: how do I know which flow created the items in my SharePoint list? The answer is simple: you don't and you shouldn't expect Flow to have this kind of capability OOTB. The reason is because Flow is a data integration and workflow development service – it […]
How Data Loss Prevention policies work in PowerApps and Flow Roles and license required for DLP If you are a Global Admin, then you can configure one or more Data Loss Prevention policies for your tenant. When you go to the PowerApps Admin Center or Flow Admin Center, this is what you will see: If you are a Global Admin with a PowerApps Plan 2 […]
How to grant permissions to one or more users to use the Outlook Tasks connector in Microsoft Flow If you are reading this article you probably noticed that if you try to use the Outlook Tasks connector with a non-global admin account, the connection attempt fails with the following error: OutlookTasksConnector-PowerApps and Flow needs permission to access resources in your organization that only an admin can grant. Please ask an admin to grant […]
Flow: how to change the style of your HTML table in Microsoft Flow I built an HTML table in Flow and now I want to change its style. I want to add CSS style to the table rows. If we look at the Data Operations – Create HTML table action, adding CSS is not supported: My method is a bit complicated, I would think, because it involves more […]