Good day,
I have developed a Flow (#1) for a SharePoint that needs to archive files weekly, from one location filled with user folders and files, to a different read-only "archive" location in the same SharePoint library. This flow saves hours a week, and is critical to a certain department's SharePoint library processes. At the start of the year, I resolved the issue of the Flow not seeing all the files within these folders via the Top Count option, setting it to 999999.
Some time last month, this seems to have shifted. No changes were made to the Flow over the year, and it has worked flawlessly since I patched the Top Count issue. However, slowly over the weeks in September, more files were missed every run. At first it was a handful, then half the targeted directory... Now, I am back to not being able to get any files in this folder of the library. Has anything changed with Flow/Power Automate (that I am not seeing) to have caused this?
The "Get Files" output is seemingly limited to 160 total items, all folders and documents that don't match the following Apply to Each Condition, now. The Condition makes sure it is at the location PATH1/username/PATH2/, doing Contains Path on Path1/ and Path2/, is of a proper document type, and that the folder path does NOT contain OneDrive/ (as I had a user somehow drag-and-drop(?) their entire OneDrive folder into their SharePoint folder...). See picture below.
I have a simpler Flow (#2) that does the same for another process (only .xlsx docs), however even that fails. Hence, my believing the Condition (that has worked fine for months) is not the issue at hand. (Still, pictured below.)
These are my first-ever Flows, so I am open to suggestions. Has anything changed since the start of September? I know the rebranding has been running, and there have been service disruptions, but this issue has been worsening over the past month consistently at every scheduled weekly run.
Condition for Flow #1:
Condition for Flow #2:
Get Files (properties only) screenshot:
tomatotech,
We have had some service issues the past couple of weeks, interoperation with other services (like SharePoint Online) was impacted as part of those concerns. If this is still reproducing for you, though then it's unlikely these services issues are involved.
The Flows you describe, especially this simpler Flow, read like they're logically sound. If they're not reporting any failures then this leans in the direction of a performance issue.
Have you also noticed these Flows running more slowly than before? We updated our throttling around the time you state these Flows began to have issues, you might be losing items as a part of that. This is even more likely if you're processing thousands of items.
For more on these changes and guidance in response:
https://support.microsoft.com/en-us/help/4531688/troubleshooting-slow-running-flows
The short of it is that the license you have matters and the structure of the Flow does, as well. It's all covered in the above link.
The SharePoint connector itself also has limits/restrictions:
https://docs.microsoft.com/en-us/connectors/sharepointonline
If you go through this and can't seem to find a link, I'd suggest opening a support incident through the Power Platform Admin Center. Although we're not solution experts, we can certainly help verify the nature of your issue.
Let us know!
Patrick
Patrick,
Thank you for your response. It certainly is not a speed issue, as at the end of August the Flow was taking 17 minutes or more (Apply to Each had 250 items). The first run on September 7th was 7 minutes (224 items). September 14th only had 195 items, at under 2 minutes. The most recent run: 160 items at 17 seconds.
While troubleshooting, I noted there was a "Degree of Parallelism" option on the Apply to Each that I had messed with, to no avail. It is currently set to 50, but no matter what that is set to, the input from Get Files (properties only) remains unchanged.
I will read all these over tomorrow, and see if I can find out more.
( Waiting on next run on Monday [10/12] to see if it manages to find any items )
- TomatoTech
The flow ran again last night, and "Succeeded" in 17 seconds. The core issue is the Get Files (properties only) block just doesn't seem to be getting all the files within the folders I've targeted. The few dozen files that are there are seemingly ignored, whereas others unrelated are detected in the output.
For example, there should be a few dozen excel files (.xlsx) being detected. All the Output file shows from the run last night are four .xlsx files in total, none are in the file paths I want (hence no actions from the For Each Condition to work on those).
Is there a way I can look deeper into the Flow's execution to see why this is occurring? Is it hitting one of the limits listed and just silently terminating that step? This all used to work perfectly without a hitch, for months, until something on the platform changed at the start of September to cause this. The Flow itself was not altered.
Thank you for hour help in this,
- TomatoTech
Dear Community Members, We'd like to let you know of an upcoming change to the community platform: starting July 16th, the platform will transition to a READ ONLY mode until July 22nd. During this period, members will not be able to Kudo, Comment, or Reply to any posts. On July 22nd, please be on the lookout for a message sent to the email address registered on your community profile. This email is crucial as it will contain your unique code and link to register for the new platform encompassing all of the communities. What to Expect in the New Community: A more unified experience where all products, including Power Apps, Power Automate, Copilot Studio, and Power Pages, will be accessible from one community.Community Blogs that you can syndicate and link to for automatic updates. We appreciate your understanding and cooperation during this transition. Stay tuned for the exciting new features and a seamless community experience ahead!
We are excited to announce the Summer of Solutions Challenge! This challenge is kicking off on Monday, June 17th and will run for (4) weeks. The challenge is open to all Power Platform (Power Apps, Power Automate, Copilot Studio & Power Pages) community members. We invite you to participate in a quest to provide solutions to as many questions as you can. Answers can be provided in all the communities. Entry Period: This Challenge will consist of four weekly Entry Periods as follows (each an “Entry Period”) - 12:00 a.m. PT on June 17, 2024 – 11:59 p.m. PT on June 23, 2024 - 12:00 a.m. PT on June 24, 2024 – 11:59 p.m. PT on June 30, 2024 - 12:00 a.m. PT on July 1, 2024 – 11:59 p.m. PT on July 7, 2024 - 12:00 a.m. PT on July 8, 2024 – 11:59 p.m. PT on July 14, 2024 Entries will be eligible for the Entry Period in which they are received and will not carryover to subsequent weekly entry periods. You must enter into each weekly Entry Period separately. How to Enter: We invite you to participate in a quest to provide "Accepted Solutions" to as many questions as you can. Answers can be provided in all the communities. Users must provide a solution which can be an “Accepted Solution” in the Forums in all of the communities and there are no limits to the number of “Accepted Solutions” that a member can provide for entries in this challenge, but each entry must be substantially unique and different. Winner Selection and Prizes: At the end of each week, we will list the top ten (10) Community users which will consist of: 5 Community Members & 5 Super Users and they will advance to the final drawing. We will post each week in the News & Announcements the top 10 Solution providers. At the end of the challenge, we will add all of the top 10 weekly names and enter them into a random drawing. Then we will randomly select ten (10) winners (5 Community Members & 5 Super Users) from among all eligible entrants received across all weekly Entry Periods to receive the prize listed below. If a winner declines, we will draw again at random for the next winner. A user will only be able to win once overall. If they are drawn multiple times, another user will be drawn at random. Individuals will be contacted before the announcement with the opportunity to claim or deny the prize. Once all of the winners have been notified, we will post in the News & Announcements of each community with the list of winners. Each winner will receive one (1) Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 ($1800 value). NOTE: Prize is for conference attendance only and any other costs such as airfare, lodging, transportation, and food are the sole responsibility of the winner. Tickets are not transferable to any other party or to next year’s event. ** PLEASE SEE THE ATTACHED RULES for this CHALLENGE** Week 1 Results: Congratulations to the Week 1 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Community MembersNumber SolutionsSuper UsersNumber Solutions Deenuji 9 @NathanAlvares24 17 @Anil_g 7 @ManishSolanki 13 @eetuRobo 5 @David_MA 10 @VishnuReddy1997 5 @SpongYe 9JhonatanOB19932 (tie) @Nived_Nambiar 8 @maltie 2 (tie) @PA-Noob 2 (tie) @LukeMcG 2 (tie) @tgut03 2 (tie) Week 2 Results: Congratulations to the Week 2 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 2: Community MembersSolutionsSuper UsersSolutionsPower Automate @Deenuji 12@ManishSolanki 19 @Anil_g 10 @NathanAlvares24 17 @VishnuReddy1997 6 @Expiscornovus 10 @Tjan 5 @Nived_Nambiar 10 @eetuRobo 3 @SudeepGhatakNZ 8 Week 3 Results: Congratulations to the Week 3 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 3:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji32ManishSolanki55VishnuReddy199724NathanAlvares2444Anil_g22SudeepGhatakNZ40eetuRobo18Nived_Nambiar28Tjan8David_MA22 Week 4 Results: Congratulations to the Week 4 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 4:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji11FLMike31Sayan11ManishSolanki16VishnuReddy199710creativeopinion14Akshansh-Sharma3SudeepGhatakNZ7claudiovc2CFernandes5 misc2Nived_Nambiar5 Usernametwice232rzaneti5 eetuRobo2 Anil_g2 SharonS2
On July 16, 2024, we published the 2024 release wave 2 plans for Microsoft Dynamics 365 and Microsoft Power Platform. These plans are a compilation of the new capabilities planned to be released between October 2024 to March 2025. This release introduces a wealth of new features designed to enhance customer understanding and improve overall user experience, showcasing our dedication to driving digital transformation for our customers and partners. The upcoming wave is centered around utilizing advanced AI and Microsoft Copilot technologies to enhance user productivity and streamline operations across diverse business applications. These enhancements include intelligent automation, AI-powered insights, and immersive user experiences that are designed to break down barriers between data, insights, and individuals. Watch a summary of the release highlights. Discover the latest features that empower organizations to operate more efficiently and adaptively. From AI-driven sales insights and customer service enhancements to predictive analytics in supply chain management and autonomous financial processes, the new capabilities enable businesses to proactively address challenges and capitalize on opportunities.
We're embarking on a journey to enhance your experience by transitioning to a new community platform. Our team has been diligently working to create a fresh community site, leveraging the very Dynamics 365 and Power Platform tools our community advocates for. We started this journey with transitioning Copilot Studio forums and blogs in June. The move marks the beginning of a new chapter, and we're eager for you to be a part of it. The rest of the Power Platform product sites will be moving over this summer. Stay tuned for more updates as we get closer to the launch. We can't wait to welcome you to our new community space, designed with you in mind. Let's connect, learn, and grow together. Here's to new beginnings and endless possibilities! If you have any questions, observations or concerns throughout this process please go to https://aka.ms/PPCommSupport. To stay up to date on the latest details of this migration and other important Community updates subscribe to our News and Announcements forums: Copilot Studio, Power Apps, Power Automate, Power Pages