power automate
138 TopicsPower 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 siteGet 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?Send recurring Email including items URL, with read Receipt.
i have got n number of list items assigned to specific people based on Assigned by Column. I would like to send an automated email once every month with a notification or link to all the documents they own. similarly i would also like to cc me once those email are sent out, and have a read receipt once those assigned people view that email along with a followup or due date similar to outlooks followup flag for recipient? i have gone through several articles and were only able to send email with individual items and couldn't figure out if we can add read receipt.How to add multiple links in a single column of a SharePoint library
I'm setting up a workflow for students to submit petitions for course substitutions and waivers. These often require students to provide documentation (copies of syllabi, unofficial transcripts, etc) which they are able to do via Microsoft forms. The petition reviewers have requested that the petitions be saved as pdf documents. I've been able to use Power Automate to grab a templated document, save it to a Sharepoint library and populate the Form details into the library columns, which populates the document, which I can convert to pdf. The only problem I'm having has to do with the files the students upload to the Form. I'm able to grab those files and save them in SharePoint, but I'm having trouble creating a column that lists all the hyperlinks to the files. In a list, I could do this in a multi-line text column with rich-text enabled, but libraries don't allow that. I'm not that proficient yet in JSON. Is there a JSON schema that would allow me to format a multi-line text or a multi-choice column to display multiple hyperlinks based on dynamic content AND have the link carry over to the Word template via document properties quick part?2.5KViews1like1CommentManaged Metadata Column, Term Label Returns Some ID Instead of Actual String Value
I have a flow which will get file properties from a library that contains a managed metadata column. But when I run the flow, the term label value returns some ID instead of the actual string value. The actual Label value should be something like "Fire Protection" and not 109. I can't find a way to get the Label string using any other way. Is this the actual behavior or it's a bug? I'm not sure. Is there any other way to get the Label value? Thanks.Word quick parts - issues with managed metadata when converting word to pdf
Hello everyone, I am having an odd issue which I am not sure how to deal with. I have a site (SharePoint Online) with document sets and different content types. Within document sets I create various Word documents which I fill with data using Word Quick parts (data from columns). Everything seems to work fine until I export the file to PDF via Microsoft flow (when I open the original Word files, everything is filled in correctly). Most of the time, all the information is filled in, except of 2 quick parts, which are basically filled with managed metadata. For some reason, only these 2 are not getting the information, even thought the original Word document has those filled in (I basically take the same document and convert it to PDF file). I am not sure why this is happening. Also, one of my former colleagues has created a custom functionality to create PDF files directly on SharePoint (not using Flow), but the same thing happens. The only way when all data is filled in PDF document is when you convert file directly from word using File --> Export --> Create PDF. From what I see, it seems that in this process, quick parts have the issue with column types of managed metadata, as the other ones work as expected. If anyone has any idea why this happens, I would much appreciate it.1.9KViews1like3Commentspower automate will not update choice column 'get items' when the value is deleted
I'm using power automates 'get items' to copy and update SharePoint list items from one list to another. Everything works when I update items or change the value of choice column items. but if I completely delete the value, the destination list will retain the previous value that was entered. The if I enter a new value in my source list, my destination list will update again? I think this changed after the mass push out of co-pilot. My flow was created previously and now I'm trying to update it. Any ideas if there is a setting I'm missing or why this is happening?2.3KViews0likes3CommentsExcluding a column in versioning
Hi, I have a column in Microsoft List that is being populated automatically via Power Automate. This happens every 1 minute. I have question if this column can be excluded in the versioning? Switching off the versioning may affect my another configuration in Power Automate > When a list is updated > send an email. My end goal is that version should change based on changes in non-automated columns.717Views0likes1Comment