Questions tagged [microsoft-flow]
Microsoft Flow is a tool to create automated workflows between your favorite apps and services to get notifications, synchronize files, collect data, and more.
185
questions
0
votes
0
answers
32
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
34
views
How to automatically populate and update a lookup column based on a condition on sharepoint?
I have 2 lists:
List A:
List B:
I want to extract all the Projects from List A and display them in ProjectsList column in List B where:
LinkTitle(List B) = Company (List A)
At the end, I want the ...
1
vote
2
answers
61
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.
- 37
0
votes
0
answers
80
views
Export the large dataset into Excel file using power automate
I have large dataset which is having more than 50000 items. Need to export that into excel file using power automate. can some one suggest me on this?
- 77
0
votes
0
answers
35
views
how to send a single email to all user using ms flow
I want to create a flow in which I can send a single email to all group members.
E.g: There a 4 members in a group:
Test1 user
Test2 user
Test3 user
Test4 user.
If I send the email to group then ...
- 21
0
votes
0
answers
85
views
Using power automate - creating random pairs of people from an excel table and emailing them
I have an excel file on OneDrive with a list of employees, and I want a flow that every monday creates pairs of people which are emailed with the simple suggestion that these two people get together ...
- 1
0
votes
0
answers
29
views
How to post video file in yammer through Power automate or Stream?
How to post video file in yammer through Power automate or Stream?
Please help me to post the video file along with text in yammer through Power Automate or Stream embedded.
I have tried with embedded ...
- 41
1
vote
2
answers
260
views
Power Automate Flow Save Failed with code 'InvalidVariableInitialization'
I've created a scheduled flow and added initialize variables to format how the data shows in my email notification. This works fine in my other flow - when a new item is created. But for this ...
- 25
0
votes
0
answers
1k
views
Best way to format null dates when using power automate to transfer excel rows to SharePoint List?
I’m needing a flow to complete these actions:
List all rows from an excel file
Put the values stored in each of the Excel rows and put them in a SharePoint List
If a row is already in the SP list, ...
0
votes
0
answers
135
views
Sending multiple approvals in one email to one approver ONLY
I have set up a nintex form to record timesheet entries of employees. Once these timesheets are submitted, I want to send them for approval from their manager. However, I'm not interested in sending ...
- 1
0
votes
2
answers
201
views
Query more than 8 Lakhs (0.8 million) documents from SharePoint Online document library using Power Automate
I have a document library with the document set content type and document content type in it. In the document library there is more than than 8 Lakhs (0.8 million) document. In the "My Document&...
- 4,034
0
votes
1
answer
632
views
Sharepoint Create Incremental Unique ID with Concatenation
I am a newbie in power automate.
I have managed to have the flow working from collecting data from Microsoft Forms to create an item in Sharepoint List.
Now, I have these 2 columns
Requisition ID: [...
- 1
0
votes
0
answers
165
views
Power Automate Flow that retrieves the name of a column in a sharepoint list
I'm creating a flow that alerts users whenever they have an expired certification inside a SharePoint list. When it comes to the part where I need to send the email to let the user know I can't find ...
1
vote
0
answers
338
views
Changing work item type in DevOps once the state of the work item changes to 'done' using Power Automate
I am trying to automate a manual task in DevOps using Power Automate which is updating the work item type 'forecast' to 'task' when the state of the work item type 'forecast' is changed to 'done'.
I ...
- 79
0
votes
1
answer
604
views
How to Share a SharePoint list item to specific external user?
I am trying to give access to a specific external user for a list item and the user is not added as a guest yet. How can we perform this using Power Automate/SharePoint Rest API.
Note: Since it is a ...
- 196
0
votes
2
answers
5k
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 ...
1
vote
3
answers
6k
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 ...
0
votes
1
answer
37
views
Trigger Options in Microsoft Flow
I have been struggling with this issue in the last few days. I have a simple SP online list with Status and comments fields. The flow is triggered when the Status changes to Completed. What I want to ...
- 581
1
vote
2
answers
4k
views
MS Flow to Email User if Certain Date Column is Equal to Today's Date
So I have a document library with a view that only shows files/trainings pertaining to each individual.
There is a Person or Group column called "Player" where I have the list view filter ...
- 113
0
votes
1
answer
63
views
Status change to open after receiving email
I have a question and want to know if we can achieve this by SharePoint & flow.
The scenario is, I have created a simple SharePoint list with a choice column (In-Progress and Completed). When I ...
- 581
1
vote
0
answers
248
views
Getting One or more recipients are invalid error
I am trying to send an email to the Shared mailbox. It is hard coded in the flow but when I try to send an email, it gives the
One or more recipients are invalid error.
I am able to send email to ...
- 2,303
0
votes
1
answer
691
views
For a selected file Power Automate - Trigger date
I was wondering how does the trigger date works in "for a selected file" in the power automate.
When I select "Date" from Add an input and Save. Later, When I select future date ...
- 101
0
votes
0
answers
48
views
How to send images inside a multiline text field to a docx file
I have a multiline text field that is being used to gather all time of information (formated text, tables, images from sharepoint that are pasted here, etc.)
I am using the Flow action to Populate a ...
- 41
0
votes
1
answer
4k
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 ...
- 23
0
votes
1
answer
123
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 ...
- 99
0
votes
1
answer
477
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
1
answer
198
views
"HTTP with Azure AD" connection is not available in my tenant
I was exploring on how Microsoft Teams can be provisioned using the PowerApps and Power Automate, where I came across this article Provision Teams using Power Apps and Power Automate. In this article, ...
- 4,034
4
votes
1
answer
2k
views
Which Power automate/flow license removes the 90 days limitation
I am receiving the below message once in a while for my flows
We noticed that your flow has not run at all in the past 90 days. We disabled it on 10/1/2021
8:15:14 PM.
If you need any help enabling ...
- 425
0
votes
2
answers
669
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
1
answer
1k
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
1
answer
355
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 ...
- 113
0
votes
1
answer
582
views
How to write a power automate(flow) to check if every department has uploaded a report file for every day?
I have a document library with the department as a column. Every day, each department upload a file and I want a consolidated email to check which department has not uploaded the file.
I have about 20 ...
- 1,895
0
votes
2
answers
2k
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 ...
- 101
0
votes
1
answer
129
views
How to store all Modifiers/Editors of a SharePoint list item in a variable using Power Automate Flow?
I am trying to append each person who have modified a SharePoint list item to a variable, so there is a record of all Modifiers and I can use that variable in emails and Microsoft Teams posts. I am ...
1
vote
1
answer
1k
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/...
- 31
0
votes
1
answer
43
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
1
answer
623
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?
- 103
1
vote
0
answers
217
views
"Create HTML Table" CSS Style to Format SP List as Single-Column layout
I am using a SharePoint List to store News Clips related to my company. I have created a flow to auto-send them to a distro list, and achieved a clean table, but wish to create an email where the ...
- 23
2
votes
0
answers
168
views
Add row to an Excel table using Flow skip columns values
I'm trying to export a SharePoint list to table in a specific worksheet in Excel (both created in the same Flow), when I try to add a row to the table it doesn't add all the values to the row as you ...
0
votes
1
answer
18k
views
Microsoft Flow Error: "You are not authorized to send mail on behalf of the specified sending account"
Using Microsoft flow I am trying to send an email Notification on behalf of an Administrator's account.
Unfortunately, my attempt results in the below error.
You are not authorized to send mail on ...
- 3,392
0
votes
1
answer
57
views
Flow To POST Direct Link of Image to HTTP Endpoint
I am having some issues with image sharing in SharePoint when using flows.
My end goal is to have the flow:
Trigger when a file is uploaded
Make a HTTP POST request to an endpoint with a direct link ...
- 1
0
votes
1
answer
2k
views
SharePoint List - Auto Increment based on count of another column
I have managed to get an auto incrementing column. See below. So the Ref column is incrementing based on how many items there are already in 'Type'. In effect there could be multiple number 1s, but ...
- 1
0
votes
1
answer
541
views
Power Automate - Export people picker data from a list
We have a sharepoint list that we want to export to excel weekly. However we also want to capture the user information that's in the people picker. See screen shot below. Is this possible?
- 25
2
votes
1
answer
8k
views
Power Automate flow check if date is not empty and null
I have excel sheet. Using Power Automate flow I am reading the excel data.
Using create item action adding the record in SharePoint list. It will not work if the date is empty or null
Column A | ...
- 3,392
1
vote
2
answers
1k
views
Uploading a new document of an existing document in sharepoint is it meant to keep the properties?
I have a question from users in the business, when they upload a new document (an updated version of existing in SharePoint) they notice that the columns that had been previously been filled are still ...
- 11
0
votes
1
answer
2k
views
Microsoft flow to read data from excel sheet
I'm working on POC where In email attachments I will get excel file.
I am trying to read that excel file using Microsoft flow and create item's in SharePoint list.
For each row there will be new ...
- 3,392
1
vote
0
answers
22
views
How to design a flow which can control other independent flows without building child-parent relation
How can we in MS flow control the execution of other flows?
To be more specific:
How can we do the followings in a flow:
1 -Check the status of other flows? e,g, running, idle
2- If they are running, ...
- 425
1
vote
1
answer
186
views
How to modify the same attribute of multiple lists with exact schemas in Sharepoint online through coding or ms flow
I have several lists with the same exact schemas in SharePoint Online. How can I do the following?
1- How to add/remove a column to/from all of them?
2- How to add/remove an option to a choice/...
- 425
1
vote
1
answer
6k
views
Update existing SharePoint list from Excel file in library
What I'm trying to do is to update the SharePoint list if there is an item in the Excel file that is not in SharePoint, for example
I have in the SharePoint list one item:
PR Number
Desc
Title
...
1
vote
0
answers
1k
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 ...
- 113