9

Very interesting question.. let us first understand the background of what is all 3 about. MSFlow - To Automate a business process we generally use workflows. Ms flow are alternative to workflows. Before MS flow, Sharepoint designer workflow was used for simple things but for complex things you had to rely on custom workflow(visual studio) or any third ...


5

It is now possible to manage SharePoint permissions in Microsoft Flow with the help of Plumsail SharePoint (Third-party connector), which is a part of Plumsail Actions product with a fair price. There is an action, called Change Permissions that gives you the ability to: Grant Permissions on Site Remove Permissions from Site Remove All Permissions from ...


4

Through auditing, SharePoint can track file downloads. But auditing is a report rather than a real time trigger. I'm not sure you can catch the event in real time, if that's necessary?! Check out Logging people who download files in SharePoint.


4

MS Flow doesnt seem to allow you accomplish this at the moment - I came across this scenario as well. You may be able to do it if you set up your flow using the Logic Apps in Azure https://azure.microsoft.com/en-us/services/logic-apps/ You will need an azure subscription to create an app


4

Follow the steps below, I assume your list structure is as below So you can follow below steps to get the email template from List. I have used Get Items Action assuming you will have to fetch email template dynamically. you can replace Filter query OR make it more dynamic using variable. If its not dynamic then you can also use Get Item action instead of ...


4

Microsoft Flow has trigger action When a new response is submitted where you have to set Form ID to listen this event when MS Forms is submitted. And it takes only one Form ID value in this control. So, unfortunately, there is no way right now that you can make common flow to listen all your MS Forms together. You will have to create separate flows for them....


4

