Power Apps: Planning SharePoint Lists Relationships - Part 3 

You are most welcome Clarence. Thanks for the compliment and let me know if there are any blog topics you'd like me to cover.

You're very welcome!

Noted!

Glad you like them!

Thanks Nathan for the compliment and supporting my channel.

You are so welcome!

Thanks for the compliment Prabhat!

You're very welcome!

Thanks Aditya, for those kind words. It's folks like you that encourage and motivate me to keep blogging.

You can do it!

Hi Cindy, Thanks for the compliment, Cindy. I have a few more videos that I am working on before I get to the 4th one of this series. I'll do my best to get it done this year.

You're very welcome, Mohamoud and thanks for the compliment.

I appreciate that compliment.

You're very welcome!

Thanks for compliment Arne'

Your welcome, Steven!

*Awww shucks* Thanks Rohit.

Thanks John. I'm starting a new one on Power Apps permissions at the control, app, Power Apps Services and Tenant level. Stay tuned for that!

Glad it was helpful!

Thanks Scott. Take a look at my 'Tightening the SharePoint list permissions'. I've explained how you can apply a filter at a user level. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-qpVGdFHs43k.html

@@DanielChristian19 I definitely will. Thanks for the response. It's greatly appreciated!

Hi Arne', I'll add that to my to-blog list 😀

@@DanielChristian19 Would love that, too!! Great stuff :-)

Your welcome Khalid!

Glad it was helpful!

Glad you liked it

You're welcome!

Hey Shonda, Great question! There's two ways you can do that. 1) using Power Apps and galleries and relate the galleries using IDs. 2) Using Power BI reports and setup relationships. Hope this helps.

Your welcome, Fori

Thanks William. No immediate plans. Shane Young has done several vides on creating PDF files using Power Apps and Power Automate. You can take a look at his.

@@DanielChristian19 will do. Appreciate the knowledge sharing

Hey Ashish, Lookup and Managed Metadata columns get challenging when it comes to patch functions. Also, say if you plan to migrate from SharePoint to another data source then you will have to redesign the data structure. Hence I prefer to use relationships if I have the option to build something from scratch.

@@DanielChristian19 Using ID columns really makes sense in migrating applications. Highly appreciate your response. Thanks for all the community help and awesome videos.

Hey Omar, Thanks for the compliment. You have a few options to create the PDF file and choosing which one you want depends on how much content you have. The free way is using Power Apps to create the HTML file, send it to Power Automate and using OneDrive for Business, convert it to a PDF file. Reza Dorrani has done some videos on this topic. There are also other connectors available that will do the conversion for you. You want to look into those for higher volume. Hope this helps

@@DanielChristian19 Thanks for your answer, I'll take a look at that Reza's video. You have a good day!

Your welcome S Kh, You will have to re-define the relationship in the SQL server tables. When you export a SharePoint list, you should get the item ID. You can import that to SQL and continue using the original list ID but make sure you do not confuse that with the SQL table's primary ID.

@@DanielChristian19 Thanks a lot. So, I concluded that it would be very difficult not to get confused when there are many tables in the project.

Hey Bill, Thanks for the compliment. Any formula in particular you are looking for?

@@DanielChristian19 i was mostly interested in the formula used to link the people and groups field in SharePoint

Hi Bill, Here is an example of the People or Groups column RespondantName: { Claims: Concatenate( "i:0#.f|membership|", User().Email ), Department: "", DisplayName: User().FullName, Email: User().Email, JobTitle: "", Picture: "" }

Hi Steven, I've already covered Power BI Integration with Power Apps a while back. I do need to record another one and show some new features.

@@DanielChristian19 Hi Daniel. That would be great because that's the place where we need to work with the relationships the most. But I might be wrong because I'm just learning the Power Platform. Your videos helped me a lot already and I look forward to see more.

@@DanielChristian19 Thank you for the videos. Seeing the Power BI integration was one I was looking forward to seeing at the end. It would be greatly appreciated if a Part 4 was added.

Haven't worked on that yet. Currently I've been focused on Mixed Reality and 3D components.

I'll need a little more information to point you in the right direction. What are you doing? Where are you stuck? What is your data source?

Hi V Tandon, Thanks for the compliment. I've received several requests for 4 hence I've added that to my to-blog list.

@@DanielChristian19 Thanks if possible cover some info on Power platform ~ & ALM

Please Hellp I would like to list in Gallery1 the Unique Order, VCode, from the below data source On Select from Gallery1 i get the detail list for the Order ORDER LINE No Item vCode Order Date 49R25147 1 TPMP83497-TPL JB 11/09/20 49R25147 2 TPMP83501-TPL JB 11/09/20 49R25143 1 TPMG16036-TPL JB 14/09/20 49R25143 2 TPMG16068-TPL JB 14/09/20 49R25143 3 TPMG16089-TPL JB 14/09/20 49R25143 4 TPMG16109-TPL JB 14/09/20 49R25142 1 TPMG16036-TPL JB 16/09/20 49R25142 2 TPMG16109-TPL JB 16/09/20 49R25142 3 TPMG16166-TPL JB 16/09/20 49R25142 4 TPMG16635-TPL JB 16/09/20 49R25142 5 TPMG16637-TPL JB 16/09/20 49R25141 1 TPMG16036-TPL JB 21/09/20 49R25141 2 TPMG16166-TPL JB 21/09/20 49R25141 3 TPMG16635-TPL JB 21/09/20 49R25141 4 TPMG16638-TPL JB 21/09/20 82174844 1 IO-82174844-01 B1 25/09/20 82174843 1 IO-82174843-01 B1 26/09/20 82174640 1 IO-82174640-01 B1 27/09/20 82174707 1 IO-82174707-01 B1 28/09/20