البحث في 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...