Use SharePoint Lists just like a Relational Database in Power Apps

Подписаться 5 тыс.

Просмотров 54 тыс.

50% 1

In this video, Chino gives you a quick introduction into how to use SharePoint lists as a data source in Power Apps and how they may work as a Relational Database.
Useful Links -
Power Apps Galleries - • PowerApps Galleries
Delegation in Power Apps - • How to fix Delegation ...

Опубликовано:

21 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 33

@karenmcdiarmid1855 Год назад

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.

@cindyjohnson2485 2 года назад

Great tutorial! Gives me some ideas of how to use for other projects. Looking forward to checking out your other videos.

@ChinoDoesStuff 2 года назад

Thanks Cindy! It's feedback like yours that keep me coming back to do more videos..

@loveb86 2 года назад

Great video! So clear and easy to understand. Can you do another video on how you would approach a many to many relationship?!

@0otholomewplagueo0 2 года назад

exactly what I needed right now, thank you!

@nebucadneza1914 2 года назад

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

@ChinoDoesStuff 2 года назад

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.

@robertonavarro4704 2 года назад

Great stuff like always.

@ChinoDoesStuff 2 года назад

Thanks Roberto.. Its great to have your support and its comments like yours that keep me doing more videos.

@reardoor Год назад

Interesting! Do you know what the speed of the power apps is? How does it compare to an actual Database Software like MSSQL?

@tonya3308 2 года назад

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.

@ChinoDoesStuff 2 года назад

Mmmmm can't say I've tried to do that..not sure if there is anything in power automate to do such a thing.

@wpryan02358 Год назад

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?

@ChinoDoesStuff Год назад

I usually model/create my database first before commencing development of my app..

@devagunalan1056 2 года назад

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.

@ChinoDoesStuff Год назад

Cheers

@jmstampe 2 года назад

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?

@ChinoDoesStuff 2 года назад

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.

@nebucadneza1914 2 года назад

@@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.

@ChinoDoesStuff 2 года назад

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.

@jmstampe 2 года назад

@@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?

@ChinoDoesStuff 2 года назад

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 :)

@deveshchourasia6355 Год назад

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')

@ChinoDoesStuff Год назад

Sorry Devesh... I have read your question over a few times and I am really not sure what you are asking. My apologies.

@Tomaszrobin 2 года назад

What is the command to return the last ID value saved in the gallery ? :)

@ChinoDoesStuff 2 года назад

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.