Questions tagged [flow]
Microsoft Flow is a public cloud service to help individuals and teams to set up automated workflows.
430
questions
0
votes
1answer
29 views
Power Automate Add new role definition using REST API
I'm trying to create a create role definitions i.e. custom permission level using Power Automate with below body in Send an HTTP request to SharePoint:
{
'request': { '__metadata': { 'type': 'SP....
1
vote
1answer
28 views
SharePoint Online - How to dynamically populate options in choice column using values from other columns?
I have a list in SharePoint online to manage transfer requests for students to move from one school to another. In my list, there are three columns (Area School, Alternate 1, Alternate 2) with the ...
0
votes
1answer
10 views
Extract the Name of the uploaded file into another columns with a flow
I want to extract the name of the file to another 6 columns.
For example, you want to put the "D" in the file name in the first column and the word "Berlin" in the second column, ...
0
votes
2answers
33 views
Update People picker column using REST API in Power Automate
How to update people picker column using REST API in Power Automate?
I have three people picker column in SharePoint.
0
votes
3answers
43 views
Update Managed metadata column using REST API in Power Automate
How can we update managed metadata column in SharePoint using REST API in Power Automate?
1
vote
1answer
17 views
Creating English-UK sites via Sharepoint Rest API
I am trying to create a new SharePoint Site collection via the REST API and trying to have that site be created using the English - United Kingdom Language rather than English - United States
I ...
0
votes
1answer
41 views
Formulating select statement in Flow within foreach loop
I fail using a select statement within a foreach loop of a flow.
The foreach loop is meant to iterate through a list of items retrieved from a SharePoint list. The get-items-operation is already ...
0
votes
1answer
34 views
Adding newly create group to “Site Permissions” section ( XXX/_layouts/15/user.aspx )
I managed to use Power Automate to create SP groups and add users to them using the HTTP request action.
The problem I have is the newly created groups are created at the "root" (in People ...
3
votes
1answer
23 views
Simple SharePoint Flow to Send Email Issues
I am at a loss of 4+ hours trying to understand why this flow will not work. I have SharePoint Library with a Yes/No choice column for whether a file Needs Updating that I want to trigger an email. ...
0
votes
1answer
19 views
How to remove specific user from item level permission through Rest API using power automate
I have a list with each list item has unique permission. Now I need to remove specific user from the item level permission using Power Automate.
I know there is REST endpoint for removing group but ...
0
votes
1answer
25 views
How to grant access to a sharepoint group using Power Automate 'Grant access to an item or a folder' action
I am using 'Grant access to an item or a folder' action to grant access to users at SharePoint list item level.
Now the requirement is to grant access to SharePoint Group as well. How can I pass the ...
1
vote
2answers
35 views
Attachment URL to column
Query is regarding SharePoint list.
Is there anyway I can get the attachment URL and add that to a new column using flow?
[
0
votes
1answer
28 views
Creating MS Teams site with PowerAutomate and adding owners to MS Teams site
I have flow in Power Automate via which we are creating a MS Teams site. While creating MS Teams site I can see the action 'Add a member to a team' and it works perfectly fine.
But I am not able to ...
0
votes
1answer
27 views
Copying data from one entry into a new entry in a sharepoint list
I wonder if you could help. I'm trying to create a log (of sorts) using a SharePoint list (i know it may not be the best option out there however its what i've been give lol). One of the things that ...
1
vote
2answers
50 views
Flow to add column data to a newly created folder
I have made a flow that creates a folder in a document library called "Maintenance" whenever a new record is created in a list called "Issues". The new folder has a "name"...
0
votes
1answer
45 views
Power Automate - How Can I Update a SharePoint List after Comparing Multiple Values from Another List
I have a list of vendors, Vendor Contacts, and I need to update their Agreement Status (Active/Expired/NA) based on another list, Contracts Tracker, that contain their Agreements/Contracts. A vendor ...
2
votes
2answers
32 views
Triggering Flow I'm not prompted for require variables
I'm triggering a Flow from a SharePoint library following this post, basically json column formatting with a customRowAction. That part works fine and I've used it many different times.
I'm using the ...
1
vote
1answer
26 views
Get Graph Drive Id from SharePoint library name
I'm trying to use some graph endpoints in a Flow to access a file in a library that isn't the default Documents library. I need to get the graph id for a file. All I'm starting with are the obvious ...
1
vote
1answer
48 views
Can't get the file extension in Flow
I can't get the file extension after Flow sends me an email. I searched through the web and saw that I can use metadata, but after I added metadata, there's a condition but the expression for the ...
0
votes
2answers
59 views
MS Flow - Approval Email - Markdown Table
I am new to MS Flow, I am creating an approval process where I have to send data in a table.
I have an array, which is
[
{
"Header": [
"Username",
"Hname&...
0
votes
0answers
29 views
How to get a Power Automate flow to stop updating after 1 item in a SharePoint list
New to SharePoint and Microsoft flow/Power Automate. I have made a flow that copies the sum of a calculated column (Summa) into a currency column that can display a sum (Total). The reason of course ...
0
votes
1answer
18 views
Different Levels of Approval using Power Automate (SharePoint Online)
I am currently developing a power automate flow for my company where we need a document stored in a SharePoint list to be approved at different levels of management.
Is it possible to write a flow ...
0
votes
1answer
22 views
Imported Flow can't update SharePoint file properties
I have created a Flow in a Library with my user and tried to export to another user to import.
Both users have the same permission level in the site.
The action to Update file properties does not work ...
1
vote
2answers
35 views
How to create a power automate on a Sharepoint List when a new item contains a certain value
I have a SharePoint list fed from MS Forms and I want to create a Power Automate alert when a specific response is received to one of the survey questions. Thinking an MS Teams notification.
At the ...
1
vote
2answers
47 views
Conditional Formatting with JSON - Write to Actual Value?
I'm pretty new to JSON.
I have a SharePoint list with employee schedules (shifts) as seen below:
My OnClock column uses the following to determine if (now) time is within the stipulated shift start ...
0
votes
0answers
24 views
Add a filter menu to the list page
I created Sharepoint - List as a stock list. I have a button in the column that sends a request for an item and at the same time adds a reserved flag to the item.
As a result of the search, ...
1
vote
1answer
13 views
Email not to use my details as on behalf
I have created shared mailbox for our team: TeamMail@inbox.com.
Currently I am trying to use it in one of my flows. Flow gets triggered when new item is added to list, there is a condition that if ...
1
vote
1answer
21 views
Get email from username by Flow
I have created a Sharepoint List with a button that triggers Flow.
In this Flow I want to send an email to the person from the column "ZapÅÆjÄeno - zo...". The name in this column is the ...
0
votes
1answer
46 views
How to set up service account to run PnP powershell scripts from backend from Flow from SP Online
I am doing SP Online development with SPFx. I have some PnP Powershell scripts I want to run from azure, but I want the end user to be able to trigger it from a flow from triggers like an item create/...
0
votes
1answer
51 views
Calculated Column and File Name 'Title' Field
I uploaded more the 2000 images files to an SP document library.
When I checked the 'See Details' under the file name property options, I noticed the actual name of the file appears in the "Name&...
0
votes
1answer
63 views
Is it possible to manually trigger a flow on list using SharePoint interface
I have an instant flow on a SP list, which accepts a parameter > Get Items > filter by the parameter and automatically creates some entries in other lists.
This flow works perfectly on flow....
0
votes
1answer
12 views
Create CSV Table and write to a CSV File - Missing Double Quotes
I am trying to write a CSV file from a flow, I have an array of JSON objects.
Output isĀ
I want something like this, I want to all fields in double quote.
I have more than 50 columns in total, some ...
1
vote
1answer
148 views
MS Flow is raising this error :- 'XrmSystemUserDisabled'. Error Message: 'The CDS system user record representing user is disabled
When the MS flow runs it raises the following error on a "Start and Wait for Approval" action:-
The request failed. Error code: 'XrmSystemUserDisabled'. Error Message: 'The CDS system user ...
1
vote
2answers
58 views
Assigned To Field - Power Automate
I am looking for a way to Manually enter a email address when I am about to start the flow - where as Approval process in flow contains a per-populated Assigned to field where I have to Mandatory ...
0
votes
0answers
16 views
Power Automate - add a new xml field to sharepoint list
I'm trying to add a XMLfield with a flow.
But I can't seem the pass the XML mark up in the correct format.
Screenshot 1: XML Markup
Screenshot 2: HTTP request
0
votes
1answer
16 views
Column can be evaluated in one Flow but not another
I'm accessing the Version of a list element via MS Flow. It works in Flow A accessing List X but not in Flow B accessing List Y. Both Flows are triggered by the creation/change of items in the ...
0
votes
1answer
50 views
Power automate: “send an http request to Sharepoint” token error
I'm trying to use a Flow to create news links in a modern site when a new post is published to an external site's rss feed.
It appears to get the JSON content correctly but the "send an http ...
0
votes
1answer
67 views
Add or remove Folder RoleAssignments not valid error
Having trouble with adding or removing Role Assignments on SharePoint document folders using REST API through Power Automate.
Process is to copy a Template folder with subfolders. Of which, 2 ...
0
votes
1answer
42 views
How Do I Copy An Item From One Sharepoint List To Another?
I am trying to manually move an item from one list to another.
The second list was created as a copy of the first list so it should have all the same columns.
ID, Title, Assignee, Due Date, Component
...
1
vote
2answers
71 views
Add Role Assignment using Office 365 group
Is it possible to use an Office365 group as the principalid for the addroleassignment function in SharePoint REST?
Trying to use Flow to copy a folder structure and then set permissions on some of the ...
0
votes
1answer
28 views
Set multi- “Person” field in list using HTTP request instead of “Create Item” in Power Automate
I'm trying to assign the value of column AssignedTo to multiple people, using data being read from another list with the same. I currently have this working with Create Item action, which requires ...
0
votes
1answer
56 views
Converting a SharePoint List Item to form format and print it
I want to retrieve an item from a SharePoint Online list (Office 365) and print it out in a form format.
I have looked at a few ways which involve using power automate and third party tools which such ...
0
votes
1answer
42 views
Convert Nintex workflow and InfoPath form to MS Flow and PowerApps form
Is there a tool or process that will allow the converstion of Nintex workflows and InfoPath form to Microsoft Flow and PowerApps.
My initial thought is no; I will need to re-develop the application (...
0
votes
1answer
26 views
How to use responses from a form and email the appropriate attachments selected from the form
I created a form that collects the email address of the users making the request and the email address where they would like to send the email. The third part of the form lists documents that are ...
0
votes
1answer
19 views
Power Automate Filter List items by person login name
We need to filter the list items by person login name (fully qualified i.e, i:0#.f|membership|xyz@abc.com),
How we can achieve this using Power automate GetList Items method or through REST API,
Any ...
0
votes
2answers
36 views
VLOOKUP type functionality in MS Flow and Sharepoint
It may be a simple question, but I want to use VLOOKUP-type functionality in my Sharepoint but I can't figure it out on my own and hours of browsing didn't help me as well.
I have a Document Library ...
0
votes
0answers
31 views
Updating a Node of an XML Form from a SharePoint List
I am currently working with a SharePoint list and an XML Form Library: List A and Form Library B.
When List A is modified, I want some data from the SharePoint List to be updated on specific nodes of ...
0
votes
1answer
237 views
How to format calculated column number in Flow
I am using a calculated column (number) in a SharePoint list, and putting the value into an email using a Power Automate Flow. The value will always be an integer.
When the value is passed through to ...
0
votes
1answer
172 views
Parse JSON elements of a list returned from a multi-choice column in Power Automate/MS flow
I am calling the SP API to get the version history of an item in my list as follows:
_api/web/lists/getbytitle('@{triggerBody()?['SPListName']}')/items(@{triggerBody()?['SPListID']})/versions?$top=20
...
0
votes
1answer
30 views
Send automated email when Sharepoint list column is changed
I'm setting up a flow to Send automated email when Sharepoint list column is changed to "Completed".
The flow seems straight forward. Flow seems to run but does not send email. Where am I ...