Develop Forms in Power Apps Canvas App- Implement New form with Real Life Scenarios

[@iamdhruvinshah]

If you don't know how to create List Structure for SharePoint Site. Please do visit below chapter 8.5 kzbin.info/www/bejne/d2WcemOvn955htk

[@myanyeinchan7984]

Hello teacher , Thank you for your video . It is good training video. Now, I would like to ask that I cannot move "Edit Form" to under datacrad1 of canvas.

[@ShravyaMishra2019]

Dhruvin sir is an outstanding human being and hope of everyone.

[@pixilladesigns1]

Dhruvin!!! You are the MAN!!! I've been developing custom forms for SharePoint since SP2007 and ALL of these scenarios exist in REAL LIFE!! I've done many different tutorials and these are hands down the most concise, real life, easy to follow, and useful tutorials I've seen yet. Thank you so much for taking the time to produce these and make them available for the rest of us.

[@pinabarberio654]

Dhruvin Shah is an excellent instructor, the best I've experienced on PowerApps subject. His teaching style far exceeded my expectations and he is extremely knowledgeable and overall an outstanding instructor. Again thank you very much for sharing great training videos!

[@iamdhruvinshah]

Thanks a lot that you love the series! Thanks for your words.. Keep sharing with your friends and keep learning!!

[@Excel-power-users]

Frankly speaking I have watched this video 10+ times and it is worth for my learning.👍

[@lobnaaittaleb3975]

Thanks alot for this VERY complete Power Apps tutoriel, yet still very concise and clear for beginners to understand and get started on Power Apps !!

[@anwaarkhalil868]

I noticed this. In the new power app update. we need first to add containers to DataCard in order to copy the form to the Canvas level

[@adkhan123456]

in detail video. Serious grilling specially if someone's hard to understand the low code on each click. Looking forward to complete your Power apps series.

[@krutikarewale14]

Your tutorial is a gem, I was struggling with this topic and this tutorial is a game changer. It helped me immensely. Thank you so much for this series.

[@waseemtarique3507]

You are a great brother may God bless you and you continue to do this work for free cost

[@iamdhruvinshah]

Thank you, I will

[@aswathm8980]

Hi dhruvin, how you copy the test collection value ? i am facing error on that place

[@meraki_kkm8119]

Hi Dhruvin, Can you explain how you got the collection code in Video time 33:22 to 33:28

[@user-rz4mv8fq2l]

Great Video and thanks for sharing detailed information.

[@Maynardjones100]

Finally! A tutorial for power apps that is not based on auto adding images from bing or not referring to the damn contoso thingy. Finally someone bothered to explain in detail where is everything and what it is for! On a separate note, I couldn’t make the collections work, but it takes practice, i guess. Thanks a lot Dhruvin, you are doing a great job, I will continue to watch your series

[@pixilladesigns1]

Manuel, check your syntax. I had issues too and just had to manually rebuild the expressions and then they worked -- when I realized I was missing a close bracket.

[@Maynardjones100]

@@pixilladesigns1 thanks, I've been practicing for the 4 monts since i posted this and you wouldnt believe what i csn do with powerapps now. Cheers!

[@tremar2430]

can i know how do you make the collections work? the answers from my form is not saving to my SharePoint list can you help me

[@ankitmatoria2496]

Dhurvin, I completely agree with you because without real life scenario we cannot relate the things. This is the most interesting video so far bcz it includes a lot of things in it. -- Thanks for such an explanation

[@minstreltokunbo]

Greate class, What! My first time creating anything on PowerApp. I did not just create an amazing Form, I tweaked it to soot my requirement. Thank you!

[@iamdhruvinshah]

Glad this helped you!

[@bhushanpatil4889]

Thank You so much Dhruvin sir for this so much useful video

[@ksrinivas30]

Hi Dhruvin, it would be great if you could provide the data set for further practice.

[@anle4056]

Thank you, can you explain how to copy the structure of collection at 33:35

[@ShaikhBilal13]

