Questions tagged [flow]
Microsoft Flow is a public cloud service to help individuals and teams to set up automated workflows.
604
questions
0
votes
1
answer
17
views
Send HTTP Request CopyTo File to different document library - Power Automate
I am receiving a 400 Status error with my Power Automate app. I am unsure as to why, it seems there's an issue with my current code but unfortunately, I am unable to find it.
For Convert to PDF, the ...
0
votes
1
answer
20
views
Call a reusable flow from existing Automated Cloud flow
I have an automated cloud flow which create 10 items inside 10 different lists. now for each item i want to set unique permission. so can i create a reusable flow which accept 2 parameters:
ItemID
...
- 984
0
votes
1
answer
15
views
Users with contribute permission can call REST API to Break Role Inheritance , but can not make a REST API call to get all role assignments
I have a power automate flow which runs under a user who have Contribute permission on a list item, the flow consists of 2 actions:-
First action is to break role inheritance, while the second flow ...
- 984
1
vote
1
answer
119
views
Does the Pagination Threshold setting in the Get Items action relate to how many items can be returned or how many items can be searched?
If I have a list that contains, for example, 3,000,000 items.
If I apply the following settings in the Get items action:
Top Count: `5000`
Settings > Pagination > Threshold: `100000`
Odata ...
- 154
0
votes
1
answer
64
views
What is the default number of items that are retrieved in the Get Items action and what options are there for getting more than 5,000 items?
The placeholder text in the Top Count field in the Get Items action says:
Total number of entries to retrieve (default-all)
That placeholder text communicates to me that, by default, it gets ALL ...
- 154
0
votes
0
answers
10
views
Create a reusable Flow which set different permission for the items based on the 10 status
I am working on a process which have 10 stages, each stage has a separate Submit button >> which change the status .
Now I want to create a flow which set different permissions on the items ...
- 57
0
votes
2
answers
43
views
Run a flow when document approval status = "Pending"
We have the following SharePoint document library:
Now we want to run a flow only when the user Publish the document (when its status is changed from Draft to Pending), so I tried this trigger ...
- 57
1
vote
1
answer
22
views
Duplicate emails being sent from Power Automate Flow. Using multiple Selectable column is issue
Hoping to get some insights / direction here. I posted on the community MS forum but no-one really help. I'm not very technical and have been battling for months to build a full solution anyways.
...
1
vote
1
answer
15
views
SharePoint Online Workflows
Can a SharePoint online List have more than one workflow associated with it, or is it limited to just one?
- 21
0
votes
1
answer
13
views
Linked lists: auto-create items
We need to split up information into multiple list, which are then linked in on "master list".
(sample image from internet)
In the sample our master list is "Orders", "...
- 149
0
votes
1
answer
11
views
Compare email From Email to Email in Excel File with different casing
I have a flow which monitors an inbox and when an email is received the senders email address is checked against a spreadsheet containing emails. If the email is found then an autoreply is sent to the ...
- 101
0
votes
1
answer
24
views
Exporting user's input to SharePoint list through Power Virtual Agents
Currently I'm working on task that demands creating a chatbot, that will save user input in SharePoint list. Bot has to ask user for details like First Name, Last Name, Date of birth etc. and after ...
- 25
1
vote
1
answer
59
views
How to create a flow when a SharePoint list column value is equal to name of file created in SharePoint folder and send that file in email attachment?
I want to create a power automate flow where i have a SharePoint list and when that list's column (filename) value is equal to name of the file in a specific SharePoint folder it will send email and ...
- 13
0
votes
1
answer
16
views
Conditionally trigger flow based on the previous value stored in the column
I have an OrderQuantity column in the SharePoint Online list, and I want to trigger the flow on the column value - For example, right now OrderQuantity has a value as '3', now if the user enters other ...
- 3,859
0
votes
1
answer
19
views
Add an Approved By Column and Approved by Date
I have created a Flow arround document approvals.
It is triggered when the document status is set to pending, and begins working through a normal flow (sent to approver etc etc.)
However what i want ...
- 3
0
votes
1
answer
26
views
Formula for 'No' Condition
I am using the following to update items in a SharePoint List whenever an Excel workbook in a SharePoint Library is updated.
If the condition isn't met, meaning rather than updating existing data in ...
1
vote
1
answer
44
views
Retrieve information from Lookup field (SharePoint list) in power automate
I am trying to create an automation in power automate, triggered when a table A is edited.
Unfortunately, multiples values of that table are lookups, getting their data in other tables.
When trying to ...
- 13
0
votes
2
answers
41
views
Which action we should use to add user to a security group (non-office 365 group) using Power Automate
We have some security groups inside our AD. Some of them are mail enabled the others are not. now we want to add user to those security groups using power automate.
So which action we need to use:
OR
...
- 57
0
votes
2
answers
41
views
Dynamic Site Address in HTTP request to SharePoint
I'm working on app that is giving SharePoint Users Groups as a result. Finally I finished almost everything - the last condition I have to complete is dynamic site address, so my app and flow could be ...
- 25
1
vote
1
answer
41
views
How to display result of HTTP Request as list
So finally I know how to get users groups using HTTP request to SharePoint in This question.
Now I need to display these groups as list in Power App. (Or it can be organized text).
The raw output ...
- 25
0
votes
2
answers
26
views
Contain function with double quotes
I need to find a string which has double quotes (") in it:
"userId": "xyz-bdd2-06870916684f"
within another string to use it as condition in a filter action. The userId is ...
- 149
1
vote
1
answer
78
views
Getting SharePoint Groups of User using HTTP Request in Power Automate
So currently I'm working on task, that will return all groups that user triggering the flow is member of.
I stuck on this:
My teammate gave me a hint, that this way is proper, but I need something ...
- 25
0
votes
1
answer
77
views
SharePoint List/Ticketing System- How to keep reply emails under the same Item
I recently just created a SharePoint list which I will be using as a ticketing system.
The idea is when we get an email send to "Ticket@outlook.com.au" it will produce an item in my ...
- 1
0
votes
1
answer
34
views
Replicating a 'vlookup' in Microsoft Lists
I'm looking for some help with a couple of lists I'm working with. Essentially I have a main list called 'Risk Events' which has an automatically generated ID for each item, and then another list ...
- 1
0
votes
1
answer
118
views
Writing to a multi-select person field with Power Automate "Create Item"
I've been pulling my hair out with this one all day.
I'm trying to write a flow to combine a bunch of Lists into one, that will run nightly to keep a master version updated by the child lists. All ...
0
votes
0
answers
8
views
Creating flow to act as Lookup
I'm looking at creating a SharePoint list with calculated columns, and need to work around SharePoint's limitation on column types. I have looked into creating a Flow to act as a look up. However, as ...
- 31
0
votes
0
answers
6
views
How to synchronise renamed files between Sharepoints?
I have a Flow which detects changes or creation of files in a repository and, after a filtering, copies them to a different Sharepoint, including metadata.
However I was informed that users in the ...
- 111
0
votes
0
answers
6
views
Can I create a dynamic entity?
I am trying to create a dynamic entity (list) on chatbot, I want it to be accessed by flow .
If an item been added to SharePoint , be added dynamically to the entity .
Is this possible ?
- 1
0
votes
1
answer
33
views
Adding a days to date column
I have a document library with two custom columns (Report Date) and (company name). One company name can have few different Report dates. Is there anyway we can get the highest date using Power ...
- 525
0
votes
1
answer
31
views
SharePoint Online Calculated Column
I am currently working in a Power Automate Flow that needs a calculated column that acts as a counter towards an expiration date to be compared in an if statement to send alerts to multiple users ...
0
votes
0
answers
49
views
Save Email Attachment Based on Received Date/Time Field in Outlook
I have emails that are routed to a Folder in my outlook. I get them multiple times a day as a status for the system. The email's contain an attachment which is the report.
I am trying to see about a ...
- 1
0
votes
1
answer
32
views
adding approved domains into white list via rest and flow
i have a flow that runs and it adds domains into the white list for a given site. The flow runs fine and the domain is added into the list. Issue is, when the user for a given domain logs in with the ...
- 17.8k
0
votes
0
answers
13
views
Power automate flow to get items and display them as Option
I want to make user choose between values that I get from SharePoint list using (Get Items) in Power automate flow.
Something like the photo but the values are variables:
Any suggestion?
- 1
0
votes
0
answers
9
views
Trigger when an user is added to a channel
I have a flow which trigger when a new user is added to team.
All I need is to detect when a new user is added to a channel from this team
- 1
1
vote
3
answers
893
views
How To Update Multi-value Lookup Column in SharePoint List using Power Automate
How we can update SharePoint list Multi-value Lookup Column using Power Automate Flow?
1
vote
1
answer
14
views
Approvals showing "Created by: [my email address]" instead of the user who is submitting the request
I am working on a Flow for a SharePoint list when a request for PTO is submitted, it will start an approval process.
I wanted to see if I can change the section of the email from the Approval that ...
- 13
1
vote
1
answer
365
views
Power Automate HTTP request to filter list by a column other than Title never halts
I'm using the "Send an HTTP request to SharePoint" action in a Power Automate flow. If I set the URI to be:
_api/web/lists/getByTitle('myListTitle')/items?$filter=Title eq 'Example'
It ...
- 13
0
votes
0
answers
38
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
101
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
22
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
45
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
...
- 57
1
vote
1
answer
141
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
280
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 ...
- 149
0
votes
0
answers
11
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 ...
- 13
0
votes
2
answers
133
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 ...
- 984
0
votes
1
answer
832
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 ...
- 984
0
votes
2
answers
744
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 ...
- 57
0
votes
1
answer
52
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 >> ...
- 984
0
votes
1
answer
252
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 ...
- 984
0
votes
0
answers
59
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