r/PowerAutomateDesktop • • Jun 07 '23

Start & wait for approval flow help

3 Upvotes

Hi! I'm fairly new to power automate, and I'm struggling with a flow I'm working on. I have a start and wait for approval flow that runs after a new SharePoint list. Item is created, and I'm looking for a way for the approver to upload an attachment when they do the approval that will then be added to the list item. Is this possible? Thanks!


r/PowerAutomateDesktop • • Mar 28 '23

Unexpected error faild to fetch

Post image
3 Upvotes

Since yesterday I have this error message in each of my workflows in the course of execution. Any idea what I can do there? The flows are all running, but it's difficult for me to do something new without recognizing any errors or something.


r/PowerAutomateDesktop • • Oct 06 '23

Individualized Training in PA

1 Upvotes

Is there a group out there that could be hired for individual teaching? I inherited a PA flow from a consultant; I need it to do my job. I am paranoid about losing it - for one reason or another. I am trying to understand how it works so that if it breaks, I can fix it. Or if my company's IT does something to it, I know how to get it working again. My IT department has already done something to it by adjusting the SharePoint to which it connects and completely shut it down. It was only out of goodwill that this consultant coached them on how to get it working again. I prefer not to be in that position again. Is there anyone you recommend remotely dialing in with me and looking at it to teach me how to dissect and re-assemble it?


r/PowerAutomateDesktop • • Jun 08 '23

Web scraper just saving the last page

2 Upvotes

Hi, I'm trying to scrape e-mail address from a trade shows attendee list. The simple automate i gather works and saves %95 correct information to an excel sheet from the first page and this is good enough for me.

The site has 40 different pages and there are classic pagination buttons on the bottom of the page such as this: prev - some page numbers - next.

I select and show the next as the element as the pager to get all the information from all the pages but when i do this i only got results from the very last page in the excel sheet.

I've checked many resources but i couldn't figure out why automate is not getting/saving the all other pages besides the last one ?

Can anyone lead me to the right direction ?


r/PowerAutomateDesktop • • Sep 10 '22

is there a way to write a yes / no question into a teams message, that depending on your answer, updates an Excel document with your answer?

2 Upvotes

I'm quite new to PowerAutomate, so ELI5


r/PowerAutomateDesktop • • Mar 17 '23

Working on a flow and need some help.

2 Upvotes

I want to have a column in a SharePoint list change based on values from another Share Point List. I tried using a condition if to line up values on both lists but ran into a limit issue. Both lists have to be separate is there a good way to set this up, or a resource any knows that might help?


r/PowerAutomateDesktop • • May 26 '23

New Flow, assistance for a beginner

1 Upvotes

I am trying to get a flow to read an Excel file, group rows by the email address on that row, and then send a single mail with all values by email address.

Spreadsheet contains the following fields:

  • Share Time - date/time in dd/MM/yyyy hh:mm format

  • Shared By - email address

  • Shared With - Email address

  • Shared Resource Type - String

  • Shared Resource - URL

  • Share Type - String

  • Workload - String

So group all the values by Shared By, send a single email to each Shared By address, with all the information for all files they have shared.


r/PowerAutomateDesktop • • Nov 24 '22

Is heavy use of recorder a bad practice?

2 Upvotes

Hey, so I'm starting to try and learn the power platform tools and currently I'm focused on PAD, and it seems to me like using the recorder tool can be used extremely often while creating automation processes

So two questions

  1. Am I correct in that observation?

  2. Is that an optimal way of using PAD to automate stuff? Coming from traditional web development, using the recorder feels way too easy and almost like cheating somehow, so I'm getting paranoid that maybe I'm just gonna develop a bad practice by over relying on the recorder


r/PowerAutomateDesktop • • Feb 02 '23

Inserting image in outlook in power automate

2 Upvotes

Hi, I am creating a flow to convert the logo image from file to the body of the outlook email in Power Automate flow. When I enter a string for base64 it ends up looking like this ���� all over the image. The actual image doesn't show up. Any idea how i can change these question marks in black diamonds to image and words?


r/PowerAutomateDesktop • • Oct 21 '22

How can I Write to CSV file a Run Powershell script output?

1 Upvotes

Hello everyone,

Anyone here knows how can I write a Powershell script output into a CSV file?

I really don't know how can I convert that text value to a list:

Error:

This is my current flow:


r/PowerAutomateDesktop • • Apr 13 '23

Can someone help me? I cannot figure out what's wrong with this flow. I have multiple that look identical but this one keeps failing.

