Questions tagged [flow]
Microsoft Flow is a public cloud service to help individuals and teams to set up automated workflows.
550
questions
0
votes
1answer
17 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 ...
0
votes
0answers
16 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 ...
0
votes
1answer
14 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 ...
1
vote
2answers
31 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 ...
0
votes
0answers
29 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 ...
0
votes
0answers
20 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
1answer
8 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 ...
0
votes
1answer
10 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 ...
0
votes
1answer
13 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 ...
0
votes
1answer
21 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
0answers
9 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
vote
1answer
60 views
/_api/web/sitegroups/GetByName('GroupName')
We want to have a form in which a site member can request to add a team member, which is then automated.
In power automate we need the ID of the group:
/_api/web/sitegroups/GetByName('Test IRE Site ...
0
votes
0answers
15 views
How to store news post's banner image to OneDrive using Power Automate?
I am trying to store news post's banner image to OneDrive.
My flow runs when an item is created into the site pages library. I do get the banner image URL using the flow but not able to find a way to ...
0
votes
1answer
47 views
The property '__metadata' does not exist on type 'SP.Field'
I'm working on a flow that needs to create a column in a SharePoint library. I'm using the SP REST API for this. When I send start the I send the API request I get the following error:"
The ...
0
votes
1answer
29 views
Looking to trim leading and lagging spaces from Title column in a Sharepoint list
So I'm trying to integrate Power Automate into our SharePoint workflow to create a folder with the same value as the value inputted into the Title column of our SharePoint list. The flow failed today ...
0
votes
2answers
73 views
Which license inside Power automate allow the service account to run more than 5000 items inside Apply to each
Currently our service account has this free license for power automate, and hence inside any Apply to each we can not process more than 5,000 items:
So what is the minimum license needed to be able ...
0
votes
1answer
33 views
InvalidTemplate. 'The number of foreach items limit exceeded for action 'Apply_to_each_3': maximum '5000' and actual '5994'.'
I have the following MS flow which Search for Users >> then for each use get its info from AD:
Now the flow is working well, except that we are not getting all the users from AD. So i defined a ...
0
votes
1answer
20 views
Power Automate MS Flow Email Issue
I have created a flow that sends an email when a new list item is created, via the mail connector, not the outlook connector.
When the user receives an email there is a message in the bottom of the ...
0
votes
1answer
27 views
Create a task in SharePoint Task list using PowerAutomate Flow
I want to create an item in task list of SharePoint from PA Flow. The issue i am getting is with "Assigned To Claims" field. I am unable to assign any user in this field. Can you please ...
0
votes
1answer
24 views
Apply a Custom Filter for a List View
So I came across the following post on Filter a list view using URL parameters, which is sort of what I was looking for but not at all at the same time.
I have a custom DataTable on a SharePoint Web ...
0
votes
2answers
21 views
Change email Display name power automate flow
Looking to see if there is a way to modify the display name on an email sent via a flow?
Using the "Send an Email (V2)" function. In the "From (send as)" field I chose the double ...
0
votes
0answers
7 views
Many to One Relational Update Flow
I have a 'TrainingList'.
The 'TrainingList' has columns titled Location, Member, ComplianceStatus.
Each Member may appear once or many times on the 'TrainingList', consequently, each Location name may ...
0
votes
0answers
8 views
Finish Automated Update List Flow
The following returns a table (from the ComplianceList) of locations ('Title' column) that are "Noncompliant" ('ComplianceStatus' column).
I have another list ('ParkComplianceList') that has ...
2
votes
1answer
34 views
Automatically click button when site is created
We use a SharePoint app to sign documents in our SharePoint sites. On each new site the app needs to be activated by simply clicking on two buttons. We use a lot of sites in our SharePoint environment....
0
votes
0answers
15 views
Automatic Flow that Updates List
I have a 'ParkComplianceList' - which tracks location compliance based on the 'ComplianceList'.
I have a 'ComplianceList' - which tracks the compliance of one or more systems at each location in the '...
0
votes
0answers
21 views
Sharepoint online APIs, how to get all the users, the list they have access to, and the group they belong to
Is there any rest API or a set up of rest APIs that allow us to get all the users, the list they have access to, and the group they belong to,
The output can be something like the below table:
Users , ...
0
votes
2answers
23 views
Create Alert when an user creates a new SharePoint Online site in Office 365
Is there a way to create an alert that lets me know when an user creates a new SharePoint Online Site?
0
votes
1answer
13 views
When I put a file (.pdf) in a sharepoint folder, I want it to go in a folder automatically created with the same name as the file
We have a folder named "X". When I put a .pdf named "human" into "X", I want a folder to automatically be created named "human" and it contains "human"...
0
votes
1answer
81 views
Sharepoint to Sharepoint - Power Flow: How to update "manager's name" based on user's name in the *same* item when item is created or modified?
My Objective:
I am trying to auto populate manager's field using flow at preview.flow.microsoft.com in a SharePoint lists. How can I achieve this
1- Add or modify item like below
2- Enter user's name
...
0
votes
0answers
41 views
Error in Microsoft Power Automate while exporting the App
I am getting this below error while exporting Power apps Canvas app. I know it's related to some permissions but I am the co-owner of this app. Do I miss anything on this?
Can anyone help me to solve ...
0
votes
0answers
30 views
How to copy SharePoint files including folder structure (nested subfolders and files) with Power Automate
I'm stuck with what I think it could be a simple flow.
I'm trying to copy SharePoint files including folder structure (nested folders and files) within site using power automate, i.e. Backup one ...
0
votes
1answer
37 views
PowerAutomate Flow query lookup threshold issue SharePoint
I am trying to use get item action in my flow to fetch data from a SharePoint list having 3000+ items.
I am getting lookup column Threshold error while fetching the records even if only 2 lookup/...
0
votes
1answer
64 views
Update item in a SharePoint list from another SharePoint list
I have two SharePoint lists: List A and List B.
Both lists have a column with a special number called VHE (text column) and a column Date.
The Date column in List B is still empty and I would like to ...
1
vote
1answer
26 views
SharePoint Online - Archival Process besides Export to Excel
We have a SharePoint online list where we have users filling in a "new request" form (power apps customized form).
Then an approver edits the form to add their details and then a processor ...
1
vote
2answers
263 views
Performing a 'Get Items' action on a list with an 'Image' column causes error: "The required field "My Image" data type is not supported"
Flow was working fine until I added a column of type Image to the SharePoint list.
(I was hoping to be able to get the image and send it in an email etc).
But now the Flow fails at the Get Items ...
0
votes
0answers
32 views
Can you add sorting and filtering to SharePoint List views using the send http to sharepoint/rest api
I am trying to create a list view with sorting and filtering on using the SP rest API and send http to SharePoint action.
I have added a CAML query to the View Query parameter in the body of the send ...
1
vote
1answer
51 views
Can we use Power automate to automate creating new users inside Office 365 and assign them list of groups
I received a request to create a Power Automate flow for HR managers as follow:
The HR Manager will add the user name inside a SharePoint list >> then the flow will automatically start
The ...
0
votes
0answers
27 views
Get SharePoint subsite permissions groups/user list
I would like to know who has the access to my SharePoint site using MS flow.
It can be granted the permission to a person or to a group.
How do I get all information by using flow? any API?
0
votes
1answer
217 views
What mailbox features are required to 'Send an email from a shared mailbox' in Power Automate?
I am preparing an I.T. request to create a new Shared Mailbox so that we can send automated emails via Power Automate, specifically using the Send an email from a shared mailbox (V2) connector.
I want ...
0
votes
0answers
16 views
Simple JSON to CSV in MS Power Automate problem
I am trying to convert the following JSON using the URL: https://api0.solar.sheffield.ac.uk/pvlive/v3/pes/0 to CSV vis MS Power Automate.
I use HTTP to get the response from above URL.
And this is ...
0
votes
1answer
25 views
status of approval mail doesn´t change if in person field is a group as approver
In my flow people can choose also groups as approver. everything works as expected just the mail in the inbox of the approvers doesn´t change in approved o rejected after approval.
If the approver is ...
0
votes
1answer
18 views
Are the AI Model's Form Processing inside power automate is provided as part of the office 365 licenses, or we need to pay extra fees
We are planning to use the Form Processing AI model inside Power Automate >> now most of our users have E3 office 365 license, where they will be uploading documents to a SharePoint document ...
0
votes
1answer
76 views
Flow number condition returning false
Flow condition is returning False, even though the condition is actually true.
Condition: if Total score is greater than or equal 7.
here is a full flow picture
Any ideas?
0
votes
0answers
26 views
Automatically capture date and time when list item status changes
I'm using a SharePoint list to manage tasks in my company. I have a choice column in my list that specifies the current status of my task. The process that my tasks need to follow are as follows:
...
0
votes
1answer
12 views
Is this type of integration supported by Power Automate (Power automate calls local API then Power automate calls SharePoint online)
We have a local API that is not exposed to the internet.
So my question is, can we call this API using Power Automate and then send the API result to SharePoint online? or to be able to call an API ...
0
votes
1answer
253 views
Will Power automate support getting more than 5,000 items from SharePoint, and can we apply paging?
I have a document library inside SharePoint where the document library contains 1 million documents. Each document has an expiry date.
Now I want to create a scheduled flow which runs daily and get ...
0
votes
1answer
48 views
Parse JSON elements of a list returned from a multi-choice column in Power Automate
How can I parse the below JSON in power automate to get the value of multi choice column 'MyChoice'.
I am trying to parse it using expression body('Parse_JSON_2')?['d']?['result']?[1]?['MyChoice']?['...
2
votes
1answer
105 views
Creating a space in SharePoint list column - by creating a syntax for the Dynamic Content combined within Flow
I have created a Microsoft Form that has two separate questions 1. First Name and 2. Last Name.
Then I created SharePoint list where it mirrored the answers on the form, after I created a Flow and ...
1
vote
0answers
51 views
Subtract amount from one column to another column on a site based on expense code
I am fairly new to SharePoint online and Power Automate and looking for a solution to do the following:
I have two lists
List 1: Budget name, Expense Code, Allowance and Total Budget available.
List ...
0
votes
1answer
47 views
Average score per student in a Sharepoint list
I have a SharePoint list which is a feedback score dump from PowerApps. The PowerApps has a drop down to select which student email(out of many) they are scoring.
Every entry is a new row in the ...
