This connects all the dots regarding Gallery and Forms as it relates to one Screen excellently. Even for the experienced, there is something to learn. Great Stuff!! Appreciated.
The fact you answered EVERY SINGLE COMMENT is an absolute proof you deserve ALL the subscribers you have, your channel is underrated as fuck, continue the good job man.
Dear Sir , I am SharePoint Developer on office 365 portal and i have worked more on power automated MS flows ,just started learning on MS power apps and i was got luckly this video and i have made my self similar app based on your video . Thanks a lot for your effort on making nice video . I will go watch all remaining all videos .
You have the most crystal clear explanations of Power Apps out of all the content I have seen! Now, whenever I want to learn something about power apps, your videos are my topmost preference on the internet. You're truly the best Power Apps teacher and I have learned so much because of your content. Keep up the fantastic work!
Thanks! Nice explanation. I added a search bar(text input) it works but when you type something it does blank till you select something. What do I have to change to fix this and make first choice appear in display in the form?
Check my videos on gallery filtering. They have most bases covered. Examples: ruclips.net/video/5dSk5iOgT68/видео.html & ruclips.net/video/6KlI1iZ_KD0/видео.html
Is there a way you can have the data from the gallery present in the form, but instead of overwriting it, it creates a new record from the existing data? (not from a blank record) - thanks! great video!
Wow! Thank You :) The love of the audience cannot be repaid. Nothing better than hard work being appreciated. Thanks for watching and following my videos.
I was trying to create a similar app and was really struck on a few steps. Your video helped me understand what i missing thank you for taking the time and effort to create and post this video Really appreciate it
This guide is being so much useful right now, I know how to edit items in a gallery but I was in doubt about how to do it "properly" (in a way that looks good) and this is being very helpful.
Salve Reza. Ainda que eu esteja no nível iniciante, sinto-me cada vez mais "experiente" com essas magistrais aulas. Parabéns pelo trabalho. Grande abraço.
Your videos are very informative and have helped me build an app actually 3 versions with each one getting more complex. Thank you. Keep the videos coming 😊
power apps seems so easy with your explanations so thank you very much for your videos. Your explanations are very clear and the rhythm of each video, although quite fast, allows you to be concise and pass on a lot of information in the given time. Kind regards, Jean-Louis
Hi Reza, this is an absolute gem. Answers my previous question on how to add an attachment to a grid. I would suggest adding a link to this video on your editable grid tutorial. Absolute banger! One question, I have added a delete button. How do I code this that when the user selects on an item, the selected Inspection Is removed from the gallery and the data source? Thanks!
Excellent video, the other day I was trying to have my form contain the New Form, Edit Form, and Use the Galley in this exact fashion. But my efforts led to a slight disaster. I was able to get things back in order but it’s currently a Form for New Stuff and a separate screen for Edit. I had a feeling it was possible but it’a hard to figure out the unknown sometimes.
Thanks! I have not done any videos on that scenario. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Excellent Reza! I have learned a lot from you. I have something similar to this but much simpler. My form has only 1 combo box, 1 text box and 1 datepicker. User submitted the form and now user wants to see the form they submitted on the day they submitted because they might need to change some info. Or, user one to see the list of forms they submitted on that day. Should I make another screen to display the form list and a datepicker for user to select the date and see a list of the form they submitted? I'm using sharepoint for the list. Thank you!🙏🙏🙏
Your scenario is a standard gallery with user and date specific filters. I do not have an exact video on your scenario but I have done plenty of videos with gallery filters, you can check those. I would also recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani No, it's a form because user needs to input information that will store in SharePoint list. Yes, I'll post that to the community tomorrow. Thanks!🙏
Hi Reza, thank you for your video. I wonder for the "New Inspection" button, why you need to use both ResetForm and NewForm? Why can't I just use NewForm? Thanks.
Thank you Reza for the video and very useful and I learned new things. One question, after delete a record the from is showing no tiems to display. How to set variable to select first items in the display after delete? Please let me know. Thank you.
@@mmms85 The key is to keep failing. I keep trying until I get it right. Folks see the final video cut but behind it there is hours of effort. Incomplete record validation is not something I have a reference for. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi Reza, this video is really helpful, thank you for your dedication. One question: when you switch the display mode of the "Edit Form" to "View", the borders of text input controls stay the same. However, by default the borders typically disappear because the form is no longer in an editable state. How did you implement that?
@@RezaDorrani Sorry I did not mean how to hide the borders, but how to make the borders visible after switching the form to Edit mode. Because is the form is switched to "View" mode, the borders of the datacardvalue disappears by default, however in your video, the border stays, I would like to implement the same effect. Thank you.
Very informative and helpful video! However, when I tried to import the application from your Git repository, the list details seemed to be missing. Would you be able to share the structure of the "inspection" list, including the data types for each field? This information would be incredibly helpful for anyone trying to import and use your app. Additionally, if you have any recommendations for the best approach to importing the app, I'd love to hear them!
Thanks for all your video. We appreciate your support. Can I ask you if there is any possibility to connect multiple data sources to a single edit form?
Hello Reza. Great tutorial. I followed all the steps and I am failing to achieve to highlight the LastSubmit item in to the gallery. Do you have any tips for possible troubleshooting?
Not sure. I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hello Reza. First, I want to thank you for all the great videos that you have created about PowerApps and Power Automate. As a novice developer, they have been extremely helpful for me and I’ve been able to put many of your teaching lessons in practice. Second, I would like to ask you something. I have a large data source in SharePoint as XML forms library. I’d like to create an App that allows users to modify the text on 3 of the columns that basically store email addresses. I was able to create galleries and forms using that data source, however the forms are not editable. Have you encounter this? If so, do you have any suggestions in how can I make the forms editable at least in those columns? Thank you again for sharing all your knowledge.
You are most welcome! I have not done any work with XML forms library and hence not sure of the limitations if any for forms with it. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi, quick thanks for providing such great content for experienced and beginners alike! I'm working through this example of reusing form controls for both New and Edit modes. My New mode forms have two hidden fields (SubmittedBy and SubmittedDate) that use the Default properties to "pre-seed these form fields with a form in New mode. How can I continue to seed the two hidden form fields when switching from an Edit form mode as shown in this video, shown at 6:30 in the video.
Hi Reza, Thank you for the video. It is amazing how you explain all this information. I have one question: Why does the formula "Reset(FormInspection);NewForm(FormInspection)" not work, but when written differently like this "Reset(FormInspection)&NewForm(FormInspection)" it does work? Why does this happen?
Thanks for your video Reza. Can you help me please, when I change the form to view mode the borders of the rectangles text disappear. How can you make to keep the borders on the view mode?
Thanks. No borders on form view mode is default behavior. What you could do is add a rectangle shape with borders and transparent fill on top of form. And show the rectangle when form is in view mode.
Hello, first of all I would like to thank you for your valuable videos you are a professional ! now I would like to ask you if there is a way to use a text box to search for information and fill an edit form not a gallery. After that do the update of the edit form. thank you very much !!!!
Welcome back Reza. Another gem indeed, I do have a question in regards to performance. Gallery filtering a form. vs gallery filtering a gallery, each form card has 4 controls. For example, 10 fields in a form would have 40 controls. Do you think this would affect the apps performance when you are loading a huge inspection lists in consideration of the 500 controls in an app guidance on performance? Also are those Fluent UI controls in a Canvas App? 😶🌫 As always, thank you for your time.
Thank You! 500 controls is the recommendation. I have seen Apps function fine with over 1000 controls as well. There are many key aspects to performance. Check ruclips.net/video/xpHkUhGisOw/видео.html Fluent UI controls in Canvas App trick - twitter.com/rezadorrani/status/1481649406055108611?s=20
Reza, thank you so much as always your videos are more than a blessing... :) I was wondering how can I duplicate an entry, so for example if need to provide an update every week about the same item, but keeping general info.... what should I use?
Create another item (copy of existing item). Check my videos on grids in power apps. I did show copy items in one of them. Idea is to take an existing item, remove its value of primary key (like ID in SharePoint) and then patch the item.
As a newbie to Power Apps, I appreciate your videos. Question has come up on the first app I am developing. We are using a Power App to create an experience for our employees to review and edit their company profile. The data source is a List. Many of the fields have multi-select options in the list, as well as the option to add new values to the list if their choice isn't available. This functionality works great in the List, however I am unable to allow a user to add a new option that isn't already available in the list. Is this functionality covered in another video? It doesn't seem very straightforward based on my research.
Power Apps does not have the list native feature of adding options. I do not have a video reference on this scenario though. I will recommend checking on forums in case someone has done something similar powerusers.microsoft.com
Awesome as usual!!! I think I missed the part of how to show the picture at the gallery, I know it is something related with a library where all pictures are saved then sharing the link with the item's list, but still can't figure how to show it. would you like to give me a hand telling me how to do it?
Those images are stored as list item attachments. I use the First(ThisItem.Attachments) to get the first attachment for item and from there I grab the Image. However the new Image control type in lists is also supported now.
Hi Reza. Thank you very much for this video. Just a silly question? At the beginnig of the video you mentioned that is only applicable for the gallery and the form on the same screen, right?. Do you have any other video that explains doing this from different screens? I have been trying to implement your solution but my scenario is having a screen where the user can either Add a new request or navigate to View Request and in there view the request details to later edit. Thanks in advance for any response. BR
Evening sir. Commented in a previous video (pen input) and came back here to re-trace my work. Is there anything in the "EditForm, SubmitForm, LastSubmit" function family or "ViewModes" that would cause a pen input to be cleared versus being saved? The only other alternative that I have is to create a "dummy" list and app and see what happens to the pen input whether it is cleared or not. Mind you, I have page on my app with a gallery, selected record/form to be displayed from the gallery, and a "Edit" and "Submit" button since the focus of this page would be for folks to edit already inputted records.
Hi Reza.Thank you so much for this.Extremely insightful.Could you guide us on how to apply a search function for this gallery?Since the records will be many, how can you edit on a record created a while back without scrolling to look for the record?
Hi Reza, Thank you so much for your video. Question, I have an edit screen which brings data into 2 galleries part details gallery and return comments gallery from SP. I made those view only in edit screen, but Now in edit screen when user adds new information and hits plus it adds to the gallery as view only. I want only that current record to be editable until user hits submit.
Hi Reza and Happy new Year. Thank you for your video its great. I do have a question however. is it possible to link a gallery with a datasource from excel online to a form which links to a sharepoint list. So different datasources?
Probably possible but not something I have tried or have a video reference for. I will recommend checking or posting your query on forums in case someone has done something similar community.powerplatform.com/
Hi @Reza Dorrani first off your videos are a life saver I was given a project at work and I've never used power apps. But, when changing from the edit mode to the view mode after clicking an item in the gallery it seems as though my formatting gets deleted from the form. But when I go to insert a new record it comes back. Imagine floating dates and times with a white background and no text boxes, drop down, or Calendar icons are present. I even went back and replicated your video to the exact second rather than trying to implement it on my half finish project.
Thanks Jeremy! As for your issue, I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hello Reza, Thankyou for such a beautiful video. I have sharepoint list for my vendors which contains a column to store their images and a edit form to update their data in the sharepoint list. The problem here is I cannot upload the images to sharepoint via form control hence I have to go to sharepoint and upload the image. Secondly the person who use the Power app form(I will refer them as End User) should have access to sharepoint list and the power apps. so is it possible that the end user can update the sharepoint via power apps only and should have no access to sharepoint list.
Thanks Reza, truly awesome video .. Just wanted to know how can i apply security to user level , so that the edit option can be visible to those users who has their row submitted , so they cant edit the rows that they have not submitted (that is of other users)
Ideally, I would filter the gallery (grid) to only show items submitted by the user (by using Filter function) so that when they edit the grid, they can only change their own items.
Hi , thank you so much for the video, this is very helpful. I have a problem with powerapps work. I have 2 lists: A & B, List B has some fields that are the same as list A. For example, They register for a device on list A, then go to list B to add user to the device, they want 2 lists separate to manage easier. In list B, I put the list A in Gallery and populated some fields into fields in List B form. For example: - List A has field: 1 - 2 - 3 - 4 - List B has field: 1 - 2 -4 - 5 -6 When I submit it, it works fine until I double click on the item and open the form view to try to edit the item, it does not show the same records as I input, every item always shows the latest submit value Please advice Thank you
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, thanks for sharing, one question, how many columns can the sharepoint list have so that it does not send an error when editing the form in power apps?
I don't believe there is a defined limit. However, if you are creating 100s of columns then you will need to look at your information architecture. SharePoint may not be the best data source in those scenarios. SQL or Dataverse offer a lot more flexibility in terms of Tables and relationships.
Thanks. Video description has link to download sample App. You can guess the column types from the form control data cards. I reuse and update the same list multiple times for my videos. So the schema would not be the same anymore.
Hey Reza, amazing video, loved it, is there a way you can add filter in this same set up using drop-down or combo box, so users can filter list of items in gallery view
@@RezaDorranithanks Rezza. In the items property of gallery though I tried combining search function along with sort to retain the scheme of things. I know I will get delegation warning, but when I preview the app the entire gallery disappears, is there a property preventing this Sort(filter(data source,search column=search input.text), modified, descending)
@@pawan579738 Debugging here on chat is not an option + I do not have the bandwidth to debug issues. Best to post your issue with screenshots on the forums at powerusers.microsoft.com/
Hi Reza, This helps me a lot, Question how do you add search text box that will show on the gallery? let say, i wil add a search box besides gallery and search for tile or name?
Hii REZA, Thanks for this great explanation where i can find the full video or playlist of inspection app from scratch, or if its for member so can a bronze member is able to watch your vedios or playlist
The inspection app was shared with gold members only as a downloadable file during one of the training sessions. Note: it was only shared to demonstrate the concept of calling a flow from power apps.
Question. In the video at 16:04 you click “New Inspection” then you click on Title Input Text block. And they it shows “Saved Data” and you are able to select it and it pre-fills out some of your New Form. How do you set that up? Is there a video you can defer me to?
Searching will need a text input control for user to provide text for searching. I have done multiple videos on searching. Check those videos on my channel.
Hi Reza, can we still utilize this function for 2 different data sources for the gallery and the edit form through a patch function? Or does everything need to be in one data source for this to work?
@@RezaDorrani I see. I agree, did some research and it is a pain to connect multiple data sources. Will stick to using the gallery as a reference instead. Thank you for the quick revert. More power! :)
Hi Reza, really great video and very professional!. I am trying build the same App, for users to input new deals in a Sharepoint database. I want the user can insert new deals, see the complete list but he should not be able to modify the exhisting ones. Is there a way to allow the user to insert New forms (SubmitForm) without leaving him the possibility to modify the existing ones?
sorry, I have realized there is a reply to my question in your video at min. 13.50 (ViewForm)..but not sure why it does not work. I can still edit the form !!??
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
Hi Reza, is it possible to save the form updates to a different sharepoint list than the one connected to the gallery? Like load the info in the form from the gallery and save the info loaded to a different sharepoint. Thanks
Reza thank you for your kind sharing. I am working on a new app for approval flow, any way can design to submit as a new request after the previous one is changed/edited?
Most welcome! I’m not sure of the options there as I have not tried that scenario. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
hi @Reza Dorrani, since the gallery item using Sort("DataSource".modified.descending), can we also have search text and filter option inside the item as well?
This connects all the dots regarding Gallery and Forms as it relates to one Screen excellently. Even for the experienced, there is something to learn. Great Stuff!! Appreciated.
Awesome! Thank You.
@@RezaDorrani😊
The fact you answered EVERY SINGLE COMMENT is an absolute proof you deserve ALL the subscribers you have, your channel is underrated as fuck, continue the good job man.
Thank You so much for the appreciation.
My focus has been more on content and less on asking folks to subscribe :)
Dear Sir , I am SharePoint Developer on office 365 portal and i have worked more on power automated MS flows ,just started learning on MS power apps and i was got luckly this video and i have made my self similar app based on your video . Thanks a lot for your effort on making nice video . I will go watch all remaining all videos .
Thank You!
You have the most crystal clear explanations of Power Apps out of all the content I have seen!
Now, whenever I want to learn something about power apps, your videos are my topmost preference on the internet.
You're truly the best Power Apps teacher and I have learned so much because of your content.
Keep up the fantastic work!
Wow! Thank You so much.
Thanks! Nice explanation. I added a search bar(text input) it works but when you type something it does blank till you select something. What do I have to change to fix this and make first choice appear in display in the form?
Check my videos on gallery filtering. They have most bases covered.
Examples: ruclips.net/video/5dSk5iOgT68/видео.html & ruclips.net/video/6KlI1iZ_KD0/видео.html
If all only instructional videos were as clear and to the point as this. Thank you Reza
Hopefully all my videos are :)
4:30 - 5:00 was exactly the missing piece of information that was stumping me for hours. Thank you sincerely.
You are most welcome
One of the best videos clearly explaining the nits & bits of Edit Form & interaction ! Wow
Thanks a ton
Excellent tutorial Reza. I finally managed to get a Power Apps developer account working and really appreciate your kind sharing.
Awesome 👍
In just 23 mins you have answered so many of my questions, admire your efforts ♥️
Glad to hear that! Thanks for watching
It's probably the most clear and concise way I've seen and heard this explained. Kudos!
Thank You so much
Is there a way you can have the data from the gallery present in the form, but instead of overwriting it, it creates a new record from the existing data? (not from a blank record) - thanks! great video!
Possible. I think I did something like it in a grid video.
ruclips.net/video/P6yqIpjmPrs/видео.htmlsi=hnObtQGvlrEbH21I
I don't know where you work or what they pay you, but it's not enough. Thanks for the great, simple explanation!
Wow! Thank You :)
The love of the audience cannot be repaid. Nothing better than hard work being appreciated. Thanks for watching and following my videos.
Honestly, your channel is my first goto for all things Power Apps. Thank you!
Wow, thanks!
You saved my life today!! I am new to Power Apps and this was beyond helpful. Thank you so much!!
You're so welcome!
I've learned a lot from you in no time. Thanks, Reza, your instructions are very helpful in a time constraining situation. Keep it up! Cheers, mate.
Glad to hear that! Thanks Mate.
I was trying to create a similar app and was really struck on a few steps.
Your video helped me understand what i missing
thank you for taking the time and effort to create and post this video
Really appreciate it
You're welcome!
This guide is being so much useful right now, I know how to edit items in a gallery but I was in doubt about how to do it "properly" (in a way that looks good) and this is being very helpful.
Great to hear!
Thanks!
👍
This is a great post. I am a newbie and your posts make it very easy for me to address specific issues I face. Thank you for sharing your knowledge.
You are so welcome!
Salve Reza.
Ainda que eu esteja no nível iniciante, sinto-me cada vez mais "experiente" com essas magistrais aulas.
Parabéns pelo trabalho.
Grande abraço.
Muito obrigado
Your videos are very informative and have helped me build an app actually 3 versions with each one getting more complex. Thank you. Keep the videos coming 😊
Great to hear!
Thank you so much, Reza! As always, your video was really helpful. And thanks for solving the issues (e.g. no data) step by step!
Glad it helped!
If i could i wouls give 10k likes, just the best teacher for power apps... 🙏👍 Amazing how u put all info in a simple and clear way. THANKS Reza
Thank You Carlos. Much appreciated.
Reza sir i cannot express my thanks to you.i love to watch all your videos
So nice of you
Thank you Reza. I follow your video to practice the gallery and edit form control, it is very helpful.
Great!
power apps seems so easy with your explanations so thank you very much for your videos. Your explanations are very clear and the rhythm of each video, although quite fast, allows you to be concise and pass on a lot of information in the given time. Kind regards, Jean-Louis
Glad you like them! I have tried to maintain a decent pace while teaching. RUclips has the option to adjust the speed of the video.
Hi Sir, Your videos are reall best, advanced & useful... Have developed app as per your various advices ...THANKS FOR YOUR GREAT WORK ...
Thank You for watching and liking my videos.
This video was just brilliant. Great teaching skills. Thanks for uploading this video. Very useful.
You're very welcome!
Thank you! I was really trying to do this and I haven't found anywhere except your video
Glad to hear the video is useful.
Thanks for watching
Hi Reza, this is an absolute gem. Answers my previous question on how to add an attachment to a grid. I would suggest adding a link to this video on your editable grid tutorial. Absolute banger! One question, I have added a delete button. How do I code this that when the user selects on an item, the selected Inspection Is removed from the gallery and the data source? Thanks!
Delete as well I have covered in my grid videos. I have done 3-4 grid videos. Check the playlist on my channel.
Beautiful video! Literally went over so many awesome helpful steps!
Glad to hear that
Excellent video, the other day I was trying to have my form contain the New Form, Edit Form, and Use the Galley in this exact fashion. But my efforts led to a slight disaster. I was able to get things back in order but it’s currently a Form for New Stuff and a separate screen for Edit.
I had a feeling it was possible but it’a hard to figure out the unknown sometimes.
There are various ways to set these up
One of the best video on PowerApps....
Its a great inside Reza. Thank you. Did you do any video to show, when editing existing entry that is to create new line item?
Thanks!
I have not done any videos on that scenario.
I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Thanks
Thank You!
Excellent Reza! I have learned a lot from you. I have something similar to this but much simpler. My form has only 1 combo box, 1 text box and 1 datepicker. User submitted the form and now user wants to see the form they submitted on the day they submitted because they might need to change some info. Or, user one to see the list of forms they submitted on that day. Should I make another screen to display the form list and a datepicker for user to select the date and see a list of the form they submitted? I'm using sharepoint for the list. Thank you!🙏🙏🙏
Your scenario is a standard gallery with user and date specific filters.
I do not have an exact video on your scenario but I have done plenty of videos with gallery filters, you can check those.
I would also recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani No, it's a form because user needs to input information that will store in SharePoint list. Yes, I'll post that to the community tomorrow. Thanks!🙏
Hi Reza, thank you for your video. I wonder for the "New Inspection" button, why you need to use both ResetForm and NewForm? Why can't I just use NewForm? Thanks.
You could use newform as well. I simply wanted to follow the pattern of reset and then form mode.
Thank you Reza for your prompt reply. I appreciate it.@@RezaDorrani
Another excellent video, many thanks Reza.
Glad you enjoyed it
Thank you Reza for the video and very useful and I learned new things. One question, after delete a record the from is showing no tiems to display. How to set variable to select first items in the display after delete? Please let me know. Thank you.
Im not sure about that
gallery and form as in one screen was excellent. Thank you.
Most welcome
Would it be possible if you can demonstrate to validate if the user attempts to submit incomplete data record? Wish i can have your brain - genius
@@mmms85 The key is to keep failing. I keep trying until I get it right. Folks see the final video cut but behind it there is hours of effort.
Incomplete record validation is not something I have a reference for. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Great video Reze,
Although title say for Beginners, but there are a lot of hidden gems that I found :). Thanks.
Glad you enjoyed it!
Yes, the video begins with beginner level content but then has some nice techniques for creating grids with attachments.
Hi Reza, this video is really helpful, thank you for your dedication.
One question: when you switch the display mode of the "Edit Form" to "View", the borders of text input controls stay the same. However, by default the borders typically disappear because the form is no longer in an editable state. How did you implement that?
Most welcome!
From what I recollect, I did not do anything specific in this video to hide borders.
@@RezaDorrani Sorry I did not mean how to hide the borders, but how to make the borders visible after switching the form to Edit mode. Because is the form is switched to "View" mode, the borders of the datacardvalue disappears by default, however in your video, the border stays, I would like to implement the same effect. Thank you.
@@yuxrone I simply added a fake border by using shapes and show it when form mode is view.
@@RezaDorrani Thank you for the clarification!
Reza, another great video. Won my like. Thank you for sharing !!!
Awesome! Thank You!
Very informative and helpful video! However, when I tried to import the application from your Git repository, the list details seemed to be missing.
Would you be able to share the structure of the "inspection" list, including the data types for each field? This information would be incredibly helpful for anyone trying to import and use your app.
Additionally, if you have any recommendations for the best approach to importing the app, I'd love to hear them!
I no longer have access to that list. The idea of sharing the app is to share the source code.
@@RezaDorrani No worries, much appreicated for your response.
Thanks for all your video. We appreciate your support. Can I ask you if there is any possibility to connect multiple data sources to a single edit form?
Thank You!
A form control only works with single data source.
Is there any way I can contact you for help that has been blockingme for days?
@@roby9390 Best place to get help is the forums at powerusers.microsoft.com
Hello Reza. Great tutorial. I followed all the steps and I am failing to achieve to highlight the LastSubmit item in to the gallery. Do you have any tips for possible troubleshooting?
Not sure. I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hello Reza. First, I want to thank you for all the great videos that you have created about PowerApps and Power Automate. As a novice developer, they have been extremely helpful for me and I’ve been able to put many of your teaching lessons in practice. Second, I would like to ask you something. I have a large data source in SharePoint as XML forms library. I’d like to create an App that allows users to modify the text on 3 of the columns that basically store email addresses. I was able to create galleries and forms using that data source, however the forms are not editable. Have you encounter this? If so, do you have any suggestions in how can I make the forms editable at least in those columns?
Thank you again for sharing all your knowledge.
You are most welcome!
I have not done any work with XML forms library and hence not sure of the limitations if any for forms with it.
I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Great video Reza. I noticed your controls have different styles, specially buttons , dropdown and calendar… how are you getting that?
Thank You.
Got the styles from Dataverse for Teams. Check twitter.com/rezadorrani/status/1481649406055108611?s=20
You made easy so many things. Very useful video.
Most welcome
Hi, quick thanks for providing such great content for experienced and beginners alike! I'm working through this example of reusing form controls for both New and Edit modes. My New mode forms have two hidden fields (SubmittedBy and SubmittedDate) that use the Default properties to "pre-seed these form fields with a form in New mode. How can I continue to seed the two hidden form fields when switching from an Edit form mode as shown in this video, shown at 6:30 in the video.
I’ve done many form-based videos. They are all placed in a playlist on my channel. I will recommend checking them.
@@RezaDorrani thanks.. Found answer... If(myForm.Mode = FormMode.Edit, Parent.Default, Office365Users.MyProfileV2().mail)
Hi Reza,
Thank you for the video. It is amazing how you explain all this information. I have one question: Why does the formula "Reset(FormInspection);NewForm(FormInspection)" not work, but when written differently like this "Reset(FormInspection)&NewForm(FormInspection)" it does work? Why does this happen?
Most welcome!
I have no clue how the second formula is even working.
Thanks for all your videos. In this case this app will not be responsive right? How we can do it responsive?
Responsive Design Videos - ruclips.net/p/PLTyFh-qDKAiHe6pHdlyBbRK1b44bNAAN_
Thanks for your video Reza.
Can you help me please, when I change the form to view mode the borders of the rectangles text disappear.
How can you make to keep the borders on the view mode?
Thanks.
No borders on form view mode is default behavior.
What you could do is add a rectangle shape with borders and transparent fill on top of form.
And show the rectangle when form is in view mode.
@@RezaDorrani Many Thanks Reza for your comment on this. It confirmed my guess (unfortunately).
Hello, first of all I would like to thank you for your valuable videos you are a professional ! now I would like to ask you if there is a way to use a text box to search for information and fill an edit form not a gallery. After that do the update of the edit form. thank you very much !!!!
Most welcome!
Video shows searching in gallery and updating data in form.
Welcome back Reza. Another gem indeed, I do have a question in regards to performance. Gallery filtering a form. vs gallery filtering a gallery, each form card has 4 controls. For example, 10 fields in a form would have 40 controls. Do you think this would affect the apps performance when you are loading a huge inspection lists in consideration of the 500 controls in an app guidance on performance?
Also are those Fluent UI controls in a Canvas App? 😶🌫 As always, thank you for your time.
Thank You!
500 controls is the recommendation. I have seen Apps function fine with over 1000 controls as well.
There are many key aspects to performance. Check ruclips.net/video/xpHkUhGisOw/видео.html
Fluent UI controls in Canvas App trick - twitter.com/rezadorrani/status/1481649406055108611?s=20
Such a great video, thank you very much for sharing! I built our form straight from this.
Awesome!
Reza, thank you so much as always your videos are more than a blessing... :) I was wondering how can I duplicate an entry, so for example if need to provide an update every week about the same item, but keeping general info.... what should I use?
Create another item (copy of existing item).
Check my videos on grids in power apps. I did show copy items in one of them. Idea is to take an existing item, remove its value of primary key (like ID in SharePoint) and then patch the item.
As a newbie to Power Apps, I appreciate your videos. Question has come up on the first app I am developing. We are using a Power App to create an experience for our employees to review and edit their company profile. The data source is a List. Many of the fields have multi-select options in the list, as well as the option to add new values to the list if their choice isn't available. This functionality works great in the List, however I am unable to allow a user to add a new option that isn't already available in the list. Is this functionality covered in another video? It doesn't seem very straightforward based on my research.
Power Apps does not have the list native feature of adding options. I do not have a video reference on this scenario though. I will recommend checking on forums in case someone has done something similar
powerusers.microsoft.com
Your videos are SO helpful. Thank you!
You are so welcome!
Awesome Reza, please if one needs to print just the view form on the right without printing the gallery....any ideas
Check ruclips.net/video/95BS378sJ1k/видео.html
Awesome as usual!!! I think I missed the part of how to show the picture at the gallery, I know it is something related with a library where all pictures are saved then sharing the link with the item's list, but still can't figure how to show it. would you like to give me a hand telling me how to do it?
Those images are stored as list item attachments.
I use the First(ThisItem.Attachments) to get the first attachment for item and from there I grab the Image.
However the new Image control type in lists is also supported now.
@@RezaDorrani much appreciated it!!!! going to check also with Image control type
Hi Reza. Thank you very much for this video. Just a silly question? At the beginnig of the video you mentioned that is only applicable for the gallery and the form on the same screen, right?. Do you have any other video that explains doing this from different screens? I have been trying to implement your solution but my scenario is having a screen where the user can either Add a new request or navigate to View Request and in there view the request details to later edit. Thanks in advance for any response. BR
I have done many videos of gallery connected forms. Same screen and different screen. Il recommend checking my playlist on form control.
Evening sir. Commented in a previous video (pen input) and came back here to re-trace my work. Is there anything in the "EditForm, SubmitForm, LastSubmit" function family or "ViewModes" that would cause a pen input to be cleared versus being saved? The only other alternative that I have is to create a "dummy" list and app and see what happens to the pen input whether it is cleared or not. Mind you, I have page on my app with a gallery, selected record/form to be displayed from the gallery, and a "Edit" and "Submit" button since the focus of this page would be for folks to edit already inputted records.
I am not aware of anything that can cause that. I would recommend posting your issue on the community forums.
Hi Reza.Thank you so much for this.Extremely insightful.Could you guide us on how to apply a search function for this gallery?Since the records will be many, how can you edit on a record created a while back without scrolling to look for the record?
Most welcome.
I have done many videos on searching and filtering on galleries. I would recommend checking those.
Hi Reza, Thank you so much for your video. Question, I have an edit screen which brings data into 2 galleries part details gallery and return comments gallery from SP. I made those view only in edit screen, but Now in edit screen when user adds new information and hits plus it adds to the gallery as view only. I want only that current record to be editable until user hits submit.
I have not tried this scenario so not sure.
Hi Reza and Happy new Year. Thank you for your video its great. I do have a question however. is it possible to link a gallery with a datasource from excel online to a form which links to a sharepoint list. So different datasources?
Probably possible but not something I have tried or have a video reference for.
I will recommend checking or posting your query on forums in case someone has done something similar
community.powerplatform.com/
Hi @Reza Dorrani first off your videos are a life saver I was given a project at work and I've never used power apps.
But, when changing from the edit mode to the view mode after clicking an item in the gallery it seems as though my formatting gets deleted from the form. But when I go to insert a new record it comes back. Imagine floating dates and times with a white background and no text boxes, drop down, or Calendar icons are present. I even went back and replicated your video to the exact second rather than trying to implement it on my half finish project.
Thanks Jeremy!
As for your issue, I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Wow! Wish I found this channel sooner.
Better late than never
Your content is so very helpful. Thank you!
Thanks for watching
So appreciate your videos Sir!
Thanks so much
Reza you are a lifesaver
Glad I could help
Great video reza!! I have a question. Is it possible to have a button to add row/column inside the form control? I've seen others done in gallery only
The Form control works with a single record only whereas a gallery works with multiple records.
Adding a row inside a form control is not possible.
@@RezaDorranii see ,thank you reza for your response!
Hello Reza, Thankyou for such a beautiful video. I have sharepoint list for my vendors which contains a column to store their images and a edit form to update their data in the sharepoint list. The problem here is I cannot upload the images to sharepoint via form control hence I have to go to sharepoint and upload the image. Secondly the person who use the Power app form(I will refer them as End User) should have access to sharepoint list and the power apps. so is it possible that the end user can update the sharepoint via power apps only and should have no access to sharepoint list.
Power Apps respects SharePoint security. There is no way around this.
Image column is read only for Power Apps at the moment.
Thanks Reza, truly awesome video ..
Just wanted to know how can i apply security to user level , so that the edit option can be visible to those users who has their row submitted , so they cant edit the rows that they have not submitted (that is of other users)
Ideally, I would filter the gallery (grid) to only show items submitted by the user (by using Filter function) so that when they edit the grid, they can only change their own items.
Hi , thank you so much for the video, this is very helpful. I have a problem with powerapps work. I have 2 lists: A & B, List B has some fields that are the same as list A. For example, They register for a device on list A, then go to list B to add user to the device, they want 2 lists separate to manage easier.
In list B, I put the list A in Gallery and populated some fields into fields in List B form.
For example:
- List A has field: 1 - 2 - 3 - 4
- List B has field: 1 - 2 -4 - 5 -6
When I submit it, it works fine until I double click on the item and open the form view to try to edit the item, it does not show the same records as I input, every item always shows the latest submit value
Please advice
Thank you
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, thanks for sharing, one question, how many columns can the sharepoint list have so that it does not send an error when editing the form in power apps?
I don't believe there is a defined limit.
However, if you are creating 100s of columns then you will need to look at your information architecture.
SharePoint may not be the best data source in those scenarios. SQL or Dataverse offer a lot more flexibility in terms of Tables and relationships.
Hey Reza, I can see you had the delete Icon at the end .. do you have a video that includes how to build that formula?
delete is the simplest formula. Remove(datasource, ThisItem)
This one is a must in a basics powerapps toolkit, thks Reza!
I agree :)
Thanks for watching
Great video! Thanks for sharing - really appreciated!
My pleasure!
Reza - great video - great content.
Thank You
Thank you! This was a great tutorial!
You're most welcome!
another excellent video Reza, thanks so much - if u don't mind, would love to know the source data SP col setup so i can reconstruct
Thanks.
Video description has link to download sample App.
You can guess the column types from the form control data cards.
I reuse and update the same list multiple times for my videos. So the schema would not be the same anymore.
Hey Reza, amazing video, loved it, is there a way you can add filter in this same set up using drop-down or combo box, so users can filter list of items in gallery view
I have done multiple videos on filtering galleries. Those concepts would work in this scenario.
@@RezaDorranithanks Rezza. In the items property of gallery though I tried combining search function along with sort to retain the scheme of things. I know I will get delegation warning, but when I preview the app the entire gallery disappears, is there a property preventing this
Sort(filter(data source,search column=search input.text), modified, descending)
@@pawan579738 Debugging here on chat is not an option + I do not have the bandwidth to debug issues. Best to post your issue with screenshots on the forums at powerusers.microsoft.com/
Hi Reza, This helps me a lot, Question how do you add search text box that will show on the gallery? let say, i wil add a search box besides gallery and search for tile or name?
I have done many videos on filtering and searching galleries. Check those ones.
Your videos are incredible
Thank u Sir, im learning from your videos
Most welcome and thanks for learning from my videos
Hii REZA, Thanks for this great explanation where i can find the full video or playlist of inspection app from scratch, or if its for member so can a bronze member is able to watch your vedios or playlist
The inspection app was shared with gold members only as a downloadable file during one of the training sessions.
Note: it was only shared to demonstrate the concept of calling a flow from power apps.
Question.
In the video at 16:04 you click “New Inspection” then you click on Title Input Text block. And they it shows “Saved Data” and you are able to select it and it pre-fills out some of your New Form.
How do you set that up? Is there a video you can defer me to?
It's been a while since I did this video, hence I do not remember the specifics. The video itself is the best reference I have.
Thanks for the quick reply! No worries I’ll keep searching.
Thank you, Reza, how would I add a button to search and display only columns with a certain value?
Searching will need a text input control for user to provide text for searching. I have done multiple videos on searching. Check those videos on my channel.
Hi Reza, can we still utilize this function for 2 different data sources for the gallery and the edit form through a patch function?
Or does everything need to be in one data source for this to work?
One data source ideally. I have tried with combining multiple data sources.
@@RezaDorrani I see. I agree, did some research and it is a pain to connect multiple data sources. Will stick to using the gallery as a reference instead. Thank you for the quick revert. More power! :)
Hi Reza, really great video and very professional!. I am trying build the same App, for users to input new deals in a Sharepoint database. I want the user can insert new deals, see the complete list but he should not be able to modify the exhisting ones.
Is there a way to allow the user to insert New forms (SubmitForm) without leaving him the possibility to modify the existing ones?
sorry, I have realized there is a reply to my question in your video at min. 13.50 (ViewForm)..but not sure why it does not work. I can still edit the form !!??
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
@@RezaDorrani thanks. is there any forum you could suggest ?
@@marco-ys1oi powerusers.microsoft.com
Thank you for another awesome video. New knowledge learnt
Great! Thanks.
Excellent! Superb! Thank you.
Most welcome
Greatest of all time
🐐
Hi Reza, is it possible to save the form updates to a different sharepoint list than the one connected to the gallery? Like load the info in the form from the gallery and save the info loaded to a different sharepoint. Thanks
May be possible if the schemas of lists are the same. Not something I have done.
Reza thank you for your kind sharing. I am working on a new app for approval flow, any way can design to submit as a new request after the previous one is changed/edited?
Most welcome!
I’m not sure of the options there as I have not tried that scenario.
I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Great video!!!! Thanks!
You're welcome!
hi @Reza Dorrani, since the gallery item using Sort("DataSource".modified.descending), can we also have search text and filter option inside the item as well?
You can sort and filter gallery. I have done a video on it.
Excellent tutorial, thank you
Most welcome