Questions tagged [flow]

Microsoft Flow is a public cloud service to help individuals and teams to set up automated workflows.

Filter by
Sorted by
Tagged with
1
vote
1answer
21 views

MS Flow stops working when I update the file in SharePoint

I have a MS Flow that updates a list in SharePoint from an Excel file that I manually upload. Whenever I upload a new file, the MS Flow stops working, see, inside the Excel file I have a table, that I ...
0
votes
1answer
2k views

SharePoint List - Get Manager Information

I have a SharePoint List with 2 columns (people or group) this list is to track users who make error in their job and we want to inform the user and his/her manager. Column 1 – user who made an ...
0
votes
1answer
9 views

Sharepoint list entry & flow

SharePoint list entry disappears after flow is completed. It is not going pass 'when an item is created'. SharePoint and list ID are correct. Checked the obvious. It has been running ok and after ...
0
votes
1answer
15 views

Get IDs of all List Items in a list and compare them to another List to sync deleted Items in SharePoint List

Using SharePoint Designer workflow or Flow how can I get IDs of all list items in a List and compare them to IDs of list items in another List so that we can sync the deleted items I am able to sync ...
0
votes
1answer
27 views

sharepoint button flow only runs for Owner

I have a button flow I've added to a SharePoint list. The button flow is triggered by a "manual trigger" action. It is a parent flow that calls a child flow via an http request. This ...
0
votes
2answers
25 views

How to create a SP List from a SP List template with Power Automate?

How can I create a Sharepoint list from a Sharepoint list template with Power Automate? This below is what I got so far. But how can I specify the list template?
1
vote
1answer
26 views

Power Automate flow, creating list item via http request using more complex columns than single-line strings

Working on a Sharepoint/Power Automate situation that is causing some issues. I have an automation that copies multiple of a certain file type to a list for easier processing. The users upload a main ...
0
votes
2answers
19 views

how to send an approval in one flow and getting response in another flow

I have a scenario like I have to send approval of 30 documents at a time, but in my case I am sending an approval and waiting for that response to send an approval email for next document. So second ...
0
votes
1answer
10 views

Questions about an article “how to create a flow in PA to change a value of column ”Modify by" in a SP List

I have an article that shows how to modify a value in the column "Modify By" of a SharePoint List with Power Automate. I have a question regarding about the flow: http://johnliu.net/blog/...
0
votes
1answer
2k views

Using flow to get folder metadata

I'm using SharePoint to track assets, and each asset is configured as a "Document Set". This allows me to set properties for each set of documents at the Folder level, such as manufacturer, required ...
0
votes
1answer
36 views

Trying to import an Excel table into an existing SharePoint List, but having difficulties

So I have a SharePoint List that contains a column that holds a special ID. Let's call it orderNumber. Then I have 2 other columns (lets call one Car and the other Color). Now, both these columns are ...
1
vote
0answers
32 views

Updating column entry for List folder based on column entries for Items in folder

I"m very new to both SharePoint & Flow, so I appreciate any help on this issue. There is probably a better way to accomplish this as well, so any other directions you could point me would be ...
1
vote
2answers
776 views

Advice sought to build Workflow to automate Scheduled Document Reviews in SharePoint

I'm new to using and setting up workflows in SharePoint so hoping for some direction - hopefully, I make some sense! My company has a library of documents, such as Procedures, Forms etc on ...
1
vote
1answer
41 views

Hyperlink column with with icon instead of text

I have a list with with a hyperlink column that contains a hyperlink to a folder associated with the list item. I created a Power Automate Flow that used the SharePoint connecter, "Send HTTP ...
0
votes
1answer
62 views

Using a Flow to Import Excel Data into an existing SharePoint list

So I have an existing SharePoint list which contains a column that holds a special ID. I have an excel sheet that has a column whose data is dependent on that ID. ex. If the Id is 1, then the ...
1
vote
1answer
35 views

How can I create a power automate flow to delete folders in SharePoint with a certain size?

