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.

Filter by
Sorted by
Tagged with
0 votes
0 answers
4 views

Create different flows with different combination of forms

I have FormA, FormB, FormC, FormD, FormE. Each form would ask for their name, birthday, and gender at the beginning. Right now, I send my client multiple links to each one. I would like to: Send ...
user avatar
0 votes
1 answer
18 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 ...
user avatar
  • 196
0 votes
0 answers
77 views

Multiple Choice Microsoft Forms object to Multiple Choice SharePoint list entry

I am really stumbling on this. The basic flow is pretty simple: When a new response is submitted, Get response details, Create item However, I have multiple questions that are multiple choice and ...
user avatar
  • 1
0 votes
0 answers
30 views

Trying to create a power automate flow that will move nested folders from one teams channel to another

Trying to create a power automate flow that will move nested folders from one teams channel to another. Here the problem is getting the sharepoint url of the MS teams. Is there any way to get the ...
user avatar
  • 99
0 votes
1 answer
299 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 ...
user avatar
  • 948
0 votes
2 answers
254 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 ...
user avatar
0 votes
0 answers
18 views

Copy a SP list record to another SP list

I have two separate SP online lists which are getting the information from Power Apps. In the first list, we have few columns and my concern is around Update Type column, and on the second list, we ...
user avatar
  • 525
0 votes
0 answers
55 views

Flow working but not receiving emails when testing

I am testing a flow for SharePoint list due dates and the flow is running successfully but I am not receiving emails when the flow is complete. Not sure what I am doing wrong. Pictures below: addDays(...
user avatar
0 votes
1 answer
26 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 ...
user avatar
  • 525
1 vote
2 answers
697 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 ...
user avatar
  • 103
0 votes
1 answer
29 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 ...
user avatar
  • 525
1 vote
0 answers
69 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 ...
user avatar
0 votes
1 answer
237 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 ...
user avatar
0 votes
0 answers
33 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 ...
user avatar
0 votes
0 answers
995 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 ...
user avatar
0 votes
1 answer
11 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 ...
user avatar
  • 145
0 votes
1 answer
124 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 ...
user avatar
0 votes
1 answer
35 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, ...
user avatar
3 votes
1 answer
410 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 ...
user avatar
0 votes
2 answers
280 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 ...
user avatar
  • 948
0 votes
1 answer
263 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 ...
user avatar
  • 948
0 votes
1 answer
80 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 ...
user avatar
  • 103
0 votes
1 answer
120 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 ...
user avatar
  • 1,885
0 votes
2 answers
482 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 ...
user avatar
  • 101
0 votes
1 answer
49 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 ...
user avatar
0 votes
1 answer
358 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/...
user avatar
  • 11
0 votes
0 answers
35 views

Restrict user to take action on flow approval

I am working on a solution where I am using Start and wait for an approval action in my flow so with this user gets an email on outlook as well as a teams notification seeking approval. Apart from ...
user avatar
  • 808
0 votes
0 answers
66 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?
user avatar
0 votes
1 answer
30 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 ...
user avatar
  • 948
0 votes
1 answer
306 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?
user avatar
1 vote
0 answers
76 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 ...
user avatar
  • 23
2 votes
0 answers
36 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 ...
user avatar
0 votes
1 answer
5k 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 ...
user avatar
0 votes
1 answer
36 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 ...
user avatar
0 votes
1 answer
670 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 ...
user avatar
  • 1
0 votes
1 answer
136 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?
user avatar
2 votes
1 answer
4k 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 | ...
user avatar
1 vote
2 answers
333 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 ...
user avatar
  • 11
0 votes
1 answer
825 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 ...
user avatar
1 vote
0 answers
20 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, ...
user avatar
1 vote
1 answer
114 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/...
user avatar
1 vote
1 answer
2k 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 ...
user avatar
1 vote
0 answers
881 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 ...
user avatar
  • 101
0 votes
1 answer
109 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....
user avatar
  • 101
1 vote
3 answers
1k views

How We Can Avoid 8 Nested Levels Of Conditions In MS Flow

Please assist me. I am pretty new to MS flow. I currently face a challenge with a flow that has 9 approvals. How can exceed the condition of the nested level? Any help will be appreciated.
user avatar
1 vote
1 answer
301 views

Adaptive card not displaying on mobile clients

I'm sending custom adaptive card from flow.. It is working on web and mobile clients for my Dev environment.. The same thing fails in my client's tenant for his android and iOS .. His web displays ...
user avatar
0 votes
1 answer
216 views

Count occurrences of a particular value in sharepoint folder

Trying to either use FLOW or calculated column in sharepoint to try and achieve the following. Appreciate anyones help on this. God Bless Janan
user avatar
1 vote
2 answers
427 views

Getting an error in flow (URI) in step "Send an HTTP request to SharePoint"

I have created a flow. What I'm trying to do is, create item in SharePoint when MS-CRM Account records is updated. But, I'm getting an error. The expression is not valid (URI). I'm Attaching a ...
user avatar
  • 13
0 votes
0 answers
113 views

What is correct variable in a flow to store a big JSON string

I have a JSON file and need to copy and paste it to a variable in MS flow, what is the best variable for doing this? I prefer not to call an API to read a file.
user avatar
2 votes
2 answers
9k views

Power Automate - Select single item from Get Items

I'm trying to fetch an item from a list to perform some operations on (parsing JSON specifically) but when I use the Get Items action it returns an array, even if I select the top 1 from the results. ...
user avatar
  • 2,660