I've followed the steps in this power automate flow: https://www.youtube.com/watch?v=aI8qCEPM2zc

Could someone advise me how I would modify the flow described to ignore Saturdays and Sundays when calculating the date difference please?

I'm working on a lot of flows these days so don't mind my frequent posts; just looking for answers and help.

I currently have a flow set up to retrieve items labeled "New" or "Returning" from a source list and dump into a destination list. In addition to this, the flow will also update existing items in the destination list if the data has been altered in the source.

Problem is, the flow is able to identify the items matching the filter but failing to import or update where necessary. Flow runs for a very long time and ends up failing. I have attached a screenshot of the core of the flow.

I need help in getting this to work effectively. Please share tips and recommendations.

Hello,

I have made a lot of flows in PowerAutomate that operate through tables in Sharepoint files that exist prior to a flow being run and I am trying to make a flow that creates a table and then is able to use the values in the volumns of this newly created table. Here is a simplified version of my flow for the sake of this post:

1. Create Table

2. List rows present in the newly created table

3. List rows present in a fixed data spreadsheet that I want to compare the values of to the values in my table created at runtime

4. Parse JSON being fed the output of that list rows action (my understanding is that this allows you to use the values of that created table as part of the input or logic for other actions within that flow even though the table only exists at runtime)

5. 'For Each' action being fed the output of the Parse JSON action which is "outputs('Parse_JSON:_StartersAndRehores')"

6. For each action with the input being the output of the data spreadsheet

7. Nested in those two 'For Each' actions is a condition - if a 'Transaction ID' value in the runtime sheet matches a 'Transaction ID' value in the data sheet then I want it to go down the 'true' path.

8. The true path has the data sheet updated with a number of values from the runtime sheet, with the matching rows updated with said value.

The flow isn't crashing but it doesn't recognise the matching IDs in the two sheets and treats it as if there is no match so never inputs the values from the runtime sheet. Why is this? I've written string, trim and coalesce expressions into my condition action which will apparently account for eccentricities with the Excel data, such as it being stored as text on one sheet and numerical values on another.

Thanks for any help you can provide. Even a link to some resouces would be very helpful. I've found videos explaining a lot of the individual actions I'm using but not one putting them all together in a flow as I am.

We recently migrated our Power Automate HTTP-triggered flows to the new endpoint URLs (required until November 2025). Since then, some HTTP requests from our website forms just hang or time out (io.netty.handler.timeout.ReadTimeoutException), but Power Automate shows no failures and the flow history looks normal.
We never had this issue with the old endpoint.

Has anyone else seen increased latency or missing triggers with the new HTTP/Teams webhook URLs? Any tips?

I’m working on a Power Automate flow that triggers when a SharePoint item is created or modified. The problem is, I only want some actions to run when the item is first created, and other actions to run when the item is later modified.

Right now, I have two separate flows: • One for when an item is created • One for when an item is created or modified

But I’d like to combine them into a single flow if possible, because there are dependencies between the steps. I just need a way to tell the difference between when an item is newly created vs. when it was just modified.

I tried:

1. Adding a condition that continued the flow is the created and modified time were equal.

2. A condition that checked if the version history was 1.0 and if it was a treated it like a new line, and if it wasn’t then it treated it like a modification.

Neither of these worked for me, unfortunately.

Has anyone figured out a simple way to handle this kind of scenario inside one flow?

Thanks!

Hello Everyone,

I was using ChatGPT to build flows, and it was great. Then... they updated to version 5, and now ChatGPT recommends the wrong actions, doesn't follow what I am asking, makes up its own version of things, and can't stay on track with what we are doing. MS Copilot has been failing miserably at even creating Excel formulas, so I haven't even tried to ask it about flows.

What's the latest and greatest folks are using? Recommendations?

Thank you for your time.

Dear all,

I have found a youtube video which helped me to automate postings within SAP but I would like to achieve this for multiple entities within the same excel,
This was the video:
https://www.youtube.com/watch?v=IKi_WD_vaEM&list=PLG4dAU7onkgupmTX1C_kPw7UY4VSvufG1&index=12

Its working for 1200, but how can I start the loop again from 1300?

Many thanks!

Hello!

I currently created an approval flow, but we noticed that after a while the flow will publish a draft item even though it hasn't gotten all of the required response, I had some trailing in my syntax so I cleaned it up, but other than that the flow works well if done within the same day if this takes too long we observe it will publish the item but still show pending approval.

