Just WOW! I admit I was bracing myself to be overwhelmed, but you explained things so well and so logically that I followed along just fine. Ready to dig into Part 2 tomorrow 😃 Thank you, Daniel!
Also amazed at your very clear explanations. I haven't developed an app in years, so I am super excited to get going with all of these prebuild components! Thank you, Daniel!
I am new to SharePoint and have not had much use for it in the past but THIS is something I can use it for (especially for data that does not need a SQL database). Thank you!
Woww Daniel!! For the 1st few minutes I felt it more complicated, at the end of the video it made me feel simple. Amazing approach! Much excited to know how you brought the data on to the app and how you saved back to respective lists. Please bring them on!
Hi Daniel, thank you for the video series. Just a kind recommendation: I believe you would save yourself energy (and video time) if you assume and state that people watching this part 1 should know what is a relational database.
Wow, thanks Darren. I'm working on the Part 4 video which has been requested several times on how to build those primary lists. That video will help complete this series.
this was super-informative. I am looking to build a fairly intricate app and thinking about the relationship matrix and what my lists are really helped me to process how I will approach this project. thanks!
Hi Daniel, your videos are just amazing. And these series of three give me confirmation I needed to build the structure of my next app (project management app with comments and additional tools). Keep going and looking forward to your next great video. Have a nice weekend, Davide
New subscriber thanks for a great video. I was going to ask about the choice of number column vs lookup column for the linking but I noticed it was asked and answered. Thanks again.
Any chance you would share that PowerPoint with us also? This is EXACTLY what I need to solve a HUGE task at hand, and I am so excited to dive into these three videos today!
@@DanielChristian19 Any chance I could get you to take a peek at this issue I posted and see if you have any thoughts? powerusers.microsoft.com/t5/Building-Power-Apps/Link-item-in-concat-string-on-detail-screen-to-clicked-item-s/m-p/699275
Hi Kiley, I read through your post. Try adding your formula to either the rich text control that allows HTML. Might have to use the Launch function. If that doesn't work then consider using a button.
This is very well explained , Thanks. For an end user we might need to give an admin App to upload the data as well. Please plan some thing of that type.
I may have missed it, but why have you chosen to create several different lists and associated them rather than have one list with all these relationships being handled as filtered views of the various columns?
Having all the columns in a single list increases the overall number of items (rows) you will have to manage. Yes, you can filter them using a view, but that doesn't decrease the total count of items.
I'll have to check and verify but you can also take a look at the video #4 of this series. This vLog shows how those lists were built and the forms to add, view and edit them. czcams.com/video/csxTmUWSiKQ/video.html
Hey Daniel, Is there anyway for you to delete an item from the Parent list in this case the (MFR's) list if the child list (Devices) no longer contains the parent's MFR ID. I have tried Remove if MFR id not in Devices MFR ID column but to no avail. Thank you
Hi Skiptracing, Yes, there is you can use a combination of filter and remove to get this done. The filter will find the same parent ID in the child list.
Daniel Christian Hi Daniel, Thank you for the reply, but what i meant was to remove a parent record based on if the parent record id is still being used in the child list. For example if i were to create a new MFR in the parent list called. “ Apple” with the id of “6” and a new record in the child list “ Mac book pro” with a “6” in the MFR id column. If i removed the record “Mac book pro” from the child list(which in this case is the only device with the MFR of “6”), i want it to automatically delete the MFR “Apple” in the parents list, because there is no longer any records in this category. I only want the remove to happen when the MFR id is not being used in the Device list at all(so when there are 0 records with the parent id). Is this possible at all? Thank you
Hi Daniel, Great video thanks. I was wondering, and I may have missed it in the video, but what column types are you using for the ID references from other Lists? As in, is it a lookup type or are you adding manually to a single line of text column? thanks for your help.
I'm using the Number column type to save the ID. I set the decimal to 0 for aesthetic reasons. Don't use single line of text. Doing that will cause delegation warnings.
In the matrix you have a "Device ID" column that points to the Device List ID but then in the sharepoint list (for example in 14:52) that "Device ID" column isn't there. Am I missing something?
Hi @daniel, I´m using PowerApps with SharePoint lists, i´m pretty sure that is not a good practice with E-R model BUT, it is what i have right now!. I apreciate your video because it brings an oportunity to us. Let me know how many data do you think should be the MAXIM to don´t affect PowerApps´s performance ? Thanksss
Hi Diego, You are welcome. I've mentored Power Apps makers who have had lists with 15k items and others with 20K. As long as you setup your formulas correct i.e. non delegable and archive your lists in a timely manner, you should be fine.
I really enjoyed this 3-piece series. And I'm planning to use this information to automate a Request for Service form based on SPO (watching you security video on SPO too 😁). However as a newbie to SPO is it possible to get an overview of how the different list are designed with their column types?
Hey John, Glad it was helpful! In this three part series the column types I used are: 1) Single and multiple line of text 2) Numerical column. This is where I saved the IDs 4) People and Groups. This helps to gather the names for future workflows. The patch function gets a little complex for these columns. 5) Date and time column. I stay clear of the lookup and managed metadata column as much as possible.
Amazing content!! Thank you. I do have a question about the relationships. Are you using lookup columns between the lists or do you use a number column and know that a certain ID is the right one? Example MFR ID =5 for MIcrosoft If you have a video on setting up the relationships at that basic level I would gladly watch. Your content is easy to follow
Hey Paul, Thanks for the compliment. I am using number column. Take a look at this video of mine, it will point you in the right direction to setup basic relationships. czcams.com/video/wpn4dnJJVTg/video.html
How can I retrieve data in Power Apps from a SharePoint list based on source list item ID? What I want to do is have fields like FormID1, FormID2, FormID3, etc. in my Power App solution, and be able to retrieve combinations of item detail from any connected lists on load, using source list ID numbers provided by Power Automate. How can I do this with Power Apps?
Hey Erica, This three-part series video I did is exactly for the scenario you mentioned. In a nutshell, you need to have that one table/list which saves the relationships of all the tables using IDs. Then you can relate those ID's using Lookup or Filter and see the data in your forms.
Hey Alfonso, I'm working on the Part 4 video which has been requested several times on how to build those primary lists. That video will point you in the right direction.
Thanks so much! Quick question on relating the tables: Is there a reason that you choose to use a numeric field type to relate the ID's in the tables rather than using the OOTB SharePoint Lookup field type?
Hi Matthew, You are welcome! Patching SharePoint Lookup fields, although not impossible, it can be challenging especially the patch commands. Hence I stick with building relationships.
Thank you for your amazing video! One questions, on Devices list and accessories list, we already have MRFID and Device ID. How do you get those IDs to be put on the Device list? Is it manually input? I understand that on Request list and the other yellowish table, we get the ID from within PowerApps
I am building a PowerApps for my practicum, and I am stuck. (I have issues with collection, radio button dependencies, checkbox displaying values.) I believe my issues are because I set up my dataset from excel. Is it difficult to change it to SharePoint? I am assuming that all my expressions will have to change and I am discouraged. Any suggestions?
Hey Carolina, It all depends on the type of columns you use for the SharePoint list. Single line, multiple line, number, people and group and number are the easy ones to work one.I'd start using these first. The beauty of using SharePoint is that you don't have to worry of the primary ID column since it is automatically generated. Now, things get interesting for the formulas because you run into delegation issues depending on the combination you use. Start small and work your way through, I personally believe it is worth it.
Excellent how to series!! One question, when I create a list from an existing excel file the and later I try to add/edit a column there is no "lookup" feature. It only appears when I create a list from scratch. Is this some kind of SPO limitation? Thank you in advance!!
Thanks for the compliment Panos. I've noticed that too and yes, that is a limitation but by design. The only two ways I created lists are either manually or using an existing list.
Great video Daniel, thank you. Q: Are the fields in the various lists 'Lookups' to other lists? I'm struggling to understand where the Links come in, are they made via the SharePoint Lists or are they created in the App?
Hey Jah015, It depends on the situation. If I cannot use it then I simply hide it from the list view. If you want to add some data then do do a combination of user-date.
Hi Daniel, I really like your videos (not only this one but all of them), I have one question regarding this one, why refer to the item's ID and not lookups to the actual item? I'm thinking of this from a reporting point of view.
Well Thanks, Mr Daniel you did it again a very nice self explanatory video of list relationships. But, I have a question why you are saving your data into 3 separate lists? what if one of the list gets deleted or some data loss? the whole model will break down? what if you save the data into one list, which is easily manageable and for backup purposes. Kindly clear me out on this
Your are welcome, Mustafa. Saving everything in one list will add you to a never end cycle of constantly adding more and more columns. Also, depending on the data entry, some items will have empty columns which can get confusing. Finally, it makes handling permissions much simpler. For lists that are used for dropdown values, you can set them as view only. Hope this helps.
Hello. Have a question regarding saving data from powerapps to an excel form. I want to register things in powerapps, and that it is added to a new line in an excel form. Is this possible? Do you have any video of this? Hope you understand what I mean :-)
Hi Frode, Technically, it's possible as long as the Excel spreadsheet is sitting in either OneDrive or a SharePoint document library. However, I highly recommend not using Excel to save data. You are going to run into limitations soon. If licensing is the main reason then use SharePoint lists.
Thank you Daniel. I am the IT support for my wife's business. I have an access database that I want to transform into a SharePoint/power app solution. The database has existing primary key/foreign key relationships. The client table has Primary Key ClientID, which is a foreign key in the exam table (eye exam - she is an optometrist). The ClientID autoincrements for each new client. Is there a way to bring in the data and maintain the existing relationship? Your comment is appreciated! Myles
Daniel. Great App! If I want to get more in depth with PowerApps and either SharePoint or OneDrive as my storage, where would you recommend I learn more?
Hi Daniel - do you have any special advice related to working with SharePoint lists more than list view threshold of 5,000 records in Power Apps? I have a customer where the primary list for their Power Apps app is going to run over 5,000 records in 6 months and I want to make sure my queries and filters are ready to handle that without things breaking.
Hey Will, Take a look at my video on large data sets. It will show you how SPO lists with 40K+ items work successfully as long as you use the correct functions. czcams.com/video/IvTiAanB3Cs/video.html
@@DanielChristian19 Fantastic! I can't believe you have a video on the exact thing I need to learn about. Look forward to seeing you in person again after this pandemic!
Great video! Looking forward to the others. Do you have the link to the app in day you mentioned in the video? I'd like to try and build it so i can try modify it to follow along with this video. Thanks!
Hi Daniel, just to confirm in the Request List, is the MFR ID, Shipping ID, Device ID and location ID using the "LookUP" column to each of the SP list above? Or just a normal single line? Please reply, Thanks!
@@DanielChristian19 thanks Daniel, fantastic videos. Do you have any videos about locking down SP to make it as secure as possible for a powerapp, aka where it's preferable that users wouldn't find the SP and if the did, minimise what they could see?
Thanks for sharing your knowledge Daniel, however I found this video difficult to watch. You are getting often too deep into small not important details, jumping quickly from one thing to the other, adding some remarks which might be a bit out of the topic as they just pooped out in your mind. This all getting me confused. I do understand relational data bases and this is the only reason I knew what you want to show on the slides, wouldn't it be better to show relations the way you can see it in relations manager in MS Access or Power BI? I think that if you have a decent plan of presentation and if you try to avoid meandering between topics it could be quite good. You have a good knowledge but need to work on the way you are presenting it.
Just WOW! I admit I was bracing myself to be overwhelmed, but you explained things so well and so logically that I followed along just fine. Ready to dig into Part 2 tomorrow 😃 Thank you, Daniel!
*Awwww* Thanks Julie.
This is EXACTLY what I've been trawling YT & the internet for! Looking forward to the next ones. Subscribed. Thank you!
Awesome! Thank you!
Also amazed at your very clear explanations. I haven't developed an app in years, so I am super excited to get going with all of these prebuild components! Thank you, Daniel!
Glad it was helpful!
I am new to SharePoint and have not had much use for it in the past but THIS is something I can use it for (especially for data that does not need a SQL database). Thank you!
Glad it was helpful!
Wow! Just Wow! I’ve been trying to figure this out. Thank you so much!
The first concept Daniel is explaining is called data normalization.
Instad of having a lot of repetition in a single table he uses relationships.
I’ll be honest, I created a an 1 list to have all info. This video is so helpful!
Woww Daniel!! For the 1st few minutes I felt it more complicated, at the end of the video it made me feel simple. Amazing approach! Much excited to know how you brought the data on to the app and how you saved back to respective lists. Please bring them on!
Thanks for the compliment Ramesh. Stay tuned for #2 and #3.
Hi Daniel, This is the helpful content. I'm just learning about powerapp and your content makes me easier to understand.
Great to hear!
Great job, Daniel! Learned a lot and i will definitely try this in our org. Looking forward for the next video.
Awesome, thank you!
You are an amazing teacher. Thank you so much!!!
Wow, thank you!
Hi Daniel, thank you for the video series. Just a kind recommendation: I believe you would save yourself energy (and video time) if you assume and state that people watching this part 1 should know what is a relational database.
Thanks Julien, for the feedback. I'll plan to do that for my next series of videos.
excellent video Daniel, best I have seen so far and first that delves into the relationship component of lists.
Wow, thanks Darren. I'm working on the Part 4 video which has been requested several times on how to build those primary lists. That video will help complete this series.
Hello Daniel,
This is perfect point A to Point B.
Thank you so much...
Thanks for the compliment. I'm pretty much a 'Point Am to Point B' kinda guy 🙂.
Great video. Thanks for your effort. All the best
Your welcome Jacek. Thanks for the compliment
Muito bom!!! realmente me deu uma nova visão de sharepoint, agora vou olhar os outros videos! congratulations!
Thanks for the compliment.
Great, It's the best Power Apps tutorial with real case. Thank you.
Glad you like it
Might want to use the single-line column for the postal code to manage Canadian and other foreign alpha-numerics. Great video.
That's a great idea!
this was super-informative. I am looking to build a fairly intricate app and thinking about the relationship matrix and what my lists are really helped me to process how I will approach this project. thanks!
Glad it was helpful! I'm working on video #4 to focus on the primary SharePoint lists as well.
@@DanielChristian19 awesome. I'll likely use all the videos. Thanks for doing what you do.
IDK y u have so low likes, U r amazing Sir.
I Actually Understand what u say.
Thanks for the info.
Hi Bhavya,
Thanks for your compliment. My CZcams channel is slowly growing. Feel free to share it with you co-workers, friends and family.
@@DanielChristian19 Sure sir, Definitely.
Hi Daniel, your videos are just amazing. And these series of three give me confirmation I needed to build the structure of my next app (project management app with comments and additional tools). Keep going and looking forward to your next great video.
Have a nice weekend,
Davide
Thanks for the compliment, Davinde.
@@DanielChristian19 this is not a compliment, but the reality.
Dude, where have you been? So many things I've made wrong lol... Thanks for the video series. Instantly subscribed, keep it up!!!!
Thanks for the compliment Fernando!
Great explainnation! This is what I was looking for! - Thank you so much!
Thanks Rasheed.
New subscriber thanks for a great video. I was going to ask about the choice of number column vs lookup column for the linking but I noticed it was asked and answered. Thanks again.
Glad it was helpful!
Great Stuff! Thank you, Daniel! 😘
Glad you liked it!
This is a wonderful explanation of this concept. Thank you. :)
Hey Connie,
Thanks for the compliment and glad to hear it was helpful.
Perfect. Any video how we assigned custom ID instead of automatic ID of SharePoint Lists?
Any chance you would share that PowerPoint with us also? This is EXACTLY what I need to solve a HUGE task at hand, and I am so excited to dive into these three videos today!
Hi Kiley,
Here's the link to download my PowerPoint file --> bit.ly/SPOplanning
@@DanielChristian19 Any chance I could get you to take a peek at this issue I posted and see if you have any thoughts? powerusers.microsoft.com/t5/Building-Power-Apps/Link-item-in-concat-string-on-detail-screen-to-clicked-item-s/m-p/699275
Hi Kiley,
I read through your post. Try adding your formula to either the rich text control that allows HTML. Might have to use the Launch function. If that doesn't work then consider using a button.
Thank you! I got a lot out of this video!
I'm so glad!
This is very well explained , Thanks.
For an end user we might need to give an admin App to upload the data as well. Please plan some thing of that type.
Amazing! This is really helpful! :)
You are most welcome and thanks for the compliment.
Ok...this was a good choice...nice job
Thanks Scott! Keep PowerApping!
Thanks!
WOW
Thanks Justine for the donation! I highly appreciate that.
wow! this is really good...
Thank you so much!
Amazing video Daniel 😄
Thanks for the compliment Srirangam. Stay tuned for the remaining two.
I may have missed it, but why have you chosen to create several different lists and associated them rather than have one list with all these relationships being handled as filtered views of the various columns?
Having all the columns in a single list increases the overall number of items (rows) you will have to manage. Yes, you can filter them using a view, but that doesn't decrease the total count of items.
Amazing @Daniel !!! thank you so much.
Glad you liked it!!
Thank you very much Daniel
Your welcome Thamsanqa.
Is part 2 out? 👌🏾
Thanks for this !!
My pleasure, Juan
great video, are these MFRID and location ID in request list of Lookup Type?
I'll have to check and verify but you can also take a look at the video #4 of this series. This vLog shows how those lists were built and the forms to add, view and edit them.
czcams.com/video/csxTmUWSiKQ/video.html
What is the difference between Lists and Sharepoint lists?
Hey Daniel, amazing and thorough explanation! Just a side note, In your description, I think your "app a day" link needs to be "https"
Thanks Jonathan. The link has been updated!
Hey Daniel,
Is there anyway for you to delete an item from the Parent list in this case the (MFR's) list if the child list (Devices) no longer contains the parent's MFR ID. I have tried Remove if MFR id not in Devices MFR ID column but to no avail.
Thank you
Hi Skiptracing,
Yes, there is you can use a combination of filter and remove to get this done. The filter will find the same parent ID in the child list.
Daniel Christian Hi Daniel,
Thank you for the reply, but what i meant was to remove a parent record based on if the parent record id is still being used in the child list. For example if i were to create a new MFR in the parent list called. “ Apple” with the id of “6” and a new record in the child list “ Mac book pro” with a “6” in the MFR id column. If i removed the record “Mac book pro” from the child list(which in this case is the only device with the MFR of “6”), i want it to automatically delete the MFR “Apple” in the parents list, because there is no longer any records in this category. I only want the remove to happen when the MFR id is not being used in the Device list at all(so when there are 0 records with the parent id).
Is this possible at all?
Thank you
Also, i can't get the 'App in a day' link to work
Hey Nick,
Here is the original link aka.ms/appinaday which I tested and it works.
Hi Daniel, Great video thanks.
I was wondering, and I may have missed it in the video, but what column types are you using for the ID references from other Lists? As in, is it a lookup type or are you adding manually to a single line of text column? thanks for your help.
I'm using the Number column type to save the ID. I set the decimal to 0 for aesthetic reasons. Don't use single line of text. Doing that will cause delegation warnings.
@@DanielChristian19 Did you change the column type for the automated ID, or create a new column and manually add the data
Thanks a lot for the video Daniel. It's great and well explained but how do you link up the ID columns in the different lists?
You are welcome! Look at the Part 4 video which focuses on how the lists were related.
In the matrix you have a "Device ID" column that points to the Device List ID but then in the sharepoint list (for example in 14:52) that "Device ID" column isn't there. Am I missing something?
Hey Sace,
The Device ID column refers to the ID column in the Device list. This ID is automatically generated by SharePoint lists.
Would there be any constraints of SharePoint view items limit of 5K?
Hey Prateek,
No constraints from the Power Apps Canvas side.
First part is normalisation
Yes it is.
Thank you Daniel
Your welcome Sundra. Don't forget to Subscribe to my CZcams channel and keep Power Apping!
Great video! Thank you! New subscriber!
Glad you liked it Nina and thanks for subscribing to my channel.
I’ve learned a lot. I will watch all your videos! 👋
Hi @daniel, I´m using PowerApps with SharePoint lists, i´m pretty sure that is not a good practice with E-R model BUT, it is what i have right now!. I apreciate your video because it brings an oportunity to us. Let me know how many data do you think should be the MAXIM to don´t affect PowerApps´s performance ? Thanksss
Hi Diego,
You are welcome. I've mentored Power Apps makers who have had lists with 15k items and others with 20K. As long as you setup your formulas correct i.e. non delegable and archive your lists in a timely manner, you should be fine.
Why are you not just using Dataverse instead of Sharepoint?
To build standalone apps with Dataverse will require additional licenses.
just wow
Thanks!
I really enjoyed this 3-piece series. And I'm planning to use this information to automate a Request for Service form based on SPO (watching you security video on SPO too 😁). However as a newbie to SPO is it possible to get an overview of how the different list are designed with their column types?
Hey John,
Glad it was helpful!
In this three part series the column types I used are:
1) Single and multiple line of text
2) Numerical column. This is where I saved the IDs
4) People and Groups. This helps to gather the names for future workflows. The patch function gets a little complex for these columns.
5) Date and time column.
I stay clear of the lookup and managed metadata column as much as possible.
Amazing content!! Thank you. I do have a question about the relationships. Are you using lookup columns between the lists or do you use a number column and know that a certain ID is the right one?
Example MFR ID =5 for MIcrosoft
If you have a video on setting up the relationships at that basic level I would gladly watch. Your content is easy to follow
Hey Paul,
Thanks for the compliment. I am using number column. Take a look at this video of mine, it will point you in the right direction to setup basic relationships.
czcams.com/video/wpn4dnJJVTg/video.html
@@DanielChristian19 - Again, Amazing content!! I feel like this is possible now. Gone are those tiresome lookup columns.
How can I retrieve data in Power Apps from a SharePoint list based on source list item ID?
What I want to do is have fields like FormID1, FormID2, FormID3, etc. in my Power App solution, and be able to retrieve combinations of item detail from any connected lists on load, using source list ID numbers provided by Power Automate.
How can I do this with Power Apps?
Hey Erica,
This three-part series video I did is exactly for the scenario you mentioned. In a nutshell, you need to have that one table/list which saves the relationships of all the tables using IDs. Then you can relate those ID's using Lookup or Filter and see the data in your forms.
I need help by putting together On primary key list with two extra lists.
Hey Alfonso,
I'm working on the Part 4 video which has been requested several times on how to build those primary lists. That video will point you in the right direction.
Hi Daniel, I'm trying to get to your App in a Day video but the link doesn't seem to work - could you help me out? Thanks!
Hey Suzanne,
You are correct, the link isn't working. Try this one aka.ms/appinaday It will download the zip file which has the training content.
hi, where to find the data files? i couldnt find them on app in a day link
Here you go-
github.com/MicrosoftDocs/mslearn-developer-tools-power-platform/raw/master/in-a-day/AIAD/AppinADayStudentFiles.zip
@@DanielChristian19 thanks a lot, videos are really great but we need to practice to become better 😀
Thanks so much! Quick question on relating the tables: Is there a reason that you choose to use a numeric field type to relate the ID's in the tables rather than using the OOTB SharePoint Lookup field type?
Hi Matthew,
You are welcome!
Patching SharePoint Lookup fields, although not impossible, it can be challenging especially the patch commands. Hence I stick with building relationships.
Thank you for your amazing video!
One questions, on Devices list and accessories list, we already have MRFID and Device ID. How do you get those IDs to be put on the Device list? Is it manually input?
I understand that on Request list and the other yellowish table, we get the ID from within PowerApps
Hey The_Eightythree,
I did set that up manually. It is on my to-do recording list on how I can add, edit and delete that list.
I am building a PowerApps for my practicum, and I am stuck. (I have issues with collection, radio button dependencies, checkbox displaying values.) I believe my issues are because I set up my dataset from excel. Is it difficult to change it to SharePoint? I am assuming that all my expressions will have to change and I am discouraged. Any suggestions?
Hey Carolina,
It all depends on the type of columns you use for the SharePoint list. Single line, multiple line, number, people and group and number are the easy ones to work one.I'd start using these first.
The beauty of using SharePoint is that you don't have to worry of the primary ID column since it is automatically generated. Now, things get interesting for the formulas because you run into delegation issues depending on the combination you use.
Start small and work your way through, I personally believe it is worth it.
Daniel Christian sincerely, thank you
Excellent how to series!! One question, when I create a list from an existing excel file the and later I try to add/edit a column there is no "lookup" feature. It only appears when I create a list from scratch. Is this some kind of SPO limitation? Thank you in advance!!
Thanks for the compliment Panos. I've noticed that too and yes, that is a limitation but by design. The only two ways I created lists are either manually or using an existing list.
@@DanielChristian19 Thank you for the prompt response!!!
Great video Daniel, thank you. Q: Are the fields in the various lists 'Lookups' to other lists? I'm struggling to understand where the Links come in, are they made via the SharePoint Lists or are they created in the App?
Hey Nick,
I stay clear of the lookup column. Take a look at the Part 4 video, it focuses on these primary lists were made.
@@DanielChristian19 Thank you Daniel, this is a really interesting set of videos, and really clearly presented. Thanks for your help.
Hi Daniel, How are you handling the Title column if you cannot repurpose it as a text field?
Hey Jah015,
It depends on the situation. If I cannot use it then I simply hide it from the list view. If you want to add some data then do do a combination of user-date.
Hi Daniel, I really like your videos (not only this one but all of them), I have one question regarding this one, why refer to the item's ID and not lookups to the actual item? I'm thinking of this from a reporting point of view.
Hi, the app in a day link doesn't seem to work.
Hi John,
No idea why it's behaving that way. The link is correct. Try coping and pasting it to a browser aka.ms/appinaday
At run time how to find out max length of a multiline text box ?
Hi Sukrutha,
You can use the Len() function for that.
@@DanielChristian19 length cannot give me the max length (total chars allowed), it can give me only the length of text entered.
Well Thanks, Mr Daniel you did it again a very nice self explanatory video of list relationships. But, I have a question why you are saving your data into 3 separate lists? what if one of the list gets deleted or some data loss? the whole model will break down? what if you save the data into one list, which is easily manageable and for backup purposes. Kindly clear me out on this
Your are welcome, Mustafa.
Saving everything in one list will add you to a never end cycle of constantly adding more and more columns. Also, depending on the data entry, some items will have empty columns which can get confusing. Finally, it makes handling permissions much simpler. For lists that are used for dropdown values, you can set them as view only.
Hope this helps.
@@DanielChristian19 Got it!! Thanks
Hello. Have a question regarding saving data from powerapps to an excel form. I want to register things in powerapps, and that it is added to a new line in an excel form. Is this possible? Do you have any video of this?
Hope you understand what I mean :-)
Hi Frode,
Technically, it's possible as long as the Excel spreadsheet is sitting in either OneDrive or a SharePoint document library. However, I highly recommend not using Excel to save data. You are going to run into limitations soon. If licensing is the main reason then use SharePoint lists.
Thank you Daniel. I am the IT support for my wife's business. I have an access database that I want to transform into a SharePoint/power app solution. The database has existing primary key/foreign key relationships. The client table has Primary Key ClientID, which is a foreign key in the exam table (eye exam - she is an optometrist). The ClientID autoincrements for each new client. Is there a way to bring in the data and maintain the existing relationship? Your comment is appreciated! Myles
Daniel. Great App! If I want to get more in depth with PowerApps and either SharePoint or OneDrive as my storage, where would you recommend I learn more?
Any suggestions?
Hi Daniel - do you have any special advice related to working with SharePoint lists more than list view threshold of 5,000 records in Power Apps? I have a customer where the primary list for their Power Apps app is going to run over 5,000 records in 6 months and I want to make sure my queries and filters are ready to handle that without things breaking.
Hey Will,
Take a look at my video on large data sets. It will show you how SPO lists with 40K+ items work successfully as long as you use the correct functions. czcams.com/video/IvTiAanB3Cs/video.html
@@DanielChristian19 Fantastic! I can't believe you have a video on the exact thing I need to learn about. Look forward to seeing you in person again after this pandemic!
HI Daniel,
Any chance of you sharing your SP lists so that i can try out the whole exercise myself and learn more by doing ?
Hi Rohit,
That is alot of lists to share 😄. You can keep your lists much simpler than what I have demoed.
Great video! Looking forward to the others. Do you have the link to the app in day you mentioned in the video? I'd like to try and build it so i can try modify it to follow along with this video. Thanks!
Hi DK,
Here is the link --> App in a day: aka.ms/appinaday
I've added it to the description as well.
Hi Daniel, just to confirm in the Request List, is the MFR ID, Shipping ID, Device ID and location ID using the "LookUP" column to each of the SP list above? Or just a normal single line? Please reply, Thanks!
Hi FZ,
That is correct I am using the IDs for the MFR, Shipping, Device and Locations list. I'm using a numerical column and not lookup columns.
@@DanielChristian19 thanks for the reply.. Still struggling with my Powerapps 😭 Nice tutorial really helps me a lot! 😅
Do you recommend a teams or communications team site?
Hey Jimbo,
Either one of them work. Plan ahead for the permissions.
@@DanielChristian19 thanks Daniel, fantastic videos. Do you have any videos about locking down SP to make it as secure as possible for a powerapp, aka where it's preferable that users wouldn't find the SP and if the did, minimise what they could see?
Thanks for sharing your knowledge Daniel, however I found this video difficult to watch. You are getting often too deep into small not important details, jumping quickly from one thing to the other, adding some remarks which might be a bit out of the topic as they just pooped out in your mind. This all getting me confused. I do understand relational data bases and this is the only reason I knew what you want to show on the slides, wouldn't it be better to show relations the way you can see it in relations manager in MS Access or Power BI? I think that if you have a decent plan of presentation and if you try to avoid meandering between topics it could be quite good. You have a good knowledge but need to work on the way you are presenting it.
Hi Pawel,
Thanks for the feedback.