How to Get Forms Responses using Power Automate | Download Excel, Filter, PDF of Quiz Results
Vložit
- čas přidán 10. 07. 2024
- This video is a step by step on how to get All Responses from Microsoft Forms with Power Automate.
We will use flow to automatically create an Excel file from Forms Responses, Filter Form Responses based on specific answers, Save & Report on Forms Data, Send an Outlook Email notification of Forms Responses, Generate PDF Certificate from Forms Quiz Results & more.
For Quiz type Forms, we will download the Excel file containing the scores, calculate the percentage score & generate a PDF certificate for respondents.
#PowerAutomate #MicrosoftForms
📚 References:
Hiro Blog (Get Question details of Forms with Power Automate) -
mofumofupower.hatenablog.com/...
Damien Bird video on All Forms Responses - • Microsoft Forms Get AL...
🔽 Download Sample Microsoft Forms & Power Automate Flows
github.com/rdorrani/Microsoft...
👉 Power Automate Forms Response to SharePoint -
• Power Automate Microso...
✉️ HTML Email Power Automate -
• Power Automate flow HT...
📄 Generate PDF Power Automate -
• Power Apps Export to PDF
🤝 Let’s connect on social:
🔗 LinkedIn: / rezadorrani
🐦 Twitter: / rezadorrani
Table of Contents:
00:00 - Intro
00:37 - Microsoft Forms Quick Introduction
01:08 - Create a Microsoft Form Survey
03:14 - Power Automate get Microsoft Forms Response
04:18 - Flow to Get All Microsoft Forms Responses
10:45 - Filter Microsoft Form Responses
12:47 - Send Microsoft Form Responses in Email
14:08 - Attach Excel file of Microsoft Forms data in Email
15:01 - Apply Dynamic Filters to Forms data
16:46 - Calculate Microsoft Forms Quiz Results (Percentage) in flow
17:46 - Generate PDF Certificate based on Quiz Results
21:44 - Subscribe to Reza Dorrani channel
Amazing. Thanks for the rich information. Learning has no endpoint!
Thank You
Thank you so much Reza! I really appreciate all of your help! You explained this very well and it was easy to understand!
You're very welcome!
Thanks a ton Reza and your all videos either Powerapps or Power automate all are very simple and in detailed. I watched other MVPs videos and they are good but your way of explaining fabulous 👍
You are most welcome
Thank you!! You are the best!
Greetings from Brazil 👏
Thanks Marcos
Wow Reza!!!! This is awesome. I spend days looking for a similar solution.
Glad to know this video is useful. Thank You for watching.
Incredible this is exactly i needed, Tks Reza
Most welcome
New Video, New Knowledge Acquired. Thanks Reza
My pleasure!
You're the best, you have really made my job easier
Thank You for the appreciation and wish you the best
Excellent Reza. Thank you so much.
You are most welcome
You are GREAT! Thx
Thanks for watching
Thanks for the amazing video. We learnt a lot from you channel.
Glad to hear that
Another Great video, thank you 😊
Thanks for watching
Very informative and useful. Thanks
👍
Thak you, this was well described and helped me out with a problem that I was really struggling to solve.
Glad to hear that! Thanks for watching
Thank you!!!!
Welcome!
Hello Reza!
Your videos are amazing!
They are my main source of learning for the Power Platform.
I was wondering if you’d ever consider doing a video where you update and modify a SharePoint list from data that’s entered into a Salesforce Report? Thanks!
Thanks Levi.
I have done no work with Salesforce and received very few requests to build videos on it.
I will add this topic to my backlog though.
Hello Reza!
Thanks for responding. I understand.
Respectfully,
Levi Sublett
I wish I known this last year would have given me a better option to create some reports, thanks for sharing.
Glad it was helpful!
wow i love this so good .
Thank You
Thank you for, once again, creating a clear video to save us all a lot of time. One question - Is there a way to capture the "Total points" (user score) prior to query the table via "List Rows..."?
You would have to query list rows and then get the total as shown in video.
So wish it was available as a property.
Great video thank you so much. Is there a way to trigger a form from particular cell or a row from Excel and response to that form should be saved in the same row/cell from wr it was triggered?
I do not have a video on this use case. Not sure about the approach since I have not come across this scenario.
I will recommend to check on the forums at powerusers.microsoft.com
Good one Reza.
Thanks for watching
Amazing 🤩
Thanks
Great and really useful ! I actually have a quiz divided in several sections. I would like to compute the score for each and every section. I didn't find anything in the json payload to get all the questions belonging to a specific section .... the only way I found is to have a naming convention for each question. Thanks to this naming convention, I can then differentiate the question and compute by section. Is there a way to get this list of section without having to maintain this naming convention in questions titles ?
I don't think section info was in JSON. So the naming approach seems correct.
Thanks for the amazing explanation Reza. Is there any other simple or quick way to do the same function? It looks quite complicated for me.
Thanks.
Im not aware of any other way.
Thank you so much for this! Is there a way to record the results to a SharePoint List as opposed to OneDrive?
You can leverage the SharePoint connector and push the info to SharePoint.
Check my MS Forms playlist (I showcase how to do that) - czcams.com/play/PLTyFh-qDKAiGPJ0JZN0i3xlACNyygTjgs.html
Excellent
Thanks
Thanks for a helpfull video! Great approach to use http requests without premium connector! Is this method will be suitable for other Microsoft API actions (i.e. flow cancellation or resubmitting using rest api post commands)?
Flow cancellation and resubmitting requires user bearer token which would need Graph API call and would become premium feature.
Hi Reza, thanks for sharing the info! I'm new at using Power Automate and your videos are very helpful. Is there a way to re-create this flow so I receive an email with the score every time a new response is submitted but only for that response, without getting the report for all the responses at that time? Also, do you do 1-1 sessions? Thanks again!!
For that you simply run flow for each form response received - I have done other videos on that.
I do not offer 1:1 sessions
Thank you so much Reza. I have been looking around on how to calculate total point from quiz and save it to SharePoint List. This video really helps. I follow through the flow, however i am stuck at Compose Operation for Question Info, i cant locate body('FormInfo')?['questions']
Video description has link to download sample flow.
Hello Reza, great video, it helped me a lot
I have a question, how can I filter the array comparing the completion time propertie against the utcnow() ? I just want to receive the responses that are sent in the current day
You can use Filter action action. I have done video on data operation actions in flow. Check that. May not have your exact use case but may help give direction.
Alternatively, I would recommend posting your query on forums at powerusers.microsoft.com
That made my brain hurt, but I enjoyed it. Very cool.
Thanks for watching and sorry for the 🧠 drain :)
Hi Reza, thanks for sharing your knowledge in such a wunderfull and clear way. I have a question. If I make an quiz in forms, and this quiz has TOTAL POINTS . How can you extract these total points to a list. Can you help. ? Thanks a million. !!
I think the video shows how to calculate the total points. You can write that to SharePoint list using the SharePoint actions in flow.
Thank you for this awesome video! Everything worked great for me! I was just curious, when creating the certificate/pdf how did you get those URLs that you place in the compose function to display images for the certificate?
Thank You.
Can you point to the time in the video when that is shown. Im sorry I dont remember my own videos :)
@@RezaDorrani 19:52, it is for composing "LogoImg" and "QuizImg"
19:52 is setting JSON not logo. Can you recheck the time please.
@@RezaDorrani In the video I don't believe there are any explanations for uploading image URLs inside "LogoImg" and "QuizImg", and then calling those outputs in the HTML for the Certificate. But if I try and switch the "QuizImg" URL it doesn't show an image of the new URL I pasted in "QuizImg".
In summary, I have the same exact flow as the one shown in the latter part of the video, but if I try to change the Images shown in the certificate by adding my own image URL it doesn't work.
My sincere apologies if this is confusing.
@@GarrettCooper-ep3ic I believe those are hardcoded. May be I showed some of this in a different video.
Check Power Apps Export to PDF
czcams.com/video/Da4do2DxmJE/video.html
Hi Reza, thank you so much for the video. But I’m wondering how to fill the response details from a Form Quiz each time when a response is submitted to an exist excel (add a row). Can we do it without creating a file to our OneDrive?
You cannot add data to a form without filling the form as far as I know. So Im not sure about your scenario. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
I was waiting for this videos, thanks.do u have any idea to post videos for SPFx?. It will be helpful if you did
I have done limited work with SPFx. My focus is around the Power Platform.
@@RezaDorrani ✌🏻👍🏻
Hey reza nice video, i have one question....is it possible to mentain dataverse m:m reletionship in offline mode?
I have not done much work with M:M relationships with Offline mode.
I will recommend you check on the forums at powerusers.microsoft.com/
Hi Reza,
Thanks for all the amazing videos. I want to get the end date from the form setting and use it in my Power flow. Is there any way I can get the end date of the form from form settings.
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani Thanks Reza for replying. I will check forums. Here is the scenario, if you would you like to provide guidance in future, "I want to compare the manager's approval date with the end date in the form settings so that manager's approval is not accepted after the end date, which is the last date for registration for the training or event." Or please suggest something using which I can dynamically apply a condition on manager's approval date.
@@sakshisachdeva5382 I cannot suggest until I try it out and I currently have no plans to build a video on this scenario. I make videos only when I receive multiple requests on a specific topic. I have video ideas with over 30 requests in my backlog.
@@RezaDorrani Thanks Reza for replying.
Hello! Is there a way to add/delete columns in the spreadsheet created from the forms response? I want to add a column for a secondary key that's stored in a variable within this same flow that downloads the forms responses. Thank you!!
Probably possible but not something I have tried :)
Hi Reza.. Great video.. Can we collect ms form data to Smart sheet?
If Flow has connectors for smart sheet. Then you could write data to it.
Again Video Was Fantastic lot's of confusion clear now. One question - How to learn HTML design to create PDF File ?
Thanks Ajay.
For basic html learning www.w3schools.com/html/ is a good starting point.
This is awesome. I have a quiz with each response (not the question itself) scored at different values. I created a flow using switch controls with increment variables assigning scores and then after I added the Add Rows in my table. The flow worked, but I added the increment variables hoping it would total the scores for me in Excel. It didn’t. Would something like this work in Excel to score each individual responders totals based on the increment variables I assigned each response?
Thanks. The total of individual responses should work. Depends on how you have setup the flow. I will have to look at your flow in action to know more.
I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
I had to make an account, but I did post my problem with screenshots of my flow in the power automate forum: powerusers.microsoft.com/t5/Building-Flows/Trying-to-get-response-total-scores-based-on-individual/m-p/1555988#M174000
Hi Reza, thank you for this video. How do you think would it be possible to send Form to a user that would have a unique ID in UTM, and then pull out this ID from UTM once form was submitted? Thank you in advance.
What is UTM?
Do you know any way to download the PDF answers of a Forms with a questionnaire, as well as it is done on the Forms page?
Since there are more than 100 questions and these questions depend on the branching
I’m not aware of a way to do that.
Really nice one Reza!!! Just one question. I have a Form with some NPS questions. I need to export the overall results in a NPS format (%ofPromoters - %ofDetractors) and share with some dynamic recipients.
My approach is to obtain the XLSX file as described on your really appreciated video and then apply filters to get for each question the percentage of Promoters (9-10) and the percentage of Detractors (1-6) and calculate the overall NPS. This will be fine for a simple Forms with a couple of questions, but mine have about 25 questions, so building the flow is kind a nightmare.
As you may know, Form owner can access to the Answers tab and see the aggregated results and the NPS for each answer. Any idea on how to export this info?
My first absurd approach was trying to perform an http call to the answers tab link and save the response as a PDF file to attach via email, but it didn't worked.
Thanks in advance for your kind support and for your really appreciated channel!
Not sure about this one. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hello Reza, Is there way to download seperate excel sheet for each time user submit request on form using power automate ?
There is only 1 excel sheet. You can trigger flow on item added and keep downloading.
Hello Reza, thank you for your videos that always help a lot. I want to use this flow but my form is group-own base and I am struggling with the group Id. How can get it ?
Sorry, in fact I was talking about a form that was "shared with me" and not a group form. So I can make the flow run when I created the form but not when a form is shared with me.
You need to be the Owner of the form.
You need to be the Owner of the form.
Hello Reza and thank you for the great videos. I have a question please, Is it possible to send the certificate to the user manager for example to sign it then send the signed certificate to the user? if yes, how to do it?
Signing is not a native capability. Probably would need some form of pdf editor (3rd party) or word template with signing capabilities. I do not have any video references on this. You may want to check on forums powerusers.microsoft.com/
@@RezaDorrani I mean something simple like the one you created in this video czcams.com/video/EACk5jlQ_jU/video.html
That is coming from a Power App not microsoft forms.
Hi Reza, at 3:43 sec can I pick a form that has been created by another user? if so, how? (I have already permission to see/edit that form). thanks!!
Form must be shared with you.
Hi Reza, is it possible to extract the form responses using the form id? provided the form is not created by me.
You would need to be the form creator
Hello Sir,
Great video. Question. I followed one of your guides to create an approval. However, instead of using Sharepoint I used teams. Unfortunately once I upload a file the person getting the file is not able to open the link. Any advice? Regards
I will have to look at your flow in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
Great vid! But i stumbled into an issue when reading the excel created by the flow at 11:05.
It tells me there isn't a table called "Table1"
Excel file must have a Table. Table 1 is the name of the table in my case.
Hi Reza, I follow your work, you are just amazing. I came across a situation where creating a flow based on forms. Can any form can be automated in a specific channel without picking up a single form to trigger a notification in a specific channel.
Thanks!
I did not understand your question.
@@RezaDorrani when a form is posted in team general chat for the voting can the team will be notified that a form is been posted
@@venketavinash6965 I'm not sure about this one. Never tried it.
@@RezaDorrani Thanku Reza:)
Thanks Reza
Thanks for watching
Hi Reza, I'd like to customize the certificate. How do I go about changing the image quiz and logo image?
You would need to update that in the flow. Change the base64 image code to reflect your image.
This is probably a super basic question, but I don't have an active Azure subscription. Is there an alternative to using a tenant ID?
Every M365 tenant is backed by Azure AD. You do not need an azure subscription to get the tenant id.
Excellent Reza.. You covered many scenario using forms in this videos. Thanks for your time and efforts.. As always you are my
super hero.🦸
You are most welcome. This video was hard work :)
Hi Reza! Thank you for this video. Is it possible to integrate this Power Automate flow to a .NET application? How would I do that?
I have not done any integration with .NET app so not sure. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani Thank you!
Thanks for your video Reza. May i know how we use MS from for users declaration everyday? For example: every day( from 8AM to 4PM) user go to form to declaration and i will collect this data for report at 5PM, each mean the info in the form will be reset or clear before 8AM everyday.
Once you store the excel file, you can also use the delete all responses API. Run a network trace and check the API for delete all form responses. Similar to what I showcased in video to grab API for Downloading the Excel file.
@@RezaDorrani Thanks, let me try
@@nguyenhuu2797 you could take a look at my video demonstrating how to do this. czcams.com/video/eq6QRz29q9Q/video.html Reza references this in his video description.
Question 🙋♂️.. it’s possible to have a user click on a link, auto populate some of the fields on the form .. passing the values from user to the form?
I don’t think that option is available
Is there a way to add the quiz score into the Sharepoint list versus sending it via email in the table and excel file?
Possible but I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Indeed great video, thanks for sharing, can we also save the form as it to one drive as pdf?
It can be done. Not covered in this video though.
can you give me a hint?, I will search, Cause this will save time spend to do this step.
@@alzaimoor79 I believe forms has option to print to pdf. You could run a network trace and fire that query.
Hey @Raza this worked so great for me, 3 weeks back my flow stopped working on the FormInfo step with an Error 400. Has a change in Forms been happen or is it maybe something my administrator has changed? A help would be great.
I am not aware of any changes pushed out to flow or forms that should affect this.
@@RezaDorrani Thanks for the quick response. it is really strange if i type in the string to the browser it works but with the automation if fails with error 400.
@@FelixMassoth I would recommend posting your issue on forums in case someone has experienced something similar
powerusers.microsoft.com/
I have the same error. Looking for fix too.
Hi Reza,
Thanks for the video. I tried following each step but every time it's giving total score not the score earned by the user. Please help.
Video description has link to download sample flows. Give that a try.
If issue persists, I would recommend posting issue with screenshots on the forums at powerusers.microsoft.com
We have a unique requirement to store responses from different forms as key value pairs in a child dataverse table. An user (in the contact table) would fill a form based on an event that they wish to attend. The form questions are different based on the event. We don not want to build a flow per form but use a single flow that uses the header row of the excel to get the questions and use that as the key in a child table while the answers are inserted in the value column. Is there a way forward? Any hint would be mighty useful.
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
is it possible to get the live results of the responses? We have to refresh the page to get the updated results.
Not sure is there is an option to do that
Hi Reza, Hope you are keeping safe. Thankyou so much for the valuable information. I just wanted to know how can we automate or create a flow that can save responses as same the one we download manually with save as pdf option. As I am working with training department I wanted to save pdf with points.
please help me with this as I watched many videos and tried many time but I cannot save. tried creating a custom html but it did not help either.
I will have to look at your flow in action to know why your flow is not working. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thank you so much for your reply. there is no problem with the flow. In Forms you are able to print a response. You can do this by going under ‘Responses’ on a Form, then click on ‘View results’. You will see three dots where you can click on, and that’s where you can choose the option ‘Print response’. By choosing the pdf-printer, we have a perfect pdf-format of the response.
I would like to have my responses of the Forms in that particular style using a Flow.
Could you maybe help me with this issue? Thank you in advance
@@anhsawid There is no out of the box action that does that. Im sure there must be an underlying api that generates that pdf. Just like I did in video, if you run dev toolbar on your browser you may get that API to call which will generate pdf.
@@RezaDorrani Thankyou so much will try again..
Hi Reza..wasn't sure the best place to send you a message so I will try here. Would it be possible to make a video on PowerApps Portal? I would like to know more about the capabilities and what you can or can't do compare to a Canvas app from a design perspective.
I have done very limited work with Portals. I do plan on creating a training portal in which I will cover the basics of different App types.
Check channel memberships. I have gone live with a training tier that you can sign up for now.
czcams.com/users/rezadorranijoin
Great tutorial but have a question how to add Paginations if i have many Pages
Not sure about paginations. I would have to try it out to provide guidance. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hello sir I want to know how we can connect two Ms forms in single shatepoint list through power automate flow
This is something I have not tried and have no references. I would recommend posting your query on forums at powerusers.microsoft.com
Thanks for the amazing explanation Reza.For the first part of the video is very clear, and the flow is working properly but starting from 19:52 to create JSON, the flow is not clear because you are very fast while explaining the flow, and it would be highly appreciated if you could mention the step in the comments or screenshot for the steps.Thank you
Most welcome!
Video description has link to download entire flow. You can check all the code in it.
@@RezaDorrani
Thank you for your message, Reza. I appreciate your feedback. The flow seems to be functioning correctly, but I have noticed that when there are 10 respondents, the system sends 10 separate emails with attached certificates for all 10 respondents. Ideally, the system should only send the latest responses and not include all previous ones. Can you please assist me with this issue? Your help would be greatly appreciated.
@@abdelazizmohamed575 This video is about getting all responses. If you need to run flow for each response, I have done videos on that too.
Im sorry but I have not run into any issues hence not sure how to help.
Hello @@RezaDorrani, I would like your help knowing how to run the flow for each response because every time I run the flow, and if there are 20 responses, the system sends 20 emails with the certificate. Thanks
@@abdelazizmohamed575 It would because you are running flow for each instance. If you need single instance then the current video shows how.
I am a great fan of your videos Reza.
Actually, I have a scenario. I think you are the only one who can help me with this. I need to convert an array into an object in Power automate. Also, I shouldn't use variables here, because the conversion is happening inside of Parallel.ForEach. (Degree of Parallelism=50)
Input: Array
[
{
"Prop1": "Value1"
},
{
"Prop2": "Value2"
}
]
Output: Single object
{
"Prop1":"Value1",
"Prop2":"Value2"
}
Your scenario is not related to this video :)
Converting objects to arrays would require JSON parsing and expressions. I do not have a video or reference point for this at the moment. I will recommend you check on the forums at powerusers.microsoft.com/
very useful, but i got blank email when submitted no files no tables, where i have to check.?
You would probably need to add a check to see count of rows in json. If 0 then dont send any email.
thank you! this is very helpful :) but is there any way for the responders receive a personalized email based on their total marks? for example, when students complete the quiz on forms, the ones with good result (eg: 10/10) will get a different response compared to the others with 4/10 result. Thank you and hope you will be able to help me with this 🙂
You could add a conditional branch in flow to check the score and accordingly send an email. I do not have a video reference on this scenario though.
@@RezaDorrani Thank you, I will try doing it!
@@RezaDorrani Hi, tried it but it was quite confusing, do I still need to follow the steps used in the video?
@@shazanasabri Yes but I dont show exactly ur scenario. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
It will be very helpful if there's a video reference on this!! :)
can we update the responses once it is submitted in Microsoft form?
No
On the select array step, I am trying to map another column using a column available from Excel. I am not getting the Dynamic Content to show, similar to your Total Points. What am I missing so that those Excel columns list from the previous step?
Use expression. item()?[‘Your column name’]
Single quotes - in between add column name
Thanks!!! how to create a flow for gamification: 4 quizzes in different teams channels, store the individual results and then store the total result
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Is there a way to delete the Excel file from OneDrive after the workflow is complete -- same with the .html file used to convert to PDF that is attached to the email as the certificate? Just looking for a way to clean up the collateral used in the workflow when it completes.
There is a delete file action in Onedrive that can be used for cleanup processes
@@RezaDorrani I can do that for my certificate file, however the excel file that was created with the Send HTTP request shows that it has a lock on it and I am unable to delete it from OneDrive. It says, "The resource you are attempting to access is locked". Certainly, I could add a delay in the flow or add another flow that would circle back and clean up after the lock period, but I didn't know if you had a trick to release the lock and then delete as cleanup exiting the flow.
@@annettemassie1962 I am not aware of a trick other than introducing a delay
I would like a process similar to this run each time a quiz is submitted. If the score is equal to or greater than a specific number, I would like the submitter of the form to receive an email with a completion certificate document. Would I start the workflow with "when a form is submitted", then get the response details and then use the Sent HTTP to SharePoint to do an API Get, connecting to just the response that was submitted?
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
I want to create a flow of hourly schedule maintenance reminder of my department equipment.Can you help me on that .
In my flow some one will response through form about the current hour meter reading of equipment. That data will get stored in perticular cell of an excel in one drive and that current hour meter value must get compere with due maintenance hour and a mail should be triggered when only 10 hours will be left.and when ever the maintenance is complete another form responses will be filled by technician and some predefined value must be added in the Excel for due hour. Please help in this regards.
I do not have any videos on that scenario. I will recommend checking on the forums at powerusers.microsoft.com in case someone has done something similar.
I do not have any videos on that scenario. I will recommend checking on the forums at powerusers.microsoft.com in case someone has done something similar.
How to provide specific I'd or Name to the Ms form which is automatically Generated when you open the form.
You can give a name to your form in MS forms. Its an out of the box feature.
Generated when you open the form? I don’t think MS form has any such option.
Hi Reza, first of all - you make an extra content, keep going ! :D I would like to ask also about one step you are mentioning about, in 19:48 you talk about "Data operation - select" and you put data to "From" field "questions" - how you get this "questions" from body ? when I try to write expression like you have I'm getting error "The 'from' property value in the 'select' action inputs is of type 'String'. The value must be an array." ;) Can I ask for a little help ? ;) Best Regards ! Pawel
Thank You!
Video description has links to download sample flows. You can check all the code in there.
@@RezaDorrani Hi...sorry for asking most probably a dumb question. How do i use the downloaded sample flow?is there any video or written guide of it?Thank you.
@@crashcash9576 www.codesharepoint.com/PowerPlatform/how-to-export-and-import-microsoft-flow
I'm a little confused. If we already have the table then we have the total points without expanding at the point in which we filter the table array.
We have to add the data from the array to get the total points.
@@RezaDorrani I just pulled the score off the spreadsheet. I think I'm missing something. Either way great video. Are there several other APIs like the one here in forms you use to do "odd jobs". I'd love to see a video on "APIs you never used" or something. Thanks for all you do.
@@kevinthetechguy Thanks Kev. I believe all actions you take with forms, you can run fiddler or run a network trace and you will get the API info.
I will plan something related to APIs for my upcoming training content.
The quizz results flow works even if the user gets 2 points and also the send email triggers more than 6 email notifications . dont know how to solev this error
I will have to look at your flow in action to know the cause of your issue. Vieo description has links to download sample flows. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani posted it
You could make a quiz tutorial by creating a sharepoint list
You could
Hello Reza, I am new to power automate, I have challenges I want to like this: Can you help me please?
I have created a Microsoft Form with the following fields: Ship Name, TID, Name, Phone Number, and Remarks. Additionally, I have an Excel file where each sheet is named based on the submission time from the form. Each sheet contains a table with columns for Ship Name, TID, Name, Phone Number, and Remarks.
I want to set up a Power Automate flow with the following logic:
Triggered when a new response is submitted to the form.
If a response is submitted today, it will add a row to today's sheet and table.
If a response is submitted the next day, it should not add a row to the previous day's sheet. Instead, it should create a new sheet named with the new date, create a table with the specified columns, and add the row with the response to this new table.
Essentially, I want each day's responses to be added to a separate sheet corresponding to that specific date.
I do not have a video reference on this and would have to try it out to provide guidance. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
At 4:29 you have an unfinished flow, then at 5:24 you seem to have switched to a new flow. How are the 2 linked? That gap has lost me
4:29 I was just talking about the standard flow we build for MS forms scenario.
5:24 is the actual step by step build
I test the flow of my quiz form. it still keep ruining in the step "List rows present in a table". I don't what it is wrong
I have not experienced any issues so not sure. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Thanks for sharing
One more question, where I get data to input the quiz image or quiz logo?
@@SOPHEARAK7777 I don’t remember every step of the video as it was done a while ago. Video description may have link to download the same shown in video.
@@RezaDorrani Hi I test the quiz flow. then got error in select step show error "The execution of template action 'Select' failed: The evaluation of 'query' action 'where' expression '{
"Time Taken (Secs)": "@div(mul(sub(ticks(item()['Completion time']), ticks(item()['Start time'])), 100), 1000000000)",
"Percentage": "@formatNumber(mul(div(float(item()?['Total points']), float(variables('quiztotal'))), 100), '###.00')",
"Email": "@item()?['Email']",
"Name": "@item()?['Name']",
"Points Earned": "@item()?['Total points']",
"Quiz Total Points": "@variables('quiztotal')"
}' failed: 'In function 'ticks', the value provided for date time string '45338.7106134259' was not valid. The datetime string must match ISO 8601 format.'." would you tell what wrong is it?
3:48 I can't find the compose task to continue.
3:48 is when the video shows "get response details".
Can you point to the exact time in the video?
Hi Reza,
Step: Get quiz Responses Excel (time 20:20). I can't create "body.rowcount". Could you please share with me detail of "body.rowcount"?
Many thanks.!
Video description has links to download the flow.
@@RezaDorrani It is json file. how to use it in power automate?
Thank you.!
@@oanminhtruc3168 There is a zip file there as well (That is the flow). You will need to import the flow.
@@RezaDorrani Great.! Many thanks Reza for your channel.!
Hi Reza, I have been using this method for over a year after watching your video. But since last week, I have been getting the "Bad Request" error for the SharePoint request to get all the forms' list. It's not working anymore. But when I try to API request on browser, it's working. Any idea? Thanks a lot!
I have not revisited this video in a long time. Not sure if anything has changed since.
@@RezaDorrani Thanks for the quick response. Totally understand. It was working perfectly but now it's giving "Unexpected response from the service" error. I'll try to figure it out. Thanks again!
@@umitkurt7087 Check if api has had some changes or may be it needs to be called from a different action like http
Hello Reza / @umitkurt7087 I got the same issue, I have been using this method from 1 year ago with no issues, and suddenly since 2 weeks ago i started to notice the same error:
{
"status": 400,
"message": "Unexpected response from the service......
Did you find how to solve it? any workaround?
Thanks!!
@@joseluisramirezcuervo8756
I spent 5 mins and literally downloaded the flow and form shared in link provided in video description and everything worked as is. My existing flow as well continues to work.
Is this method still working for anyone? I'm getting an error 400
I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
How do I find out my tenant id?
learn.microsoft.com/en-us/sharepoint/find-your-office-365-tenant-id
Hi, but why do all the replies come to me with the same email address?
How can I view the email address of someone who responds?
Because the flow is running under your account.
You can always pass the responders email address as it is available as a dynamic property.
@@RezaDorrani potresti essere così gentile da spiegarmi come fare? È molto importante per me. Ti ringrazio davvero tanto
I would have to try it out to provide the steps. It would be best to post your query on the forums at powerusers.microsoft.com/
@@RezaDorrani grazie di cuore per la disponibilità...
I am getting the wrong number of total points when doing the increment quiz total. There are 14 questions in my quiz, with 12 of them having 0 points (two questions are to enter your name and email). When the increment step occurs, it is adding 1 point for all 14 questions, which is incorrect as the name/email questions are worth 0 points. I have verified the outcome of the json shows all questionInfo as the 12 pointed questions, so I am not sure why the for each is processing for ALL 14 questions instead of the 12 from the JSON. I have verified that ALL steps are correct. Any ideas?
Video description has link to download sample app and forms. You can check all the code in it.
I have not faced the mentioned issue.
I think you didn't run into the issue because all of the questions in your quiz had point values. Since I have two questions that are not awarded points, I cannot increment the quiz total by checking Point in questionInfo as it was blank. As a result it was just adding 1 each time it found an entry with Point, regardless if there was a point assigned. To resolve, I added a condition checking if items('Apply_to_each')?['QuestionInfo']?['Point'] is not equal to null, then I performed the increment of the quiztotal variable. As always, thank you so much for providing a comprehensive solution!!!
@@annettemassie1962 Oh yes the condition check would do the trick 😊
Can you able to give training on power apps
Email me at reza.dorrani@outlook.com.
I am working on my training portal. It will be ready in 2022.
@@RezaDorrani A full power apps training would be amazing
@@Brothercole1994 Coming soon.
From beginner to intermediate to advanced.
I would be starting to record these from Nov onwards.
These would be paid trainings though.
@@RezaDorrani Honestly, for a comprehensive beginner tutorial fro m stat to finish I would be happy to pay a fair price. Cant wait!
Hi Reza. I am interested in this training. Let me know the price.
How to get form id
Check the video again. The step to get form id is shown.
@@RezaDorrani actually in that vdo Ur own form created,but I want to use other user created form,so that there id not reflecting
@@nilams1914 You need to ask the owner of that form to give you ownership access
@@RezaDorrani ok got it thanks Reza , it's lovely explaining all thing in that vdo.also thank you for replying
When I selectes 'manually trigger a flow' system says you can not select this trigger as an action....😢
I have never come across this issue. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hello Reza! Great upload! I'm on the middle of building my flow and I got a different endpoint when I performed the network trace when I download my Forms responses which by the way has more than 50K. Hoping to help me on this to finish my flow.
PUT method (This API triggered upon clicking the Get latest responses)
formapi/api/[tenantID]/users/[userID]/forms('[formID')/GenerateCSVFile
GET method (This API triggered multiple times between 25-30s interval)
formapi/api/[tenantID]/users/[userID]/forms('[formID')/GetCSVInfoList
GET method (This API triggered once generation of CSV is completed which will download the responses in csv format)
formapi/api/[tenantID]/users/[userID]/forms('[formID')/DownloadCSVFile/6ff2badf-f6d0-4e5f-abe9-dbae46ed9445.csv
Probably because of the amount of the number of responses. Not something I have tried.