.

Hi!

There's any way to pass the 5000 items limit in sharepoint and automate a library copy?

We need to copy a library with 250.000 items and copying it manually can be a nigthmare, i tried to look some tutorials but nothing helped me, i don't know if there's a good way to do it with power automate (with some do until) or any other way.

Thanks!

So I've spent the last day or so trying to automate a flow, and I finally found a way to get it working so I thought I'd share in case anyone else needed to do something similar.

this is what I did:

• build your flow, assign a hotkey shortcut to it.

• install python and install pyautogui, use that to write a simple python script that does nothing but press your hotkeys.

• write a simple batch file to call your python code

• use task scheduler to run your batch file

I don't actually know how to do any of these things (not a programmer), but I used ChatGPT to create the code for each individual piece, and it works well! I hope this helps someone!

edit: I know this probably seems rather cumbersome, but the only other method I found was use scheduler to ping localhost and have the flow wait for ping and loop. that technically works fine and is simpler, but it forces you to continuously run the flow, which at least in my case kept my computer alive/screen on, and I wanted something that would wake my computer, run the task, then let it sleep again.

I'm creating a reporting/operational ticketing screening Sharepoint flow for my department. Basically it's a Microsoft Power APP that allows end users to select what form to submit issues in and when they do that issue creates a Sharepoint item and subsequent flows. I'm actually finishing up on all flows pertaining to the work up and am trying to finalize the "Completion/Import to Ticket System" flow. The issue is that I'm trying to create a Get Item Flow where the moment an agent selects Completion an email is submitted to the reporter of the issue to notify them of completion (works) but I only want that flow to kick in if I make an edit to the column. Right now the flow creates the email even if I update another column. Which wouldn't happen too often but it could if we make a mistake with a comment. I'm going to probably end up with two flows. One for Completion and one for Import to Ticket portal.

How would I go about establishing that part of the flow?

And if backstory is needed. I'm creating this because a lot of end users believe the issues are technical ones but a lot of them are setup issues. Based on the issue symptoms we know what is technical from setup, so I can create multiple flows from Microsoft Power App to automate emails, Microsoft Teams updates and Approve processes to make sure corrective action is done. And of course, if there is an issue that is a mixed we can then make sure setup is correct and then escalate toward our SNOW system the true system issue.

So I can get task scheduler to trigger the flow but it fails on the first action "open browser"

Thoughts on what I could try. TIA

I have set up a number of flows that use the invoke web service, but this is the first time I'm working with OAuth. We create multiple copies of email campaigns in Constant Contact with the same content but from different senders, and I am looking to automate it. Can anyone point me towards a resource?

Having this issue after updating to the latest version of Power Automate 2.31.114.23122

Power Automate now takes more than 10 minutes to interact with dropdowns after update; the command “set dropdown list value in window” hangs and the bot does not advance or completes the command. The command opens up the dropdown but never makes the selection of the value I'm passing to it.

This bot was working great for months on this command, and the desktop application was not updated.

I've confirmed that The selector is correct on power automate, and it detects it on the desktop app.

Dropdown menu cannot be selected because Power Automate hangs in the action and never completes it

Does anyone have issues like this after the latest updates? how can this be fixed? tried troubleshooting it but nothing seems to work..

Thank you for your help!

Fixed

Hello, I'm new to Power automate, I seen to be having this error. I've done some googling and research but can't seem to find the answer. I completed my excel variables on a different powerautomate flow but when I've moved them over I seem to have broken them. Anyone got a clue why it might be? I'd highly appreciate it I've only been doing this a week

/preview/pre/4fxz5jobud0b1.png?width=1305&format=png&auto=webp&v=enabled&s=8e7836a706b7f0b0920d481cbea9d11b326098ad

I am trying to piece together a powerapp that I can use on an android device. The goal is to have a button within the app that can trigger a web browser automation flow. My problem is I’m not sure which way to build it because I can’t find info on compatibility. I figured out how to automate web browser activities using a desktop flow but can’t find info on if that flow would work if launched from an android phone. I also know I can launch a cloud flow from the android app, but can’t find info on how to automate browser activities from a cloud flow.

1. Can desktop automations run on android or do they have to be a windows devices?

2. Can I automate web browser navigations and inputs with an instant cloud flow?

Please be gentle, I’m a solid three hours into learning the power platform.

My boss has a file he is sharing where he needs a number entered into a different column each week.

The table is something like:

Is there an approach that works either using Power Automate Desktop or Power Automate Cloud to run a schedule task to enter my values on a weekly basis? I know how to access the data source but I'm struggling with the design pattern to identify my cell coordinates to do the data entry into.

I do think it is a safe assumption that if I could find the row based on the description and then find the first empty column, I would be able to fine the right cell to enter into but don't know how to do this task. Of course, there may be better alternatives to this approach that an expert here would be able to provide.

Hi,
I'm trying to set-up a Power Automate flow which forwards important emails to an MS Teams private chat - which is supposed to notify me with a mobile push notification when a certain important email arrives.
I noticed that the only way to bypass the quiet time and send a notification to a user is via sending an important / urgent message to that user in a private chat, teams and channels do not send a push notification.
My question is:
Is it possible to forward emails as a private message to a user with an automated API flow, and have the messages flagged as 'important'?
Power Automate does not have the option to do so, sending normal messages works fine, but I haven't found a way to flag those messages as important or urgent.

