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
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!
Thank you so much for this video. Using this video, and other videos on your channel, I have been able to build a request form for our business, which in turn has made so many people's lives a lot easier in my workplace. I really appreciate your channel and your excellent way of explaining how to do things.
Hi Reza! Thank you for all your hard work. How would you approach collecting multiple “records” for one request? In this example you have travel details, what if you have to request 2 distinct flights on the same request?
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“
Reza, so grateful for your videos. I’m excited to be a channel member. I understand the download parameters, but would you consider re-opening this so I may download? Thanks. Reza!
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.
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
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.
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?
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.
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?
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.
Thank you so much for amazing video @Reza. You are my GOD. I try to implement the same setup in one of the application. But, I noticed that the font of the Approval form text fields (label's) appear blur for first screen. How we overcome this? Any idea Sir?
Hello Reza, thank you for this video ! can you tell me how to resize the part with the steps, in fact in my form I have 6 steps and I would like it to be displayed entirely
The video is the best reference I have. You can try downloading the sample code shared with members (check description of video for details) and learn more about the code.
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.
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 :)
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.
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
Thanks for the reply! I want to be able to click on the stage of the form on the left to jump to that step. My form has 14 steps and users might not complete all in one sitting. Trying to make it easy for them to pick up where they left off
@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.
Hello reza. Thanks for this wonderful video. Question, is there a way to submit/patch these multi screens/forms to another SP list as new or update (not considering ID as primary key)? When i tried to use patch function, im getting error that record doesnt exist on another SP list. Thank you
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.
@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.
For that you would need to lock down the steps based on user role. I do not have a specific video reference on this scenario. I will recommend checking or posting your query on forums in case someone has done something similar community.powerplatform.com/
Thanks, Reza, for sharing, I am trying to add Hyperlink filed with two fields the URL link and the name of the link, but in customize form it gives me only the URL field any suggestion
Hi Reza, Had a question in SharePoint list calculated columns, It does not get auto update so i have made a cloud flow to auto update it it updates a temp column with random value so that the calculated columns get refreshed for that row, but sometimes it is working sometimes it is not, is there any solution for this? any workaround for it to update calculated columns on it's own, tried the json method but got no success
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
@@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)
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. “
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.
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.
I have not experienced the mentioned issue, hence not sure. I will recommend checking or posting your issue on forums in case someone has experienced something similar community.powerplatform.com/
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
Hi I have 4 different forms, but when submitting data it produces different excel rows, how can I make it so that when submitting data without having to add additional rows and data from all four forms can be saved in one row? Please help.. im newbie sir
I have no clue about this as I would have to reproduce your scenario to know what's going on. I will recommend posting your issue/query on forums in case someone has done something similar community.powerplatform.com/
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.
I have a really weird issue. Two Forms, one where it shows my OnVisible (identical) variable varStep as 1 when hovering over the formule, and one (identical!) where is says varStep = Leeg (empty/null, in Dutch), despite the formula just being Set(varStep;1) (Dutch settings require ';' instead of ','). Any idea what might cause this?
I'm not sure about this issue. I will recommend checking or posting your query on forums in case someone has experienced something similar community.powerplatform.com/
Hi there. Thanks for the video it is wonderfull. I want to add the varSTEP to this If( OTAssetInventoryDataCardValue.Selected.Value = "Disagree", true, false ) How will I do that.
@@RezaDorrani It is ok I got it to work. I had a question with options. If they choose Yes, it will go to next question. BUT if No was selected, I wanted a new question to open to explain the "No". But this is also link to the fact that I'm using your varSTEP option. So, what I did was ...If(varSTEP=2 && OTAssetInventoryDataCardValue.Selected.Value = "Disagree", true, false)
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.
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.
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
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
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
@@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. “
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
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.
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
Most welcome and glad to know you built something similar
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!
Thanks for sharing!
Various ways to do this. Goal was to keep it simple for the video.
Thank you so much for this video. Using this video, and other videos on your channel, I have been able to build a request form for our business, which in turn has made so many people's lives a lot easier in my workplace. I really appreciate your channel and your excellent way of explaining how to do things.
So happy to hear the videos are helpful and being actively used to build apps.
Hi Reza! Thank you for all your hard work. How would you approach collecting multiple “records” for one request? In this example you have travel details, what if you have to request 2 distinct flights on the same request?
I will recommend checking my videos on list relationships and grid experiences.
This is amazing! Thank you for making such great videos Reza, I am very grateful! :)
Glad you like them!
Well done, sir! Such an elegant solution to a problem I've been wrestling with for some time now. Thank you!
Renza you are a Amazing teacher thanks 😊
Thank you!
Wonderful technique for multi steps form Reza!. Thank you for your valuable time to educate & make it easy.
Most welcome
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“
Always up to date content! Thank you Reza!
Thank you Reza for this timely video.
My pleasure!
Very elegant process, and code minimized ! thanks Reza!
Great to hear
Reza the king strikes again!!! wonderful video
Thanks so much!
Content is King
Hi @Reza, very nice this demonstration. this will be very helpful content. Keep posting 🙂
Thank you, I hope to keep going as long as possible
Thank you very much for this awsome video.
Glad you liked it!
Reza, so grateful for your videos. I’m excited to be a channel member. I understand the download parameters, but would you consider re-opening this so I may download? Thanks. Reza!
The link will be in membership tab of my channel. If link is expired, please post a comment on the secured membership post and I will enable it.
thx for sharing , nice tips with the submit form for non validate field
Glad it was helpful!
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?
Welcome!
Power Apps does not understand SharePoint content types.
@@RezaDorrani Is there a workaround then?
@@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.
Wonderful content. Thanks for these amazing content 🎉
Thanks for watching!
Another great video Reza!!!
Thank You
Nice video Reza! Is there a way to review the request before submitting it?
May be this can help
ua-cam.com/video/S0Zs66RVka4/v-deo.htmlsi=UY2ScFUKMku0WwCR
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?
I have not found a way around that. Little bit of give and take.
@exe5933 Did you find any solution for that? Im on the same boat buddy!
@@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
Really good video. Thanks for sharing.
Thanks for watching
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.
Thanks!
The video shows a gallery connected to a form.
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?
Gallery for now as Table control is not GA yet
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.
It was superb , small tricks but very useful as always
Thanks
Neatly done... impressive👏👏
Thank you! Cheers!
This is amazing! :) You think I can add an Email body in the form so that the form will send an email based on the chosen things on the form?
I have not tried that scenario, but should be possible
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?
Thanks so much!
With the current pattern shown in video, there is a single form only. So it would show the mandatory validation across.
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.
Thank you so much for amazing video @Reza. You are my GOD. I try to implement the same setup in one of the application. But, I noticed that the font of the Approval form text fields (label's) appear blur for first screen. How we overcome this? Any idea Sir?
Thanks so much!
I have not come across any issues with label's blurring. Try publish the app and test it when running the App.
Hello Reza, thank you for this video !
can you tell me how to resize the part with the steps, in fact in my form I have 6 steps and I would like it to be displayed entirely
The video is the best reference I have. You can try downloading the sample code shared with members (check description of video for details) and learn more about the code.
Once again there is a great lecture. will you please make a video on userphotometadata blank value on userid
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.
Cool Video, I tried the same and its working Very well. Is there a way I can select a record in table and then edit the same.
You can use the editform function
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?
Your question is not clear
@@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 :)
@@facun_OK I did a tutorial video on table control. Try checking that.
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.
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!
Not sure what icon are you referring to.
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
Is there a way to add navigation in the reviewers gallery to each step of the form?
I did not understand the ask.
Thanks for the reply! I want to be able to click on the stage of the form on the left to jump to that step. My form has 14 steps and users might not complete all in one sitting. Trying to make it easy for them to pick up where they left off
@@kimberlyshaddrick-kz2xl You can always make the step gallery clickable. As user clicks on an item, simply update the variable for step number.
@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?
I check formmode and accordingly change color. I show that formula in video.
@@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.
Hello reza. Thanks for this wonderful video. Question, is there a way to submit/patch these multi screens/forms to another SP list as new or update (not considering ID as primary key)? When i tried to use patch function, im getting error that record doesnt exist on another SP list. Thank you
Not something I have tried or have a video reference for.
Quick question, in this multi step form design can you edit existing record?
Yes, possible
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.
@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.
Great stuff!!!
Thanks!
how about for each step, different person/department that need to fill it up?
For that you would need to lock down the steps based on user role. I do not have a specific video reference on this scenario. I will recommend checking or posting your query on forums in case someone has done something similar
community.powerplatform.com/
Thanks, Reza, for sharing, I am trying to add Hyperlink filed with two fields the URL link and the name of the link, but in customize form it gives me only the URL field any suggestion
I have not done any work the hyperlink column, hence not sure
Great technique for creating Multi-Step Form. Certainly another tip to add to my armoury for subsequent projects. Thanks for sharing.
Very welcome!
Hi Reza, Had a question in SharePoint list calculated columns,
It does not get auto update so i have made a cloud flow to auto update it
it updates a temp column with random value so that the calculated columns get refreshed for that row, but sometimes it is working sometimes it is not, is there any solution for this?
any workaround for it to update calculated columns on it's own, tried the json method but got no success
I have done very little work with calculated columns. And certainly not tried updating it with flows.
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
what's the formula for the button to view the selected record? also, edit the selected record? I didn't see this step in the video.
View I think I showed in video.
Edit will be to use editform.
@@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)
How did you insert a header with your logo and photo? was it pre-made?
Modern header control ua-cam.com/video/UEX4mXjxWOI/v-deo.htmlsi=YJ2VR1KOgef09Pjv
Nice. Informative video
Thanks
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. “
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.
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.
In every card, there is a "ErrorMessage" controller. Click on that and go to the "Style and theme", there you can edit the Font weight and color 👍
Hi Reza, Can you put multiple containers inside a Form? I have so many DataCards.
Not something I have tried. Give it a shot and see.
I have tried. Couldn't. I wish they have this feature.
@@dawnyang5634 May not be supported then
Travel Type field is not visible in power app even though it is present in sharepoint I don't know why?
I have not experienced the mentioned issue, hence not sure.
I will recommend checking or posting your issue on forums in case someone has experienced something similar
community.powerplatform.com/
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
Very Nice! and fast
Thanks!
Hi I have 4 different forms, but when submitting data it produces different excel rows, how can I make it so that when submitting data without having to add additional rows and data from all four forms can be saved in one row?
Please help.. im newbie sir
I have no clue about this as I would have to reproduce your scenario to know what's going on. I will recommend posting your issue/query on forums in case someone has done something similar
community.powerplatform.com/
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.
I have not experienced any issues with his so not sure.
I have a really weird issue. Two Forms, one where it shows my OnVisible (identical) variable varStep as 1 when hovering over the formule, and one (identical!) where is says varStep = Leeg (empty/null, in Dutch), despite the formula just being Set(varStep;1) (Dutch settings require ';' instead of ','). Any idea what might cause this?
I'm not sure about this issue.
I will recommend checking or posting your query on forums in case someone has experienced something similar
community.powerplatform.com/
Hi there. Thanks for the video it is wonderfull.
I want to add the varSTEP to this If(
OTAssetInventoryDataCardValue.Selected.Value = "Disagree",
true,
false
)
How will I do that.
I did not understand the question.
What you shared seems to be a formula to show or hide something
@@RezaDorrani It is ok I got it to work.
I had a question with options. If they choose Yes, it will go to next question. BUT if No was selected, I wanted a new question to open to explain the "No". But this is also link to the fact that I'm using your varSTEP option. So, what I did was
...If(varSTEP=2 && OTAssetInventoryDataCardValue.Selected.Value = "Disagree", true, false)
how do i get the data set which you have used
There is not way to share SharePoint list with data and schema. Idea of video is to enable you to use it with any list that you have.
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 will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
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.
Person fields are currently not supported by modern controls. Alternative will be to use classic combo box.
@@RezaDorrani thanks
Can we also get the link to thsi project so we can create it.
You can try downloading the solution shown in video (members only - check video description for details)
How can you apply this within integrated SharePoint list form? Thank you :-)
I may have done a video on it. Check my videos on tabs in power apps.
Hi Can i do the same without a dashboard page and a button to raise new request , I want the form to be the landing page itself, Please help
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 Thank you will check on it .
It would be nice content for skills improve with new approaches...
Thanks
Can Use Power apps without a work or school account?
I don't think so
FYI: Modern controls and themes is now under the updates tab, not general
Thanks for sharing. There will come a time where it wont be there also and simply available right out of the box.
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?
As an app maker, once you set the widths in edit mode and publish, the same width holds for users running the app.
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
I am talking about modern table control only. When editing the app, simply hold alt key and set the widths.
Hi Reza, That Ctrl+Z logic for selecting DatacardKey & Datacard Value in a form does not work anymore. Right ?
You mean the one to select all data cards?
That does work
@@RezaDorrani Yes Correct. I don't know that's not working for me.
@@techwithchanchal Im not sure why
@@RezaDorrani No worries, Thank you for your reply. 😀
How did you add emoji within the step gallery?
Windows + .
@@RezaDorrani Thank you for your help, it is not working from my laptop.
@@sonalipatel12 Im not sure why thats the case
Ok, I learn so much from your videos, very helpful with my work. Thank you!
On desktop it is working fine!
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
I have not experienced this issue
Hi Reza, I am not able to download the above app (Creating Multi-Step Forms in Power Apps). Could you please enable?. Thanks in Advance.
You need to add a comment on the secured link post in memberships tab where link was shared.
Hi Reza is there a way to find whether the current logged user in powerapps male or female
I don’t know if that’s an option
@@RezaDorrani thanks for your confirmation 😍
Hi reza sir, how can I get power apps developer job as a fresher?
I have no clue about that.
Please what if I want to edit?
Similar to viewform function there is an editform function.
Hi, I m new to IT field, can you pls make a small video how to use ur project from github and can create my own. Love ❤ fro. India
Which project?
Now I share all my apps/flows with channel members (silver and above)
It includes read me docs which includes steps on how to install.
@@RezaDorrani kanban board I m interested in which you made long time back 5 years ago...
@@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. “
Ok sure, anyways good work thank you... I have learned a lot from you.
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
That is a novel way to use the Approval screen template.
Look good, but little difficult to understand as beginners that variable and other stuff
Thanks for the feedback
is this responsive ?
Yes as I see the app using responsive containers
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.
@@RezaDorrani I'm sure you'll get more views if you work on it, most people won't say it but its the truth
@@hermetism Thanks for the advice
Another great one Reza!
Thank You!