Power Automate 검색
검색
Email recipient based on Form response
커뮤니티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
커뮤니티@Pstork1 That's exactly I thought to layout. How about setting the reminder?
format dateTime from Planner tasks to excel table
커뮤니티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
커뮤니티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
커뮤니티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
커뮤니티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?
커뮤니티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)
커뮤니티@jdoss see screenshots below. Thank you for your assistance First flow Second Flow &nbs...
Run Desktop Flow as Admin? (third attempt)
커뮤니티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
커뮤니티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.
커뮤니티@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
커뮤니티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
커뮤니티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.
커뮤니티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
커뮤니티@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
커뮤니티@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
커뮤니티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
커뮤니티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
커뮤니티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...
Re: Excel to sql server
커뮤니티Hi @vb2608 First you need to read the Excel sheet list rows. Then filter the id to find the record exists in SQL table or not. Follow the below steps. ...
Re: Get one record from a sharepoint list which matches another record, add to table in Excel
커뮤니티Thank you! That video was very useful 🙂
Re: Create folders based on excel list
커뮤니티Hi @Nielsmans Under the Folder Path you can extend by adding the other folder names. General/NewMain/Newsubs
Re: date and time
커뮤니티Hi Rahber I figured out how and where add it, but i have problem and message: Do you know how to fix it?
Re: Power Auto formatdatetime
커뮤니티Well, I think we are getting closer. I did find using a Compose that the date is in fact coming in as a serial number. I did some Googling on how to convert it and found: addDays(items('Appl...