Power Automate Search

Search

Re: Excel to sql server

Community

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

Community

Hi @Nielsmans    Under the Folder Path you can extend by adding the other folder names.   General/NewMain/Newsubs

Re: date and time

Community

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

Community

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]

Community

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

Community

@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

Community

@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

Community

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

Community

@codrz619 , please use the Attachments Content directly in the Array as shown in below screenshot    

Re: New Connector- Podio

Community

We agree aswell, this would be a great addition

Re: convert text to date (flow to sharepoint list)

Community

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

Community

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

Community

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

Community

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: Sharepoint Time show 12 hours earlier then my timezone

Community

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)

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: WinAutomation to Power Automate Desktop migration

Community

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

Community

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

Community

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

Community

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

Community

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)

Community

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

Community

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.