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!
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.
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: th-cam.com/video/5dSk5iOgT68/w-d-xo.html & th-cam.com/video/6KlI1iZ_KD0/w-d-xo.html
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.
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
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
@@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
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!
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!
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
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.
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.
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
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.
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!
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, 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.
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
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 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.
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 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.
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
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.
Sorry but I did not understand the question. If question is related to checking for duplicate data, it is possible by querying data source however I do not have any video references on it@@leonardobarrosdemourabened6396
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.
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
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 !!!!
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.
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?
Hi Reza, me and a collegue are following your guide. We are at 4:12 and are stuck. We do exactly as you do. We make a vertical gallery and a form. Gallery has as items "I do something about it" and is called GalIDSAI Form has as datasource the list from Sharepoint. As item 'GalIDSAI.Selected' Yet the 'selected' is red underlined. It doesn't connect. Did i miss something or has something changed in powerapps since 1 year ago from this guide?
There have been no breaking changes. I have not come across the mentioned issue and hence not sure what the fix for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
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.
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.
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!🙏
@@RezaDorrani I am trying to develop a team work tracker / time logger app. Who spend time on what and which work took how long. Any similar reference example to follow? Should be a common application I think.
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.
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?
Greetings Reza! Hope you are well. Is there a way to create a form where the user can add multiple lines within the form and submit all the data back to a SharePoint list as unique rows associated to the single user/same item id. I hope that makes sense.
On 4:40 when I trie to write the formula form.Item = galley.Selected I get the error "Invalid Formula. Expected a value compatible with 'DataSource'". Both controls have the same list as source.
Hi Reza. Great video, very well explained. I am building my first app and am having a problem with implementing the Template Fill property. When I enter the syntax exactly as you suggest, I get a warning "This formula uses scope, which is not currently supported for evaluation". As a result when I click the item in the gallery, its background colour does not change. Any ideas how to fix this problem?
I will have to look at your App in action or to see your formula to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, 9:25 My SharePoint list has four columns. I want to sort my gallery in first screen showing distinct vehicle types(cars, lories, vans). I want to navigate to second screen when I click on vehicle type on gallery. The second screen has these details. lets say I click on car in first screen gallery, second screen should show following details as on SharePoint list. Vehicle number: engine capacity: vehicle location: vehicle price: Here's my problem. How do I sort my first screen gallery with the distinct items?.😕
This seems to be a specific scenario for which I probably do not have a video reference. I have done independent videos on group by and sorting. You may want to check those. Alternatively, you can check on forums in case someone has done something similar powerusers.microsoft.com
@@RezaDorrani Hi reza, I used distinct function to get the distinct items for the first screen gallery. now its showing the vehicle types🙂. second screen gallery should display vehicles related to selected vehicle type in first screen gallery. how should I set the item property for second screen gallery to display vehicles based on selected vehicle type from first gallery.😟
@@tharindaabeysinghe Group By in Power Apps Gallery th-cam.com/video/57ADxeo_13k/w-d-xo.html This video has something similar Apart from this, I will recommend posting your query on forums at powerusers.microsoft.com
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.
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
In just 23 mins you have answered so many of my questions, admire your efforts ♥️
Glad to hear that! Thanks for watching
One of the best videos clearly explaining the nits & bits of Edit Form & interaction ! Wow
Thanks a ton
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.
Excellent tutorial Reza. I finally managed to get a Power Apps developer account working and really appreciate your kind sharing.
Awesome 👍
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: th-cam.com/video/5dSk5iOgT68/w-d-xo.html & th-cam.com/video/6KlI1iZ_KD0/w-d-xo.html
You saved my life today!! I am new to Power Apps and this was beyond helpful. Thank you so much!!
You're so welcome!
Honestly, your channel is my first goto for all things Power Apps. Thank you!
Wow, thanks!
It's probably the most clear and concise way I've seen and heard this explained. Kudos!
Thank You so much
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!
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!
Reza sir i cannot express my thanks to you.i love to watch all your videos
So nice of you
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
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.
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
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.
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!
Thank you Reza. I follow your video to practice the gallery and edit form control, it is very helpful.
Great!
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!
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!
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. TH-cam has the option to adjust the speed of the video.
Beautiful video! Literally went over so many awesome helpful steps!
Glad to hear that
This video was just brilliant. Great teaching skills. Thanks for uploading this video. Very useful.
You're very welcome!
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.
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.
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.
th-cam.com/video/P6yqIpjmPrs/w-d-xo.htmlsi=hnObtQGvlrEbH21I
Wow! Wish I found this channel sooner.
Better late than never
Another excellent video, many thanks Reza.
Glad you enjoyed it
You made easy so many things. Very useful video.
Most welcome
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.
Your videos are SO helpful. Thank you!
You are so welcome!
Reza, another great video. Won my like. Thank you for sharing !!!
Awesome! Thank You!
Such a great video, thank you very much for sharing! I built our form straight from this.
Awesome!
Your content is so very helpful. Thank you!
Thanks for watching
Thanks!
👍
Reza you are a lifesaver
Glad I could help
So appreciate your videos Sir!
Thanks so much
Thank u Sir, im learning from your videos
Most welcome and thanks for learning from my videos
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
Greatest of all time
🐐
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)
Thank you! This was a great tutorial!
You're most welcome!
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!
Excellent! Superb! Thank you.
Most welcome
Thank you for another awesome video. New knowledge learnt
Great! Thanks.
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.
Reza - great video - great content.
Thank You
I want more of your videos. Thankyou.
Thanks! I will keep trying my best to provide weekly content.
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
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
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.
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, 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!
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
Awesome Reza, please if one needs to print just the view form on the right without printing the gallery....any ideas
Check th-cam.com/video/95BS378sJ1k/w-d-xo.html
Brilliant stuff! Appreciated
Thank You George
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 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.
Excellent tutorial, thank you
Most welcome
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 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.
Great video!!!! Thanks!
You're welcome!
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
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.
Vídeos excelentes! Parabéns pelo trabalho e dedicação!
É possível criar um botão de duplicação de dados para inspeções que mudam poucos dados?
Thank You!
Sorry but I did not understand the question. If question is related to checking for duplicate data, it is possible by querying data source however I do not have any video references on it@@leonardobarrosdemourabened6396
Love your lesson ❤
Thanks Nicky
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
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
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.
very helpful ...
Thank You !
You're welcome!
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).
Amazing video. Thank you Reza
Glad you enjoyed it. Thanks for watching.
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
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
thank you so much for these videos bud.
My pleasure!
Very good videos, merci beaucoup
Thank You
Thanks for all your videos. In this case this app will not be responsive right? How we can do it responsive?
Responsive Design Videos - th-cam.com/play/PLTyFh-qDKAiHe6pHdlyBbRK1b44bNAAN_.html
Hi Reza, me and a collegue are following your guide.
We are at 4:12 and are stuck.
We do exactly as you do. We make a vertical gallery and a form.
Gallery has as items "I do something about it" and is called GalIDSAI
Form has as datasource the list from Sharepoint. As item 'GalIDSAI.Selected'
Yet the 'selected' is red underlined. It doesn't connect.
Did i miss something or has something changed in powerapps since 1 year ago from this guide?
There have been no breaking changes.
I have not come across the mentioned issue and hence not sure what the fix for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Great Learning ! helps a lot
Glad to hear that!
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.
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.
You are the best!
Thank you
Thank You for your kind words.
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!🙏
Very good tutorial
Happy to hear that
@@RezaDorrani I am trying to develop a team work tracker / time logger app. Who spend time on what and which work took how long. Any similar reference example to follow? Should be a common application I think.
@@UncleF115 I have not done a video on timesheet App. I will recommend checking on 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.
Power Apps respects SharePoint security. There is no way around this.
Image column is read only for Power Apps at the moment.
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.
Greetings Reza! Hope you are well. Is there a way to create a form where the user can add multiple lines within the form and submit all the data back to a SharePoint list as unique rows associated to the single user/same item id. I hope that makes sense.
Something like a grid experience. I have done videos related to grid views. Check those. It may give some ideas.
Thanks so much for sharing!
Thanks for watching!
On 4:40 when I trie to write the formula form.Item = galley.Selected I get the error "Invalid Formula. Expected a value compatible with 'DataSource'". Both controls have the same list as source.
I have not experienced the mentioned issue hence not sure. Video description has link to download the sample app. I would suggest giving that a try.
Hi Reza. Great video, very well explained. I am building my first app and am having a problem with implementing the Template Fill property. When I enter the syntax exactly as you suggest, I get a warning "This formula uses scope, which is not currently supported for evaluation". As a result when I click the item in the gallery, its background colour does not change. Any ideas how to fix this problem?
I will have to look at your App in action or to see your formula to provide guidance.
I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
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)
Hi Reza,
9:25 My SharePoint list has four columns. I want to sort my gallery in first screen showing distinct vehicle types(cars, lories, vans).
I want to navigate to second screen when I click on vehicle type on gallery. The second screen has these details.
lets say I click on car in first screen gallery, second screen should show following details as on SharePoint list.
Vehicle number:
engine capacity:
vehicle location:
vehicle price:
Here's my problem. How do I sort my first screen gallery with the distinct items?.😕
This seems to be a specific scenario for which I probably do not have a video reference. I have done independent videos on group by and sorting. You may want to check those. Alternatively, you can check on forums in case someone has done something similar
powerusers.microsoft.com
@@RezaDorrani Hi reza,
I used distinct function to get the distinct items for the first screen gallery. now its showing the vehicle types🙂.
second screen gallery should display vehicles related to selected vehicle type in first screen gallery.
how should I set the item property for second screen gallery to display vehicles based on selected vehicle type from first gallery.😟
@@tharindaabeysinghe Group By in Power Apps Gallery
th-cam.com/video/57ADxeo_13k/w-d-xo.html
This video has something similar
Apart from this, I will recommend posting your query on forums at powerusers.microsoft.com
@@RezaDorrani thanx Reza I'll try.