Questions tagged [flow]
Microsoft Flow is a public cloud service to help individuals and teams to set up automated workflows.
670
questions
0
votes
1
answer
26
views
Get the email addresses of a People/Group field which allow multiple selection inside my Select
I have a People/Group SharePoint field named "Person" which allow multiple selection >> and I am getting the related list items (which contain the "Person" field) using Get ...
0
votes
1
answer
15
views
Is there an option to automatically create environment variables when connecting to data source
In Power Apps there is an option to automatically create environment variables when connecting to data source.
So in Power automate is there similar option? if not, then how we can manually create ...
0
votes
1
answer
19
views
How to get the 3rd element after doing a split
I have this formula to concatenation and get the last element after doing a split:-
concat(body('GetRootFolder')['d']['ServerRelativeUrl'], '/', 'Closed','/',last(split(items('Apply_to_each'),'#;')))
...
0
votes
2
answers
31
views
How to save "Site Address" and "List Name" to variable and use it in power automate .I want multiple list to use one power automate
I have several lists with the same fields names. I'm working on a flow that I need to re-use.
I want to be able to pass the site name and the list name dynamically to the flow.
So basically I would ...
0
votes
1
answer
39
views
Power Automate flow to send a reminder if Due Date is passed
I'm working on a Power Automate flow based on a SharePoint list. I have a Date column (Due Date) and a Choice column (Status) that I need this flow to look at. Basically what i'm tryign to ...
0
votes
0
answers
18
views
Update a sharepoint list if condition met
I have been trying to create a flow which will update sharepoint list, when a user added or removed.
Flow as followed:
[![enter image description here][1]][1]
I'm trying to achieve:
When a group ...
0
votes
1
answer
18
views
Allow users to mark or flag an item that its has been opened/read - SharePoint Online
I have got several lists and I would like to have a flag that users can use e.g yes/no to say they have read the content or not.
Any ideas or resources would be appreciated.
Thanks in Advance.
0
votes
1
answer
22
views
Allow specific user to view SharePoint documents (minor versions) / Create file with specific user 'Created By'
A document has been created by flow in SharePoint Online and 'Created By' is the set to the flow Owner. Unfortunately, the flow action does not allow me to set the 'Created By' to a specific user.
...
0
votes
1
answer
10
views
What is the equivalent action inside Power Automate which mimic creating tasks inside Workflow designer 2013?
I have this workflow designer 2013 >> which create a task and wait for response:
So I am planning to redesign this using Power Automate, so inside power automate what is the equivalent action ...
0
votes
1
answer
51
views
Power Automate selected item trigger for multiple selected items
I want to trigger a flow for the selected item in the SharePoint Online list, I have developed a flow for the selected item trigger and I could see my flow appears in the Automate section from the ...
0
votes
1
answer
33
views
Getting JSON array value gives errors. I've tried two different ways
I am pulling Office 365 information into a SharePoint Online list and it works fine.
I have a 'Create Item' step for the SPO list and I add metadata from a Parse JSON step like this : body('Parse_JSON'...
0
votes
1
answer
57
views
Power automate Flow - Extract information from invoices - get value from keyValuePairs
How to get values from array with Composeaction?
I will try Azure Cognitive Service - Extract information from invoices. There is an Array called keyValuePairs.
How I can get to single values ?
...
0
votes
1
answer
180
views
How to extract ONLY numbers from string using Power Automate
I have free text column in Dataverse table where alphanumeric values are entered e.g. abc123, 123abc, 1abc23. (numbers can be anywhere in string - no fix pattern) I want to extract ONLY numbers and ...
0
votes
2
answers
22
views
Selectively clearing a list in SharePoint
I have a list in SharePoint which has 26 columns and I have a task to delete the contents of all rows except the first 4 columns. How can I do this automatically?
I created a flow in Power Automate ...
0
votes
0
answers
25
views
Upload metadata to a folder with power apps
I.have a document library named Project, with metadata STATUS, PROGRAM, BUILDING and Projectleader.
I have a APP with flow, thats create a documentfolder. But I also want to set the above metadata in ...
0
votes
1
answer
9
views
How MS-Bookings calendar meeting data save in SharePoint online List using Automate?
I have Bookings shared calendar, If anyone book any meeting using that calender I want the booking details in the SharePoint list.
Like
Booking Title.
Booking Time.
Start date.
End Date.
Attendees.
...
1
vote
1
answer
90
views
One or more fields provided is of type 'Null', a different type is expected
I'm very new to Flows so I need some assistance setting up a Round Robin for Sharepoint Files.
When someone browses a file in Sharepoint Online they can run a flow which uses a round robin list and ...
1
vote
1
answer
22
views
Calculated Value Code
I have a list with about 15 columns. I need to have one of my columns pull the initial value entered (only) of one of the other columns.
Example:
[Column A] is blank then changes to 2/2/2023 .... [...
1
vote
2
answers
90
views
Disabling PowerApps button on SharePoint list
I am attempting to disable the PowerApps button on the hero ribbon without success.
I've tried the following:
Set-SPOSite –Identity SiteUrl -DisableAppViews Disabled -DisableFlows Disabled
and
...
0
votes
1
answer
10
views
Error when inputting Site Address and List Name in Power Automate
I'm trying to get my MS Form to be added to my SharePoint List as a new item using Power Automate. However, I am stumped on the step where I need to input my Site Address and List name.
I'm getting ...
1
vote
0
answers
28
views
How to create power automate flow where multi select question from MS Form is null/blank
I have an issue with my power automate flow, where I need to feed data from a MS form with mult select answers and feed it into a sharepoint list.
The null is working, when I don't select any of the ...
0
votes
1
answer
15
views
Can we add new co-owners to an existing flow using another flow
I want to add new co-owners to an existing flow using another power automate.
Is it possible?
Please guide me on this.
Thanks in advance!
0
votes
2
answers
31
views
How do I remove links from the left navigation in a flow?
I am automatically creating sharepoint sites on our tenant and have most things done.
However I would like to remove the links (only the links, not the libraries) for Pages and Documents from the left ...
1
vote
1
answer
10
views
Take data from Multiple Line String and create multiple new Datasets
I have two lists:
Bin Data:
BinBarcode
Tapes inside
12345678
MA0053L8/nMA0053L8/nMB0030M8
Tape Data
Tape Barcode
Bin
I want to automate when a entery is put into Bin Data. It creates multiple ...
0
votes
1
answer
12
views
Nof replacements counter not working as expected
Update item Noofassignments field has below expression and its working as expected
So when first time if for item modified with status active then Noofassignments counter will be 1 and ...
0
votes
2
answers
192
views
Power Automate - Workflow to update properties of new file only
I have a SharePoint Library (modern) in which there are numerous files already uploaded, and more get uploaded every few days. I have a "Reminder Days" column (Date) that I'd like to add 30 ...
0
votes
2
answers
408
views
Power automate Flow, Do not create new records if they exist
How can I not create duplicates with my flow? I want to create records from List A into List B IF they don't already exist in B, if they already exit, DO NOT create them, as it is creating duplicates.
...
0
votes
1
answer
82
views
When item modified with trigger condition it should trigger email
I have set below Trigger condition when item create or modified
@and(equals(triggerOutputs()?['body/SRVolunteer/Value'],'Yes'),equals(triggerOutputs()?['body/SRroles/Value'],null))
Issue: It is ...
0
votes
1
answer
513
views
Get files from a folder in Power Automate is not working
I am querying all files from a given folder in Power Automate. I have used the below in the filter query of Get Items action:
{FullPath} eq 'GSD Test Document Library/DS0001'
But while running the ...
0
votes
0
answers
77
views
Get Jira issue id and description from power automate http json response of Jira query
Get Jira issue id and description from power automate http json response of Jira query.
Trying to extract two values Jira Issue and Description from below JSON Jira query response using power automate....
0
votes
1
answer
27
views
SharePoint online problem with HTML link in the column
I have nearly solved my problem how to open Attachment directly in web Browser from SharePoint list without downloading the file.
I have only problem with more then one Attachment.
My Power automate ...
1
vote
2
answers
61
views
Power Automate Create record based on filter criteria
I have a flow that is supposed to update OR create a record in list B based on if an item is added or updated in List A.
But I want only this to apply to a subfilter of list A, i.e. where a column A ...
1
vote
1
answer
40
views
Uneditable column
I have a column in the SharePoint list in which the name of the person who edited the previous column appears (using a power automate), I need this column to be no longer editable after the name ...
0
votes
1
answer
90
views
Unable to reference a environment variable inside our Site Address property inside a cloud flow
We have a solution with 2 environment variables:
One which reference a SharePoint site
The other reference a SharePoint list
Now when we created a new cloud flow inside our solution >> we are ...
2
votes
1
answer
50
views
sending email to 2 sharepoint groups using msflow when item created or modified
Kindly help me with the steps
I need to trigger email for two SharePoint group when item is created or modified
0
votes
1
answer
705
views
Power Automate, Filter Query, Multiple Conditions
I am trying to filter my Get Items for multiple conditions. So my first condition on its own works fine but when I add the later 2 conditions, my flow fails.
Requester_CostCenter eq 1463 and Specific ...
0
votes
2
answers
114
views
How we can change the SharePoint lists URLs when we export/import a Power Apps canvas application
We have a Power Apps canvas application, which have the following SharePoint lists and libraries as its data sources for our test environment/site:
and the following Flows:
now we want to create a ...
0
votes
2
answers
114
views
Change the site URL for all the actions inside our imported Cloud Power automate Flow
We have created a SharePoint test site and and Power Automate cloud flow, where on most of the action we have define the site URL a follow:
Now we will export this Flow and import it again then we ...
0
votes
0
answers
57
views
Add run-only users to Flow via a List
As I was looking for a way to share a Flow, which is ran on List A, to multiple users without sending an email, I found out I can share the Flow using a SharePoint list (from my understanding, this ...
0
votes
1
answer
168
views
People Picker Apply to each Creating multiple entries when Copying to separate list
The problem I have is, I have a flow that triggers when and item is created. This flow copies items to another list.
The items it copies over
single line test fields
Multi line text fields
People ...
0
votes
2
answers
30
views
When a site has joined a hub site trigger
I am setting up most of our SharePoint Online project sites using PnP PowerShell and when the project site is ready, I join it to our hub site for projects. The way the hub site is set up, I am the ...
0
votes
1
answer
13
views
Power Automate flow - substring Expression with condition
i have big trouble with simple expression with substring.
My goal is merge two sharepoint list to one excel table. And problem is when value is empty that flow crash.
is possible create expression ...
0
votes
1
answer
902
views
Power Automate Filter query on created date column
I have a big document library has documents for than one lakh in it. I am trying to get all documents created in certain months in year, let's say I want to get all documents created in the month of ...
1
vote
1
answer
469
views
Power Automate, Update Item ID Field
How do I update item? My work is not working because I think ID are not matching between lists.
What is ID here? I am trying to update records.
ID in list B:
ID in list A:
So how do I match these ...
0
votes
1
answer
233
views
Word and pdf using "create file" action does not open when created by flow - Power automate
I'm trying to generate some word or pdf documents on the fly by using the Create file action but I can't get to open the files when its generated inside a document library in SharePoint online.
See ...
0
votes
1
answer
225
views
OData Filter query designer not showing in Power Automate
I have seen many people are referring to use ODATA filter query designer but in my Power Automate in Get Items, I don't see the filter query designer, it is the same as it was:
For example, I getting ...
0
votes
0
answers
110
views
Using Power Automate - Create Sharepoint List with column headers and row contents from Excel sheet
As per the header but I'll start with some background.
I was tasked with creating an app that would give reduced access (via an app front end) to an excel spreadsheet.
I have created an app (and some ...
0
votes
1
answer
536
views
How to get email and send Email To Multiple Values In People Picker Field In SharePoint
Any ideas how I can easily send email from multiple values in person and group field using power automate?
Thanks in Advance.
1
vote
2
answers
606
views
Power Automate: Create/Update record in List B from List A
I want to:
Trigger flow when listA has a new record or is modified.
Determine whether this record exists in listB.
If it exists, update this record, if it does not exist, create a new record
My flow:...
0
votes
1
answer
18
views
Image Uploaded From PowerApp Is Not Viewable
I have created a very simple Power App that takes a picture on the phone, then uploads it to a SharePoint Library, using a flow. The actual upload works, but when the picture arrives in SharePoint, ...