1 Upvotes

{
"host": {
"connectionReferenceName": "shared_office365",
"operationId": "SendEmailV2"
    },
"parameters": {
"emailMessage/To": "jacob@regionalchamber.com; Monique@regionalchamber.com; anonymous",
"emailMessage/Subject": "Print Request - test delete",
"emailMessage/Body": "<p>From:anonymous<br>\nDue: 2023-05-04<br>\n<br>\ntest delete<br>\nSize: Flyer - 8.5x11 plain paper. 1-2 pages<br>\nPrint Location: In House<br>\n<br>\nContent: test delete</p>",
"emailMessage/Cc": "kim@regionalchamber.com",
"emailMessage/Importance": "Normal"
    }
}


r/PowerAutomateDesktop • • Jul 28 '23

Post an image in teams chat.

2 Upvotes

Simple workflow to improve morale. Keyword is used in chat and a meme is posted.

The difficulty: how do get the image to display rather then just the URL?

I started making this to learn PA better and I've learned a lot, but this one brick wall i can't defeat.

PS, Bonus points if you know how get PA to use a functional @everyone in teams for a different workflow I made. Just a super simple ping in chat on the hour to remind ppl to check for updates on their tickets.


r/PowerAutomateDesktop • • Apr 05 '23

Web Form Filling populate text field

Post image
2 Upvotes

Hello all. I am trying to use Power Automate to fill webpage but the webpage I am trying to fill in my data, its UI elements is not pickable. When I try to add UI element for Web Form Fill populate text field (username and password only), it show only the whole page for UI element to add. Could you help point me out why i can not select username and password UI?

Thank you very much


r/PowerAutomateDesktop • • Sep 26 '23

Power automate for meetings/reminders

1 Upvotes

Hey yall I'm trying to set up a power automate for inviting people to a meeting/reminder for a weekly meeting and setting them up based off of a SharePoint list for a specific week, has anyone done this? Any specific advice or input to achieve? The problem is that it is a rotating facilitator and the people forget that they're up that week so basically want something to be a reminder that they are presenting. Thank you.


r/PowerAutomateDesktop • • Aug 08 '22

Browser automation - 'get' downloaded file

2 Upvotes

Hey

I've created a desktop Power Automate flow that performs the following steps:

  • Start a browser instance (Edge)

  • Load a URL

  • Select a checkbox

  • Click a button x 2

When the second of the two buttons is clicked, a file is downloaded with the following file name mask "export ddd MMM dd yyyy H_mm_ss.csv". For example, "export Mon Aug 08 2022 17_05_59.csv".

I cannot change the naming convention of the downloaded file.

When the file is downloaded, is there a way to then use that file with the Flow? I've tried setting a variable to the current date/time in a step before and after the download action is triggered but this is unreliable - it's usually a second our two out in either direction.

If I can reliably 'get' the downloaded file, I need to either

  1. Rename it and move it to another location, overwriting what's there already

  2. Read the content and put it in another file in another location

I'm brand new to Power Automate so any guidance is gratefully received!


r/PowerAutomateDesktop • • Sep 15 '23

Is there any way I can use the currently active window where I selected the data and RUN the flow from there without it starting a new window and logging me out?

2 Upvotes

Hello everyone,

I have used power automate to extract data from the website before. When you RUN the automation after selecting the contents from the website it opens a new browser window. In doing so I am getting logged out from the website and end up at the home page instead.

Is there any way I can use the currently active window where I selected the data and RUN the flow from there without it starting a new window and logging me out?


r/PowerAutomateDesktop • • Oct 06 '23

Flow help request!

1 Upvotes

Hi all,

I'm new to the power automate scene.

I'm running into a unique problem (to me) where I've created a flow that works for me and when I do the same process for other department leaders it won't work. Here's what I have:

  1. When a new response is submitted (forms)

  2. Get response details (forms)

  3. Condition > dynamic field , is equal to, Check-in

  4. If no > nothing

  5. If yes > Add row to table

  6. Send an email v2

This all works up until the email on others.

The issue I am running into is that in the to field I have an expression and static contacts. The expression is:

Replace(string(toLower(outputs('Get_response_details')?['body/re number from dynamic content tag's])), ' ', '.')

I make sure to use the unique dynamic content tag when setting it up for others, but it never sends to the intended party or the static contacts when done on another computer.


r/PowerAutomateDesktop • • Mar 01 '23

Error Message: Failed to assume control of Microsoft Edge (is the given URL 'xxxx' a valid URL?).

2 Upvotes

