Тёмный

Power Apps: Planning SharePoint Lists Relationships 

Daniel Christian
Подписаться 26 тыс.
Просмотров 110 тыс.
50% 1

This is a beginning of a three-part video series on building advanced Power Apps app using SharePoint lists as the data source. This series focuses on how the relationships are built across the lists. The three part series comprises of:
1) Planning SharePoint Lists Relationships
2) Initial build of the app using the relationships to view data
( • Power Apps: Planning S... )
3) Final build of the app saving data with the relationships. (End with how easy this makes the future Power BI report) ( • Power Apps: Planning S... )
Here is the link to the App In A Day workshop I've mentioned in the video.
aka.ms/appinaday
Interested in my blogging gear? Then take a look at them on Amazon:
- Blue Yeti USB Mic for Recording & Streaming on PC and Mac - amzn.to/3d9g7bY
- Microphone Stand, Mic arm Desk Adjustable Suspension Boom with accessories - amzn.to/2N0YNLp
- Neewer 2 Packs Dimmable 5600K USB LED Video Light with Adjustable Tripod - amzn.to/3qteqdf
- Flexible Desk Mount Clamp Gooseneck Stand for Logitech Webcam - amzn.to/2Ozc4eH
- Sunpak tripod - amzn.to/3jJeov2
- Logiteh C922x Po Stream Webcam - amzn.to/3aZlqrt

Наука

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

 

