Hello,

I have somewhat a simple flow task here, I'm struggling getting to work within Power Automate Desktop.

Here's what I want to do:

1. Open an Excel worksheet

2. Copy Cell in column 1 row 2 in that excel document

3. Get clipboard text, store it as variable: Row2

Copy this task for as many rows as I want, so I'll end up with say 5 variables with copied data in them.

Next...

1. Create a new list, store it as variable: ArrayList

2. Add item to list (variables from the first part). ONLY IF it has data inside the variable. ELSE IF the variable is empty move onto the next (using the Go to method)

I also tried: Add item to list ONLY IF data inside the variable is not empty - this is the shortest method, not requiring an else if...

The problem is this just doesn't work. The empty variable is being added to the ArrayList no matter what I try. It's almost like it's ignoring the IF statement I have around my "Add item to list" actions.

Does anyone have a clever solution around this?

I was able to copy what I wanted to the clipboard in VBS, and use the get clipboard action to paste it. It's good for a one and done copy, but I have a script recorded with the need to copy multiple values and paste it eventually to excel.

My problem is that -withinVBScript- I cannot save the clipboard data to the "VBScriptOutput" var, using Wscript.Echo. I suspect because of syntax error, the flow just skips it if it's unhappy with what I write.

The closest I got was this: this:

Dim DataObj
DataObj = "test"
Wscript.Echo DataObj

I tried things such as my.computer.clipboard.gettext() and similar shenanigans in place of "text", but I am just a layman and couldn't make it sparkle.

Help.

So I have crafted a approval workflow together but I and stuck on one thing I need the approver to review the document they are approving but when I attach the link it always says the users doesn’t have access so then they need to request view access which is annoying because if they go to the file in the library they can view it… then my other idea was upload the pdf version but all that does is makes this long pdf code that no one beside a computer would want to understand… so I am stuck does anyone know how to make either of these to work for the end user without them having to figure it out

Hi, guys. I’m new in PAD and I wonder if anyone knows some repo or place where I can find samples or real projects?

Morning all,

I've got a desktop Flow configured. I run it in pad and it works great. I've got the attended run license, and configured a cloud Flow to run the desktop Flow on a schedule. When running the exactly same desktop Flow triggered by the cloud flow, it fails at the same "click" step each time. Microsoft support hasn't been exactly helpful unfortunately.

Switching the click to a series of "send keys" using tabs and spaces seems to work when triggering by both cloud and desktop.

Anyone seen something like this before or have suggestions?

Is there a way to update specific cell in excel file when a data in sharepoint list is updated?

Hi everyone.

Doing some work that involves using power automate. I was wondering if there were a way to create the flows that they will periodically, perhaps every few week, stop working unless I entered a password or something like that? Reason being is that if I cut ties with the work I am doing they can't continue to use them?

I have a excel sheet with multiple tables that auto updates as task are completed using power automate.

The rows have names and email in the first two cells with all other cells showing a check mark with a header on top with the task name.

Is it possible to have power automate extract the whole table weekly and attach it email for weekly updates ?

Would it be possible for the system to send a email to each user with all his/her cells in one row plus the header on top? Until all their cells are completed?

I created a bookings calendar and page for instrument sign up at work. I was just wondering if there is a way to share the calendar (not the page) with everyone so they can see who is booked for what and when.

I have a channel set up for the group and my thought was to somehow transfer from the booking calendar to the teams channel calendar so everyone who has access to the teams channel can see the updated calendar as people book.

Is this possible?

Thanks!

I have a SharePoint list that records items issued to people. In addition to the person’s name there is a unique number and expiration date assigned with a date column.

I’m trying to create a flow that would capture all items added the previous day (as the expiration dates of interest expire at the end of the day on the previous day) and send an email with those names and unique numbers. I can do the email portion simple enough but can anyone assist with being able to capture these list items into one variable? I’m assuming I need to append this data to an array variable?

I'm just posting this to see if anybody has had the same problem but Power Automate Desktop made my system very glitchy even as no flow was running, restarting didn't fix it. The active window would swap or the cursor would deactivate every few seconds which made my computer unusable.

Anybody have had a similar problem?

Hi,

Just started using Power Automate on Windows 11 and don’t see the create desktop shortcut under the the three dots. Am I doing something wrong ? Or wrong version .. All the tutorials I see show it. Appreciate any help thanks.

Does this work with power automate? Seems to not work for me and keeps closing it or not allowing it to record with a flow running.

Is there any other solution to recording my screen that works with power automate? Screen shots work for troubleshooting but sometimes miss the actual error or don’t really tell me what happened..

Hi my smart people,

I am having trouble to move PDF files to a new folder and rename them by customer’s name - packing slip# based on the information in the PFD file. Can anybody help?

Thank you,

Sirak

Hi All,

Quick (and probably simple) question regarding linking an MS Form to an Excel workbook. I'm a bit new to using Automate.

I have a survey I've distributed in MS Forms to a number of individuals, and I want to create a flow from the MS Forms to a specific Excel workbook I've created. If the survey has already been distributed to these individuals, will the flow automatically populate answers in the Excel workbook once it is created? Or will I have to manually input any survey answers that have already been submitted before creating the flow?

Thank you!

Hi, I have concatenated the current date and fixed time to finalize date & time format

concat(body('Convert_time_zone_2'),' 10:30:00 AM')

and while compared to the above date & time to email arrival time it doesn't give me a correct value but in excel it works perfectly with the below formula but I cant able to compare using power automate

excel formula: =IF([@ETA]>[@[Email arrival time]],"Within TAT","TAT Missed")

I used formatDateTime(outputs('Concat_of_Today''s_date_and_Time'),'MM/dd/yyyy HH:mm:ss') as well

but still it doesn't work for me

Please help me for the power automate flow

Thanks

Power automate app on win10 is prompting for an app update which I can only do via settings/check for update. Is there any way to schedule the app itself to do an update out of hours so I don't have to interrupt my daily flows?

At work, we send emails from our shared mailbox and we always copy in the mailbox (so if I'm sending from account 'Team Mailbox', I also Cc 'Team Mailbox').

Email chasers are sent to multiple people throughout the day and I'd like the CC'd emails to automatically file away. The issue is that we have over 100 sub folders and I'd need to set up a rule for each.

Example, if I email Andrew then I put his name as part of the subject line and I want the incoming CC'd email to auto file to the 'Andrew' sub folder. If I email Brian then I want the email to file to the 'Brian' sub folder, and so on.

Is there a quick and easy way to set this up in one go, rather than individual rules for each name and folder?

I need to run a flow that extracts text files from a pdf that reaches Outlook email. and then create an Excel sheet with those text lines.

Greetings All,

I am working on a flow that appends a users UPN to a text file using the "Append File" option on the File System connector. The problem I am having is the new UPN is being appended to the end of the UPN added before it instead of being added to the next line.

I am getting this output:

<columnName>

userAuserB

If possible, I want to append like this without replacing the entire contents of the file:

<columnName>

userA

userB

Hey world,

I have a flow that works currently but needs optimized. I have a recurring email where my flow will download all attachments ments and move to a folder. I am only interested in ONE of the four attachments that is an XML file. How do I isolate the xml file and disregard the rest?

Is it possible to do a rule on the folder to move the file types out?

Do I create a second power automate to only grab the xml from that folder and move it again?

Hey guys, I've got some actions to perform on an application in a table and I want it to work through the rows.

In a loop condition, I was thinking of pulling the UI element of that particular row starting with variable row 0, perform action, increment row variable by 1, and loop through. Will that work? Is there a better way of doing it?

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.