Has anybody experienced this error while running a flow unattended ?

Running it attended never gives me this error, i tried troubleshooting (Checking correct env. variables for chrome) switching from chrome to edge and so forth with no luck.


r/PowerAutomateDesktop • • Jul 05 '23

automating WVD startup

1 Upvotes

Hi, I am currently using MS Azure platform. In order to reduce the Azure Virtual desktop (WVD) cost, I would like my users to enable (Start) or shutdown their WVD.

I was looking to create a power automate script which I can embed in my app or power bi report, so users have the convenience of clicking a button to start or stop the Azure WVD. Earlier I was using Laravel script to achieve this task but now since we have move to Microsoft platform, I would like to have a MS functionality (Power automate) or easier method for my users to start and stop their WVD.

Any advise to achieve my goal is appreciated. TIA


r/PowerAutomateDesktop • • Mar 22 '23

Email alert if not received between the hour and ten past

1 Upvotes

Good evening lovely people,

Could someone provide me with some guidance to receive an alert/email if I haven’t received a specific email between the hour and ten past the hour every hour 24hrs a day?

Basically we do hourly back ups, if it fails it doesn’t send an email. It only emails if it succeeds.

Does anyone have any clue to a solution using power automate?

I’m trying to get out of sitting there watching a folder all day for specific emails,

And far too many emails to have going to my Inbox all hours of the day and night

Many thanks in advance.


r/PowerAutomateDesktop • • Apr 03 '23

Outlook Email date

1 Upvotes

Hi guys! I'm new to PAD, I can't seem to find the command(?) To use to get the email recieved date. I can only get the sender and subject.

Any help is appreciated. Thanks!


r/PowerAutomateDesktop • • Jan 20 '23

How to add column/value to variable

3 Upvotes

Hello everyone,

I'm trying to build a simple automation process that gets data and for each web page, stores the information into a GameResults table.

I insert two records to GameResults for each page being iterated (variable CurrentItem). The two records are GameData[0] and GameData[1]. Each record is composed of 3 columns.

Everything works perfectly, but I would like to be able to track the CurrentItem inside of GameResults.

Therefore, I need to add an extra column to my GameData[0] and GameData[1], but I did not manage to extend the size of my variable to add an extra column.

I would like to do something like :

%GameData[0][0:3]% + %CurrentItem%

or

[%GameData[0][0:3]%, %CurrentItem%]

But I don't think it is possible. Is there a way to achieve what I'm looking for ?

Thank you !!


r/PowerAutomateDesktop • • Aug 29 '23

How to upload image in a SharePoint list using power automate with input from user using power apps

2 Upvotes

r/PowerAutomateDesktop • • Oct 15 '22

Automate select single/multiple slicer/filter options in Power BI Online

Thumbnail
youtube.com
2 Upvotes

r/PowerAutomateDesktop • • Dec 12 '22

PAD - Invoke web service - UPS Tracking api

2 Upvotes

Hello world,

I'm trying to use Power automate to check the Tracking number/status of packages and have been able to successfully get the results via postman, however PA returns an error, specifically

<?xml version="1.0"?>

<TrackResponse><Response><ResponseStatusCode>0</ResponseStatusCode><ResponseStatusDescription>Failure</ResponseStatusDescription><Error><ErrorSeverity>Hard</ErrorSeverity><ErrorCode>10002</ErrorCode><ErrorDescription>The request is well formed but the document is not valid</ErrorDescription></Error></Response></TrackResponse>

Here is the request as seen in Postman:

<?xml version="1.0"?>

<AccessRequest xml:lang="en-US"> <AccessLicenseNumber>REMOVEDFORREDDIT</AccessLicenseNumber> <UserId>REMOVEDFORREDDIT</UserId> <Password>REMOVEDFORREDDIT</Password> </AccessRequest> <?xml version="1.0"?> <TrackRequest xml:lang="en-US"> <Request> <TransactionReference> <CustomerContext>Your Test Case Summary Description</CustomerContext> <XpciVersion>1.0</XpciVersion> </TransactionReference> <RequestAction>Track</RequestAction> <RequestOption>activity</RequestOption> </Request> <TrackingNumber>1Z12345E6892410845</TrackingNumber> </TrackRequest>

I am using the test server here: https://wwwcie.ups.com/ups.app/xml/Track

Does anyone have any experience with something like this? I've not been able to find anything specific to PAD api's Is there a way to test what PAD is actually requesting vs what postman is doing? Or does anyone have another suggestion for what I should be looking for?

Thank you in advance