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?
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.
Managed 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.
Power Automate email notification
Hello, I have an automated email when certain fields meet "Completed" I also have a flow that updates the a date field at midnight to ensure the calculated fields I have are updated, however when this flow runs it also sends out the emails for the completed flow. Can I stop this from happening?
Check on double entries in Sharepoint list
Hello I'm looking for a way to prevent double entries in a Sharepoint list. I have 3 lists: One list with names and addresses of Students. (called students), one with names of courses they can subscribe for (called courses) and another called subscriptions, used when a student subscribes for a course. A student can subscribe for multiple courses. I want to prevent that when subscribing a student for a course, the student allready has a subscription for this course. Sometimes it happens that a student does a subscription and has to wait for the course to start (sometimes more than one year). In that case they sometimes come back a few months after the first subscription and want to subscribe again for the same course. To prevent double entries, I want sharepoint to do a checkup before subscribing the same student for the same course again. If the check is positive, I want the user to be prompted that the student allready has a subscription for this course. When the check is negative, I want the data entered in the subscription form to be saved in the sharepoint list. Because the subscription list uses lookup fields from both the courses and students list, sharepoint doesn't let me combine values from those fields in a calculated column to make sure these values are unique entries. I read that to solve this problem, I need to use Power automate to do the check-up. Is that correct, and is it the simplest solution? How do I get started? Thanks!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.Microsoft 365 & Power Platform Conference
365 EduCon Chicago, a Microsoft 365 & Power Platform Conference will have workshops and sessions focused on Power Platform, Power Automate, Power Apps and more, taught by the Top Experts! October 30 - Nov 3, 2023. McCormick Place South. https://365educon.com/Chicago
