Power Apps: Planning SharePoint Lists Relationships - Part 2 

You are sooo great at explaining things. Usually I have to watch 4-5 videos to connect the dots.

Outstanding! Dude, I spent a week looking for a breakdown like this on countless videos and websites. I have migrated from an MS Access background, and you have essentially related the understanding of Power Apps to the MS Access relational model like no one else. Thank you!

Your sequence of instruction makes it easy to understand. Great content Daniel!

Love your work!!! really like the hands on approach of talking through each stage of developing the application. Well done mate!!!

This is brilliant video 👌🏽 thank you, I have subscribed now and looking forward to watch your previous videos and of course upcoming too 👏🏼👏🏼

WHOO HOO 3D looks .....that's a perfect spice for this video, Thank you Daniel for your time putting this together from A to Z . I like your way of thorough explanation , presenting end to end process and using real scenarios,......which balances all levels of learners Advance Mid and Beginners like me. Thank you Thank you Thank you Thank you Thank you Thank you

3 months after watching this, I am still amazed on your work, Daniel! I am re-watching it now because I do need your help here. I want to put up a drop-down option on the AppScreen. I have 2 SharePoint list for the brands - let's say your brand sample is in List1 and I will add another set of brands in List2. Both this list will appear on the drop down menu. If I choose List1, it will show all brands from the list and if List2 show all brands from the list. I thought about creating a completely new screen for each list but I am hoping there is an easier solution instead of creating another screen. Thanks, Daniel! Stay safe!

All 3 parts are superb, well explained, great work. Thanks a lot ..!!!!

Hi Daniel, thank you for uploading this. I learn a lot from your videos

Excellent video Daniel, this has tremendously helped with planning my current project to next level using Relationships. Part 3 tmr :)

Keep *Power... Happing* 🤩! This video is so helpful and weel explained. Thank you so much 😍👍

Excellent! Best explanation I have found

Great work on relationship DAniel. How we can apply this in invoice shop request order , Invoice parent list and line items , and supplier in my case . HAVE you a video on that and how to patch multiple line items collection to list in sp.

Awesome! love it, I'm new on this and with your videos helped a lot!! Thank you!

Thank you Daniel for sharing your knowledge, I use for the Foreign Key columns in the SharePoint List a LookUp Column for reinforce the referencial integrity. According to the previous video you use a column of type Number, Which option will be the best practice?, Thank you.

Justo lo que necesitaba, Muy bueno, gracias! Saludos.

Again great job thanks so much

Love the content, thank you so much for explaining in such detail. Quick question: Where did you find the shadow image? Everything I am getting off google doesn't have that transparent background.

Hi Daniel. Thanks for the video.

The PowerApps Doctor - Mr Daniel Christian. !!!

Great video for sharing the full benefits and construction of proper data relationship usage. I am doing something similar for employees when I happened across this. One question- if you wanted to extract the actual data values (eg: csv output of all open requests withe actual products), is it possible to do that easily with Power Automate based on the relationships?

Wow, this is incredible. In which video do you discuss how to autogenerate the ID’s. Do you need to use a Power Automate Expression when a new item is created for that or is there a setting in sharepoint lists that generates the ID’s automatically?

Hi Daniel, can you please share the link where i can get the shadow image link you are using ?

Thanks Daniel

Hi Daniel, I'm trying to achieve something similar - I have 3 SP lists that have common fields to join them e.g. ID field. I want to be able to search on the data and edit certain fields. Is it possible to create these sorts or joins/relationships when using edit forms?

Hi Daniel - I'm trying to do something similar where I have multiple SP lists with the necessary ID fields from each table in the respective tables (as you'd build a relationship database. Here's the question... in a "child" table I have a dropdown in Power Apps that is meant to display all the values for aircraft in a parent table . In my SP List I am not using Lookup columns as I want to try and do it your way. So when I edit my list item (with a customized Power App form) I want to display the value of the appropriate aircraft in the dropdown list. It should determine the value from the aircraftId column in the "child" table and do a match on that to the parent.id value and display the parent.displayName value in the dropdown. In your latest videos where do you have an example of that where the dropdown value is being defaulted based on the value in another variable. I hope that makes sense...I realize this is easy stuff for you.

Can you show us how to edit an existing Request please ? You mentioned that you will come up with a 4th video for it. Do you have it already ?

Hi Daniel, for the list relationship did you type all the information manually? or you did a lookup on sharepoint list?

hai do you know why my powerapps says that i couldnt compare the data because of the types can't be compared?

Any video that overcome the power App limit 500rows of lists/Excel. I have table/lists with more than 500rows

There is no copytoclipboard in PowerApp, any alternative solution ?