Поиск 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: New Connector- Podio

Сообщество

We agree aswell, this would be a great addition

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.