i think he type it Manually

[@akshaysankpal909]

Hello, Dhruvin Shah can you please explain in detail about the people picker type example? It is a little bit confusing for me.

[@SMARTOFFICERSL]

Best tutor for Power apps

[@habeebmk21]

Thanks! For wonderful video 😊

[@johnpaul5836]

Excellent tutorial and I have everything working as you have taught. I have a question about what you did at 33.32. You copied some data into the curly brackets from the collection. How did you get this data structure? It wasn't clear how you got this information.

[@elfyjohnson261]

Was it CNTRL C on the Test collection? I am also confused

[@lijunchen]

It is not very clear how he copied the fields info.

[@kanwalraheja5836]

just Awesome! So clear! thank you :)

[@conaxlearn8566]

Thank you sir. At 14:24 , how would you calculate the days when it covers weekends, please?

[@sagarshinde4527]

Hi Druvin, I am facing to copy and paste to datacard value which is reference by 3:16. So please how I copy and paste to the datacard.

[@srinivasCollection]

Add one container and paste the form in that container (screen 2 -> Canavas1 -> Datacard1 -> container1 -> form1 is the tree view)

[@avinashtiwari9005]

@@srinivasCollection Thanks a lot, It worked

[@dhanjeet2565]

Hi Dhruvin, how to trigger an email to the respective Manager when submitting the form?

[@marutmahajan7406]

Hello Dhruvin, how are you..really thank you for such a nice tutorial. ..I need ur help. As you have cut and pasted the Form control under Data Card1 as I m not able to do that ..could you please help me with the same. As I cut the control and now trying to paste the control under data Card1 but it is not happing. Could you please suggest me on the same

[@rnaveenkumar2946]

Excellent Video Dhruvin sir, very nice way of teaching...you made it very simple...

[@iamdhruvinshah]

Thanks a lot

[@LamNguyen-jp5vh]

Hi Dhruvin, thank you so much for the tutorial video. I have a question about cut the form from Screen 2 to DataCard1 at 3:10. When I cut the form, I cannot paste it into the DataCard1. Do you know what problem I am having right now? Thank you so much for your help!

[@TymPass-gy9tj]

I am also having same problem , were you able to find how to do it ?

[@LamNguyen-jp5vh]

@@TymPass-gy9tj I have to create another one inside

[@deepikagangeswaran3656]

I have same issue... How to fix this

[@LamNguyen-jp5vh]

@@deepikagangeswaran3656 In this case, I will ignore it and put it outside the datacard1. It will be a little irritating because when you edit the app, there still a line of text :"insert to datacard1" but everything works normally. Just ignore that line of text and follow the instruction.

[@radiantinternational9436]

I am having the same issue of cutting and pasting.

[@shaunlewis3222]

Awesome video Dhruvin. This video beats some paid classes on this topic. Great Work!

[@sinziyaparveen1951]

very helpful video👍🏻

[@sumanth16782]

hi Dhruvin - I am unable to move the form within the canvas / datacard - the cut & paste which you have shown does not seem to work. Thanks!

[@nidaakbar422]

Same thing is happening with me How to resolve it Plz guide us

[@myselfsk6752]

Thanks, Dhruvin For sharing such knowledge. Can you help to create a VLOOKUP in PowerApps?

[@itsmyvlogs7197]

Thanks Bro for sharing this information and i gain more knowledge about power apps. Bro, I have a doubt how to write function , if we have multiple screens and i need submit through one button function.

[@baskiram4041]

@dhruvin Shah, Excellent tutorial video for beginners. I'm facing issue while adding the form (Edit Form) into DataCard section. I tried multiple way but nothing happened. I can't past the my Edit form into Datacard.

[@suryaprakash-rn8wz]

i am also facing same problem do you find any soluation

[@srinivasCollection]

Add one container and paste the form in that container (screen 2 -> Canavas1 -> Datacard1 -> container1 -> form1 is the tree view)

[@rozitajack7778]

thanks a lot for this tutorial