8 июл 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 171   
@sweetpickel
@sweetpickel 3 года назад
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!
@DanielChristian19
@DanielChristian19 3 года назад
*Awwww* Thanks Julie.
@RVidz100
@RVidz100 3 года назад
This is EXACTLY what I've been trawling YT & the internet for! Looking forward to the next ones. Subscribed. Thank you!
@DanielChristian19
@DanielChristian19 3 года назад
Awesome! Thank you!
@jaspurbeck
@jaspurbeck Год назад
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!
@DanielChristian19
@DanielChristian19 Год назад
Glad it was helpful!
@ResponsibleXI
@ResponsibleXI 3 года назад
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!
@DanielChristian19
@DanielChristian19 3 года назад
Thanks for the compliment Ramesh. Stay tuned for #2 and #3.
@mikedsjr
@mikedsjr Год назад
Wow! Just Wow! I’ve been trying to figure this out. Thank you so much!
@darrenturner4812
@darrenturner4812 3 года назад
excellent video Daniel, best I have seen so far and first that delves into the relationship component of lists.
@DanielChristian19
@DanielChristian19 3 года назад
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.
@ericweakley5477
@ericweakley5477 3 года назад
Hello Daniel, This is perfect point A to Point B. Thank you so much...
@DanielChristian19
@DanielChristian19 3 года назад
Thanks for the compliment. I'm pretty much a 'Point Am to Point B' kinda guy 🙂.
@yadanada8396
@yadanada8396 3 года назад
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!
@DanielChristian19
@DanielChristian19 3 года назад
Glad it was helpful!
@davidemercadante2406
@davidemercadante2406 3 года назад
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
@DanielChristian19
@DanielChristian19 3 года назад
Thanks for the compliment, Davinde.
@davidemercadante2406
@davidemercadante2406 3 года назад
@@DanielChristian19 this is not a compliment, but the reality.
@TheArmando00
@TheArmando00 2 года назад
I’ll be honest, I created a an 1 list to have all info. This video is so helpful!
@_sonicfive
@_sonicfive 3 года назад
The first concept Daniel is explaining is called data normalization. Instad of having a lot of repetition in a single table he uses relationships.
@rasheedkhanmohammed5406
@rasheedkhanmohammed5406 3 года назад
Great explainnation! This is what I was looking for! - Thank you so much!
@DanielChristian19
@DanielChristian19 3 года назад
Thanks Rasheed.
@forioktavianto3022
@forioktavianto3022 3 года назад
Great, It's the best Power Apps tutorial with real case. Thank you.
@DanielChristian19
@DanielChristian19 3 года назад
Glad you like it
@juliusmebalo3510
@juliusmebalo3510 2 года назад
Great job, Daniel! Learned a lot and i will definitely try this in our org. Looking forward for the next video.
@DanielChristian19
@DanielChristian19 2 года назад
Awesome, thank you!
@careyjohnson6630
@careyjohnson6630 2 года назад
You are an amazing teacher. Thank you so much!!!
@DanielChristian19
@DanielChristian19 2 года назад
Wow, thank you!
@conniebraley1213
@conniebraley1213 3 года назад
This is a wonderful explanation of this concept. Thank you. :)
@DanielChristian19
@DanielChristian19 3 года назад
Hey Connie, Thanks for the compliment and glad to hear it was helpful.
@apichatmeesaeng5999
@apichatmeesaeng5999 2 года назад
Hi Daniel, This is the helpful content. I'm just learning about powerapp and your content makes me easier to understand.
@DanielChristian19
@DanielChristian19 2 года назад
Great to hear!
@saveeshmply
@saveeshmply 3 года назад
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.
@crwebers
@crwebers 2 года назад
Muito bom!!! realmente me deu uma nova visão de sharepoint, agora vou olhar os outros videos! congratulations!
@DanielChristian19
@DanielChristian19 2 года назад
Thanks for the compliment.
@herbertkunze3610
@herbertkunze3610 3 года назад
Great Stuff! Thank you, Daniel! 😘
@DanielChristian19
@DanielChristian19 3 года назад
Glad you liked it!
@jacekbrychcy7880
@jacekbrychcy7880 2 года назад
Great video. Thanks for your effort. All the best
@DanielChristian19
@DanielChristian19 2 года назад
Your welcome Jacek. Thanks for the compliment
@awimanu3221
@awimanu3221 3 года назад
Amazing @Daniel !!! thank you so much.
@DanielChristian19
@DanielChristian19 3 года назад
Glad you liked it!!
@sundrapillay6668
@sundrapillay6668 3 года назад
Thank you Daniel
@DanielChristian19
@DanielChristian19 3 года назад
Your welcome Sundra. Don't forget to Subscribe to my RU-vid channel and keep Power Apping!
@labahlabahoren
@labahlabahoren 3 года назад
Perfect. Any video how we assigned custom ID instead of automatic ID of SharePoint Lists?
@juansagarra
@juansagarra 3 года назад
Thanks for this !!
@DanielChristian19
@DanielChristian19 3 года назад
My pleasure, Juan
@sparramore
@sparramore 3 года назад
Ok...this was a good choice...nice job
@DanielChristian19
@DanielChristian19 3 года назад
Thanks Scott! Keep PowerApping!
@SS-zi3ky
@SS-zi3ky 3 года назад
Thank you! I got a lot out of this video!
@DanielChristian19
@DanielChristian19 3 года назад
I'm so glad!
@tenisviejos
@tenisviejos 3 года назад
Dude, where have you been? So many things I've made wrong lol... Thanks for the video series. Instantly subscribed, keep it up!!!!
@DanielChristian19
@DanielChristian19 3 года назад
Thanks for the compliment Fernando!
@nipun399
@nipun399 3 года назад
Amazing video Daniel 😄
@DanielChristian19
@DanielChristian19 3 года назад
Thanks for the compliment Srirangam. Stay tuned for the remaining two.
@amyrah8949
@amyrah8949 3 года назад
wow! this is really good...
@DanielChristian19
@DanielChristian19 3 года назад
Thank you so much!
@7UL13N
@7UL13N 2 года назад
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.
@DanielChristian19
@DanielChristian19 2 года назад
Thanks Julien, for the feedback. I'll plan to do that for my next series of videos.
@joannesoledad799
@joannesoledad799 2 года назад
Amazing! This is really helpful! :)
@DanielChristian19
@DanielChristian19 2 года назад
You are most welcome and thanks for the compliment.
@JeffersonMartinSynfluent
@JeffersonMartinSynfluent 3 года назад
Might want to use the single-line column for the postal code to manage Canadian and other foreign alpha-numerics. Great video.
@DanielChristian19
@DanielChristian19 3 года назад
That's a great idea!
@djerebus
@djerebus 3 года назад
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!
@DanielChristian19
@DanielChristian19 3 года назад
Glad it was helpful! I'm working on video #4 to focus on the primary SharePoint lists as well.
@djerebus
@djerebus 3 года назад
@@DanielChristian19 awesome. I'll likely use all the videos. Thanks for doing what you do.
@mtamitolanga
@mtamitolanga 3 года назад
Thank you very much Daniel
@DanielChristian19
@DanielChristian19 3 года назад
Your welcome Thamsanqa.
@mtamitolanga
@mtamitolanga 3 года назад
Is part 2 out? 👌🏾
@justinwickens7286
@justinwickens7286 Год назад
Thanks!
@DanielChristian19
@DanielChristian19 Год назад
WOW Thanks Justine for the donation! I highly appreciate that.
@davidm203
@davidm203 3 года назад
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.
@DanielChristian19
@DanielChristian19 3 года назад
Glad it was helpful!
@sheilananyitti8136
@sheilananyitti8136 3 года назад
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?
@DanielChristian19
@DanielChristian19 3 года назад
You are welcome! Look at the Part 4 video which focuses on how the lists were related.
@bhavyapatnam7586
@bhavyapatnam7586 2 года назад
IDK y u have so low likes, U r amazing Sir. I Actually Understand what u say. Thanks for the info.
@DanielChristian19
@DanielChristian19 2 года назад
Hi Bhavya, Thanks for your compliment. My RU-vid channel is slowly growing. Feel free to share it with you co-workers, friends and family.
@bhavyapatnam7586
@bhavyapatnam7586 2 года назад
@@DanielChristian19 Sure sir, Definitely.
@matthewgedris8768
@matthewgedris8768 3 года назад
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?
@DanielChristian19
@DanielChristian19 3 года назад
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.
@RACHIMSAJA
@RACHIMSAJA 3 года назад
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
@DanielChristian19
@DanielChristian19 3 года назад
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.
@bujiririemmanuel5091
@bujiririemmanuel5091 9 месяцев назад
just wow
@DanielChristian19
@DanielChristian19 9 месяцев назад
Thanks!
@RadoslavovK
@RadoslavovK 2 года назад
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.
@klayanimation16
@klayanimation16 3 года назад
Great video! Thank you! New subscriber!
@DanielChristian19
@DanielChristian19 3 года назад
Glad you liked it Nina and thanks for subscribing to my channel.
@klayanimation16
@klayanimation16 3 года назад
I’ve learned a lot. I will watch all your videos! 👋
@JohnTromp71
@JohnTromp71 3 года назад
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?
@DanielChristian19
@DanielChristian19 3 года назад
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.
@chahineatallah2636
@chahineatallah2636 11 месяцев назад
great video, are these MFRID and location ID in request list of Lookup Type?
@DanielChristian19
@DanielChristian19 11 месяцев назад
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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-csxTmUWSiKQ.html
@jethrofriggens7704
@jethrofriggens7704 3 года назад
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.
@DanielChristian19
@DanielChristian19 3 года назад
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.
@nancystevens2443
@nancystevens2443 3 года назад
@@DanielChristian19 Did you change the column type for the automated ID, or create a new column and manually add the data
@paulmaclennanc9310
@paulmaclennanc9310 3 года назад
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
@DanielChristian19
@DanielChristian19 3 года назад
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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-wpn4dnJJVTg.html
@paulmaclennanc9310
@paulmaclennanc9310 3 года назад
@@DanielChristian19 - Again, Amazing content!! I feel like this is possible now. Gone are those tiresome lookup columns.
@jah0415
@jah0415 3 года назад
Hi Daniel, How are you handling the Title column if you cannot repurpose it as a text field?
@DanielChristian19
@DanielChristian19 3 года назад
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.
@pmertis
@pmertis 3 года назад
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!!
@DanielChristian19
@DanielChristian19 3 года назад
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.
@pmertis
@pmertis 3 года назад
@@DanielChristian19 Thank you for the prompt response!!!
@KileyOhl
@KileyOhl 3 года назад
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
@DanielChristian19 3 года назад
Hi Kiley, Here's the link to download my PowerPoint file --> bit.ly/SPOplanning
@KileyOhl
@KileyOhl 3 года назад
@@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
@DanielChristian19
@DanielChristian19 3 года назад
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.
@Vihushrihu
@Vihushrihu 3 года назад
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 ?
@DanielChristian19
@DanielChristian19 3 года назад
Hi Rohit, That is alot of lists to share 😄. You can keep your lists much simpler than what I have demoed.
@optimisesocialmedia
@optimisesocialmedia 3 года назад
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?
@DanielChristian19
@DanielChristian19 3 года назад
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.
@optimisesocialmedia
@optimisesocialmedia 3 года назад
@@DanielChristian19 Thank you Daniel, this is a really interesting set of videos, and really clearly presented. Thanks for your help.
@diegopaz83
@diegopaz83 3 года назад
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
@DanielChristian19
@DanielChristian19 3 года назад
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.
@jonathanaghachi1464
@jonathanaghachi1464 3 года назад
Hey Daniel, amazing and thorough explanation! Just a side note, In your description, I think your "app a day" link needs to be "https"
@DanielChristian19
@DanielChristian19 3 года назад
Thanks Jonathan. The link has been updated!
@frodesellevoll
@frodesellevoll 3 года назад
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 :-)
@DanielChristian19
@DanielChristian19 3 года назад
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.
@danbingman
@danbingman 3 года назад
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?
@danbingman
@danbingman 3 года назад
Any suggestions?
@mustafahussainmohsin320
@mustafahussainmohsin320 3 года назад
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
@DanielChristian19
@DanielChristian19 3 года назад
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.
@mustafahussainmohsin320
@mustafahussainmohsin320 3 года назад
@@DanielChristian19 Got it!! Thanks
@mylesdavidmorris
@mylesdavidmorris 3 года назад
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
@skiptracing8711
@skiptracing8711 3 года назад
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
@DanielChristian19
@DanielChristian19 3 года назад
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.
@skiptracing8711
@skiptracing8711 3 года назад
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
@WillCooper1
@WillCooper1 3 года назад
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.
@DanielChristian19
@DanielChristian19 3 года назад
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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-IvTiAanB3Cs.html
@WillCooper1
@WillCooper1 3 года назад
@@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!
@fzayub6400
@fzayub6400 3 года назад
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
@DanielChristian19 3 года назад
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.
@fzayub6400
@fzayub6400 3 года назад
@@DanielChristian19 thanks for the reply.. Still struggling with my Powerapps 😭 Nice tutorial really helps me a lot! 😅
@AlfonsoGalindoPellegrin
@AlfonsoGalindoPellegrin 3 года назад
I need help by putting together On primary key list with two extra lists.
@DanielChristian19
@DanielChristian19 3 года назад
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.
@TheSaceone
@TheSaceone 3 года назад
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?
@DanielChristian19
@DanielChristian19 3 года назад
Hey Sace, The Device ID column refers to the ID column in the Device list. This ID is automatically generated by SharePoint lists.
@mehtaprateek2000
@mehtaprateek2000 2 года назад
Would there be any constraints of SharePoint view items limit of 5K?
@DanielChristian19
@DanielChristian19 2 года назад
Hey Prateek, No constraints from the Power Apps Canvas side.
@suzannejennions9239
@suzannejennions9239 3 года назад
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!
@DanielChristian19
@DanielChristian19 3 года назад
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.
@carolinebinet5148
@carolinebinet5148 3 года назад
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?
@DanielChristian19
@DanielChristian19 3 года назад
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.
@carolinebinet5148
@carolinebinet5148 3 года назад
Daniel Christian sincerely, thank you
@chahineatallah2636
@chahineatallah2636 11 месяцев назад
hi, where to find the data files? i couldnt find them on app in a day link
@DanielChristian19
@DanielChristian19 11 месяцев назад
Here you go- github.com/MicrosoftDocs/mslearn-developer-tools-power-platform/raw/master/in-a-day/AIAD/AppinADayStudentFiles.zip
@chahineatallah2636
@chahineatallah2636 11 месяцев назад
@@DanielChristian19 thanks a lot, videos are really great but we need to practice to become better 😀
@ericabrown1622
@ericabrown1622 3 года назад
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?
@DanielChristian19
@DanielChristian19 3 года назад
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.
@disturbedcarrot
@disturbedcarrot 3 года назад
Do you recommend a teams or communications team site?
@DanielChristian19
@DanielChristian19 3 года назад
Hey Jimbo, Either one of them work. Plan ahead for the permissions.
@disturbedcarrot
@disturbedcarrot 3 года назад
@@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?
@Skk1976
@Skk1976 3 года назад
At run time how to find out max length of a multiline text box ?
@DanielChristian19
@DanielChristian19 3 года назад
Hi Sukrutha, You can use the Len() function for that.
@Skk1976
@Skk1976 3 года назад
@@DanielChristian19 length cannot give me the max length (total chars allowed), it can give me only the length of text entered.
@EnlightenedOne90
@EnlightenedOne90 Год назад
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?
@DanielChristian19
@DanielChristian19 Год назад
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.
@optimisesocialmedia
@optimisesocialmedia 3 года назад
Also, i can't get the 'App in a day' link to work
@DanielChristian19
@DanielChristian19 3 года назад
Hey Nick, Here is the original link aka.ms/appinaday which I tested and it works.
@user-yk7vz9lh1m
@user-yk7vz9lh1m 4 месяца назад
What is the difference between Lists and Sharepoint lists?
@issiewizzie
@issiewizzie 3 года назад
First part is normalisation
@DanielChristian19
@DanielChristian19 3 года назад
Yes it is.
@dkfresh6656
@dkfresh6656 3 года назад
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!
@DanielChristian19
@DanielChristian19 3 года назад
Hi DK, Here is the link --> App in a day: aka.ms/appinaday I've added it to the description as well.
@johnpaul5836
@johnpaul5836 3 года назад
Hi, the app in a day link doesn't seem to work.
@DanielChristian19
@DanielChristian19 3 года назад
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
@pranavjain8498
@pranavjain8498 8 месяцев назад
Why are you not just using Dataverse instead of Sharepoint?
@DanielChristian19
@DanielChristian19 8 месяцев назад
To build standalone apps with Dataverse will require additional licenses.
@curiousape001
@curiousape001 3 года назад
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.
@DanielChristian19
@DanielChristian19 3 года назад
Hi Pawel, Thanks for the feedback.
Далее
The tactic worked 😂#shorts by  Leisi Show
00:26
Просмотров 3,7 млн
Power Apps Editable Table
20:42
Просмотров 131 тыс.
Choose a phone for your mom
0:20
Просмотров 6 млн
Так ли Хорош Founders Edition RTX 4080 ?
13:00
🛑 STOP! SAMSUNG НЕ ПОКУПАТЬ!
1:00
Просмотров 358 тыс.