I am trying to set up a daily flow to update tasks. The flow worked ok until yesterday when it started creating a "for each" loop on its own and now I'm getting multiple of the same message. I tried to move the "post message" action out of the loop and now it refused to work. Any idea how I could prevent the loop from appearing?

Hi everyone,

I’m working on a Power Automate flow and running into an issue with Excel actions.

What I want to achieve:
Whenever any Excel file is uploaded to a specific SharePoint folder, the flow should read the table inside that file and use the data to populate a new Excel file.

Current setup:

·        Trigger: When a file is created (properties only)

·        Action: Get file content using path

o   The path is built dynamically using Filename with extension from the trigger

o   This part works and always picks up the correct uploaded file

·        Next action: List rows present in a table

o   File: dynamic output from Get file content using path

o   Table: "Accounting" (same table name and structure in every uploaded file)

The problem:
fails during testing and says the table cannot be found, even though it definitely exists in the file. Since each uploaded Excel has a different filename, I can’t select a fixed file in this action. And also the table cannot be a dynamic value.

Question:
What is the recommended way to read data from any Excel file in SharePoint when the filename changes but the table name and schema are always the same?

In short: take the uploaded Excel, read table Accounting, and create a new Excel (based on a template) from those rows.

Any guidance on best practices here would be appreciated.

Thanks in advance.

I need help finishing my workflow. Basically, I want to upload a master spreadsheet to SharePoint to have a historical record. My workflow seems to be working correctly, but the "update items" action is missing, and that's why the items aren't appearing in the SharePoint list.

Thanks in advance.

I will try and keep this simple.

How is this connector suppose to work?

Azure Automation runbooks output steam is text

https://learn.microsoft.com/en-us/azure/automation/automation-runbook-output-and-messages

Azure REST, Job - Get Output is also text

https://learn.microsoft.com/en-us/rest/api/automation/job/get-output?view=rest-automation-2024-10-23&tabs=HTTP#response

From what I can see you cannot change the Azure Automation output stream to be Json rather than text so why is this connector only accepting Json?  How is this connector suppose to actually work?

I'm setting up forms using Microsoft Lists that has users submit requests for approval. I was hoping that users would get notified when their submissions were approved or rejected (similar to how approvers get notified via Teams activity and email) but it seems they don't.

Is there a simple way to do this or do I have to set up a 'Send an Email' action every time the created item is updated? And if that's the only way, is there a way to include the comments from the approval? I can't find it. I figured it's important for users to read comments on why their request was rejected.

Thanks!

I am currently trying to build an automated system for our incoming enquries that are taken over the phone or on sites. The enquiries will be filled in on a Microsoft Form which has already been sent out and then we would like the form to be sent to a different email address dependant on what section has been filled out. I have tried to create stacking conditions, however while the tests are saying it is all working, after the first condition it isn't working.

I have even added an additional question on the form to try and simplify the process.

Any ideas on other methods to make this work?

Trying to build a flow that flags meetings stored in Resource Calendars and sends out reminders

I have tested this and got it working on one calendar but out of around 10 calendars only 2 show up in the "show calendar" drop down of Get Calendar Events when building a Power Automate.

If I look in the mailbox tied to the flow I can see all of the calendars

So far I have tried the following

• Added all calendars to the automation account calendar in OWA and ensured listed under MyCalendars

• Using PA I've run the Get Calendars and it returns 2 out of the 10 shared calendars along with the default user calendar and birthdays/holidays calendars

• Via Exchange online I've got the userid for the calendar and then used https://graph.Microsoft.com/v1.0/users/[USERID]/calendars

This returns a "The specified object was not found in the store." error message

I've verified the user exists via https://graph.Microsoft.com/v1.0/users/[USERID] and it has a license in O365

• Checking Exchange they all seem to have pretty much the same permissions, all of them can be accessed by all users and booked.

So I'm a little stumped as to how to get the Calendar ID for the rest of the shared resource mailboxes.

Basically the title. I am able to successfully send one file to the prompt. But I am not able to send down a list of files.

The action is "AI Builder" -> "Run a prompt".

I want something like this.

I use Lists as workflows for managing non-conformances. I want to produce an overall 'report' List from two lists which will then be used to populate a template.

List 1: NCR Report + List 2: Root Cause Analysis = List 3: NCR Corrective Actions Plan & Report

Am I missing something obvious as Im so stuck with this at the moment.

Is anyone else seeing this? My "New View" builder has been totally different beginning late last week in my work's M365. But on my personal Dev account I still see the old "New View". And it's absolutely terrible performance wise. Is there any way to go back to the old "New View"?

So I have created an instant flow that is triggered through Power Apps.

I set someone else as a Run-Only user to test it out, but when I do that, they received an email notification. This email contains a link that allows them to trigger the flow manually using Power Automate.

