Power Automate 検索
検索
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...
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...
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: 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: 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: Multiple emails sent with Send an email (V2)
コミュニティ@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?
コミュニティ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: 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...
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: Delete a row in excel showing error
コミュニティ@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
コミュニティ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...
Customizing when an item is created or modified
コミュニティ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: Flow: Multi-level Approval
コミュニティ@Pstork1 That's exactly I thought to layout. How about setting the reminder?
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: 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: Get one record from a sharepoint list which matches another record, add to table in Excel
コミュニティThank you! That video was very useful 🙂
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...
Re: WinAutomation to Power Automate Desktop migration
コミュニティI 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)
コミュニティ@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)
コミュニティThanks, 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
コミュニティI 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
コミュニティ@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
コミュニティHi @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
コミュニティ@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 ...