[@spreadsheetinteraction1088]

Great video!

[@habeebmk21]

Good explanation

[@fatimahgraphics4525]

Informative

[@BibhashJha]

how to restrict start date should be smaller or equal to the end date?

[@kaveris3363]

in the manager comments column at list how did u bring the value view entries do we need to defaultly give or it will automatically generate

[@officeedu846]

Hi Dhruvin, Thanks for the video. i tried to cut and paste form in to data card as you explained on 3:16, but it's not working the form is not pasting, can you help on that?

[@ngoctuandt3]

You can do that now? Please help me

[@yassinechmangui4054]

Hi @Dhruvin Shah, what if I want to do multiple selections (HR, DEVELOPMENT, ..) !!! . Thank you in advance

[@bojjaiaht8450]

Thank you for your video. Really awesome. But you are not shown here for date validations like before dates and non-working days. If we have really appreciate.

[@iamdhruvinshah]

I will prepare separate video for Date Validations! Noted ! Stay tuned, will upload video soon!

[@DiamondKhan]

I really apricate for your fantastic work.👌✔🎁😊👍 I really liked each and every video. 💖In the tutorial for the you have not created any column to store requester name. How can I store requester name instead showing in the UI upon saving it will be stored in the requester Column.

[@mhdaflah6720]

Hi can we add command for multiple dropdown list selections in visible

[@TheElayris]

Amazing! How I can filter the gallery from 10th(Previous Month) to 9th(Current Month) for each month as default. I used date picker to make it but I couldn't make it stable for that dates. Thank you!

[@raviperala78]

Great Videos, Similar to the Canvas Apps, please share Model Driven Apps playlist link?

[@swapnilpednekar4278]

very nice

[@norhidayah889]

hi dhruvin, can u share how to display numbers data from SharePoint lIst based on user's id or email address?

[@cousinslove7209]

instead of using back() for " < "this icon we can use navigate() becoz it will also redirect to the home screen ryt? or what is back() function? how it works here ?

[@Excel-power-users]

at time stamp 27.35 you mentioned Department internal name is Title how can we check it in the system.

[@antonpierre6565]

Hi Dhruvin, great vid very easy to follow....if I'm using forms, hope I'm describing it correctly, where I created via SharePoint a list, connected to the data in SharePoint, as you showed, used the PowerApps forms that brought list items together and I'm now attempting to create scores, can this be done using the forms format.

[@hoavoduong4800]

The tutorial is very useful. But volume is small.

[@crimson_33]

Hi Dhruvin, the test clear collection function doesn't show the overview of the first 5 items in the collection. How can I fix it?

[@solstice_flow]

What did you do to copy and paste at 33:31? Please understand we will not be able to figure it out without explanation.

[@kanwalsingh2802]

Hi Dhruvin, do you think we could use if condition for Department & HR filter values?

[@nandhineesundaresan3961]

Hi. Thanks for the great explanation. Am trying to create an issue management system with my data source as Excel. Can you please help me with the schema of the list I need to have in excel for creating this ?

[@vaughanscott5540]

Hi Dhruvin at somepoint I realised my "Manager" column was text and not choice. I changed it to choice and refreshed the data connection but now my manager data card keeps complaining that it expects a text not choice how do I correct this? Thanks for the great guide.

[@iamdhruvinshah]

You need to remove column Create a new column with some new name with Choice column. Refresh DS Add Datacard Again This should now work!

[@ajjusaeen36]

hi dhruvin, i followed the video and every thing is going great but when i use collection for department column is went right but for manager column i didn't find any data stored in my collection

[@souravsisodiya3157]

Hi Duruvin sir How we can set date for weekend holidays?

[@challacommunications137]

Hi dhruvin,, In the Datacard we have taken edit form that should be added in screen2, then you did cut and paste at datacard it is added in your video but practically it is not working,, what should i do

[@PetrOndrusek]