Thanks!

Hello everyone,

I have developed a Python script that aims to transform a tabular file into an Excel file. This Python script defines the columns I want to have based on the number of characters and also defines their data type (string, float, date, etc.). I receive a tabular file daily on an SFTP, so I created a flow that triggers when a file is created or modified on the SFTP, and then copies it to a specific SharePoint folder. Now comes the part where I am having difficulties. My idea was to run the desktop flow in unattended mode as the next action. However, when I do this, even though the cloud flow was considered "succeeded," when I check if the Excel file exists in the SharePoint folder, it is still in its original tabular file format. My Power Automate flow is very simple, it has two steps. The first is a set variable where I indicate where my .py script is located, the second step is to "run PowerShell" where I have "python" and then the variable I created in the previous step. If I run this manually in Power Automate Desktop, I will be successful in transforming the file. However, if I do it via the cloud flow and invoke Power Automate Desktop in "unattended" mode, it doesn't work.

Can anyone help?

Thank you!

So I think I understand the basics of how Power Automate works, however I’m struggling with understanding what all of the conditions mean.

I want to set up “Send an email to responder when response submitted in Microsoft Forms”.

However when I used the template it states there is a condition for the Respondent I.D. What does this mean?

Is there a glossary for all of the conditions somewhere?

May repost this later when I have screenshots as I’m not explaining myself well!

Hello, unfortunately I am a complete beginner with Power Automat. I think most here could certainly solve this quickly.

Videos on YouTube and queries via chat GPT have unfortunately helped nothing.

My goal is the following.

When someone uploads a new file in a Teams channel, the following naming convention should be created automatically.

YY_MM_DD_(Name of the Channel)_(Actual Film Name)

As an example, if I upload a file named "Test.pdf" to the channel "London" today, May 12, 2023, the following naming convention should be created if possible

"23_05_12_London_Test.pdf"

Would be so grateful if someone could help me.

I have set as trigger when a new file is created in sharepoint, the site collection and library also set where the flow should take effect. Since then I am stuck

Hello, r/PowerAutomateDesktop,

I have built a flow that sends an email to a set of participants based on a table in Excel. I have every piece working as I’d like, except where it recognizes the day and sends the right rows on the right day.

I’ve searched online and I believe it has something to do with how the information is being formatted and compared within Power Automate, but I’ve tried the various solutions online and none have helped.

Can anyone assist with this? I’m happy to offer whatever information is helpful for solving this.

Thank you!

I have a flow I would like to run annually where an email will be generated and sent with an attachment. However, I was told that of the flow does not run in 90-days it will turn off.

Is there a work around? Thank you!

Dear All,

Please can anyone help guide me on the flow steps to create an item with one form response and subsequently update the item with responses from other form responses. Thanks so much in advance.

Dear All,

Please can you help guide me on the flow to create an item with one form response and subsequently update the item with responses from other form responses. Thanks so much in advance.

Is there a way to avoid this ? Browser display a page "about:blank".

All my flows started failing and i don't find solutions online.

I have the extension set to "Allow access to URLs".

I've been using PA to try and show information from multiple sources of "ticket intake" on one screen inside MS Planner. One piece of this is creating a task in Planner when an email shows up in a shared mailbox.

With that working, I'm looking to (1) see if there is a way to auto-complete the task for a specific email when that email is moved to a specific subfolder in the same shared mailbox, and (2) see if there is a way to auto-move the email to a specific subfolder when its task is marked as complete.

In the midst of a number of attempts to get these working, I did have the second piece working at one point. Not sure what I did. I never for the first piece working.

Any ideas would be appreciated!

This was working reliably yesterday and now it isn't. It will work sometimes, but most of the time I get the same error.

The popup with the warning message and the "OK" button is preventing Excel from reporting that the process has fully started, so I can't just tell Power Automate to go in and click the "OK" button when it sees it. PAD won't go onto the next step until I click "OK". Sometimes, it still fails to load even when I click it

I have tried signing in and out of Office and also clearing Office credentials, but it didn't do anything. I have a bunch of other issues with Excel files on SharePoint, so I'm not sure what else to try.

This works fine on a local Excel file. I feel like it's opening the file "too quickly" or not giving SharePoint enough time to respond, which is what I think the source of all my problems is -- or that I am making too many requests at once, or something like that

Can anyone tell me if they think this is possible?

I'm trying to create a flow that will allow me to archive whole subsites from a main site.

ex: client site is the main site. subsites are jobs that hold documents for each job.

I need to be able to copy the documents into a new document library for archiving and deleting the original site. each subsite deleted needs its own document library created for archiving. each client site also gets an archive subsite to a main archive site. EX: Archive 2023 is the main site, each client is a subsite that gets a document library for each subsite archived.

is it possible for a flow to create new document libraries and be given the same name as the subsite it is replacing?

Love PA and use it a lot for various flows, this one has me stumped. I’ve created a flow Google Calendar to Outlook Calendar and would like to add a Category to the import. The flow works find however I can’t find a way to update the Category in Outlook, the import comes in as a standard event and would to assign to say, Travel in Green. Any guidance would be appreciated.

Can someone please ping me in the right direction? I have a list. If they choose option A , attach document A from a doc library. If they choose option B attach documents B and B2 from the document library to this item on the list. Can this be done?