Wonderful delivery of the presentation. Felt like we working in the same room. There is so much included I went back again. Thank you for capturing some complex features clearly and logically.
Love it! Please more. I have a use case: Im currently trying to figure out a way to manage your leave requests incl. Documents like military, doctor or other evidences. The leave must be approved by the HR chief and the department chief. An aproved request must visible in a calendar (preferably outlook) so HR chief can check if the request is OK or it creats problems with other departments leave requests. I was planning to create first a list for employees and roles so i can determine what department chief needs to approve the request. New emplyees could be entered in powerapps by HR. Once this is done, i would then start planning out the actual leave request and approval process in powerapps and how to solve the problem with the calendar thing. I tried already with planner and outlook calendar but that is not streamlined since you need to add the calendar manualy. Man this is complex 🤣 i love it
Nice Use Case! I don't really want to comment further on it as I don't know the full details and I wouldnt want to lead you down the wrong path but remember you can connect to Office 365 Outlook data within Power Apps and / or Power Automate so there are lots of options there for automation and streamlining your process.
Awesome video. Any ideas on how to grab a PDF doc from a doc library and extract data from it to populate a database - such as grabbing a name, address, etc. from a PDF form and using it to populate a database.
Thanks for this very informative video. In my prior life I developed various Access databases. Is it necessary or advisable to approach the building of a PowerApps application, by setting up tables (or rather, lists) the same way I would with Access?
This is amazing very great to learn about. I’m just learning PowerApps and using it to customize SP forms. Was curious if you know of any limitations PowerApps may have if being used only for SharePoint forms?
The big gotcha is delegation and list threshold limits. Make sure you have your filters designed in a way that delegation always happens server-side and that data returned never exceeds 2000 rows (remember to change settings in your app to 2000 if you want as many as that!).. Thanks for watching and your comment.. its much appreciated.
@@ChinoDoesStuff i think you can create a collection in powerapps to avoid delegation. At least thats how i do it. Basicly i load the list as collection into powerapps and clearcollect the list on the save button. Dunno how you would change that logic when working with patch function.
Using a collection may remove the error but the issue of not having the entire dataset still remains. As soon as your records go beyond your row limit you will run into problems.
@@ChinoDoesStuff thanks for the information I appreciate that. Fortunately, I shouldn’t need to worry about such a large filter. One thing I was wondering is if you can show/hide the edit form based on if the current user is part of specific user groups or is in at least one of 2 people fields?
Yep.. you can totally hide and show different records in a gallery or anything really in Power Apps through the visible property of that object. Its a Boolean value so you can add some logic to that field to either return true or false based on what you are trying to achieve. Just on the filter size / record size...I would be careful there, regardless of if you think the record limit will never be reached. I've seen developer's caught out on this in the past and its not pretty to go back and have to fix it. Also, always dealing with the full dataset is not very efficient and will lead to your app performance getting worse as the data grows. Just food for thought :)
On the overall, your tutorials are very informative to inspire new developers to get started. A couple things. the volume was a little low and could not hear clearly. Next, I believe this is targeted to more towards intermediate users and such, its my opinion that the basics of setting up the lists may not be necessary. It would have better to concentrate on the presentation of the relational lists such as the Sort feature. Just a thought. Once again another great tutorial and keep helping us Oh Guru.
Please help me on this issue, I have two different list List1 and list 2 and on list 1 one column value and 2nd column value need to check with option if 1st option match then it suppose to get the value update the for the list 1 column with list 2 column 3 If(ThisItem.'List1'.Value = List2.'@SSG_Level' And List1field = "India Off", ThisItem.'List1column'= List2.'List2column ', List2.'list2column2')
Patch will return the last record saved. To save this value for later reference, wrap your Patch function in a Set() function. I demonstrate this in many of my videos.
Wonderful delivery of the presentation. Felt like we working in the same room. There is so much included I went back again. Thank you for capturing some complex features clearly and logically.
Great tutorial! Gives me some ideas of how to use for other projects. Looking forward to checking out your other videos.
Thanks Cindy! It's feedback like yours that keep me coming back to do more videos..
exactly what I needed right now, thank you!
Great video! So clear and easy to understand.
Can you do another video on how you would approach a many to many relationship?!
Love it! Please more.
I have a use case:
Im currently trying to figure out a way to manage your leave requests incl. Documents like military, doctor or other evidences.
The leave must be approved by the HR chief and the department chief.
An aproved request must visible in a calendar (preferably outlook) so HR chief can check if the request is OK or it creats problems with other departments leave requests.
I was planning to create first a list for employees and roles so i can determine what department chief needs to approve the request.
New emplyees could be entered in powerapps by HR.
Once this is done, i would then start planning out the actual leave request and approval process in powerapps and how to solve the problem with the calendar thing.
I tried already with planner and outlook calendar but that is not streamlined since you need to add the calendar manualy.
Man this is complex 🤣 i love it
Nice Use Case! I don't really want to comment further on it as I don't know the full details and I wouldnt want to lead you down the wrong path but remember you can connect to Office 365 Outlook data within Power Apps and / or Power Automate so there are lots of options there for automation and streamlining your process.
Great stuff like always.
Thanks Roberto.. Its great to have your support and its comments like yours that keep me doing more videos.
Interesting! Do you know what the speed of the power apps is? How does it compare to an actual Database Software like MSSQL?
Awesome video. Any ideas on how to grab a PDF doc from a doc library and extract data from it to populate a database - such as grabbing a name, address, etc. from a PDF form and using it to populate a database.
Mmmmm can't say I've tried to do that..not sure if there is anything in power automate to do such a thing.
Thanks for this very informative video. In my prior life I developed various Access databases. Is it necessary or advisable to approach the building of a PowerApps application, by setting up tables (or rather, lists) the same way I would with Access?
I usually model/create my database first before commencing development of my app..
This is amazing very great to learn about. I’m just learning PowerApps and using it to customize SP forms. Was curious if you know of any limitations PowerApps may have if being used only for SharePoint forms?
The big gotcha is delegation and list threshold limits. Make sure you have your filters designed in a way that delegation always happens server-side and that data returned never exceeds 2000 rows (remember to change settings in your app to 2000 if you want as many as that!).. Thanks for watching and your comment.. its much appreciated.
@@ChinoDoesStuff i think you can create a collection in powerapps to avoid delegation. At least thats how i do it.
Basicly i load the list as collection into powerapps and clearcollect the list on the save button. Dunno how you would change that logic when working with patch function.
Using a collection may remove the error but the issue of not having the entire dataset still remains. As soon as your records go beyond your row limit you will run into problems.
@@ChinoDoesStuff thanks for the information I appreciate that. Fortunately, I shouldn’t need to worry about such a large filter. One thing I was wondering is if you can show/hide the edit form based on if the current user is part of specific user groups or is in at least one of 2 people fields?
Yep.. you can totally hide and show different records in a gallery or anything really in Power Apps through the visible property of that object. Its a Boolean value so you can add some logic to that field to either return true or false based on what you are trying to achieve. Just on the filter size / record size...I would be careful there, regardless of if you think the record limit will never be reached. I've seen developer's caught out on this in the past and its not pretty to go back and have to fix it. Also, always dealing with the full dataset is not very efficient and will lead to your app performance getting worse as the data grows. Just food for thought :)
On the overall, your tutorials are very informative to inspire new developers to get started. A couple things. the volume was a little low and could not hear clearly. Next, I believe this is targeted to more towards intermediate users and such, its my opinion that the basics of setting up the lists may not be necessary. It would have better to concentrate on the presentation of the relational lists such as the Sort feature. Just a thought. Once again another great tutorial and keep helping us Oh Guru.
Cheers
Please help me on this issue, I have two different list
List1 and list 2 and on list 1 one column value and 2nd column value need to check with option if 1st option match then it suppose to get the value update the for the list 1 column with list 2 column 3
If(ThisItem.'List1'.Value = List2.'@SSG_Level'
And List1field = "India Off", ThisItem.'List1column'= List2.'List2column ',
List2.'list2column2')
Sorry Devesh... I have read your question over a few times and I am really not sure what you are asking. My apologies.
What is the command to return the last ID value saved in the gallery ? :)
Patch will return the last record saved. To save this value for later reference, wrap your Patch function in a Set() function. I demonstrate this in many of my videos.
Isn’t this what the column type “lookup” in lists is for?
No... Not really.
Oh you sweet summer child. 😅 I wish!
Thanks so much for making this vid. Can I call you and pay you for advice/help?
God that was a lot of BS and waist of my time.
I guess you can't please everyone. Do you have anything actual constructive to say or did you just want to say something toxic and disappear?
*Waste