2,807 questions
0
votes
0
answers
9
views
Accessing Items Nested in a List, Power Automate Desktop
For context I am trying to make a desktop flow that opens severals Project files, Clicks on the Calendar view, and saves the Calendar view as a PDF for each file.
To do that I have to use some logic ...
- 61
0
votes
0
answers
14
views
Power Automate to import list items into SharePoint, difficulty getting a multi-value lookup column to work
I have an excel template that will be used to import list items into SharePoint. One column in SharePoint is a multi-value Lookup column. I'm having trouble importing multiple values from excel into ...
- 23
0
votes
0
answers
14
views
What could be the cause of the inconsistent processing time of Apply to each in Power Automate?
Assumptions:
The action in Apply to each is formatting the result of an HTTP request.
Concurrency control is turned on for Apply to each, and the order is set to 20.
The flow (child flow) including ...
0
votes
0
answers
18
views
Pulling data from HTTP request in Power Automate Desktop
I am trying to pull data from Power Automate Desktop from an HTTP Request. It is simple in a cloud flow but very difficult in Desktop.
I converted the HTTP Request to a JSON Custom Object and am still ...
- 61
0
votes
1
answer
30
views
How to send an email when a column changes in excel using Power Automate
My use case is that I've been asked to change our event tracker so that when the column "signed agreement" changes to "signed" and email is sent to our finance guy to process an ...
-1
votes
1
answer
18
views
Substitute /Concatenate
The apostrophe is this string is breaking a power automate flow. I would like the name to just be "Sheerin, Jon" Instead of "Sheerin, Jon O'Hare" and remove everything else after ...
-1
votes
0
answers
25
views
How to Identify the Flow ID for Power Automate Approvals via API?
I’m working on an application where I need to fetch all Power Automate approvals associated with specific flows. For example, I have three different flows, and each one has its own approvals. The ...
0
votes
0
answers
35
views
Power Automate task runs manually, won't run as a scheduled task
I am currently working on a task using Power Automate, where I need to create a flow that automatically exports specific details from my Outlook calendar to a SharePoint list every morning at 8:45 AM (...
- 1
0
votes
1
answer
25
views
Power Automate - Excel to Excel
I'm a new user to MS Power Automate.
I've been trying to get data in an excel table to copy over to another excel table. It needs to check if the data already exists using the ID column, if it does, ...
1
vote
1
answer
41
views
How to Use Dynamic Environment Variables in Power Automate Trigger for SharePoint File Creation?
I am trying to create a Power Automate flow that triggers when a file is created in a specific folder within a SharePoint site. The trigger I am using is "When a file is created (Properties only)&...
- 103
0
votes
1
answer
36
views
Power Automate Access Issue
I am creating a Power Apps app using a Power Automate flow. There are SharePoint, Excel, and Office 365 Users connections. Everything goes as planned on my end, but when a user tries to use the app, ...
- 1
0
votes
0
answers
31
views
Power Automate - Read from excel [no table present] and send alert with specific value - Range of dynamic excelsheet
I'm trying to find a solution but I really get stuck with the following:
I have an excel file that looks like this:
Test.xlsx
It's on "Sheet1". This file is generated via Power Automate, it ...
- 319
0
votes
1
answer
24
views
How to update Business Phone on Admins with Power Automate
I am running a workflow that pulls employee information from a spreadsheet and fills in their contact data and organization data. Everything runs fine except when it gets to updating the business ...
- 1
0
votes
1
answer
29
views
Power automate datetime comparison seems wrong in just one instance
I have a book rental PowerApp, where an evaluation in a connected Power Automate Flow regarding a Due Date in ONE entry is "misbehaving" (Datetime field in SharePoint List).
The automation ...
-1
votes
0
answers
30
views
Reconfigure all environment variables when importing a managed solution inside PROD environment
I have 2 environments inside Power Platform:-
Dev
PROD
Where inside the Dev environment i set all the environment variables as follow with the "Export value" checkbox turned off:-
I ...
0
votes
2
answers
86
views
Problem with populating a created excel table with data from a transposed HTML table using power automate
I have created a transposed HTML table in power automate that looks like the following table:
My problem is trying to create an excel table in power automate to populate the above data given that the ...
- 59
1
vote
0
answers
25
views
Number of Billable Actions Per User/Day
I am trying to figure out how to find the number of billable actions per day per user in our Power Automate tenant.
I have set up our company Microsoft Center of Excellence and none of the dashboards ...
- 61
-1
votes
1
answer
33
views
Get the IP address/es for scheduled and automate flows to add them to the white list inside external API
We have an automate flow and a scheduled flow which integrate with external API using the Premium connector "Send Http request". now we want to secure the calls to the external API endpoints,...
0
votes
0
answers
22
views
How to Include "Area" Information in Email Notifications in Azure DevOps? [closed]
I have a question regarding email notifications in Azure DevOps. Is there a way to configure them so that when a task is assigned to me or when someone mentions me in a task, the notification email ...
-3
votes
0
answers
27
views
ResponseSwaggerSchemaValidationFailure on create record from Power Automate using Service Now Connector
ResponseSwaggerSchemaValidationFailure. The API 'service-now' returned
an invalid response for workflow operation 'Create_Record' of type
'OpenApiConnection'. Error details: 'The API operation '...
0
votes
0
answers
36
views
Power BI Embed and passing data from user interactions between it and the custom application
Question:
How do you associate "Custom app" users with the Power BI Service? In other words how do you pass Custom App user data to the Power BI Service? For example is there a way to pass ...
- 514
-3
votes
0
answers
30
views
How to send a notification in teams chat to the users, when chat is about to delete before 5-10 days? [closed]
Hello community members,
I have created a retention policy to delete the team chat after 30 days in Microsoft Purview.
Now, I need to notify a message to users before 5-10 days of their deletion. So, ...
1
vote
1
answer
29
views
Join the outcomes of multiple FilterArray Power Automate actions without using ApplytoEach
I am doing multiple API calls inside an Apply To each, to get data from the same external API but for different date/time. Then I am doing the following:-
RemoveSOAPTAgs from the API call response
...
2
votes
2
answers
122
views
Need assistance with Xpath expression to count non-null values after a delimiter
I have tried to make the following expression work in a power automate flow without luck. The objective of this expression is to count all the non-null values after the second ";" for each ...
- 59
0
votes
0
answers
21
views
Power Platform deploying From Test to Prod
my company is just starting to utilize Power Platform and I have been put in charge but have no previous experience.
I am implementing Power Platform Pipelines and am specifically having issues ...
- 61
0
votes
1
answer
26
views
GetItems from a SharePoint list will convert the DateOnly field to the site time zone?
I have a SharePoint list with a column of type DateTime (DateOnly) field named StartDate1, and our site collection has UTC+2 time zone.
Now when i directly use SharePoint REST API "/_api/web/...
0
votes
1
answer
38
views
change the display name of a sharepoint list without breaking the associated powerapp and powerautomate
I am rewriting an integrated SharePoint list power automate to be a stand alone canvas power app. and I have a link on the first column of the list that does a deep link and opens the power app with ...
- 5,266
0
votes
0
answers
44
views
Update Link using OfficeScript
I have a VBA macro created for excel where formula have linkage to external links so I use
Myworkbook.UpdateLink Name:=Myworkbook.LinkSources
Now we are planning to move the macro to OfficeScript so ...
- 43
0
votes
1
answer
75
views
Extracting keys of nested json in PowerAutomate
I'm trying to use Microsoft Power Automate to extract the values for the property "name" from the JSON object shown below:
{"sites": {
"1": {
&...
- 687
0
votes
1
answer
38
views
How to Add Comments to SharePoint List Items Using Power Automate?
Problem Statement:
I am trying to add comments to a SharePoint list item using Power Automate. For this, I used the "Send an HTTP request to SharePoint" action. However, my flow fails with ...
- 9
0
votes
1
answer
42
views
Add Days but Exclude Weekends from Calculation
I am currently trying to set the due date for a task (Using MS Planner in the workflow) to 2 days after something is submitted. However, I want to exclude weekends from this calculation (sort of like ...
- 25
1
vote
0
answers
34
views
How to correctly set orderHint to preserve checklist item order in Microsoft Planner via Power Automate?
Title:
How to correctly set orderHint to preserve checklist item order in Microsoft Planner via Power Automate?
Question:
I'm working on a Power Automate flow that clones a Microsoft Planner bucket, ...
- 720
1
vote
0
answers
26
views
Power Automate Desktop keyboard comands dont't make JavaScript functions talk to the backend?
Title is my best guess at the problem. Here is what is happening:
I need to download several thousand files from a very old system (Cogon, in case anyone is interested). For several reasons, the only ...
- 366
0
votes
0
answers
25
views
How to download a zip file attachment from an Oracle UCM SOAP response in Microsoft Power Automate
I'm attempting to access an Oracle UCM folder using Microsoft Power Automate, that has Zip files in it. A CSV file is included with every Zip file. The objective is to copy this Zip file (or extract ...
- 47
1
vote
1
answer
58
views
How to dynamically add rows to an Excel table when the table name is determined by a Compose action?
I’m working on a Power Automate flow where each week is stored in a separate tab (worksheet) in an Excel workbook. Each tab contains a table with the same structure, and the name of the table matches ...
- 11
0
votes
2
answers
46
views
How do I fix Power Automate Create Item Error
I'm having trouble with my workflow copying the data to a sharepoint list due to the following error message:
"The 'inputs.parameters' of workflow operation 'Create_item' of type '...
0
votes
1
answer
73
views
Power Automate Filter Array output "object" issue
Thanks in advance to whomever takes the time to read and assist!
Ok I am trying to build this flow to send onboarding emails to employees.
What it is supposed to do is check through a sharepoint list ...
- 35
-1
votes
0
answers
26
views
Power apps Business process flow
When users are using a business process flow on their forms, I want to stop them selecting the stages out of sequence and before all mandatory information is collected for the previous stage. So, ...
- 3,335
0
votes
1
answer
86
views
HTTP function doesn't wait for response
I am having the worst time of my life trying to get this Power Automate Flow to work.
I have made a Power Automate flow that was extracting a Purchase Order from Invoices. It was triggered on every ...
- 777
0
votes
1
answer
28
views
Automate Flow fails with empty row in table
I have a problem with my flow in Power Automate. The flow is supposed to check if a row has been added to a table in Excel, and if so, it sends an email. Everything works well until a user adds an ...
- 23
0
votes
0
answers
11
views
How to create a planner board with specific template with graph API
I am trying to create a planner board using graph api.
I am able to get the basic board. But instead I want to create a planner using lets say "Software Development" Template.
Or Option 2 ...
- 1
0
votes
1
answer
56
views
In Power Automate Get just email address values from Select
I'm trying to get a semicolon separated list of email addresses stored in a SharePoint list's text field.
My workflow gets items from SharePoint, uses a 'Select' action to just get the email address ...
- 180
0
votes
0
answers
46
views
Power Automate calling stored procedure returns corrupted XML response
I have a stored procedure in SQL Server that is simply a select statement:
SELECT TOP 3
'SIMPLERULE' AS 'Header/TransactionType',
'PROJECT' AS 'Header/BusinessRule',
REPLACE(j.Job, '-', ''...
- 461
0
votes
0
answers
44
views
Exclude attachments from E-Mail Signature - save the rest to OneDrive
I have created a flow in Power Automate that creates a flagged email as a Planner task and attaches the email attachments to the task by storing them on OneDrive. However, many emails contain images ...
- 874
1
vote
1
answer
171
views
Power Automate Send an HTTP request to SharePoint returns BadGateway error when creating a Lookup field
I'm trying to use Power Automate to create a Lookup field in a SharePoint document library using the "Send an HTTP request to SharePoint" action. However, I’m encountering the following ...
- 13
0
votes
1
answer
66
views
How to get all messages post by person in team channels using power apps in teams
I have teams group in which there are multiple teams channel. I want to get all the post messages by any user and from those messages only want messages which contains "Open" as a string in ...
- 37
0
votes
2
answers
41
views
Sending an email via Power Automate when specific items in SharePoint is edited
I have a SharePoint site which is used by other people as well. One of the columns consists of my name in it.
What I would like to do is that whenever an item which has a column with my name, is ...
- 533
0
votes
0
answers
17
views
Extract data from coinmarketcap api http get response with power automate cloud flow
The api returns data in a json object but it has an unusual structure. For example if returning bitcoin data I get this:
"data": {
"1": {
"...
0
votes
1
answer
741
views
Error from token exchange: Runtime call was blocked because connection has error status: Enabled| Error, and sharepointonline is in the block list
I encountered an error while patching data in SharePoint using Power Automate. Does anyone know the cause or solution for this issue? Please help.
"status": 401,
"source": "...
1
vote
0
answers
74
views
Power Apps: PDF - Expand Containers not working for Gallery and Container
It would be much appreciated if you would help me on this.
I have screen consist of one main container (ResultMainContainer_Test), one left sub-container(LeftContainer_Test) and one right sub-...
- 53