Power Automate Search
Search
Re: Get itemId of an attached item in sharepoint list, save it in an excel and then update an item in a list in sharepoint
CommunityThank you for the details. Can you convert the excel column using Int and see if that works? I had a similar requirement to convert the excel column to float and since it's an Array of rows from exce...
Setting the default column value of a subfolder in a document library using Power Automate
CommunityI have a Flow that automatically creates project folders in a document library on SharePoint based on a form response and I need different folders to have different default column values to make use ...
Re: When a new email arrives in a shared mailbox - Only collect specific file types
CommunityHi @Karmik, You could add a condition action within the apply to each (before the create file) to check for the name of the files and use an endswith function. Below is an ...
Re: Query to get a range of data in between two item
CommunityHi @NeohLooi In your case, I would build a Stored Procedure that would take the values and do the query. Then you receive the values back to the Flow and back to Power Apps. &...
Re: Exclude subfolder in "find file in folder"
CommunityHi Barry, I know this is an old post but just wanted to say this worked perfectly for me when I had the same issue today, so many thanks 👍 cheers Richard
Re: Query about template :Send a digest email of all outstanding Planner tasks
CommunityHi @danielhinojo Although there's no direct way of doing this, I found an article that explains a workaround for you. Sort an array in Power Automate in 3 easy steps (sharepai...
Re: calculated column flow error
Community@Expiscornovus I just realized what ive done wrong. I was working on Apply to each 3, so just corrected the formula to 'Apply_to_each_3' and it did work. I will delete the other rubbish trials,...
Re: copy items inc attachments from one list to another based on a condition
Community@v-duann-msft @Ler thank you It was a yes/no check box, I tried Yes and true it still would not work I have now deleted the check box and created a choice menu called 'Migrate to' ...
Re: Checking if File exist
CommunityVersioning and checkout/checking in was disabled. I was able to figure it out based on another post. I turned off 'Allow Chunking' under Content Transfer and i was able to overwrite the f...
Re: Can I use power automate to compare data from source to target ??
Communityhey @Gopala_Krishna thanks man. really appreciate for your quick response. I would like to try what you said.. Thanks Again, SP.
Conditional based on Column Value
CommunityI have a Column called Status. This is a drop down list in SP List. I would like to send an email whenever the user select a specific value - in this case whenever it contains the word "Help". Curren...
Re: Common Data Service Trigger: Filter based on lookup value
CommunityWe are experiencing a similar problem.
Re: "content": "" The content for attachment ' DIN TeamList.xlsx' is empty
CommunityHi @AzizQuazi , I also blogged about the fact that the content may need a conversion using default expressions: See: Power Automate: Email Common Data Service Files related to an Ent...
Power Automate: Possibility to restore a previous version from a flow
CommunityHello, Please, enable a feature where you can restore a previous version from a flow. Having the possibility to restore a previous version could help a lot when you make big changes. Than...
Re: How to integrate third party OCR tool with Power automate?
CommunityDear Manuel, Thanks for your input, I wanted to integrate abby OCR with Power automate. Is it possible? Cheers Sabari Nath J R
WorkflowOperationParametersRuntimeMissingValue. The 'inputs.parameters' of workflow operation 'Delete_a_row_2' of type 'OpenApiConnection' is not valid. Error details: The resolved string values for the following parameters are invalid, they may not be null or empty: 'id'
CommunityMy flow works. It does everything it should, and yet it keeps telling me that it's failing with the above error. This part of the flow is deleting rows from an excel template to revert it back to emp...
Re: Reading an excel file in a shared network drive
CommunityHi @Jsalaz1989 Yes that would be a good option. Here is the Power Desktop config for reading an excel sheet from a directory.
Re: Teams Approval adaptive card not displaying correct information
CommunityHi @manuelstgomes thanks for the reply. It seems that which ever account triggers the flow is the name that appears on the card. So if I use just one flow for the entire process it will di...
Re: Reading an excel file in a shared network drive
CommunityHi @abm thanks for confirming that. It's a shame. I think I will be opting for excel file -> SharePoint -> Power Automate.
unable to open pdf file
CommunityHas anyone seen this error message before? {"error":{ "code": "generalException", "message": "Error from Office Service. Url=https://wordcs.osi.office365.us:973/wordca/wordconvers...
Re: ExpressionEvaluationFailed. The execution of template action 'Apply_to_each_4' failed: the result of the evaluation of 'foreach' expression '@outputs('Get_attachments_2')?['body']' is of type 'Null'. The result must be a valid array.
Community@annajhaveri weird - i'm sure i had a base64 in here... so i've now corrected that to: and get: ExpressionEvaluationFailed . The execution of template...
Re: ExpressionEvaluationFailed. The execution of template action 'Apply_to_each_4' failed: the result of the evaluation of 'foreach' expression '@outputs('Get_attachments_2')?['body']' is of type 'Null'. The result must be a valid array.
CommunityThe body parameter as highlighted in below screenshot, where does that come from, that seems to be empty
one drive connector
CommunityHello How to write a flow to copy selected file of onedrive account to another one ? copy ,not create thanks
Re: unable to open pdf file
CommunitySorry about that. I have a SharePoint document library and I used a Word document with Quick Parts on there for template. I have a workflow converting word document to PDF file. In PowerApps...
power automate sharepoint list
CommunityI am looking to create a flow where a sharepoint list is downloaded to excel then saved in a library. I have tried several ways but the csv does not work for me or it creates a file for each line.&nb...