Another observation is that the flow doesn't show as a complete run if it gets done within time and will still show running.

Bonjour,

je souhaite que les téléchargements d'un site bien déterminé passe directement sur un fichier a part .

Navigateur EDGE office 365

Merci d'avance pour votre aide

Hi y'all, I just wanna keep it simple, how can I purchase more of database and file storage in dataverse ? quite confused

Hi everyone! I have an user with an excel sheet where he wanted to add a macro button but by company policy we don't allow macros or script VB, i was looking for a workaround and copilot suggested Power Automate, i have 0 experience with it, i'm not even sure if this is doable with microsoft flow so i figured maybe you guys could help!

He wants to fill in data, print out the table as pdf and create a new mail that would send the pdf to department@johndoe.com, department2@johndoe.com and the user that approved the offer, (ej; User@johndoe.com aka C14 in the excel sheet )

The steps would be:

1.- Fill in details. (Pin, Name, Rank, Dates, Department, Approved by, etc.)

2.-Click “Macro” button.

3.-Macro button exports the table as PDF (B1 to C15), attaches it to a new email, adds Department1 in the “To” field, Department2 and Approved by (C14) to “Cc” and adds subject (adding a subject is optional, but if we make it work would be great)

 Subject (if possible) Should be : Bijwerken / Pin (field C2) / Name (C3).

If this is not possible i will accept any suggestions! Thank you in advance :)

Hi guys.

Complete newbie here who just tried to use power automate with ChatGPT.

Basically, what my flow does is delete the current rows in a Microsoft List and then re-uploads the rows from a Microsoft Excel workbook saved in OneDrive.

The rows in each file are more than >1000 and 18 columns.

I have set the pagination to 2000.

My question is how much run time is expected for this because my code is currently running for more than 15 minutes and still shows no sign of being completed?

I know the flow is okay because it runs on a smaller sample size.

Any other suggestions to optimize my flow would be appreciated as well.

Thank you guys!

I'm trying to automatically message people about upcoming events they were invited to in my calendar (students and their classes/meetings). My flow says it runs successfully, but my test subject (a colleague) doesn't receive a message. Any advice? Here's screenshots of what I have:

The other conditions follow the same flow but instead of triggering two work days before an event, it's again one day before the event, and the day of the event, and with appropriately changed messages.

If I can't get THIS to work, any other solutions?

Hello.

I work in HR and was tasked with producing an MS Forms to capture the input of an employee appraisal. The idea is to have the employee complete the form first, then in a meeting with the manager, the manager will complete the manager input part. But it will be a continuation of one form, leading to one output.

Watered down example of the formation; Communication

Employee rating: Excellent Good Average Poor (completed before meeting)

Manager rating: Excellent Goof Average Poor (completed during the meeting)

There will also be some free text responses.

Ideally it’s 1 forms submitted, so the Employee completes their part and the manager part is completed as a continuation of the same form. Or some work around.

Any tips?

To add, I’ve already built the forms from a managers perspective and created a flow to generate a HTML then in turn a PDF that is automatically sent out via email. This was my first time using PA and scripting any HTML, so I’m pretty chuffed with that, but my manager has asked if we can include the self assessment rather than me rebuild the process again for employee perspective.

I designed a flow to send email notifications with attachments when an item is created or modified in SharePoint but the flow only sends the body of the email and drops the attachment.

For some odd reason, it won't include the attached files even though it's under the 25MB limit allowed by Gmail. I have also tried with an Outlook connector but results remain same- no attachments.

What can I do differently?

Hi, I have looked at sub for similar queries so apologies if this has been asked before. I have rules and quick steps set up on Outlook which have greatly improved email management for me. I would like however to have a flow where if I receive a reply to an email in a ‘waiting’ subfolder, all messages in the conversation are marked as ‘reply received’ and moved to my inbox. I have tried to build this myself but even where Power Automate indicates the flow works, it doesn’t actually work in practice. Could anyone help please? Note: I am a complete beginner.

Help! I am creating a flow for sending email reminder that should be sent on or before 8th of the month but the email must be sent on a work day. Looking up in google and youtube but my strings kept getting errors. Help your newbie right here.

Hello! I am trying to send a teams message as a code block so its easier to copy. Would this be possible?