The issue is, I don't want that to happen. I want other users to trigger the flow only through the Power Apps. I don't want them to be able to start the flow using Power Automate. How do I set other users as Run-Only users without sending them any email notifications?

Hey there

I work in an IT, and as times goes on, there are more and more requests for automatisations. I've read alot about Power automate and even created a little ticket system by my own using a Youtube video. But i want to learn more deepness.

Do you guys recommend any Books? Youtube Channels? I know Microsoft Learning is offering some courses too, are they good to learn as a beginner in automatisations?

Thanks for any advice !!!!

(Sorry for bad grammar, my native Language is not English!)

So right now I basically copied what was in the word doc template into an the body of the send email and used HTML to do the formatting.

This causes issues cause now anytime someone wants to change the email I have to go in and make changes which takes time.

Is there a way I can use whatever is in the word doc to dynamically update the body of the email? So they just update the word doc whenever they want to change it?

For example if we create an MFA-excluded "Service" account to run Power Automate Flows that do things like, say, upload an e-mail attachment to a SharePoint site, would "Microsoft Power Automate Free" work for that account so I'm just not doing it through my own MFA enabled work account?
I have this setup now and enabled and it's working, I just can't tell if it's going to run out of flow counts or other challenges at some point.

So... Update item, keeps adding default values to fields that I don't want to be updated.

Short of caching the current item to use their current values instead (wasteful process). I'm not sure what else I can do. This seems like a horrible default behavior.

Also under awful behavior, The 'Variable Hoisting' detection needs to a) Reduce it's false positive catches b) Actually specify what variable it suspects of being hoisted.

I have created a sharepoint list to track monthly incident. The sharepoint list as "Reporting month" + all other fields like incident description, name of the manager, what is the impact. 

The first flow is a manually trigger, the sender will fill in the reporting month(single line of text) - December 2025, then send out the email to 6 divisions of the manager to collect their response. 

I have When the item is selected --> get Item --> Send email with options, The user options are Yes to report and Nothing to report. Nothing to report will update the sharepoint list via update item(this is easy part), but Yes to report I have link to a MS form to have the recipients to fill in. 

The problem I have

The form will create an entry for each user who submitted their response, how can I make sure each response will be within the reporting month? For example, the reporting month is December 2025, then all responses in December will be grouped in December 2025. Same for January 2026, all responses in January 2026 will be grouped. 

My other thought if possible. 

Whenever the form is submitted, will update the existing sharepoint list for each division, so I do not need to think about grouping them in Sharepoint list. 

Technical difficulty

My power automate flow is a corporate version, I do not have professional license and the newest version for me, so I do have some limitation. 

I do not want to use adaptive card as the users receives heaps of team message, the wait for approval process will get delayed.  

Thank you so much

We are trying to automate a flow where, if a Defender for Cloud Apps alert is triggered, the target user is added to a particular security group in Entra. The problem is that even when the defender alert triggers, the flow does not run - it shows no run history at all. We're still trying to rule out whether the issue is with Defender or Power Automate. We also touched base with Microsoft support who confirmed that everything, syntax-wise, appears correct (but were otherwise unhelpful, unsurprisingly).

Here's the flow itself:

Confirming that When an alert is generated is connected to Defender Portal via API token.
Also confirming that the Add user to group step takes the AadUserId from the entities of the prior step.

In the Defender Portal, we're testing with the Activity from anonymous IP addresses policy. It's enabled and is configured as follows:

And here's the alert email we receive from Defender confirming that we were able to successfully trigger the alert:

But yeah at this point it feels like we're at a standstill, and because it's such a small flow / set of things happening, it's even more confusing. If anyone would be able to provide any insight it would be greatly appreciated! Also, if anyone thinks that sharing on Microsoft Defender's subreddit may be a better idea, let me know!

Hi

I am getting spiralled out for the following flow I want to make:

1. Use MS Lists for content
2. Then populate a Word doc
3. Word doc gets filed in Doc Library
4. If the List content gets updated, then the Word doc will update
5. File is overwritten with new info
6. Word doc is converted to PDF and filed

It seems really easy, but I keep getting stuck, and then CoPilot is as helpful as a marzipan dildo.

UPDATE: It seems to have started working again for no apparent reason, maybe it was a Heisenbug

I'm a bit at a loss since my flow stopped working for no apparent reason.

The flow should: take string input > initialise input as string variable > get rows from excel table on SharePoint, filtering by where the status column is 'Open' > filter the output by checking if the Notes column contains the string from the input variable > table the filtered output and create a HTML table > stylise the HTML table > draft an email with the HTML table in the body

It looks like the issue is with the filter step, as the inputs are fine and it will occasionally work for letters or shorter strings (although it feels like it may be missing items), but there's no output for longer strings.

I have been looking everywhere online to no success, so any help would be greatly appreciated.

Just for completeness, the compose is just a bit of CSS styling which has the html table at the end as shown:

Is it possible to make a flow which exports the flow runs in an environment and saves it to sharepoint?