Have you tried using Parse JSON action? For input to Parse JSON, use the Person object retrieved by Get Items action, and for Schema, use the below: { "type": "object", "properties": { "@@odata.type": { "type": "string" }, "Claims": { ...


3

Good day, As far as I know breaking the item level permission in Flow and assigning a new one is not possible. In the SharePoint action - Update Item there is no option to change the privileges of the list item which you are editing. Regards,


3

One of the actions is sharepoint: update list item. It will ask for the id of the list item, just use the id of the item from a previous step. Be careful though, this action is a PITA: if your list has 20 fields, all 20 fields will be added in the designer. choice fields will have their default values set, so you'll need to go through and clear those as to ...


3

SharePoint online sites within office 365 have got two versions I would say: Classic experience Modern experience (Latest) The one you are seeing in the blog is from Modern experience. Classic lists/libraries do not have option of flows internally. You need to change it to modern experience. Process for switching to modern experience is: -> Click on the ...


3

Export a Flow: click on ellipsis "..." menu, select 'Export' then click on 'Package (.zip)' provide a name and a description for your package and configure other options click on the "Export" button in the bottom right corner your package should start downloading shortly after (or click "Download" button) Import a Flow: click on the import button in ...


3

I found the problem, the create item is in the "Apply to each 2", when I removed it it worked fine. I guess the reason was copying it from the update item. Because when I created the "update item", flow puts it in "apply to each", so when I copied it to "yes", "Apply to each" was also copied, while it should not be. However, I am sure I will be corrected if ...


3

Yes, we could do that using Microsoft Flow, SharePoint designer workflow or Nintex workflow. Follow the below steps: Step1: Step2: Below are the good reference articles: Send email with attachment from SharePoint list when condition is met Send list Item attachment as email attachment using flow For HTML column formatting in the Microsoft Flow, refer ...


3

A cloud flow that has no successful triggers will expire and be turned off. After 90 days of inactivity, the flow creator will receive an email. If no action is taken in next 30 days, the flow will be systematically turned off and the creator will be notified in an email. For enterprise scenarios, we recommend you buy a standalone Power Automate license ...


2

There was no such functionality to import/export flows or any other backup option previously. But you can configure Data Loss Prevention (DLP) policies as shown here for prevention. UPDATE As per @SP Combatant's answer now you can import and export the flows: Export a Flow: click on ellipsis "..." menu, select 'Export' then click on 'Package (.zip)' ...


2

It turns out that currently this can only be done in "advanced mode". Enter this formula: @equals(triggerBody()?['Test_YES_NO_DEFDAULT_YES'], true) Note that this is not the same as you tried (true), since writing "true" in Basic mode puts the string in the formula, instead of the bool value true.


2

As a short answer: Yes, It's possible. Microsoft Flow is a public cloud service only. However, you can securely connect to your own on-premises services through the on-premises data gateway. The supported data sources are: SQL Server SharePoint Oracle Informix Filesystem DB2 To configure on-premises data gateway for SharePoint check Understand on-...


2

Yes this can be done using flow with below steps. Add trigger for item modified. Add action to get item from same list with item ID returned as dynamic output of step 1. Add condition check the field value. Add action to send E-Mail.


2

Workflow triggers always run once event is already occurred it will not wait til item is approved or anything. If you triggering point is item deleted, it does trigger MS flow(just tried this) but it won't anything for status as you trigger is when item is deleted. If you want to handle situation than item is deleted when it is only approved. you should ...


2

As long as you have clear understanding on what DAY means, below solution can be applied. If your users are geographically distributed around world, it can get tricky, so please take with pinch of salt. Write schedule based Flow - https://docs.microsoft.com/en-us/flow/run-scheduled-tasks This flow can Update item to a config list every night say 1AM In ...


2

Try HTTP Request to sharepoint:


2

Your formula for date time like this: 1. formatDateTime(triggerOutputs()?['body/Start Time']) 2. formatDateTime(triggerOutputs()?['body/End Time']) Flow input: Regards, Chandani Prajapati


2

If your flow is running on an automated trigger then it will always run in the context of an owner of flow (Who created the flow). So that is who shows up in Modified By field in your SharePoint list. However the manually triggered flows, like the ones that start with a button in a PowerApp runs in the context of the user who presses the button. Possible ...


2

Try using this formula: formatDateTime(startOfMonth(addToTime(utcNow(), -1, 'Month')),'dd/MM/yyyy')


2

So, if you are referencing a value from the Flow Trigger inside your Flow, that value will not change until the next time the Flow runs. If you hover over one of your references, you will see that the expression it is using is something like triggerBody()?['MyAssignedToField'] -- the values from the triggerBody do not change during the course of the Flow. ...


2

You can as long as you have Version History turned on for the list. While it is not a built-in function, you can use the Send HTTP Request to SharePoint action in Power Automate to call the Versions REST API and restore the previous version. Start by using the Send HTTP Request to SharePoint action to call /_api/Web/Lists/getbytitle('NameOfTriggeredLibrary')...


2

Below steps worked for me, please check if it's working for you: Create a flow with trigger "Manually trigger a flow" trigger. And select email option. Add "Create approval" action and set email property as assigned to in this action. Set other values in above action as per your need. Run the flow and pass email address of the user ...


2

Here are the steps that I would follow: After [Get Items] action add a [Compose] action Execute the Flow and examine the output from the [Compose]. Copy the output of the [Compose] into clipboard Add [Parse JSON] action and use the output from step 3 as sample data to generate schema Add addition actions like another [Compose] action to verify the Parse ...


2

Try using below expression in Condition action inside "Apply to each" on excel rows: @equals(empty(items('Apply_to_each')?['DateCol']), bool('True')) Source: Check for empty cells in Excel If you are not able to able to use the advanced mode for conditions, use below: Left condition: empty(items('Apply_to_each')?['DateCol']) Operator: is equal to ...


2

Suppose the connection in "Send an email (V2)" is of User1. And you need to send email on behalf of Admin Account i.e. AdminUser1. User1 should should have Send on behalf permission on AdminUser1 Mailbox. Steps : Go To exchange Admin Center Click on MailBoxes from the left navigation Click on the AdminUser1 (it will open AdminUser1 Mailbox ...


Only top voted, non community-wiki answers of a minimum length are eligible