Questions tagged [flow]
Microsoft Flow is a public cloud service to help individuals and teams to set up automated workflows.
743
questions
0
votes
0
answers
8
views
Flow run-only permissions
I want some users with edit permissions to a list to run a manually triggered flow, and others not to be able. It looks like you can share run-only access with an AD group, but not with a SharePoint ...
- 21
0
votes
1
answer
13
views
Is there a way to refresh the targeted values in a sharepoint list field after workflow is finished?
Due to the limitation of using calculated fields on lookup columns, I created a flow on SharePoint Online to update a field with the value we needed from this lookup. Unfortunately due to human error ...
- 427
0
votes
1
answer
37
views
Power automate flow - cached data issue
In my flow I'm extracting data from excel file located on sharepoint and then I'm inserting it to sql server database, after that file is moved to another location. First execution is working fine, ...
0
votes
1
answer
146
views
Power Automate Document Library Nested Folders Recursive Dig to Document Name
I have a document library with a main folder and several nested subfolders. I'm trying to create a Power Automate flow that can navigate through these folders to retrieve the names of all the ...
- 155
1
vote
2
answers
55
views
Hyperlink column with icon instead of text in a classic SharePoint list
I created a Power Automate Flow that uses the SharePoint connecter, "Send HTTP request" to create a custom hyperlink using a dynamic list value. I'd like to use an image or icon instead of a ...
- 11
0
votes
1
answer
26
views
What type of AD/security group can I get members of when using Power Automate
I'm sure I can get members of a group from a SharePoint group and Office 365 groups.
Can I also get members from AD group or mail-enabled security group. We don't have power automate premium ...
- 4,308
0
votes
1
answer
410
views
Get items and get files (property only) Is just Returning Path in output not file names
The overall purpose of the flow is to add the appropriate metadata to the corresponding columns based on the name of the document located in an Excel file.
Steps:
The flow is initiated manually.
Upon ...
- 155
0
votes
2
answers
68
views
Azure/PowerFlow App (Get-PnPFlowRun/Microsoft.ProcessSimple) XrmApplyUserFailed Failed to create a representing user
Current system runs over user + plain password authentication.
2MFA is coming so I want replace it by client/secret solution.
I have did an app in Azure and things like read/write SharePoint is ...
0
votes
0
answers
97
views
Update a SharePoint list item based on another item in the same list
I'm attempting to update a SharePoint list item based on another item's value in the same list. The column I'm testing is called "EOP Response Documentation", which is multiline text. If ...
- 1
1
vote
1
answer
47
views
REST API filter by date giving "The expression is not valid"
I am trying to get a list of old files from our SharePoint online site via REST API but keep getting error:
"The expression is not valid"
I tried the following links with same error:
https:...
- 63
0
votes
1
answer
37
views
Power Automate Flow - Send an email if a SharePoint 'Proposal Date' Column = the current month
I have a SharePoint list with a proposal date column (SP column name is ProposalDate). I want to manually run a flow that will query the entire list, identify items with a Proposal Date this current ...
- 415
0
votes
1
answer
133
views
Ways to replace semicolon with comma or remove the semicolon
I have 10 document libraries with different numbers of records, from 500 to 20000.
Under the Invoice Tracking Text column, users used a semicolon to separate entries; however, for some reason, I ...
- 605
0
votes
0
answers
49
views
Update document library folder when SharePoint list attachment is modified/updated
I have a SharePoint list. The list contains separate rows of issues. Each issue requires attachment upload from the respective person. There is a separate document library mapped for each issue.
How ...
1
vote
1
answer
31
views
Join multiple mails from output to send for approval
I have multiple person in approve list. My output result is:
[
{
"": "[email protected]"
},
{
"": "[email protected]"
}
]
I need to format it as:
...
- 13
0
votes
1
answer
587
views
HTTP POST request to add Image to SharePoint List
I have the following image in a SharePoint library:
I wish to insert this image into an Image Column as part of the metadata of a List called QSAR Analysis Data.
TEST Flow to try and achieve this I ...
- 105
0
votes
1
answer
13
views
How to do one GetItems call to SharePoint then filter the items inside the workflow
I have this SharePoint list named "WorkFlow Groups", which contain title and email, as follow:
Now I want to do a call to get all the items, then filter the items by the Title to get the ...
0
votes
1
answer
16
views
Standalone Power Automate per user plan for Premuim connectors
I need a connector to be able to call any HTTP endpoint to retrieve some data and push them to SharePoint.
I'm looking at the HTTP connector which is a premium connector
I was thinking of going for a ...
- 4,308
0
votes
1
answer
91
views
Error in Power Automate, When a item is created or modified
I have a flow that is executed when a SharePoint item is modified. The list it refers to has a hidden lookup column, but when the flow step is executed, it fails in the trigger, it says:
The query to ...
0
votes
0
answers
20
views
Lookup Equivalent - Display Results in HTML table
I currently have a flow that scrapes bookings made (from MS Bookings) into an Outlook Calendar and prepares a HTML table that I can then email to people or use in different reports.
Outlook previously ...
0
votes
0
answers
13
views
SharePoint Calendar Auto reject
Looking to auto reject an item created on a SharePoint calendar if the item created is less than a 24 hours from the current date/time. Please advise.
- 3
0
votes
0
answers
831
views
Workflow error 'ActionBranchingNot Satifisted
Can you explain to me this error am getting on my workflow:
'ActionBranchingConditionNotSatisfied. The execution of template action 'Send_an_email_(V2)' skipped: the branching condition for this ...
- 1
2
votes
1
answer
632
views
How to include a link to a supporting document in "Start and wait for approval"
I have created a document approval workflow in Power Automate for a SharePoint Library. This is working fine.
I now want to add a link to a supporting document which could be 5-20MB in size (from ...
- 23
0
votes
1
answer
848
views
Condition to check if output contains any Text
I have a flow that triggers when a new form is submitted. I want to use a condition to check if a certain question has any text or symbol in it.
- 37
0
votes
1
answer
386
views
Errors in flow to allow multiple choice in a form to be saved in a list
I have viewed numerous solutions to convert a multiple choice question in a form to separate variables in a list.
I used this one: https://www.intelogy.co.uk/blog/how-to-populate-a-multi-select-column-...
0
votes
0
answers
146
views
Do Until inside automate Power Automate never end
I have this Do Until, where I am checking if a variable named i = Frequency. but the do until never ends:
Although the Frequency is a SharePoint number field.
Any advice?
1
vote
2
answers
268
views
How to configure a custom list form header using SharePoint Rest API
How to configure a custom list form header using SharePoint Rest API?
It can be done using GUI : Configure custom header but I am interested in doing the same using Rest API calls from a flow.
- 13
0
votes
1
answer
314
views
Create subfolders when a new folder is created
I have a problem with a flow, there are errors at the 'Create Folders' stage. I'm getting a bad request error message (see the Flow Errors header below).
The flow is meant to use an array that ...
- 2,215
0
votes
0
answers
467
views
Eliminate duplicate flow run in power automate
I am facing unbearable problem with the flow in power automate. Previously my flow worked perfectly without any problem. But recently, all of my flows keep running twice every time after the trigger ...
- 1
0
votes
0
answers
1k
views
Power Automate Trigger Conditions for specific column in SharePoint list
I have a SharePoint list that I want to trigger the flow by using Trigger Conditions when the specific column value changes.
The flow triggered when the Current Status changed to Approved but the ...
- 37
1
vote
2
answers
152
views
SP List - JSON to change font for column list entries
I have a Power Automate flow set up to copy email to a SP list, the column is set to rtf so that the list just has the email body rather than all the (I'm guessing) HTML stuff plain text gives but I'd ...
- 13
0
votes
1
answer
324
views
Power Automate Starting Multiple Flows and sending multiple emails
I am attempting to build a flow that
When an item is created or Modified
It gathers email addresses using an HTTP request
Does a select and join action to parse out an email address from a SP group
...
- 155
0
votes
1
answer
25
views
Need Help with Flow for a sharepoint list
I have created a flow with a conditon
CONDITION if Company Name = CACI, Inc., send email with attachment. It only is successful for the "yes" side. I have read online for hours and not ...
- 1
1
vote
1
answer
70
views
Add 3 conditions to an actionParam from JSON
I have managed, somehow to add 2 conditions for an "actionParam" in JSON.
Now I would like to add an extra condition.
Please can anyone help me?
Thank you!
{
"$schema": "...
- 11
0
votes
1
answer
135
views
Is there a way to make a SharePoint sharing link into an attachment or something nicer instead of an URL in Power Automate?
Just as the title states can I make a sharing link to SharePoint look nicer in an email which I am automating through Power Automate?
0
votes
1
answer
446
views
Power Automate Trigger Condition
I have created a simple SharePoint list with two columns: job Number and comment. An email will send out if the job number is not null.
However, if the job number is not null and someone updates the ...
- 605
0
votes
2
answers
492
views
Get doc library ID from trigger
I want to place the GUID for the library specified in an automated flow trigger into a variable. This variable will then be passed to a child flow.
The trigger is "when a file is created or ...
- 202
1
vote
1
answer
1k
views
flow that sends email: concatenate existing attachment items with an array of variables - is it possible?
I have a flow, whose final step is to send an email. The attachments field/-s can be populated by specifying individual attachments, or by specifying an array of variables (in case the number of ...
1
vote
2
answers
398
views
how can I break inheritance on a particular document/file in Sharepoint Library using MS flow?
I made a flow which is triggered when file is created .I want to break inheritance on document and clear all permissions from every user.
- 39
0
votes
1
answer
2k
views
I have a flow that is running twice so i get two emails and am not sure where the issue is
I have a flow that is running twice. As soon as i put the details on the form, the flow is running twice exactly at the same time and am not sure how to troubleshoot this to find which step is ...
- 3
0
votes
2
answers
893
views
"When a file is created or modified (property only)" with 3 trigger conditions will never run
I have this document library named "Customer Share" and inside it, it contains "Clients" folder >> then inside the Clients Folder we have clients sub-folders.
Now I want to ...
0
votes
2
answers
9k
views
Power Automate - Get value of one column from array created by Get Items
In my flow, I need to get the value of a specific column (ApprovalType) for an item in a SharePoint list.
First, I use Get Items with a filter query which gets to one item. This produces an array. ...
- 202
0
votes
1
answer
61
views
Does creating a child flow that is called from an automated flow create a security hole inside our tenant
We have a solution which contain 2 flows:
"SetPermission" is an instant flow which runs using the service account context,as follow:
While "WhenItemIsCreated" is an automated ...
1
vote
2
answers
508
views
Use variable in expression:
I would like to add a dynamic variable in addDays function named Czasookres his value is equal 14 days.
How can I insert this variable and is that possible ?
Examples:
addDays(utcNow(),Czasookres) - ...
- 11
0
votes
1
answer
47
views
licensing requirements to use PREMIUM connector when calling workflow after adding SharePoint item
We want to create a workflow which use this Premium action:
The workflow will run as an automated flow when a SharePoint custom list item is created >> where the workflow will create a document ...
0
votes
1
answer
278
views
Power Automate permissions to create item in SharePoint list
I have an Instant Workflow with the following setting:
SharePoint
Run-only users will be asked to provide their own connection to this connector.
I have a 'Create Item' action in the workflow with a '...
- 1,535
0
votes
1
answer
139
views
Need to remove a part from Power Apps Output
I have made a power app which returns a list of Email Address of SharePoint owners.
I need to remove the part of email and curly bracket from the output (Please refer image). How to do that?
1
vote
1
answer
1k
views
Composing and selecting Data from odata Output in Flow
I have used Power automate flow to return O365 group owners using Graph API. It has returned data in @odata.context. From that output I need only "Email" field so I can send it to Powerapps ...
0
votes
2
answers
1k
views
Need to use Graph API to get SharePoint site owners in Power Automate
Need to use Graph API to get SharePoint site owners in Power Automate. Able to achieve it through REST API but not finding Graph API to fetch the SharePoint owners of the site.
Can you guide?
0
votes
1
answer
89
views
How i can dynamically build part of a string array inside Compose
I have this JSON array which I am passing as part of an http request body:
Here is the string:
"peoplePickerInput":"[ { \"Key\":\"@{items('Apply_to_each_-_Certificates_2'...
0
votes
2
answers
578
views
Service account with MFA enabled , how to transfer the membership/ownership to the client after completing the project
I am working on a project for external client >> and I needed to create some SharePoint lists, solutions & Power automate flows.
Now they gave me a service account username/password, and the ...