Power Automate Search
Search
Salesforce cases using spo lists
CommunityHi 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...
format dateTime from Planner tasks to excel table
Communitydear 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...
Re: HTML tags in the approval emails won't work in Power Automate
CommunityApproval 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: Email PDF from SharePoint Document Library as an attachment.
CommunityI 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: List item missing from condition list
CommunityIt 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: Multiple emails sent with Send an email (V2)
Community@jdoss see screenshots below. Thank you for your assistance First flow Second Flow &nbs...
Taking output from SQL Get Rows and turning into individual Strings?
CommunityHi 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: Flow: Multi-level Approval
CommunityHi @EllanReddy , Check out my flow approvals playlist which includes multiple scenarios for building approval flows. https://www.youtube.com/playlist?list=PLTyFh-qDKAiFUGTtwSwF...
Re: Check if a Planner Task exists
CommunityGood 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: Delete a row in excel showing error
Community@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
CommunityI 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...
Customizing when an item is created or modified
CommunityI 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: Flow: Multi-level Approval
Community@Pstork1 That's exactly I thought to layout. How about setting the reminder?
Re: Excel to sql server
CommunityHi @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: Create folders based on excel list
CommunityHi @Nielsmans Under the Folder Path you can extend by adding the other folder names. General/NewMain/Newsubs
Re: Get one record from a sharepoint list which matches another record, add to table in Excel
CommunityThank you! That video was very useful 🙂
Re: date and time
CommunityHi 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
CommunityWell, 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...
Re: WinAutomation to Power Automate Desktop migration
CommunityI would also like to stick with WA while I can, eventhough I'm not in the same situation as you regarding multiple processes and having to renew the license in a few days.. I can't even understand th...
Re: Flow Performance - What is considered an "action"? (Cross post for visibility)
Community@Hardesh15, So they are a multiplicative condition, not an OR condition? I interpreted it as doing this for x number of times if the limit is reached break or is x minutes is reached break. Th...
Re: convert text to date (flow to sharepoint list)
CommunityThanks, but I cannot find any such settings, not in the Flow itself nor in the environment? Where are they suposed to be located?
Re: Updating Date field to TODAY
CommunityI received this error: Flow save failed with code 'OpenApiOperationParameterValidationFailed' and message 'Input parameter 'item' validation failed in workflow operation 'Update_item': The parame...
Re: Power Automate Trigger Conditions made EASY
Community@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: Logic App flow sending duplicate email when it should only send one
CommunityHi @AdamD , Do you see this flow only running once? But it is sending multiple email messages? I assume i.e. a button is connected to your Power Automate trigger here. By the way...
Re: Find Files in Folder by Path - Returns Empty Body
Community@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 ...