13
votes
Accepted
PowerApps and Flow vs SharePoint Framework
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. ...
- 5,945
5
votes
what are the limitations of Microsoft flow as compare to designer workflow.
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.
...
- 1,287
4
votes
Accepted
Is there any trigger to know if an attachment from an item in a list is downloaded?
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 ...
- 25.5k
4
votes
Update SharePoint item using Microsoft Flow?
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....
- 1,765
4
votes
Accepted
Microsoft Flow - Get email body content from another list?
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 ...
- 2,865
4
votes
Accepted
Microsoft Flow: Single flow for multiple Forms
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.
...
- 6,704
4
votes
Accepted
Power Automate - Get DisplayName from People object as text
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",
&...
- 2,122
4
votes
Accepted
Which Power automate/flow license removes the 90 days limitation
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 ...
- 9,427
3
votes
Accepted
what are the limitations of Microsoft flow as compare to designer workflow.
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 ...
- 88
3
votes
Accepted
Set a Field Equivalent in Microsoft Flow
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 ...
- 8,000
3
votes
Accepted
How to start a microsoft flow in SPO Classic Experience?
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/...
- 2,406
3
votes
Export/Import microsoft flow in SharePoint Online
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" ...
- 417
3
votes
Microsoft Flow always run in context of user who published it
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....
- 38.7k
3
votes
Copy a list to another list by MS flow
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", ...
- 425
3
votes
Accepted
I need to create an auto-generated email when an item in a Sharepoint list are added which includes few columns from the list item and the attachments
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 ...
- 3,974
2
votes
Accepted
Export/Import microsoft flow in SharePoint Online
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 @...
- 6,704
2
votes
Accepted
How do I correctly use Microsoft flow conditionals with a YES/NO Columnin A sharepoint list?
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),...
- 3,606
2
votes
Accepted
Create SharePoint 2010 list datasource using Microsoft flow
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 ...
- 45.3k
2
votes
Using microsoft flow - sending email with attachment when specific field is modified in sharepoint
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 ...
- 2,865
2
votes
Accepted
Flow 'When an item is deleted' never triggers, item just gets deleted
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 ...
- 5,945
2
votes
Increment column then reset to 1 every day
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 ...
- 1,051
2
votes
2
votes
Microsoft Flow to add event to outlook calander
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
votes
Microsoft Flow trigger skipped when item modified multiple times in a minute
This has been my experience in several O365 tenants, When the Flow trigger event happens in rapid succession you get this behavior. Flow seems to run on a 15 minute timer, so when you make multiple ...
- 1,009
2
votes
Accepted
SharePoint file name help
Try using this formula:
formatDateTime(startOfMonth(addToTime(utcNow(), -1, 'Month')),'dd/MM/yyyy')
- 38.7k
2
votes
Accepted
Do-Until not working as expected
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 ...
- 3,704
2
votes
Accepted
roll back an item in alist due to rejecttion in the approval process
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 ...
- 3,704
2
votes
Assigned To Field - Power Automate
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" ...
- 6,704
2
votes
Power Automate - Select single item from Get Items
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 ...
- 2,122
2
votes
Accepted
Power Automate flow check if date is not empty and null
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
...
- 38.7k
Only top scored, non community-wiki answers of a minimum length are eligible