Questions tagged [flow]
Microsoft Flow is a public cloud service to help individuals and teams to set up automated workflows.
580
questions
0
votes
0
answers
4
views
SharePoint Library: Flow with Switch Case is always cancelled
I want to run a flow for sending out some notifications when a file is changed in a doc library. Those notifications depend on the state of two columns. I have now tried some different variants on how ...
- 1
0
votes
1
answer
14
views
How can I include the the original Item ID# in a new Item created/cloned using Power Automate flow?
I am using Power Automate to clone original Items in an existing SharePoint List. All is working perfectly, as the clone flow results in an exact copy of the original List Item. Now my users want to ...
1
vote
0
answers
13
views
Calculated column dates are a day out when queried in Flow?
I've got a SharePoint list that is used to work out renewal dates of software. The three key columns are "NCE SKU", "NCE Purchase Date" and "NCE Renewal Date". The &...
- 55
0
votes
1
answer
24
views
Send Email For a selected file
I am trying to send an email for a selected file in power automate, I would like to see the flow only on subfolders which I have set the flow but not on all Subfolders.
Ex: Parent Folder
SubFolder 1
...
- 55
1
vote
1
answer
27
views
Take value from a person or group column in a list and insert it into another list
I have a list that includes a person/group column, and I'd like to set up a flow to extract that value and insert it into a similar column in a different list.
Is this possible?
Not quite sure what ...
- 21
0
votes
0
answers
37
views
"Filter Array" action returns 0 elements
I'm looping trough an simple array with string-values.
I want to filter another array with each item() of the loop:
The "Loop TrainingID" returns the exact value AM_AMiaL_ but when I use ...
- 129
0
votes
0
answers
9
views
Infopath columns added after Flow created not appearing in Update Items
We added 60+ fields to an Infopath form in SharePoint Online (iterative development) after creating the approval workflow for it. The new fields are all published and appear in SharePoint. New flows ...
- 11
0
votes
2
answers
73
views
What is "Flow widgets" and how we can use & benefit from them
I am reading documents about Power Automate from Microsoft Docs and in below link, they are talking about "Flow widgets":
Integrate Power Automate with websites and apps
But I am not sure ...
- 2,224
0
votes
1
answer
124
views
Get Outcome of the "start and wait for approval" Vs get the ResponsesComments. For the later, Power Automate will automatically add a "Apply to Each"
I have the following "Start and wait for approval" step inside my automated flow:
Then I wanted to send an email containing the Outcome of the "start and wait for approval" + the ...
- 2,224
0
votes
2
answers
129
views
Power Automate Trigger condition (Created <> Modified)
I have created a new flow which run when item is created or modified inside SharePoint list. But I do not want this flow to run when item is created.
I only want it to run when the item is further ...
- 93
0
votes
1
answer
33
views
How the logic will run if I have "start and wait for approval" inside a ForEach
I have a normal scenario of getting the members of a Group >> and set a "start and wait for approval" to wait for all responses >> but since the Assigned To is a list >> ...
- 2,224
0
votes
1
answer
50
views
Can we create a rich text email body for our "start and wait for an approval"
We have this "Start and wait for an approval":
But I need to create custom email body, which will have tables, links and rich text. So is this possible? as in our case the Details field can ...
- 2,224
0
votes
0
answers
28
views
Compare Two Array for Each Unique ID and Send Email
I have 3 arrays on my Flow and I would like to compare the two arrays for each index on another array.
Array 1 - Is a list of users who completed the training:
[
{
"Title": "Test&...
- 1
0
votes
2
answers
136
views
Can i get the members of a Mail-Enabled security group inside my automated workflow
We have the following Mail-Enabled Security group:
So my question is, can I get the members of a Mail-Enabled security group inside my automated workflow?
- 93
0
votes
0
answers
32
views
How to share multiple cloud flows in Power Automate?
How can I share multiple cloud flows with a person?
I know how to do it one by one (i.e. clicking on vertical ... and then share), but how to do it for multiple flows without being the admin (i.e. I ...
- 405
0
votes
1
answer
42
views
Get libraries filtered by content type in SharePoint Online flow
I have a SharePoint Online site that contains several document libraries, some of which use a custom content type named, "Legal." And the Legal content type contains a metadata field named, &...
- 3
0
votes
0
answers
15
views
Multiple Approvers email [duplicate]
I have a SharePoint list that on a certain trigger needs to start an approval process for multiple users - depending on the situation this can be between 3 and 6 approvers. I started with a column ...
- 57
0
votes
1
answer
27
views
Create a clone of an item in a list2 - Update list2 columns when there are changes in list1
I would like to ask you about the following flow.
I have a list (list1) that
first I run a flow to update status columns based on some conditions (from blank to "pending") and then
I need ...
- 5
0
votes
0
answers
15
views
Another strange error on GetItems. Missing parameter error, although column isn't mandatory
This question relates to some strange behaviour of GetItems on a list namely a calendar. I got an error message complaining about an unfilled mandatory column when I issued a GetItems request which ...
- 171
0
votes
1
answer
54
views
Strange error on GetItems. Missing parameter depending on Item
Given: 2 lists (1 calendar, 1 custom list).
Calendar has a lookup column to custom list.
Within a flow I want to retrieve all items from the calendar which have the lookup column set to a certain ...
- 171
0
votes
2
answers
63
views
Having a problem with Apply To Each in a simple email flow
I'm creating a simple alert email flow. When an existing item is modified -> Send an email (V2).
The problem is I need to CC all the users in a Person/Group field with Multiple Users checked. When ...
- 243
0
votes
2
answers
30
views
Trigger for one off workflow
I have been using Power Automate to create some workflows for a SharePoint list. There are a series of emails which get sent to different users as the Status column is changed - this is triggered when ...
- 57
0
votes
0
answers
30
views
Update item from Secondary SP List back to the Primary SP List
I need to trigger an update back to my primary list of a column changes (choice). I had a simple flow for updates but there were multiple lists that will also need the same updates of the same column. ...
- 1
1
vote
1
answer
74
views
How to remove space from a title column in SharePoint online
I am sure this question has been asked many times, but would someone please be able to guide me with my issue with removing a space between title word, e.g. title "Project ABC" and I would ...
- 23
0
votes
1
answer
151
views
Power Automate Flow multiple selection column
I am trying to write a flow from a SharePoint list where depending on a condition an email is sent to a group of users and lists the fields from the list in the email.
This seems straightforward when ...
- 57
0
votes
1
answer
62
views
Modify a specific column for an Item when another column is modified
For an Item in my list I have three columns, "date started", "date completed", and "# of business days to complete"
Is there a way to build a flow so that when "date ...
- 11
1
vote
1
answer
68
views
How to remove HTML in email output generated by Power Automate for lookup columns
My Power Automate solution produces the desired values except I can't figure out how to remove the HTML metadata in the email output. Instead of:
{"__metadata":{"type":"SP....
- 31
0
votes
1
answer
365
views
Power Automate - Create list of folders with list of subfolders
I want to build a flow that enables me to mass create a list of folders. It's easy enough to create a list of single folders (initialize variable to an array, loop through the array and create a ...
- 3
0
votes
1
answer
128
views
Trigger condition when DateTime field is null
I have a flow that triggers on When an item or a file is modified in a document library.
To stop it re-triggering when the item is updated, I'm checking that a DateTime field called FlowModified isn't ...
- 103
0
votes
0
answers
12
views
Use Flow to create public RSS from SPO list?
I have some information in a SharePoint Online list that I want to display on a secure/internal SharePoint 2016 publishing site. The problem is that credentials for our 2016 site are managed through ...
- 114
0
votes
0
answers
56
views
Power Automate for two-way updates in two SharePoint lists?
I've seen information about this using SharePoint Designer and workflows, but hoping I can get some guidance to do it successfully in SharePoint Online with Flow (Power Automate). At a high level, ...
- 114
1
vote
1
answer
51
views
Send an customized email when new site is created in SharePoint Online
Is there any web hook or Power Automate trigger available when a new site is created in SharePoint Online?
Goal is to send a customized email to site owners when the new site is created.
Newly created ...
- 2,114
2
votes
1
answer
27
views
Power Automate Reminder flow error
I am trying to create a flow that takes the Expiry date from the list and sends an email to outlook.
This is my list:
This is my flow:
I have added this string (Should send a reminder when 1 day is ...
- 23
0
votes
1
answer
137
views
Set "Audience Targeting" via Power Automate
I've created a power automate flow that automatically creates a page from an item when the item is created. Everything works fine except the ability to add audience targeting. I've enabled audience ...
- 103
0
votes
1
answer
212
views
Can't set variable using dynamic content within a switch case in my Flow (returns NULL)
I have a flow that's retrieving the values from an MS Form and then pushing them to a SharePoint Online list, and it's running without errors:
The problem is that I have 10 different "...
- 114
0
votes
1
answer
90
views
Send Email Notification when the SharePoint item modified
I am having an issue sending email notifications when the item has been modified. I have an SP online list of two columns. The first column is a choice field called job status and has In-Progress and ...
- 507
1
vote
1
answer
51
views
Why does my flow create multiple items when I upload a new document to a SharePoint library
For some unknown reason whenever I upload a new document to the document library, my background flow pulls the required data correctly but it creates multiple new items when it's only meant to create ...
- 23
0
votes
1
answer
201
views
For a selected file Power Automate - Trigger date
I was wondering how does the trigger date works in "for a selected file" in the power automate.
When I select "Date" from Add an input and Save. Later, When I select future date ...
- 55
0
votes
0
answers
31
views
Create a flow to automatically apply metadata to a new folder based on name
I am attempting to create a flow that automatically updates any new item's (folders in this case) metadata. I have previously made a flow that runs manually to search for a particular expression in a ...
- 1
0
votes
1
answer
330
views
List - Change Column value on Button Click
In old versions of SharePoint (classic lists, SP 2013, SP 2016) it was possible to create a button via calculated column that changes the value of a column in this item instantly (example at the end ...
- 1,077
0
votes
0
answers
19
views
Loop trough Collection to find true results
New to power flow so my trials exhausted and is time to ask help as couldn't find an example to my needs.
I have a excel dataset
Table1:
Table2:
Flow starts with Power App sending a int , used to ...
- 1
0
votes
1
answer
35
views
Power Automate: Loop through SELECT
I want to send a personalized email with additional infos to hundreds of employees. The informations are stored in a massive Excel file.
My goal is to create a Flow which runs every morning, filters ...
- 129
1
vote
2
answers
1k
views
How to prevent Power Automate from being suspended after inactivity?
I have a Power Automate that is triggered on SharePoint list item update. But that SharePoint list is updated rarely once in a year.
In this case, my Power Automate is automatically suspended by ...
- 8,445
0
votes
0
answers
802
views
Why can't I select the table from an excel file in a new flow?
I have a project requiring two separate flows to pull data from excel files when uploaded to a SharePoint document library.
One flow works and allows me to pull the required data:
However the second ...
- 23
0
votes
0
answers
99
views
How to update multiple items in SharePoint Online library with Power Automate
This is my flow, which is responsible for changing users in my document library in Responsible Person column.
Uri - there is a document library guid with "items" (which is ID of desired ...
0
votes
1
answer
11
views
Power Automate, Email Flow not sending correct value
I setup a flow to send an email of the value of my SharePoint list.
My Project ID is sent fine via email, but my PMName is not sent in a correct format.
Does anyone know why this value is not giving ...
- 145
0
votes
1
answer
49
views
Exclude weekends and holidays in Leave Request flow
Hope I get some guidance.
I have a leave request working almost good (after 3 month trying all sort of things).
Employee request a leave (SP List1) --------> Approver receives an email to approve ...
- 1
1
vote
1
answer
23
views
Add require more information to approval flow
I am trying to write a simple approval flow on a SharePoint list. The standard approval is Approve/Reject but want to add a third option 'more information required' which triggers an email to the ...
- 57
0
votes
1
answer
80
views
How to format calculated column number in Microsoft flow
I am using a calculated number in a SharePoint list and using this value in an email using a Power Automate Flow. The value should come as an integer.
When the value is passed through to Flow, it's ...
0
votes
0
answers
33
views
Set boolean in JSON using if statement
I am building a flow to copy all items in one SharePoint list to another SharePoint list in the same site. The target list varies, so I am creating the list name as a variable. I can't use the Create ...
- 1,051