I am trying to find a way to create a flow that will delete folders in SharePoint but with a certain condition. I need the folders to be for example 10 KB or less in size. Can anyone help please?
0
votes
1answer
23 views

Sharepoint List losing item level permissions after adding permissions are granted

I have multiple lists with specific item-level permissions. Two different kinds: The default "Users can only read/write items which they created" toggled on Specific item-level permissions ...
0
votes
0answers
7 views

select a line or Tuple of a List and insert itnto a to another List on Sharepoint

I have two lists. a Menu list with the attributes Date, Vegetarian, Carnivore, Salad and another list "Order". which allows you to order a complete meal. I am new to Sharepoint and would ...
0
votes
1answer
52 views

Any way to do a draw from a filtered SharePoint list (multiple random items)?

I have a list in SharePoint online where I want to filter on several columns and then select a specific number of random items that meet the filter criteria. Is this possible? For example, I may have ...
0
votes
2answers
35 views

Update item flow

I would like to set up a flow so that when a choice column changes to a certain value, it triggers a flow to update a column on a different list. I included destination ID column entry so that the ...
0
votes
1answer
19 views

How to change the “creator” of a Flow in Power-Automate and of a Team in MS Teams?

Basically these are two questions, but they belong to each other. First question: We've made the experience, that a creator of a team (the one, who created it) is still the owner of a team when we ...
0
votes
1answer
11 views

Complete task planner flow

SharePoint list item has 5 actions, which are sent to a planner task with flow. No issues here. Next flow, when a task completed change column status to completed. The issue is, if only one action is ...
0
votes
1answer
2k views

Update item when file is created in folder which is created with FLOW

I've got a list A. When an item is created, a folder is created in library A. When a file is created in one of the folders in Library A, the item (which triggered the folder) from List A must be ...
0
votes
1answer
18 views

Change SharepointOnline site description with api call to Sharepoint

I need to change the description of a SharePoint site with a Power Automate flow. It is a really easy task with SharePoint online, it is kind of a nightmare with api call action "Send an HTTP ...
0
votes
1answer
22 views

Don't Automatically Open File Upon Creation in Document Library

I have a document library in SharePoint Online. I want to automatically populate the documents in the library with some metadata upon file creation using Flow/Power Automate. The problem is that ...
0
votes
0answers
24 views

Update JSON Property Value Inside Array - Power Automate

I'm trying to create list/library template using Site Script API in SharePoint Online through power automate. Below is the site script JSON of library and associated lookup list { "$schema"...
0
votes
1answer
501 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
0answers
22 views

Filter Object Array - Power Automate

I'm working on Power Automate to add users in O365 group. When I'm trying to add if user already exists as "user exists already" so to prevent adding further just checking if user is already ...
0
votes
1answer
836 views

How to return an existing column value from sharepoint to flow?

