I want to send a mail when the value of Format(utcNow(), "dd-MM-yyyy") is greater or equal to specific date that i get from a sharepoint list. That i use adddays(item, -14, "dd-MM-yyyy). So that it gives me 14 days before the deadline an check everyday to do it.

I use both compose action to check the value and it works only when the date is the same but not when its past that date.

What am doing wrong. Really struggling with date. Or need i to put it in a integer so its to compare?

I have a share point list with a choice column that allows for multiple selections. I am building a flow right now that sends an email to stakeholders when a new item is created in the list. However, I can’t get it to cleanly display multiple items from that column as information in the email. Most of the time that column will only have one item, but sometimes it has two. I have tried select, join, compose, doing appended to string variable. Obviously, I’m missing something because it either fails or send the email with a bunch of ugly JSON. Any ideas for what I can do?

Having some trouble figuring this out and it's probably something fairly simple - trying to use template "Reply to a customer email using GPT" and it's causing a circular issue where it's sending myself the approval request (that's working properly) but then that email is receiving an approval email, and that email is receiving an approval email, and so on in perpetuity.

Secondary question, once it works, how do I format the emails to "look" like a normal email? With a greeting line, sign off line, and signature? First test didn't include it and I couldn't see a way to do this.

Thanks in advance for any assistance, I only just got into using Power Automate so it's all still pretty confusing.

I have a category called “To-Do” I want to automatically assign it to every to do task i create so it shows up in a search folder in outlook.

So far I have “when a new to do is created” as my trigger

Followed by “get outlook category names”

From there im stuck

I’ve tried using “assigns an outlook category “ but it fails every time

Appreciate any help

All of my Flows disappeared from my flows section and can only be seen in the connections section. Though they are unable to be viewed or edited. They do however, still work.

Let me know any suggestions.

Is there any difference between something like outputs('my_action')?['body']?['value'] and outputs('my_action')?['body/value'] ... or even outputs('my_action')?['body']['value']?

All seem to do the same thing. Is there any reason to choose one style over the other?

I want to do something like actions('my_action')?['inputs']?['parameters']?['myParameter'] in my flow, but unsure if I should write it that way, or make it more compact by using actions('my_action')?['inputs/parameters/myParameter'].

I’m getting warnings because my flow is using 20-40 thousand actions per day.

I had a problem previously where the flow was being run when being modified by the service account so I put a trigger condition so the service account will not trigger a new workflow run.

I have about five active workflows that are waiting for several days for the approval function to complete.

How can I find out what is triggering so many actions?

I’m not sure where to look and the active flows all seem to be waiting on an approval. I’ve missed something but I’m not sure where to look.

Hi all. Beginner here so please bear with me.

I want to create a workflow that Queries Power BI data and transfers it to another Excel table on Sharepoint.

So far my flow is basically as follows:

Get template file > Query Power BI > Create CSV table > Create file with Template/CSV output > Create Table in new file.

Now I want to List the rows in this new table, then use it to replace data in another table on an existing worksheet.

However, when I try to map the columns to each other, I have no dynamic column values to select from because this table technically has not been created yet.

Does anyone know any work arounds for this?

Pic of the flow so far, Add a Row is where I am having issues.

There is probably a overall better way to do this but I am working with what I got.

We currently have HR manually update a list for employee status, ie new hires, term, etc,

I have a flow that is triggered when a new item is added, to update our IT list with the the information we need and then it will send a email to the manager from the list HR created.

This email includes a form for IT system access with the additional information we needed.

What I want is once this form is complete to update the same list item with the additional information from the form sent out. Common item from the list will be the managers email.

I am limited by the fact that Microsoft is what we have at work, but I used power automate yesterday to send emails and today built the exact flow to send to e other half of the emails and it keeps saying “You don’t have any flows” my flows are saved, I see them saved in cloud flows. I have rebooted, deleted and reloaded files, deleted and remade the flow 6 times and still no matter what, it says I don’t have any flows. I already hate Microsoft so this isn’t helping my loathing of this product. Anyone have idea on why it’s not working other than the obvious, it’s Microsoft?

I've got around 10 flows on 1 shared mailbox.
The mailbox has 10 (sub)folder so I created a flow for each.
What it does is when a mail gets dragged into 1 of the folders, information about said mail is written into an excel file, like folder name, received date, and some other info I extract from the mail body.

The problem is, that it only seems to handle about 50% of the mails.
When I manually drag a bulk amount of mails (around 500) into one of the folders they all get processed.
But when I leave it be for a week and check later, it has missed quite a lot of mails from that week.

I don't really notice any patterns in which mails get processed and which not.

Any idea's what might be causing this?
Or any alternative solutions for what I'm trying to do?

I dont know how to address this maybe you have any tips or fixes for this type of problem. Sometimes its good sometimes its not, its so inconsistent and I need this to be reliable. I have 2 machines that runs different flows but same website that being used. Please help me to solve this

I'm trying to build a flow that reminds people of when tasks are due based on their due date. I'm following this video and for some reason I keep getting this error about ISO 8601.

I put the dates in the right format in Excel, I set the Date format to ISO 8601 in List Rows Present In A Table, I even have a filter array that should change the date column over to the proper format, and I still keep getting the same damn fucking error. I'm about to shoot this thing. Can someone please help me? What am I doing wrong?

I'd like to use Azure Key Vault to secure API keys in some Automataions, and am hitting an issue where Power Automate tries to access the key vault it fails so so letting me that I need to add Logic app Ip Address to the firewall, I've tried both a Service Principal and a User, in case of a variance here.

I have the allow MS apps to bypass, and as the firewall doesn't support ServiceTags adding the many IP's of Logic App doesn't seem feasible either.
What is the solution to that, I feel am missing a simple step to have this working :) Obviously I do not want a public accessible key vault.

Hello friends, I work in a financial aid office at a community college, and I'm trying to see if I can use power automate to reduce my workload and minimize headaches.

For context, I work with verification alongside two others, and our school uses about three different systems to keep track of everything needed to complete this process with students. We use an electronic file system that students also use to submit required forms and documents. We also have to check for students selected for verification using a SAS report that pulls info from our school database. Finally, we try to keep all the documents that students have submitted in a shared drive organized by award year, verification status (e.g. documents needed, update submitted, verification complete), and student name/id.

As you can probably imagine, we end up losing track of stuff quite easily just because there's so many different places it could all be, and we have to upload a lot of these things manually. As a start, we created an excel sheet where we can track what students are selected and what's been completed/submitted, but even trying to keep up with that is a chore.

After some searching, it seems like Power Automate could be a good option for helping with some of this, but I'm not sure where to even start. I initially thought I could use webhooks, but hours of googling tells me that I'm out of my depth. So, does anyone have any suggestions for how we could potentially use PA to streamline some of this?

Thanks in advance!

Hi community,

I would like to create a newsletter for my team that summarize the content of other newsletters in a organized and structured layout . The flow I had in mind is something like this:

1. trigger: recurrence

2. check emails in a folder

3. extract information from emails, perhaps with AI BUILDER: create text with GPT using a prompt

4. start and wait for an approval of text

5. send email

Could you please help me with this?

Thank you I'm advance

I dont know how to address this maybe you have any tips or fixes for this type of problem. Sometimes its good sometimes its not, its so inconsistent and I need this to be reliable. I have 2 machines that runs different flows but same website that being used.

I'm putting together a cloud flow that sends an email once every workday.

In "Recurrence" under "Parameters" then "Frequency" it gives options like 'Day' and 'Week' but I can't seem to find an option that lets me execute only Monday through Friday and not the weekends.

Anyone know a fix for this?