Αναζήτηση Power Automate
Αναζήτηση
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...
Re: Differences in the behavior of the Power Automate Desktop and WinAutomation [Substract lists] action]
ΚοινότηταHi, You are right, it does not work as expected with Get first free column/row from Excel. So, I have used Read from CSV file to solve this problem for my flow instead of waiting for MS to f...
Re: Saving responses as documents - there is an example
Κοινότητα@Realy8 This is a powerapps application with powerautomate
Re: CDS 'Perform a bound action' step parsing Entity Reference parameter as an Entity, exceeding max number of properties allowed
Κοινότητα@drewbino I have gone into this issue before because it counts every property in the entity reference as a Property, so i ended up modifying my action Input / Output to use string instead of ...
Replace query is failing in PAD
ΚοινότηταHello Team, I am trying to use database actions to replace the text in the Excel column. But Replace query is failing with some unknown error. SQL Query - UPDATE [S...
Re: PDFs getting corrupt when sent as an email attachment from a SharePoint List
Κοινότητα@codrz619 , please use the Attachments Content directly in the Array as shown in below screenshot
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: 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: Flow 28-day run history vs 30-day duration and retention limits
Κοινότηταhi @Mira_Ghaly Do we have documentation that even though the flow history instance is gone it will still run? I just that I noticed when the flows are deleted in the flow history, our pro...
Re: Format HTML table with dynamic data when number of rows changes
ΚοινότηταNevermind! I figured it out!
Re: Sharepoint Time show 12 hours earlier then my timezone
ΚοινότηταYes I just created item directly from SharePoint list and its coming fine as I set. Date and Time.
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: 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...
Delay flow to run in a sequence
ΚοινότηταHello, I've got a list onto which I want to add multiple items at once. One item triggers a flow which creates folders and documents within them in the Library (documents are being populate...
Re: Forms Response to Table and then Use the Start date and email data from the table to send scheduled email 7 days after start date
ΚοινότηταI think you need to format each day in the same way. Try setting both up in an initialize variable before comparing them and then you'll be able to see why they are not equal to each other.
get specific value from sharepoint list
ΚοινότηταHi all, I am new to Power Automate and trying to get a specific value from a sharepoint list and increment a variable. The list looks like this: The flow shoul...
Flow to create new item in existing SharePoint List using adaptive card template
ΚοινότηταHi All, I have a requirement to create new row item in an existing SharePoint List which already has list of rows and columns. Headers of the column are Title, Body, Occurred on. This list i...
Re: convert text to date (flow to sharepoint list)
ΚοινότηταThat is dependent on the locale settings for your flow environment. Double check what those are in the flow settings and where your environment is located.
Add new user to a calendar with certain rights
ΚοινότηταRight now there needs to be a way when a new user is added to MS Teams to be able to add that user to a office 365 Calendar with specific rights.