I always enjoy your videos. This opens up a lot of possibilities! I like forms, and now I have so many ideas on how to incorporate forms into more daily tasks. Thanks Reza!
Doing the same thing (but with a Power App front end - not MS Forms). Hopefully using "Patch" for attachments will be a bit easier. I always stop everything to watch these. Always extremely helpful. Thanks Reza 💥💥
Thanks for the great work Reza. 1. How can we just send back the request to users asking for additional information rather than rejecting it. Don’t want our users to submit multiple responses. (Wants to send back and forth) 2. If we want to forward to another person for approval how can we do? Example if the users manager is Out and wants to forward to managers manager for approval.
1 - There is no back and forth in forms. There is a new option to edit but that's not something I have explored. 2 - I have done a video on that. Its automated fwd if user is OOO. Check my approvals playlist.
@@RezaDorrani Hi Reza, have you had a chance to explore the new option to edit forms? Any updates on that would be greatly appreciated! If you could also create a video showcasing that solution as part 2, that would be awesome.
Hi Reza, a great video thanks. However, I'm getting stuck on the third step (7:08) with an error saying 'No Dynamic Content Available". Is there something in the first two steps that may have changed since you first made this video that is blocking Dynamic Content?
Im not aware of anything that has changed since I made this video. I have not come across this issue and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hi Rez, truly amazing mate. You are a STAR 🌟 Thank you for very insightful tutorial. One question though, I did not make my supporting documents compulsory (optional to the responder) but we added supporting documents attachment layer in powerautomate and if the user won’t attach optional supporting documents in the form the powerautomate process fails. how do we address this? your input would be greatly appreciated. Thanks
Hi Reza, I'm not sure if there is an update or glitch but it seems that Get Response Details > Response ID is no longer an option. Instead it gives "List of Response notifications Response ID" that automatically turns into a "For each". I tried to run the flow this way but it doesn't work. Can you tell me how to get the old dynamic response id back or how to work around this? I would greatly appreciate it. Thank you!
This is probably an issue with the new flow designer. Go to trigger action, go to settings for trigger action, turn on split on and set array to @triggerOutputs()?['body/value']
I did this, but select no longer allowed for dynamic content, and "send an email" would let me select for dynamic content but wouldn't allow it to save. Am I the only one having this problem?@@RezaDorrani
Reza, so happy to see an update on this topic. I have a question though: When I add the response id in get response details it forces me into a for each loop. Any idea why or how to prevent that? As always, thanks for the great videos!
Hello Reza Thank you very much for your videos, with them I have learned to create flows without knowing programming and having knowledge and it has helped me a lot in my work
@@RezaDorrani Hello Reza, again annoyingly I saw the video that you recommended to rename the files (th-cam.com/video/PRwUn0aZysM/w-d-xo.html&ab_channel=ChadKealey) is there a way to add this to the flow at some point to be able to rename the files? files?
Hello Reza, thank you so much for all your great videos. This video is only 7 months old, so I'm wondering if MS Forms has changed. I can't seem to find the Response receipts "Get email notification of each response". I have looked in several locations, others seem to have the same issues on other sites. Do you know if this is this a restriction for some users?
Good Day Reza, You helped me/us a lot!!! Double Thumbs up! Subscribed!. I would like to request about this scenario - If the approver attached a file/files upon approving, I want to get the file from that approval step and add it to the attachment in sharepoint list. hoping you will notice this. Thank you
Good evening, Reza. I've watched a number of your videos - they have been very helpful for learning the power automate basics when designing workflows for my firm (I'm a CPA learning this on the fly). Can you point me to a video in your library that would help me for when I want to attach a link to a submitted Microsoft Form within a "start and wait for approval form" that is hosted on a global admin account? The form is accessible by individual 365 users on our Sharepoint intranet to fill out and submit, which triggers a "start and wait for approval form" workflow. I have the workflow mapped and working, but the link in the workflow will not direct to the results of the submitted form (an URL not found page comes up when clicked). Any suggestions would be appreciated. Thank you.
Most welcome and thanks for watching and learning from the videos. I do not have a video reference for the link scenario. I would recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hello Reza, thank you for your video. I have a problem with the select operation where it shows that there is no dynamic content available. Would appreciate your help on that matter
have not come across this issue, hence not sure. Video description has link to download the entire solution (members only - check description for details)
Hi Reza, amazing video - all steps explained perfectly Is there a way that the email be sent to a particular person based on the person selected on the MS Forms?
great video. the only issue I have is it being in a One Drive. For team environment, thats to risky. So I always build the form from a Teams/SP site. The slightest change here is getting the id, you literally have to paste that id from browser to load it. Team forms will not show on forms drop down. Doing this and sharing ownership of the PA should increase resiliency
Thanks Reza, good example. But this only works for MS Forms with authenticated users. If you allow anonymous responses you cannot ask for file uploads. Do you know why this is?
Hello, in this example you added files uploaded as attachments to a sharepoint list, right? If so, can i use the same method to add an email sent to a specific mailbox in a Ticketing System to add that email as attachment to the list? Thanks.
This video is all about taking form attachments to SharePoint. If you attach eml file to form attachments, it should save that as well. If you are looking to get email file and then save to list attachments automatically - I do not have a video reference on it.
@@RezaDorrani will try according to your guide. I want to add the email that was sent to a shared mailbox as attachment to a sharepoint list item that is created when the mail arrives via power Automate, and after i have another flow to add any replies on that email to the same item in sharpoint but is of type MultiLine Text, i believe that adding as attachment will be more elegant. Now i am stuck with another thing, filtering based on a selected value in TabLists and sorting by ID in a Data Table preview control.
Another great lesson… I have a customer that does not have actionable email configured in their government tenant. Are there any work around to allow users to take actions directly from within outlook?
@@RezaDorraniI guess I don't see the difference. You use the response from the clicked option in the email in your flow and change your status field accordingly.
I have a question in regard to PowerApp capability: a home screen that you can view/edit multiple sharepoint data list. For example, data list named: idea1 and idea 2, and each data list has the same control number. When you select the control bumber, the data entered in idea 1 data list will show, and data in idea 2. You can also click on that idea 1 entry to view/edit of all the data detail. Similar to data gallery but it is for multiple data list rather than just one data list. Is it possible? If so, would you be interested to do a video tutorial on that?
I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
Hi Reza, I’m getting an error when my flow reaches the Apply To Each action and tells me action ‘get file content failed’, along with File ID ***** is not valid. How do I fix this? Thank you
I have not come experienced this and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, I have a question, if in my form I have enabled the option "Allow respondents to save their response" and "allow interested parties to edit their responses" when resending a response adding a missing attachment, it no longer performs the approval and does not is added to the list, is there a way to solve this?
I have not come across this and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
It's Nice work...Rezo I have a doubt that can we create list items from excel fast for large sets of data using SharePoint http connector....that if we have 5000 rows and 10 columns it should be done with 10 to 12 minutes like that.
Welcome! This video is not about excel data load :) Explore graph api for excel. There are ways to do it faster there but something I have not explored.
The designer has a new refreshed look but the steps are the same. You also have option to swap to old designer. Video description also includes details on how to download the flow (members only - check description for details)
Hi Aries, I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, i know my ask is different, may I have some solution to handle a list with 150 columns and more than 7k row using power apps. Actually its showing an error of column threshold. Thanks for all such awsome tutorials.
The ask is completely different from the video :) Power Apps can handle large lists - check my delegation videos Column type threshold limit cannot be changed - This video will show the must know things - th-cam.com/video/AkyW8cWDVoc/w-d-xo.htmlsi=1CG98oYx4bEZC2uO
I keep getting the failure error on my file upload attachments can you help? "Unable to process template language expressions in action '1650' inputs at line '0' and column '0': 'The template function 'variable' is not defined or not valid.'.
Have not experienced the mentioned issue, hence not sure. You can try downloading the solution shown in video (members only - check videos description for details)
Hi Reza, Thank you for the great content as always. I tried to replicate this flow, but it keeps automatically putting Get Response Details into it's own For Each action and then I can't call on any of the dynamic content for Get Response Details. I've pulled the dependent actions into that For Each, and I was able to get the flow to start working, but then when it hit the Get File content action I kept getting errors saying the 'id' was null. Is there a way to keep Get Responses out of a For Each loop so I can replicate exactly what you have?
Im not sure about that. Check video again to see the steps. Also, Video description has link to download entire solution (members only - check description for details) I would suggest giving that a try.
@@RezaDorrani I tried again this morning starting completely from scratch and had the same issue when I tested the flow at the email portion of your video. I got an error that the Response ID field of Get Response Details was null. When I edit the flow to check the dynamic content of the Response ID field of Get Response Details it forces me to use the dynamic content List of response notifications Response ID, which then creates an apply to each loop automatically. This in turn throws this error: Action 'Select_Quote_Attachment' failed: Unable to process template language expressions in action 'Select_Quote_Attachment' inputs at line '0' and column '0': 'The template language expression 'json(body('Get_response_details')?['r914ed519ed444982888fa851a8179a57'])' cannot be evaluated because property 'r914ed519ed444982888fa851a8179a57' cannot be selected. Array elements can only be selected using an integer index. Please see aka.ms/logicexpressions for usage details.'. I looked at joining your membership, but it looks like I'd have to go with Silver to download the flow, but I'm concerned there has been some sort of update since you posted the original video, and I'm going to run into the same issue even using your flow.
I have not revisited the video since the day I made it and not sure if any updates have been pushed out since. The video download is an option you can explore or post your issue on forums at powerusers.microsoft.com/ in case others have experienced something similar
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
Hi Reza! I'm trying to build an app, where Edit form should contain editable data table/gallery inside it, so that when new user create a request he should have new data table created inside the form. Please advise me on how I may accomplish the same. Thanks in advance.
The video is about flows and forms not apps :) 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
At 25:52 type property should have either 'supporting documents' or 'images' as declared in the select actions, but how you got the type of the file (.pdf,.doc,.xls etc....)
@@RezaDorrani HI, my staff need to fill out the first part of a form which contains personal information, then the second part is about the training they are requesting. They will then submit the form and it will move through the approval flow. IF approved. there is then a last section which is "for offiicial use only" where the training team need to fill out what company supplies the training... and other information my company wants to capture. But this "for official use only" section will only be filled out AFTER the training is approved. Is this possible thanks
@@alexandraklados3492 I would have to try this scenario out to know the options. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
I would have to try it out to know the steps. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi Can you please add a example with list of text and images? Like the following: We have a word file (storred in Sharepoint) the document has tags product text and product image. Aand then we have a Sharepoint list with columns "productText" and "productImage" The flow then make pdf , each row corresponds to one pdf. (To be frank, the biggest issue i have is extract the image, the text is easier)😅😊🎉❤
I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
I have not come across this issue and hence not sure what the cause for it could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
I am trying to replicate this but using Get file content from Sharepoint as the form is a group form. If I use "Get file content" the flow fails because "file not found" and if I use the action GetFileContentUsingPath, I get error "empty path given". Please assist
I have not come across the mentioned issue and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
I need help.. I have created a Microsoft forms and the response is sent to teams. My problem is within the responses, there are some questions were the responders leave blank. But when the teams message comes in, the blank question also shows. How do I filter it to show only if there is a response? Could you show step by step in power automate?
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.
Video description has link to download entire solution (members only - check description for details) I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@@RezaDorrani I should have framed my question properly. My intention in this question was, is it possible to make comments mandatory in case of rejection?
I have not experienced that hence not sure. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@@RezaDorrani it's so weird if I don't put any action in between, the dynamic content will not be available. But if I do, it will be there..is this familiar to U? Ty for the reply I'm subbing to u
Hi Reza! I was really curious about all the new features for Power Automate released in MPPC23. Can you please give it details it will be really helpful.
Announcements were around new cloud flow designer and copilots. I have already done videos on it. th-cam.com/video/-AQ_lcpaRec/w-d-xo.htmlsi=o194tTADiY70ufzT
@@RezaDorraniThanks for replying ❤ I did see the video but was just curious if any more features were released 🤘. Thanks again for always sharing great content. Big fan here 🙌🙌
how to enable anyone can respond button(when sharing outside org it asking please login )i just want without login fill the form is it possible can you share any link are steps Thanks . Reza
Hi Raza I have been using the same method but unfortunately getting the below error in start and wait for approval connector- AttachmentContentNotValidBase64String
I always enjoy your videos. This opens up a lot of possibilities! I like forms, and now I have so many ideas on how to incorporate forms into more daily tasks. Thanks Reza!
Awesome! Thanks Nick.
Im happy to hear that this is useful.
Reza, I am glad that I found your channel. Your teaching is no bs and practical. Keep up the great work
Thanks
This video is amazing. It answers every question that I have needed and searched for for months - THANK YOU
You're most welcome!
This is awesome. I was struggling with attachments for email vs approval. This is the video I was looking for. Thanks for all your videos.
Most welcome
Wish this video would have came out 2 months ago. I probably spent 6 hours on this before I figured it out then. But as always, great content Reza.
No worries! Hopefully it helps more people
Doing the same thing (but with a Power App front end - not MS Forms). Hopefully using "Patch" for attachments will be a bit easier. I always stop everything to watch these. Always extremely helpful. Thanks Reza 💥💥
Most welcome
It works, thanks! Important to mention that you have to switch flow to the old design to have possibility to combine expression with dynamic content
Thanks for sharing!
@Reza: Every time a pleasure to see these videos, thank you very much
You are most welcome
Thanks for the great work Reza.
1. How can we just send back the request to users asking for additional information rather than rejecting it. Don’t want our users to submit multiple responses. (Wants to send back and forth)
2. If we want to forward to another person for approval how can we do? Example if the users manager is Out and wants to forward to managers manager for approval.
1 - There is no back and forth in forms. There is a new option to edit but that's not something I have explored.
2 - I have done a video on that. Its automated fwd if user is OOO. Check my approvals playlist.
@@RezaDorrani Hi Reza, have you had a chance to explore the new option to edit forms? Any updates on that would be greatly appreciated! If you could also create a video showcasing that solution as part 2, that would be awesome.
@@RyanKuy-t4c I have not explored the new option and currently have no plans for a follow up video as I am working on multiple new video ideas.
Hi Reza, a great video thanks. However, I'm getting stuck on the third step (7:08) with an error saying 'No Dynamic Content Available". Is there something in the first two steps that may have changed since you first made this video that is blocking Dynamic Content?
Im not aware of anything that has changed since I made this video.
I have not come across this issue and hence not sure what the cause could be.
I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
I had the same issue. Turning off the new designer feature in the top right corner helped to resolve it.
This video is just a pearl of great price, thanks for your contribution
Hi Rez,
truly amazing mate. You are a STAR 🌟
Thank you for very insightful tutorial.
One question though, I did not make my supporting documents compulsory (optional to the responder) but we added supporting documents attachment layer in powerautomate and if the user won’t attach optional supporting documents in the form the powerautomate process fails. how do we address this? your input would be greatly appreciated. Thanks
Thanks so much!
The video shows how to handle scenarios when no file is uploaded.
Thank you Rez! i will run through it again. Top man 🔥
Hi Reza, I'm not sure if there is an update or glitch but it seems that Get Response Details > Response ID is no longer an option. Instead it gives "List of Response notifications Response ID" that automatically turns into a "For each". I tried to run the flow this way but it doesn't work. Can you tell me how to get the old dynamic response id back or how to work around this? I would greatly appreciate it. Thank you!
This is probably an issue with the new flow designer. Go to trigger action, go to settings for trigger action, turn on split on and set array to @triggerOutputs()?['body/value']
thank you so much. I will try this.@@RezaDorrani
@@kenellem.6233 Check th-cam.com/video/0Tvs9VLcQ3g/w-d-xo.html
I did this, but select no longer allowed for dynamic content, and "send an email" would let me select for dynamic content but wouldn't allow it to save. Am I the only one having this problem?@@RezaDorrani
Never mind--best is to switch to classic view.
Nice work Reza, I tried it with a co-pilot and i got exactly but with a different step, it build the variable and the expression for me
Thats nice to hear
Your Videos are very helpful for me right now, Thank you!
Glad to hear that!
Thank you @Reza Once again, the video was excellent, providing practical and applicable examples.
Awesome! Thanks for watching
very helpful thanks a lot! starting the year right!
Great to hear!
my question rn is how do i now transfer the approved files from the list to a document library? @@RezaDorrani
Thanks Reza the video is clear step by step to understand.
Glad to hear that
Amazing video Reza! Easy to follow, every complete and helpfull!
Happy to hear that!
Reza, so happy to see an update on this topic. I have a question though: When I add the response id in get response details it forces me into a for each loop. Any idea why or how to prevent that? As always, thanks for the great videos!
Check th-cam.com/video/0Tvs9VLcQ3g/w-d-xo.html
Got it! Thanks! "Split On" section for anyone wondering!@@RezaDorrani
Hello Reza
Thank you very much for your videos, with them I have learned to create flows without knowing programming and having knowledge and it has helped me a lot in my work
Glad to hear that!
@@RezaDorrani Hello Reza, again annoyingly I saw the video that you recommended to rename the files (th-cam.com/video/PRwUn0aZysM/w-d-xo.html&ab_channel=ChadKealey) is there a way to add this to the flow at some point to be able to rename the files? files?
Sorry but that is not a video I am aware of. I would recommend posting your query on the forums at powerusers.microsoft.com/
Hello Reza, Thank you very much for all this information. Is there any way to contact you for additional questions?
Most welcome!
For questions related to video, TH-cam comments is the best space.
Beyond that I do not offer 1:1 consulting.
Thanks a lot Raza, I have been trying to fix the null issue since last 4 days which you have resolved only 4 mins 😊
Happy to help! The main reason why I started working on this video was the null issue :)
@@RezaDorrani Just a question- I want to give a link to the filled form to the approver.
@@RenewYourPower I am not sure if they would get the access along with it. Not sure if that's an option. I have not explored it.
Many thanks again ,this is also ehat I need.
Most welcome
Hello Reza, thank you so much for all your great videos. This video is only 7 months old, so I'm wondering if MS Forms has changed. I can't seem to find the Response receipts "Get email notification of each response". I have looked in several locations, others seem to have the same issues on other sites. Do you know if this is this a restriction for some users?
I am not aware of changes in forms. But the flow shown in video continues to work as-is.
Good Day Reza, You helped me/us a lot!!! Double Thumbs up! Subscribed!. I would like to request about this scenario - If the approver attached a file/files upon approving, I want to get the file from that approval step and add it to the attachment in sharepoint list. hoping you will notice this. Thank you
Thanks for the sub!
Currently, there is no option for approver to attach a file in approval task when approving.
Good evening, Reza. I've watched a number of your videos - they have been very helpful for learning the power automate basics when designing workflows for my firm (I'm a CPA learning this on the fly). Can you point me to a video in your library that would help me for when I want to attach a link to a submitted Microsoft Form within a "start and wait for approval form" that is hosted on a global admin account? The form is accessible by individual 365 users on our Sharepoint intranet to fill out and submit, which triggers a "start and wait for approval form" workflow. I have the workflow mapped and working, but the link in the workflow will not direct to the results of the submitted form (an URL not found page comes up when clicked). Any suggestions would be appreciated. Thank you.
Most welcome and thanks for watching and learning from the videos.
I do not have a video reference for the link scenario. I would recommend checking or posting your query on forums in case someone has done something similar
powerusers.microsoft.com
Hello Reza, thank you for your video. I have a problem with the select operation where it shows that there is no dynamic content available. Would appreciate your help on that matter
have not come across this issue, hence not sure.
Video description has link to download the entire solution (members only - check description for details)
Hi Reza, amazing video - all steps explained perfectly
Is there a way that the email be sent to a particular person based on the person selected on the MS Forms?
Thanks!
I dont think that MS Forms has a person selector option.
great video. the only issue I have is it being in a One Drive. For team environment, thats to risky. So I always build the form from a Teams/SP site. The slightest change here is getting the id, you literally have to paste that id from browser to load it. Team forms will not show on forms drop down. Doing this and sharing ownership of the PA should increase resiliency
Thats how teams forms works.
I have done a video on it already - th-cam.com/video/K-hiDOPAG-4/w-d-xo.htmlsi=VeQTQEqiQmog256v
Great video, thanks for sharing sharing
Thanks for watching!
Thank you Sir very helpful for me. This make me join as a member.
Always welcome
Thanks Reza, good example. But this only works for MS Forms with authenticated users. If you allow anonymous responses you cannot ask for file uploads. Do you know why this is?
I clearly called it out in video :)
File upload is only for authenticated users.
Thank you, Reza.
Welcome
Hello, in this example you added files uploaded as attachments to a sharepoint list, right? If so, can i use the same method to add an email sent to a specific mailbox in a Ticketing System to add that email as attachment to the list? Thanks.
This video is all about taking form attachments to SharePoint. If you attach eml file to form attachments, it should save that as well.
If you are looking to get email file and then save to list attachments automatically - I do not have a video reference on it.
@@RezaDorrani will try according to your guide. I want to add the email that was sent to a shared mailbox as attachment to a sharepoint list item that is created when the mail arrives via power Automate, and after i have another flow to add any replies on that email to the same item in sharpoint but is of type MultiLine Text, i believe that adding as attachment will be more elegant. Now i am stuck with another thing, filtering based on a selected value in TabLists and sorting by ID in a Data Table preview control.
@@sitecraft_ro I would recommend posting your issues/queries with screenshots on forums at powerusers.microsoft.com
Another great lesson… I have a customer that does not have actionable email configured in their government tenant. Are there any work around to allow users to take actions directly from within outlook?
Thanks!
I am not aware of any workarounds for actionable messaging in emails.
We use "send with options" to allow users to have clickable responses in email for the same reason. We don't have actionable emails allowed.
@@MrAirtaz Makes sense but that is not an approval action.
@@RezaDorraniI guess I don't see the difference. You use the response from the clicked option in the email in your flow and change your status field accordingly.
@@MrAirtaz An approval action can be responded from teams, approval center, mobile app and email.
Anyone could lose an email or mistakenly delete it.
This is great! Thank you!
Most welcome
I have a question in regard to PowerApp capability: a home screen that you can view/edit multiple sharepoint data list. For example, data list named: idea1 and idea 2, and each data list has the same control number. When you select the control bumber, the data entered in idea 1 data list will show, and data in idea 2. You can also click on that idea 1 entry to view/edit of all the data detail. Similar to data gallery but it is for multiple data list rather than just one data list. Is it possible? If so, would you be interested to do a video tutorial on that?
I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
Hi Reza, I’m getting an error when my flow reaches the Apply To Each action and tells me action ‘get file content failed’, along with File ID ***** is not valid. How do I fix this? Thank you
I have not come experienced this and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, I have a question, if in my form I have enabled the option "Allow respondents to save their response" and "allow interested parties to edit their responses" when resending a response adding a missing attachment, it no longer performs the approval and does not is added to the list, is there a way to solve this?
It wont because the video scenario only covers new forms not editing. Editing is not an area I have investigated in.
I just need to take attachments from an MS form and save them in a SP library. Is there a way to do that?
There is a create file action in power automate for that
hi there, Great video...learning a lot. I tried it, however, my images show up on an email with a long file number and not open. any ideas?
I have not come across this and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
It's Nice work...Rezo I have a doubt that can we create list items from excel fast for large sets of data using SharePoint http connector....that if we have 5000 rows and 10 columns it should be done with 10 to 12 minutes like that.
Welcome!
This video is not about excel data load :)
Explore graph api for excel. There are ways to do it faster there but something I have not explored.
@@RezaDorrani Yeah know that this video is not about excel data load but just making some ideas of that😅😅
Following your steps but look different on 'Select action'... cannot convert string to JSON. Ms Power Automate just upgrade?
The designer has a new refreshed look but the steps are the same. You also have option to swap to old designer.
Video description also includes details on how to download the flow (members only - check description for details)
Nice video Raza
Thanks
Hi sir, is it possible that to attached or send files, while approving the request?
Not an option
Very good, great content. THX 🙏🙏
Glad you liked it!
Hi Reza, i have tried to use expression "items" on the action "select data" but it always said that the expression invalid. Could you tell me why?
Hi Aries,
I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi Reza, i know my ask is different, may I have some solution to handle a list with 150 columns and more than 7k row using power apps. Actually its showing an error of column threshold. Thanks for all such awsome tutorials.
The ask is completely different from the video :)
Power Apps can handle large lists - check my delegation videos
Column type threshold limit cannot be changed - This video will show the must know things - th-cam.com/video/AkyW8cWDVoc/w-d-xo.htmlsi=1CG98oYx4bEZC2uO
@@RezaDorrani thanks
THANK YOU VERY MUCH
Most welcome
I keep getting the failure error on my file upload attachments can you help?
"Unable to process template language expressions in action '1650' inputs at line '0' and column '0': 'The template function 'variable' is not defined or not valid.'.
Have not experienced the mentioned issue, hence not sure.
You can try downloading the solution shown in video (members only - check videos description for details)
Hi Reza, Thank you for the great content as always. I tried to replicate this flow, but it keeps automatically putting Get Response Details into it's own For Each action and then I can't call on any of the dynamic content for Get Response Details. I've pulled the dependent actions into that For Each, and I was able to get the flow to start working, but then when it hit the Get File content action I kept getting errors saying the 'id' was null. Is there a way to keep Get Responses out of a For Each loop so I can replicate exactly what you have?
Im not sure about that. Check video again to see the steps.
Also, Video description has link to download entire solution (members only - check description for details)
I would suggest giving that a try.
@@RezaDorrani I tried again this morning starting completely from scratch and had the same issue when I tested the flow at the email portion of your video. I got an error that the Response ID field of Get Response Details was null. When I edit the flow to check the dynamic content of the Response ID field of Get Response Details it forces me to use the dynamic content List of response notifications Response ID, which then creates an apply to each loop automatically. This in turn throws this error: Action 'Select_Quote_Attachment' failed: Unable to process template language expressions in action 'Select_Quote_Attachment' inputs at line '0' and column '0': 'The template language expression 'json(body('Get_response_details')?['r914ed519ed444982888fa851a8179a57'])' cannot be evaluated because property 'r914ed519ed444982888fa851a8179a57' cannot be selected. Array elements can only be selected using an integer index. Please see aka.ms/logicexpressions for usage details.'.
I looked at joining your membership, but it looks like I'd have to go with Silver to download the flow, but I'm concerned there has been some sort of update since you posted the original video, and I'm going to run into the same issue even using your flow.
I have not revisited the video since the day I made it and not sure if any updates have been pushed out since. The video download is an option you can explore or post your issue on forums at powerusers.microsoft.com/ in case others have experienced something similar
Hello
Can you make tutorial
How to create approval flow for time leaving request during work
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
Hi Reza!
I'm trying to build an app, where Edit form should contain editable data table/gallery inside it, so that when new user create a request he should have new data table created inside the form. Please advise me on how I may accomplish the same.
Thanks in advance.
The video is about flows and forms not apps :)
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
Thanks for the quick response@@RezaDorrani
At 25:52 type property should have either 'supporting documents' or 'images' as declared in the select actions, but how you got the type of the file (.pdf,.doc,.xls etc....)
type property only gives 'supporting documents' or 'images'
I am also performing action to get file metadata. Thats where all the info comes from.
HI, I have a sharepoint from that the training team needs to add information to AFTER approval. Is there a way to do this?
Sorry I did not understand the question
@@RezaDorrani HI, my staff need to fill out the first part of a form which contains personal information, then the second part is about the training they are requesting. They will then submit the form and it will move through the approval flow. IF approved. there is then a last section which is "for offiicial use only" where the training team need to fill out what company supplies the training... and other information my company wants to capture. But this "for official use only" section will only be filled out AFTER the training is approved.
Is this possible
thanks
@@alexandraklados3492 I would have to try this scenario out to know the options. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
How would the "Empty" work if the uploads are going to a sharepoint list? I do not see an option to view the array in the "add attachment" function?
Nevermind. I wasn't closing the parenthesis after the null. Went back to look at it and read it in IF statement order. Terrific videos.
Thanks
How to rename with submitted file attached after being approved. Could you help to guides it?
I would have to try it out to know the steps.
I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi
Can you please add a example with list of text and images?
Like the following:
We have a word file (storred in Sharepoint) the document has tags product text and product image.
Aand then we have a Sharepoint list with columns "productText" and "productImage"
The flow then make pdf , each row corresponds to one pdf.
(To be frank, the biggest issue i have is extract the image, the text is easier)😅😊🎉❤
I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
In Select action, In from field No Dynamic Content is available. How to add? Please help
I have not come across this issue and hence not sure what the cause for it could be.
I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
I am trying to replicate this but using Get file content from Sharepoint as the form is a group form. If I use "Get file content" the flow fails because "file not found" and if I use the action GetFileContentUsingPath, I get error "empty path given". Please assist
I have not come across the mentioned issue and hence not sure what the cause could be.
I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
There's somethigth that im not doing well. But when i receive the attachment its size is 1kb and is unable to open. 😢
I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
I need help..
I have created a Microsoft forms and the response is sent to teams. My problem is within the responses, there are some questions were the responders leave blank. But when the teams message comes in, the blank question also shows. How do I filter it to show only if there is a response? Could you show step by step in power automate?
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 Please make a video solution
@@paradise2750 I have no plans to make one on this scenario. I have many
video ideas lined up that I am working on
subscribed!
can you make this flow to connecting to docusign please :)
Thanks for the sub!
I have done no work with docusign
i can't continue on select data operation using json() no selection on dynamic content.
Video description has link to download entire solution (members only - check description for details)
I have not experienced the mentioned issue and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
can this flow work on Group form?
Not the same flow. Group forms are stored in SharePoint.
In the approval email, Is it possible to make comments in case of rejection?
Check the video again. I do show comments being entered for rejection
@@RezaDorrani I should have framed my question properly. My intention in this question was, is it possible to make comments mandatory in case of rejection?
@@anjanchidige Currently, there is no option to make comments mandatory in flow approvals
Can you help why is it when I try to use the Select data operator, it says no dynamic content available?
I have not experienced that hence not sure.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@@RezaDorrani it's so weird if I don't put any action in between, the dynamic content will not be available. But if I do, it will be there..is this familiar to U? Ty for the reply I'm subbing to u
@@dvsalim09 thanks for the sub! I don’t remember experiencing that.
@@RezaDorrani Sir why does it say that my "from" is null, although I did the json() thing already
@@dvsalim09 I have no idea about that.
Video description has link to download entire solution (members only - check description for details)
Hi Reza! I was really curious about all the new features for Power Automate released in MPPC23. Can you please give it details it will be really helpful.
Announcements were around new cloud flow designer and copilots.
I have already done videos on it.
th-cam.com/video/-AQ_lcpaRec/w-d-xo.htmlsi=o194tTADiY70ufzT
@@RezaDorraniThanks for replying ❤ I did see the video but was just curious if any more features were released 🤘. Thanks again for always sharing great content. Big fan here 🙌🙌
@@UBOTSYT most announcements are on power Apps blog
@@RezaDorrani Roger that!
how to enable anyone can respond button(when sharing outside org it asking please login )i just want without login fill the form is it possible can you share any link are steps Thanks . Reza
You cannot share form external with file upload control
without documents images can we share outside org
@@kamalakarreddyuppala3772 form is for data entry. Docs include images and files
@@RezaDorrani Thanks Reza
Hi Reza , great video, i need your help to design work flow for my team, can we connect
I do not offer 1:1 consulting support.
My email info is in About Tab of my TH-cam channel
How to attach documents in second and third approval. 13:00
Same as shown in first approval
Hi Raza
I have been using the same method but unfortunately getting the below error in start and wait for approval connector-
AttachmentContentNotValidBase64String
Video description has link to download entire solution (members only - check description for details)
I have used - base64(body('Get_file_content')) and it’s working 😊
I can’t thank you enough for quick response.