Power Automate ‑haku

Haku

Re: Query: sending mail by Microsoft Planner task out of time with power automate

Yhteisö

Hello @Gopala_Krishna , thanks for your answer, but what I was referring to is how I can create a sequence to validate and send by mail that every time there is a Task in Microsoft PLanner in a delay...

Re: Error saving flow with "Execute a SQL Query" action

Yhteisö

Hi @sujan ,   Is there any roadmap for Execute SQL query connector to work for On-prem sqls server.?   Also, if I want to filter some rows in Get rows action, how it can be fu...

Customizing when an item is created or modified

Yhteisö

     I currently have a flow set up that sends out an email when an item is created or modified on a SharePoint list. What happens now is that an email gets sent out only if the item p...

Re: Delete a row in excel showing error

Yhteisö

@GAbraham  As excel date and time is coming in date format so you need to use one compose action before delete action. 1. Compose: pass your excel date 2. Compose: expression first(Split(Output(...

Email recipient based on Form response

Yhteisö

I am using a Microsoft Form to collect input from users, and want to email the form results to a recipient based on the response to one of the questions. The question requires the user to select from...

Re: Flow: Multi-level Approval

Yhteisö

@Pstork1  That's exactly I thought to layout. How about setting the reminder?

format dateTime from Planner tasks to excel table

Yhteisö

dear All,   I'm trying to export tasks data from Planner to Excel table. All data are exported but dueDateTime, startDateTime ana completedDatTime are in format '2020-01-25T00:00:00Z' and I ne...

Salesforce cases using spo lists

Yhteisö

Hi all,      I am using this connector https://us.flow.microsoft.com/en-us/galleries/public/templates/4844ba12dc784771860e8ebffbaa743b/create-a-record-in-salesforce-when-an-ite...

Re: Check if a Planner Task exists

Yhteisö

Good day,   I was able to make it work by Initializing a variable of the Title of the tasks  1- verify if the Subject is in the Value of Tasks if not create a new one if so 2- set the v...

Re: Flow: Multi-level Approval

Yhteisö

Hi @EllanReddy ,   Check out my flow approvals playlist which includes multiple scenarios for building approval flows. https://www.youtube.com/playlist?list=PLTyFh-qDKAiFUGTtwSwF...

Taking output from SQL Get Rows and turning into individual Strings?

Yhteisö

Hi all, I have established a connection from Power automate to our SQL database, and seemed to figure out how to get the rows I am looking for, but I cannot seem to take these rows and do anything wi...

Re: Multiple emails sent with Send an email (V2)

Yhteisö

@jdoss see screenshots below. Thank you for your assistance     First flow                 Second Flow &nbs...

Run Desktop Flow as Admin? (third attempt)

Yhteisö

This is my third post on this topic and no answer to this day.   I have built a flow out at least 7 different ways and it will not work.   I am a domain user on a domain PC. I have loc...

Create a new bucket based on a SharePoint list

Yhteisö

Hi!   I'm trying to create a planner task with its corresponding bucket for every new item created in a SharePoint list. I was able to create buckets based on one of the columns in the list bu...

Re: Can the new sharepoint list item added every week be automatically sent out by email? All the new item information is summarized in one email and sent automatically once a week at a specific time.

Yhteisö

@Dennis_Qiang  Answering your questions above: I still don’t understand how " Created It'EndDate’ and gt'StartDate’ " is implemented? Does "Created" use the automatically generated Created c...

Re: HTML tags in the approval emails won't work in Power Automate

Yhteisö

Approval Emails use adaptive cards and don't support the use of HTML.  You can find the markdown characters here:  Use markdown to format Power Automate approvals - Power Automate | Micro...

Re: List item missing from condition list

Yhteisö

It will not show much. The item I am looking for is LastStatusCheck.  The first is flow and the second shows I have the item on the SharePoint list.    

Re: Email PDF from SharePoint Document Library as an attachment.

Yhteisö

I removed the Flow from Power Apps, re-added and now the email works. I would still love to know how to send file content back to Power Apps in a useable format though.

Re: Power Automate Trigger Conditions made EASY

Yhteisö

@Craig_Humphrey    What would the formula look like if the SP column name is [Replacement Cost], and the field is set to Number, and I want to trigger when this field is over 1,000? &nbs...

Re: Find Files in Folder by Path - Returns Empty Body

Yhteisö

@Johnnyg    I just had an epiphany while doing a test, i just had the file deleted from my computer, and then went to the app, i was super fast because i just had to do "next" on the app ...

Getting data from Microsoft Bookings

Yhteisö

Hi,   I want to print a pdf-report everytime a new booking is received through Microsoft Bookings. Is it possible to connect Power Automate to MS Bookings?   If not directly, perhaps th...

HTTP Request GET Webhook returns 400 and success = false

Yhteisö

I am trying to automate updating Salesforce with information from an online training platform (Thinkific)  I have done so before in Zapier, but when using Power Automate i get a response status...

Re: Automatic email generated at 6 Months

Yhteisö

Hello,   I have found another solution which allows me to use files with the same name (since the file name is the main "functionality" of the flow). Made two different folders into SharePoin...