I am creating a flow using ms forms in which when an user submit a response with 'x' value it should fetch the corresponding column value for the [articular 'x'value both of which are already stored ...
2
votes
2answers
8k views

Conversion of csv file to xlsx via Flow or SharePoint

I have a Flow to store email attachments (in .csv format) to SharePoint. Now, I want to use the file in Power-BI from SharePoint. However, I want the file in .xlsx format. Could you please suggest how ...
0
votes
1answer
37 views

Power automate: “send an http request to Sharepoint” 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 ...
1
vote
1answer
1k views

How to link two Sharepoint Online list together?

I have the following table "New" and "Invoice Test". "New" list is essentially a PO List. So, the current process is, I input company, title, amount and status in the "New" list. Then, I populate ...
0
votes
0answers
26 views

Sharepoint String Column being set as boolean

I have a PowerApp that submits all fields to a PowerAutomate script via JSON. For my Yes/No fields, I set the value of the JSON objects to the strings "Yes" or "No" rather than ...
0
votes
2answers
1k views

Parse the JSON in Power Apps

I have below output from flow to Power Apps. [ {\"Name\":\"GHI.docx\",\"Path\":\"/Cont/A/GHI.docx\"}, {\"Name\":\"Tes1.docx\",\"...
0
votes
1answer
56 views

Copy whole column content into array (Power Automate)

I want to bring every value of a SharePoint List column to an array. At the moment I'm using an 'Apply to each' connector to iterate the whole column and then use the 'Add to Array' connector to fill ...
1
vote
4answers
3k views

Send HTTP Request error in Flow (Invalid JSON)

I am creating a flow right now that will create pages every week. The thing is, im using the "Send an HTTP request to sharepoint" to create the pages. Below you can see that part: The problem is, ...
0
votes
0answers
12 views

html coding of combo boxes in PowerApps and SharePoint

I have created a PowerApp that is connected to a SharePoint list and am attempting to create a button that will print to pdf as PowerApps has not created such a thing yet. I have added the button and ...
1
vote
2answers
36 views

Creating a custom control/action for a document library

I am wondering if it is possible to add a custom control/action for files in a document library in SharePoint. For example, when I select a file or click the ellipsis for a file I get the options to ...
0
votes
0answers
11 views

analyse calendar with Power Automate

For every day I want to analyse the entries of a calendar. To pick all appointments from a calendar is the easy part. I just do a getItems on my calendar with an appropriate OData-Filtering. Now ...
0
votes
0answers
21 views

Upload Excel File from Local PC to Network Drive via PowerApps/Flow

I want to upload excel files to Network Drive from Local PC by using PowerApps ( Attachment Control ). is there any particular way to do this?  I am actually stuck on this requirement by the client as ...
0
votes
1answer
11 views

assign column entry to a planner bucket

I am setting up this flow. When a SP new entry create a planner task. The issue I have is that on the planner I have buckets set by location. The entry column on SP is site. I need to send actions ...
0
votes
2answers
51 views

How do I create an array of text email addresses to send a message from Flow?

I have 10 text fields in my SharePoint list which may contain: An email address A note of "Email Missing" if an address is expected but not available Null/empty I want to send an email to ...
0
votes
1answer
16 views

Update Item Action error in Power Automate

I have a SharePoint online list with approval mechanism set through Power Automate. Now While executing the "Update Item" action I am getting below error: The query cannot be completed ...
0
votes
1answer
30 views

Remove Role Definitions From SPO Group - Power Automate - MS Flow

I'm trying to remove full control role definitions from Site Owner Group, because I have added another permission level through Power Automate/MS Flow. From Microsoft docs - Below is the syntax for ...
0
votes
2answers
30 views

Creating a Flow vs. Using Lookup Columns in SP List

I have two lists MemberList and MemberCertsandQualsList. Both lists share several common columns: Location Alpha Location Name and No. Location Region Location County, etc... I have a Patch in Power ...
0
votes
1answer
31 views

Copy file option successfully but it is not retaining the version history - Power Automate - MS Flow

I have used the Copy file option successfully but it is not retaining the version history in the destination. For ex. if I copy Document1 from x library in site collection 1 to y library in site ...
0
votes
1answer
22 views

Power automate nested switch does not display option of adding new actions under 5th level switch

I have a workflow where I have multi level (7-8) of approvals with one by one level at one point of time. In one branch [Case 1] of root level switch I am able to nest up to 6 more switch statement ...
0
votes
2answers
18 views

How to set System account as value to SharePoint people picker field using power automate?

I want to set the people picker field value with SharePoint online default system account using power automate. Please guide to achieve the same.
2
votes
2answers
1k views

Microsoft flow - Get First Char from File Name

I have a form that creates .docx files from a form / word template. User inputs Firstname = Joe Lastname = Dirt Then a file is created "Joe Dirt - New Hire.docx" I like to find a way to get the ...
0
votes
1answer
2k views

Flow to delete files in SharePoint sub folder completes but files not deleted

I created a Power Automate flow to delete files every 5 minutes from a subfolder in a document library. It runs successfully but does not delete any file. Below are the two flows that I tested, none ...

1
2 3 4 5
10