Thank you for the guide. Just one question: When I run this app from PowerApps editor it runs Ok, but when I run it standallone or inserted to Sharepoint button from main screen do nothing. What can cause this?

[@radiantinternational9436]

Thank you, when I tried to cut the Form1 and paste it to Datacard1, it didn't let me do that (3:30 mm, your video). I can cut but the past couldn't happen. Do you have any solution for that?

[@prashanthsanke1212]

This video is really awesome. Great efforts!!!

[@iamdhruvinshah]

Thanks a lot!

[@jayjaiswal5766]

@@iamdhruvinshah Actually sir I am very new in Powerapps and sharepoint, I got a project to create a user form, I have successfully created the form in Powerapps by using sharepoint list, but when I clivk on submit button all the entry is saving to sharepoint list but dropdown value is not saving, Then I researched and I found that I have to use patch function to save dropdown values in sharepoint, but it's not working, Now Please suggest me how can I use patch function with submit form function, Please suggest sir

[@jiteshmarathe1422]

Hello Dhruvin, I have one query that I am going to calculate ticket duration but I need to exclude out-of-business hr to calculate the duration, the duration is calculated from close date-time minus opened date time and I want this duration in hours, please help

[@minstreltokunbo]

way to go video!

[@vaughanscott5540]

Hi Dhruvin, How did you do the selecting of multiple datacards to do the fill for all of them at the same time?

[@vaughanscott5540]

Sorry Got the holding CTRL to work not sure why it didn't work earlier. :) Thanks

[@nihhhil2624]

How you Select Pending Leave Status By default When Form Gets Submitted???

[@tejamogilipuri7344]

Nice Sir but Inside Form did not Past the out side please explain

[@VenuKolar-r8h]

Hi Dhrvun Sir, Sharepoint data lists that I created were not reflected in the App, for example like "leave type" when I click on the drop-down nothing is showing actually. what could be the error over here, please assist me. Thank you.

[@amlansahoo4867]

How to set the default value of elave status to pending as I can see that part is missing in the video

[@maddishirisha2867]

Hello sir, is ur code working for no.of days if diff is zero

[@ShaikhBilal13]

Can You Explain how Copy Structure of collection at 34.00 second in this Video

[@aadarshvalsange8548]

Hello Dhruvin, Form is getting submitted. But the list records are not get reflected in sharePoint List and I can see only 7 records in my SP list

[@asifpatel7422]

Hi Dhruvin, i tried to connect data source but in connectors i am not able to see any SharePoint option as such...can you please tell me why is it so or is it because i am in default environment in Powerapps? Please reply

[@LiyaG-u2i]

Hi, I couldn't figure out the Notify syntax on the form as it shows on your chapter 9. I wrote a condition on the form section but when I hit submit button the message doesn't show :(

[@wayofgods1414]

Hai dhruvin.... I'm trying to paste edit form in datacard ..... But I can't paste it .... Could you please help me

[@AmirNaved]

Thank you so much

[@hemangiektare8635]

Hi Dhruvin, Thank you for all the tutorials. I'm developing a Leave Application form where I do not want user to submit same days leaves/duplicate leaves. For example, if user has submitted leaves from 1st Jan to 5th Jan, then he should not be able to submit leaves from 3rd Jan to 5th Jan or any overlapping dates between 1st-5th. Can you please help?

[@VikashYadav-hy9hn]

Not able to insert the form under datacard , using excel databse pls suggest how to do

[@ruthruth8533]

Hi Dhruvin, poowerapps is unable to paste form in the datacard. Can you please help

[@Excel-power-users]

At timestamp 33:29 how did you paste the value of Test between the curely{} brackets. I tried to copy the Test from the button and paste here but only the text got copied and not the value.

[@navyashreebr4621]

How to add another data card in the same canvas? I'm not finding any option, pls let me know

[@VikasKumar-fn6sj]

Not Able to move forms in Canvas data section, can you please provide me any solution.

[@mercuryptapb]

Hi dhruvin, My Manager choice is not getting saved after submitting the form

[@ralphlaurencemanosca8909]

Hello Dhruvin good day! May I ask how did you cut and paste the form? It's not working for me, I can paste it everywhere except the datacard please help!

[@burakdagli7356]

Yeap, same problem. Did u solve it?

[@LORD_ORiGiNALz]

Hi Dhruvin I'm wondering is there a way to create a form without using forms because I have some fields I want to take from another table but the custom cards I put in won't be saved

[@anujchaudhary6985]

Hello Dhruvin, Hope you are doing goo :) I have a probelm, in adding edit form in Datacard. I am unable to add it. Please help me here

