Dear @Reza. I built a similar app for a hackathon project with similar thought process last week. Went down the memory lane of what I did… Thank you for making such wonderful videos
Thank you so much I was looking for this for a long time, amazing video. I have a question what if we have multiple content type in SharePoint list, how can we handle this?
@@ibrahimabu-awad8511 it would require calling flow to get column details of content type and then showing or hiding columns. It can get complex quickly.
Reza, is fhere a way to have the required fields show in red font? A lot of end-users will zip through forms like this, and not realize that they are missing required fields, without a more refined visual indicator.
Yes, if you notice my first screen, the require fields do show up in red font. The modern controls are in preview and hence not all controls show the red font currently. But you could always check the validation state of the control and accordingly show the color.
Hi Reza, the default view of the Table control's columns are in the Compressed state. The user has to expand all the columns whenever they refresh the app. Is there any way to fix the width of the columns in the Table like we do in excel?
But for modern Table control, there is no option to set the width for columns. I tried to set the width by expanding the columns while app making, but after publishing the app the columns are compressed
Great video, one small issue - notice how when there's a validation on the first step of the form, all the fields are validated and once you go to the next step, there already are error messages displayed even though the user didn't choose anything yet. Is there a way around it?
@@Asenay999 Yeah, found like yesterday although it's not perfect, sorry for not answering - for each step I have a label which value is set to a global variable - everytime I validate the form fields using the "if" statements like that: If( (!IsBlank(DateValue1.Value) && !IsBlank(DateValue2.Value) && DateValue1.Value >= Today() && DateValue2.Value > DateValue1.Value // here add more steps if needed ), Set(varStep, varStep + 1); Set(varStepValidation1Error, ""), If( DateValue2.Value
Great job, Reza! You consistently make the difficult cases seem straightforward! I was working on this scenario (a bit different) a few days ago and ended up with a kind of 'enum' (records) for better control in 'if' cases. For example: Set( FormSteps, { Travel_Info: {Value: 1, Name: "Travel Info"}, Travel_Details: {Value: 2, Name: "Travel Details"}, Airface_Hotel: {Value: 3, Name: "Airface / Hotel"}, Attachments: {Value: 4, Name: "Attachments"} } ); Then, all you need to do is use Set(FormStep, FormSteps.Travel_Info.Value) and so on. I'm eager to vote for that at your channel! Thanks for sharing Reza!
This was awesome, I was able to follow everything and get it to work! Do you have a followup video on how to surface the multi-step form for edit? When I navigate from a gallery, my first view of the completed form is missing all elements. For the "edit" arrow Onselect, to go to form I tried this but still missing the elements of my first part of multi-step form. Appreciate any advice! Set(VarStep,1); Set(varReviewForm, ThisItem); EditForm(ReviewForm); Navigate(ScreenReviewForm);
Most welcome! I do not have a follow up video on edit however I have done many multi form based videos where in I have shown edit functionality. I would recommend checking those.
Hi Reza, I've been following you for a very long time. Your content is always helpful and easy to grasp. Could you please create some content on CoE or courses for Power Platform CoE? Thanks!
Thanks so much! I want to make videos on a lot of topics. However, my rule for making videos is set. “I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post“
I'm asking out of desperation, but has anyone run into an issue with modern text input boxes configured to Multi-Line? It seems that when you try to insert text into the box, it will jump your cursor to the end of the text immediately after pressing a single key... I can't find a fix anywhere
Hello @Reza. I have a question. I tried the multi step formand I have until varstep 6. Somehow the next button stop adding +1 to the varstep after step 3. I tried removing the submit form and it work. Anyway around this? I still want to validate the form as I move on, but I don't want the submit form function to make the +1varstep from working.
Wonderful video as usual Reza. Wondering thou how can I make this change. If I select the steps in the gallery, I want it to show the relevant fields in the form. That way the user have 2 ways to navigate.
Dear @Reza - I just discovered your channel today and the content is really great. This seems really elegant solution for multi step request forms. My question is, that with the check of the form at each step with the Next button - it automatically shows on the "next screen" all errors for mandatory fields even the user has not been on that page before. Is there a good solution to prevent that?
Someone help with this - I have a form control on a mobile view screen. Datacards are arranged in a vertical manner. Certain data fields are only visible when a button is clicked and when these fields appear, they are the bottom of the screen. I basically want to scroll down the form control automatically to those fields once they are visible.
I am facing one problem in this form when i deployed this project on SharePoint and i am coming from gallary to view the data only text field values are coming not choice
I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hey Reza! Love your videos. I want to join your channel as a premium member. But do your "gold" members really only have access to 90 days of flows and apps as mentioned in the description? I figured those you'd keep historically for that tier.
Gold members have access to all recorded videos. Access to app and flow resources is restricted to 90 days but I am always open to re-opening specific links upon request.
This is a nice solution, thanks for sharing. When I click on an item from the table, it does not take me to the specific item in the form display--it simply stays highlighted. At the end of your video, you have created a button to "View Request". Can you explain how that works?
Video description has link to download entire solution (members only - check description for details) I have not come across the mentioned issue and hence not sure what is the cause for your issue.
I do not have a video reference on this and would have to try it out to provide guidance. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@@RezaDorrani I rewatched the entire video again and I don't see the formula to view the record. You do show the button at the very end of the video being used, but I don't have the onselect formula to view the selected row from the table control ETA: I figured out the formula: EditForm(ApprovalForm2);Navigate(Screen3)
@reza great content as always!! thank you very muchi have been following your help for a while whilst continuing to improve my working platform ..... my question - is it possible to build on this experience and have the NEW initial record created by the data inputter, but then have an edit button, so that a record could be edited and step 2 and step 3 could be completed by other users??? any help would be greatly appreciated. many thanks @reza!
Thanks! I have not tried the mentioned scenario and do not have a reference video for it. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thank you @Reza - I'm currently working on similar travel authorization for our office. Would you mind adding multiple travel routes as staff can visit different locations for differnet work purposes. thank you.
The video idea is more around multi step forms than the use case. I don’t plan to expand on it further. Video description has link to download entire solution. Feel free to customize it based on your scenario.
Hi Reza! 🙂As of this month, If a user wished to create a new SharePoint data enabled Power Apps form, would you recommend a new modern responsive screen template with Gallery or a Table Control to list the data items?
Hi @Reza. I want something like I'm creating a news post in a site and same news post will be copy to my another site by a power automate flow. News post is like site page and don't saving any data in sharepoint list. Can you please help me to build a flow for this? It'll be kind enough. Thank you.
I do not have a video reference on this scenario and would have to try it out to provide guidance. I will recommend checking or posting your query on forums in case someone has experienced something similar powerusers.microsoft.com
Dear @Reza, how to make the button to edit a form and go to the form with all the data of that item? Do you have a video explaining this? Thank you for this video, it's amazing.
Use same logic as view form but use the EditForm function. I have done several videos on form control. They are all placed in a playlist on my channel.
I'm a beginner, but I often feel limited by the form control. What would be the important changes to do, if I wanted to create the same experience but using patch commands instead?
I would have to try the scenario out to know what changes would be needed. I will recommend checking or posting your query on forums in case someone has experienced something similar powerusers.microsoft.com
@@sanskritisabhayta I have no plans to revisit content shared years ago. My rule for making videos is set - “I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post. “
bro sorry but your accent and voice are unbearable, I'll watch it anyway cause I need to learn but you could really benefit by improving the delivery just soften the voice and reduce the accent
Oh!! I’m sorry that my voice isn’t up to your standards. I’ll work on that right away, only for you. In the meantime, I’m thrilled that you’ll still endure my unbearable accent for the sake of learning.
Also Reza… I had one request for future if you can do.. in our org, we build apps where we put images on home page and other relevant pages to create a UI. I have understood that there are limitations… but if you have had an opportunity to handle it better… please share or if there is any article that can help, I would appreciate it.
I have no plans for a video on this topic. My rule for making videos is set - “I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post. “
Welcome! I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
@14:25 when you hit the "View request" button how did the varStep setted to 4 and the steps list showed up all green? Did you add "set(varStep,4)" to the OnSelect property of "View request" button?
@@RezaDorrani what i didnt understand (and now i did) was the selection table column "Current: varstep=4" . At first it was weird for me cause i thought i was setting a value for varStep in "Current" column. And now i got that it works like "if varStep=4 then Current = true" so the circle turns to green. Great work, i liked your videos on youtube.
Not sure if this is new or just appeared in our tenant, wondering if you know how to hide the "info" icon in the header. We don't want to hide the whole PowerApps header just that icon since the hover over is showing description/comments from the last published version and the created by person (not the owner) which is going to confuse end users. Thanks for all the videos! Very helpful for our developer community!
In our PowerApps header we started seeing a circle with a lowercase letter i in it after updating our default tenant theme. When you hover over it the app description and created by values display which are not always relevant if this is an older app and the creator is no longer the owner.@@RezaDorrani
Wow - a whole new way of doing things for me from now on. I have add to delete and add back fields - date fields were showing "object errors" but when I removed from Form and added back they worked. I am however left with one problem - in my list I have a Person field - and for some reason I can only pick from a 5 digit number - names not showing - I know Person fields are a pain with all the different elements to them - but I really want to use it. An alternative would be to use the name of the person completing my form to be the default for this field. Any help gratefully receveid.
Hi Community and Reza!!! amazing video and I would like to know the next... is there any recommended technique to modify the table where all items are shown to add buttons which allow editing an item?
@@RezaDorrani thank you for taking the time to respond and my sincere apologies for not explaining myself properly in the first place. My question is about how can I create an experience to allow user selecting an existing item from the table to view/edit, something like adding a custom card with a view/edit button as I can see from tables there is no straightforward method for it and wanted to know if there is a recommended tutorial for it. Again, thank you for the time and amazing video :)