Questions tagged [power-automate]
Microsoft Power Automate, formerly known as Microsoft Flow, is one of the pillars of the Microsoft Power Platform. Power Automate is a low code platform for workflow and process automation.
979
questions
0
votes
1
answer
19
views
How to run a Power Automate flow on a selected folder in a library
I searched this topic but only found a few old posts from 2019 that no longer apply.
The Power Automate Action command now shows up with a folder selected.
I want to run a flow on the selected folder, ...
- 8,877
0
votes
0
answers
11
views
pass the user's timezone from power app to power automate to create an event [duplicate]
I have a workflow which get called from Power Apps, to create an outlook event:-
now currently i am hardcoding the time zone, so how i can pass the user time zone from power app to the flow, so the ...
0
votes
1
answer
21
views
Call a flow to create an OutLook event using the users' timezone.. is this possible?
I have this form inside our canvas app to call a flow which create an event:-
and this is the code inside the Save button:-
WFHSendInviteToCalender.Run(
"{
""WFHId&...
0
votes
1
answer
12
views
Sharepoint 2019 news alerts with Power Automate
Sharepoint 2019 on-premises and local data gateway to connect with Power Automate.
I'd like to send mail alerts when a news post is published.
How can I distinguish between news posts and normal pages?...
- 1
0
votes
1
answer
22
views
Extract the date in PowerAutomate
When a user pastes a email (.EML) file in a document library in SharePoint, a Power Automate flow should extract the reception date from that email. In the MIME type, the date is like:
Date: Thu, 2 ...
- 133
0
votes
1
answer
15
views
SharePoint Online List Form PowerApp zip file difference between PS5 and PS7
We have several SharePoint Online List form Power Apps. We export and import them to different site collections in our tenant [DEV/TEST/ACCEPTANCE/PROD]. This requires to change the datasources.json ...
- 453
0
votes
0
answers
19
views
Power Automate - Create Document Set with Metadata to SharePoint library
I have a SharePoint Online Library, with a customized PowerApps form. I've been able to create a flow, and run it from my PowerApps form, to create a Document Set in my SharePoint Library. My form ...
- 373
0
votes
1
answer
34
views
SharePoint Online Calendar Time entries are off by several hours - Power Automate Flow
I have a SharePoint Online calendar (set to EST in the Regional settings), and an Intake Form that requests vacation, time-off, etc. When this is submitted, then subsequently approved, I have a Power ...
- 373
0
votes
1
answer
19
views
Create Unique ID in MS Lists using Power Automate - Error
I'm trying to create a unique id in my lists, which is exported from a MS form. But I keep getting errors.
So my logic is very simple:
Step 1: once a form is submitted, the responses will be ...
- 1
0
votes
0
answers
36
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
1
answer
55
views
Different image resolution in SharePoint Online
I have a requirement - When user uploads images to SharePoint they would like the images to have a low/med/high resolution for each of the images.
They don't want to upload individual images with ...
- 4,232
0
votes
1
answer
21
views
How can I setup a user not to have acccess to publish pages but have contribute access - SharePoint Online
I'm working on a project - using the site pages to publish news contents.
I want users to be able to create/edit pages but not to be able to publish them. Currently when a user creates a page, it get ...
- 4,232
0
votes
0
answers
49
views
Power Automate Trigger Conditions for specific column in SharePoint list
I have a SharePoint list that I want to trigger the flow by using Trigger Conditions when the specific column value changes.
The flow triggered when the Current Status changed to Approved but the ...
- 35
1
vote
1
answer
25
views
JSON to Show Time Until a Specific Timestamp - SharePoint List
I have a list of participants in a conference. All participants are arriving and departing on numerous different flights. I am trying to create a Power Automate flow that will send a Teams message as ...
- 13
0
votes
0
answers
11
views
PowerApps Form (SharePoint customized), receiving expected table value error on Lookup formula
I have a People field in my form with its defaultselectedvalue = LookUp('Travel Request Approval Workflow',Project in DataCardValue5.Text).ProjectManager. This people field gets changed via Power ...
- 373
0
votes
1
answer
11
views
execution flow button in a SPO library
I have created an SP document library with an execution flow button that extracts the zip files when the users click it. The extract file locations are the same as the zip file in the document library....
- 581
0
votes
0
answers
14
views
Office Scripts not shown in Power Automate
I created a flow for adding value in excel. for which I want to use office script but office script is not visible in script section .
How can I add value in certain column of excel using the above ...
- 37
2
votes
1
answer
72
views
SharePoint List Conditional Formula not working
I'm having an issue with the SharePoint List conditional formula. I'm trying to show the Resignation with Notice field only when Job Movement Details = Resignation.
Below is the formula that I used ...
- 41
0
votes
1
answer
80
views
Setting up an email reminder based on dates in excel sheet
I've been asked to find a way to have an excel spreadsheet (that will be updated often) send an email to the email address from a column, as well as on a specific date according from another column. ...
- 1
0
votes
1
answer
32
views
Add new user in a sharepoint group with more than 5000 users
I have a SharePoint site the is used by internal and extarnal users. We use the default visitor group to manage the access. The group has more than 5k users. I cannot add new user in the group and ...
0
votes
0
answers
34
views
Avoiding Duplicates in SharePoint List from Microsoft Accounts Using Power Automate
I've set up a flow in Power Automate to add the names, cities, and workplaces of my colleagues to a SharePoint list using their Microsoft accounts, and it's working well. However, I'm encountering a ...
- 1
0
votes
1
answer
23
views
Reformat the 'Created' SharePoint column to something readable in Power Automate
I have a flow that sends an email to an item's original submitter. In this email I need to display the Item's Created Date AND Time. I'm looking to display something like "11/14/2023 2:40pm&...
- 373
0
votes
0
answers
12
views
Infinite Loop Issue with RSS Feed
What's the deal? I am a novice user of Power Automate, trying to keep an RSS feed on SharePoint through a List web part. Had a developer put this together today and then peace out on me with no reply ...
- 1
0
votes
0
answers
23
views
Which approach we can follow to build large & dynamic PDF files from HTML
I want to create the following:-
We have a custom SharePoint list >> which contain items with attachments.
Now I want to show the items' attachments inside a PDF file with the following format ...
0
votes
0
answers
11
views
Can we have a child flow that is calling from automate flow + from power apps
I want to create a child flow inside a solution which get those details:-
Text of comma separated names
EndDate
StartDate
Type
The child floe will then create a separate SharePoint list item for ...
0
votes
0
answers
49
views
Power Automate - compose in apply to each
Can someone explain how come using compose action in Apply to each create an array of all objects and not overwrite the compose action everytime?
I've seen it in numerous blog posts as a time saver ...
- 113
0
votes
1
answer
27
views
How i can get the Principle ID of an Office 365 security group
I have an Office 365 security group (without email), and i want to add it to an Item permission, where the built-in action "Grant access to item or folder" will not work, as it only accept ...
0
votes
1
answer
346
views
Array elements can only be selected using an integer index
I have a List Group Members action to get the members of a security group >> then I am trying to build semicolon separated string for the members emails inside a compose action, as follow:-
but ...
0
votes
1
answer
24
views
How i can get the members of a office 365 security group (none-mail enabled)
Inside Office 365 , i have security group without email address and I want to list its members. I found 2 actions:-
but I am not sure how I can filter the "List Groups" by name to get the ...
0
votes
1
answer
22
views
Who can use the Asana connection which get created inside out power automate flow
I have created a scheduled flow, which loop through a SharePoint list items and create Asana tasks, as follow:-
now when I added the Asana step >> i were asked to login to Asana, so i login ...
0
votes
0
answers
11
views
Power automate Approval Flow question - Can you update the "Status" column in Teams based on a field value?
I have an Approval flow (Create and Approval, and Wait for an Approval). When an approval response is given in in the Teams/Email notification, it updates the "Status" column in the "...
- 373
0
votes
0
answers
11
views
Power Automate Approval Flow - Response provided in app - How to end Approval
I have an Approval workflow (Power Automate) that gets sent to a Project Manager when a user submits a new item. If the Approver provides a response in either Teams, or the Email notification, the ...
- 373
0
votes
0
answers
22
views
What to use for Workflows after retirement?
SharePoint 2013 workflow will be turned off for new tenants as of April 2, 2024. It will be removed from existing tenants and will be fully retired as of April 2, 2026
So we are a big company with ...
- 13
0
votes
0
answers
8
views
How do I create a power automate workflow for Sharepoint Paige approvals?
I’m quite new to power automate, and the following requirements is what I need to achieve, and it’s all quite tricky to understand at my early stage.
Has anyone got any ideas on how to construct a ...
- 1
0
votes
1
answer
40
views
How to create a sub folder within an exisiting folder in a document library with power automate
I am trying to create a sub folder when a new request is added to my jobs list using power automate. At the root level of the document library, I have a root main folder, example; named Photo-Request-...
- 101
0
votes
0
answers
8
views
Whenever I click on any item on Powerbi dashboard, can the item be updated (number addition) on the SharePoint list
I was trying to create a voting dashboard on Powerbi. Now I want to make that dashboard interactive with live voting. So whenever there is a click on any item of any column on that dashboard, I want ...
0
votes
0
answers
31
views
How to start Power Automate workflow from code/SPFX solution web part?
Is it possible to trigger start of Power Automate workflow and pass parameters to workflow through spfx solution/webpart on sharepoint (with React)?
Without premium connector.
I only found one way but ...
- 123
1
vote
1
answer
38
views
Add Save and Submit Button
I have a custom form where I need to add a "Save and Submit" button that will trigger the power automate flow I created.
I want the "Save" button to only save the list item so the ...
- 15
0
votes
1
answer
50
views
What does "Security Group" when creating a new environment means?
We want to create a new power platform environment, and we are asked to define a Security group, as follow:
So what is the purpose for this security group? so only members inside this group will be ...
0
votes
2
answers
27
views
"Add Dataverse data store" & "Pay-as-you-go with Azure" settings when creating new environments
We want to create 2 power platform environments:
one for testing and development
the other for production
now the environments will mainly contains:
Solutions for connecting Power Apps and Power ...
0
votes
0
answers
64
views
What causes Excel action "List Rows present in a table" to fail to return existing Row?
I need to filter out some data from an Excel table, but since the ID is not unique, I wanted to sort it by latest Submission Date from Ms. Forms.
Here's my List action
Before this step I also added a ...
- 101
0
votes
0
answers
21
views
Extracting emails and url( link) from SharePoint Pages
I woud like to iterate through pages in SharePoint and get/extact any emails or urls and export it to an excel format.
Which tool will work best?
Power Automate Desktop or Power Automate Online?
...
- 4,232
0
votes
1
answer
26
views
Find folder in subfolders
I have a SharePoint folder structure.
Test/Pay/Active/Owner Holding
>01 Record
>02 Misc
>NY101-Holding/Report
Test/Pay/Active/Rock Road
>01 Record
>02 Misc
>NY065-Road/Report
Test/...
1
vote
3
answers
29
views
Get Month and Day from one column and update another column with same month and day but current year
I have a list for purchase agreements that has a column for start date, what I want is a way to populate another column with the month and day from the start date but with the current year. I assume ...
- 11
0
votes
0
answers
24
views
Can we calculate the nearest location between 2 locations?
We have a SharePoint list which stores the Assets' locations (Latitude & Longitude).
When a support ticket is created for an asset >> Technicians will get an email that a support ticket was ...
0
votes
1
answer
80
views
Power Automate Starting Multiple Flows and sending multiple emails
I am attempting to build a flow that
When an item is created or Modified
It gathers email addresses using an HTTP request
Does a select and join action to parse out an email address from a SP group
...
- 155
0
votes
0
answers
21
views
Add all the content type columns as indexes inside a Document library
I have this flow which do those main 3 actions:-
Create a new Document library
Add a custom content type
Remove the built-in Document content type
now i want to get all the fields inside the ...
0
votes
0
answers
30
views
Power Automate connectors are not visible
I have created the service account and imported the flow to power automate and shared the flow with another user but somehow Connectors are not visible to the shared user and when another user logged ...
- 101
0
votes
2
answers
259
views
Power Automate - Selecting from an array with multiple objects
New to Power Automate and I'm struggling with what seems to be a very small problem and likely be a doddle for someone to resolve:
I have an array that looks like this:
{
"index": 0,
"...
0
votes
1
answer
35
views
Can a Power Automate flow update my custom column to display just the folder name where the document is uploaded inclusively for subfolders?
Can a Power Automate flow update my custom column in SharePoint to display just the folder name where the document is uploaded inclusively for subfolders?
I want it to show just the folder name where ...
- 37