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?Microsoft Planner @Mention and Comment Notification in Microsoft Teams - NEW VERSION
Hi Planner Community, Thank you for the overwhelming support for my original post last year on how to @mention someone within the Microsoft Planner community and have a message automatically emailed to them. I'm excited to share that I've completely redesigned and updated the solution to now support the new Microsoft Teams Planner and remove the issues some users found with setting up the solution. Additionally, the notification is now an adaptive card within the Microsoft Teams chat to the user you @mentioned in the Microsoft Planner comment. Screenshot example above shows a comment posted by me in a Microsoft Planner task where I’ve @mentioned David at the end of the message. Screenshot example above shows the comment posted by me in Planner being automatically sent to David (thanks to the @mention in the comment) on Microsoft Teams. Allowing David to reply in either the traditional Planner or new Teams Planner. Attached is a zip file containing the Microsoft Power Automate solution, along with a detailed walkthrough to help you set it up. Enjoy! If you download the solution, all I ask is that you please give this post a thumbs up. Thanks, everyone! Matthew Davis No More Bad Monday
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.MS Forms Weighted
We have various surveys that we send to client using an external survey provider. I am investigating the ability to satisfy our needs by using MS Forms. One requirement we have is the ability to have a weighting tied to our questions as I have specified below. We would like to capture the scoring value in the Excel document behind the Form for easy tabulation. Can someone guide me as the whether this is possible? Thanks. Question: How was the quality of service you received? 1. Superior (worth 100) 2. Good (worth 80) 3. Average (worth 60) 4. Poor (worth 40) 5. Terrible (worth 0)Microsoft Forms - Branching question
Hi all, I have just joined these forums and this is my first post. Is it possible to do the following with Microsoft Forms and if so, how?:- Create a form in Microsoft Forms with 4 multiple choice questions. Each answer/option for each of these questions has a number of points allocated to it, for example, option1 has 10 points, option2 has 20 points and option3 has 30 points etc. (See below) Question:- "What is the size of the audience for your in-house training?- Select one answer: Option1:- 100 - (10 points) Option2:- 500 - (20 points) Option3:- 2000 - (30 points) Option4:- 10,000 - (40 points) The user does NOT see how many points are allocated per possible answer and all the other questions are like this. Once the user has selected their respective answers, they are required to click a SUBMIT button at the bottom of the screen. Depending on how many points they have accumulated, they will see a different feedback screen, for example, if they have just "scored" 40 points, they will see the FIRST information/feedback screen with some text, a link and a graphic (if possible). If they have scored 60 points, they will see the SECOND information/feedback screen. This also applies if you get 80 or 100 points and you get different feedback depending on how many points you have "scored" as this form has a branching methodology with the form itself linking to 4 different screens or HTML pages with this feedback. Now million dollar question as before... Is this possible? If so, how can I do this and do I have to use some other kind of technology like Power Automate etc in conjunction with Microsoft Forms. I look forward to hearing from you. Thanks in advance. Keith
Weighted Answers in 2 Survey Pages adding up to a end value.
Hello there, new to MS Form and Power Automate so bear with me on this one: Part of an Ideas Survey, requires a user to complete a 'Survey Page' where there are 7 Questions with 4 possible choices. 1 Choice per Question, each Choice is weighted Option 1= 0 Option 2= 1 Option 3 = 2 Option 4 = 5 Once answered, should give a value of the sum of weighted answers... so 3 Question have option 3, 2 questions were answered option 2 and 2 were answered option 4. totaling 18 A second survey page very similar weighted options to the questions. What these values I would need to utilise to find a reference based on a Grid of Values. 1 to 35 along and 1 to 21 Up, the values in the survey would be used to gauge 18 cells along and , lets say 15 rows up. In that specific Cell would be a Reference. something like H15 a Formula would be something Like if Survey1 Value >15 then H, <=15 and >=10 then M, >=0 to <10 then L Then it would be to concat the value of the of that plus the Survey 2 Value. How, would I go about doing that? Just from messing about, it would have to be a triggered Power Automate to then add to a variable, then after that no idea. Anyone able to do this and to help with a step by step? Much appreciated. Mike.
"Allow respondents to edit their responses" does not fire flow trigger
New Option "Allow respondents to edit their responses" is added. https://www.microsoft.com/ja-jp/microsoft-365/roadmap?filters=&searchterms=124819 But flow doesn't fire when answer is edited and submitted. This makes no sense...Also test the connector, plz.
Extracting Custom Question Answers with Power Automate
I am working on developing an N:1 bookings page where several people are able to register for the same time slot. We ask several custom questions and the end goal is to use the Power Automate connector to extract that data, put it into an Excel sheet, and import into our CRM. I am tried several different methods to extract the custom question answers without success. Has anyone been able to make this work?
Validating consent on MS Forms
I'm creating new forms which will capture children attending activities and needs to be approved by a parent. The old way was to have the parent sign and authorise participation. Can anyone in the community think of a way to do this with MS Forms which would meet legal requirements that a proper person has authorised the form instead of the child completing the form on behalf of the parent?
Generate Dollar Signs in Word Template
I am using a Word template to create and invoice with Power Automate. I have two tables in the Word template. Two of the columns in each table should display numbers as currency, specifically dollars. The generated template only shows the content as numbers. Can I correct this, and if so how?