[@mayankgr8]

Edit form can't be cut and paste inside the Data Card. What to do in this case. Please suggest.

[@dipayanbhattacharya8128]

How can I get or prepare the SharePoint list in my trial environment??

[@iamdhruvinshah]

Please use this video kzbin.info/www/bejne/d2WcemOvn955htk

[@skprince2826]

Hello sir, am practising leave application app In screen1 i have add a button apply leave then i will connect with datasource list schema(sharepoint) giving site address and choose the list(leaves ,approvers) again am taking a new scrollable screen then am clicking on form(edit form) it will show out of the canvas am trying it will show inside the canvas(by using cut & paste method) but its not reflecting may i know the reason sir pls help me am new to powerapps

[@maheshrao6089]

Hello Dhruvin, is there a way that once the details are filled in a form and saved, it should be visible in the form itself in a grid view

[@iamdhruvinshah]

Yes, we can display with the help of Gallery!

[@maheshrao6089]

@@iamdhruvinshah Great👍 can we expect an small video on how to do that in your next video.

[@gangaramchandramohanreddy8348]

Hai sir , Recently I started watching PowerApps tutorials and also practice, i try to insert form with in datacard1 but it is not possible what should i do for insert an from with in datacard1,Please help me to resolve the problem

[@vivanitsa]

Dhruvin, first, thank you very much for this course. Regarding this video - you did not show how to prepopulate Departments and Leave Types...

[@iamdhruvinshah]

Please check this new video kzbin.info/www/bejne/d2WcemOvn955htk

[@samuelmyanga1587]

Hello, i have been trying to cut the form and paste it inside the Data Card of the scrollable screen but it is not working.

[@barunroyghatak4380]

Hi Dhruvin very nice tutorial but I have one query. When you just passing the collection name test to the Approver Manager schema do you apply some specific shortcut key like copy ctrl+c and ctrl+v then six column added added in the people picker. At 33:34. Kindly please help me.

[@barunroyghatak4380]

Hi Dhruvin it's done. Thanks.👍

[@nitinj312]

@@barunroyghatak4380 Brother? Could yu help me out how to carry out the steps?

[@barunroyghatak4380]

@@nitinj312 You don't need to panic. I also got stuck only you have to copy each and every step as presented by Dhruvin and you got the outcome. Actually I missed to passes the collection name to the manager data card value and once I did it. I got the results.

[@rhushikesh9]

Hi @Barun, could you please explain, how did he do that? I really did not get what needs to be copied and what needs to be pasted.

[@barunroyghatak4380]

@@rhushikesh9 what problem are you facing? Or you can directly connect to Dhruvin Shah. His number is 9537981467 through Whatsapp

[@pavanikannayagari]

hi Dhruvin, The sound quality is very very low. please try to improve it.

[@madanthapa575]

Hi Dhruvin, Thank u very much for sharing such an informative video.I am very new to this PowerApps platform. I just wanted to ask i also need hourly leave option in the leave management system .I want to add leave hours like 1 hour or 2 hours and once the hourly hours option is selected i want to disable leave days to be disabled and the value of days should be 0.Please suggest it would be really a big help for me.Thanks in advance.

[@iamdhruvinshah]

Yes, you can do that easily. Just add one additional leave type = Hourly Then add a conditional statement on #of Days = IF(drp.selected.value ="Hourly", 0,thisitem.text) Same way add a condition in DisplayMode.