If column value of one item in list 1 match column value of items in list 2, send email (how to?)
Hi all! I have two sharepoint list: List 1 is "Market Intelligence Library" and List 2 is "MI Interest" (see example screenshot attached). List 1 acts as a library to house news articles that are tagged by "Category", "#hashtag", and "Geography" related to the article. List 2 acts as an email distribution list and individual notification preference for articles that contain certain "Category", "#hashtag", and "Geography" tags. Is there a way to send an email via power automate to those in List 2 only if the value in their "Category", "#hashtag", and/or "Geography" matches an item (news article) tags in list 1? Only one column of the three need to match to be notified (contain matching values in either "category", "#hashtag", or "geography"). My trigger right now is "when an item or file is modified" from List 1. Specifically, when an item in list 1 status is moved to "released", then those in list 2 should be emailed if the value in one of the three columns match.Power Automate not copying file
I have a super simple flow - copy a file to a second folder when it is copied into a first folder, as illustrated. Both folders are within SharePoint. I am using ID to identify the file to copy. But Power Automate cannot find the file (error 'The system cannot find the file specified. ). Any suggestions please?Sharepoint files and folders created with Power Automate do not sync to desktop (OneDrive)
I created a folder, and file within it, with Power Automate and it shows up in Sharepoint but does not (ever?) sync to the desktop. If I use Power Automate to create folderA/folderB/file.txt It will not sync by itself "after a while" - where "a while" is exceeding the utility of automating it (I did not test longer periods of time) It will not sync if you create things in OneDrive that sync properly It will not sync if you press the sync button in Sharepoint it WILL sync if you create FolderA in OneDrive (as in, it will sync folderB/file.txt) it WILL sync if you create anything directly on the Sharepoint site
Get the content of pervious file version
Hi All, I'm trying to get the content of the last Major version of a document (so it can be published to another site as a PDF). So if the document is at version 3.6, I need the content of 3.0 to publish. I'm able to work out the current Major version by looking at the actual version and splitting on the decimal. If the decimal portion is 0, the current file is published. I then use a "Send HTTP request to SharePoint" with _api/web/getfilebyserverrelativeurl('/sites/SrcSite/@{items('Apply_to_each')?['{FullPath}']}')/versions as the URI The results are then filtered to get the version I'm after. I've seen posts else where that use the resulting _vti_history/17/SrcSite/File name.docx Uri within a "Get file content using path", however that just returns a 404 error. Any ideas on if/how this might be doable?
Unable to process template language expressions for action 'Apply_to_each_2' at line '1' and column
Hi All, Is there a possibility after the owner email is disable, the entire workflow cannot work properly. Previously, the flow do not have any error regards to the subject mentioned. After the flow's connections was changed, this error occurs. Has try recreating the workflow but did not work. Below is the attachment of the error. Unable to process template language expressions for action 'Apply_to_each_2' at line '1' and column '31497': 'The template language expression 'outputs('Start_and_wait_for_an_approval')?['body/responses']' cannot be evaluated because property 'body/responses' cannot be selected. Array elements can only be selected using an integer index. Please see https://aka.ms/logicexpressions for usage details.'.
The connection does not contain a vault name. Please edit the connection and enter a valid key vault
Hi , I am getting error when get secret from Azure Key Vault from Power Automate. { "status": 400, "message": "The connection does not contain a vault name. Please edit the connection and enter a valid key vault name.", "error": { "message": "The connection does not contain a vault name. Please edit the connection and enter a valid key vault name." }, "source": "keyvault-wus.azconn-wus.p.azurewebsites.net" } I have a Power Automate which is having azure key vault connection to get secret. This Power Automate will be executed from Powerapps. When playing Power Apps, It is asking user consent to connect Azure Key Vault, but no way to provide azure key vault name. Has anyone experienced this kind of scenario and any leads on this? Regards, GaneshPopulate a Microsoft Word template with information from specific row in SharePoint list
Hello, I am relatively new in Power Automate and I am trying to create new flows. I have SharePoint List with lost of items. Then I have form in Sharepoint with one question "ID ?". (Sorry for Czech language in this screen) I created a flow: When I fill out the form, for example with ID 3, then the flow will start. And what I need from this flow is to insert row number 3 (ID of the row is 3) into the document with all information in that row. Creating the document is working. I tested that. But I do not know how to insert only information from the specific row into document. Can you please someone give me advice ? I tried something but nothing worked. I appreciate any help :-). Thank you and have a nice evening, Standa
