Huge thanks to you Shane. I've been watching your videos for some time now and they've been a massive help. Having watched this video some time ago, I'd forgotten all about "Explicit Column Selection" and it's been causing me no end of frustration, as soon as I saw your explanation once again, I knew exactly what had been causing me so many problems. I hope you can find some time to do some more videos on 'FlexiDataMegaVerse' (or whetever it's called these days), [hint] It would be great to see something on Navigating many-to-many relationships in canvas apps. You have my undying gratitude. Thanks again.
@@ShanesCows I'm beginning to wish I hadn't !! I can't get any of my galleries to refresh / update when linking records together 🥲 Looks like I'm going to have to roll out a few more collections.
You keep answering all my questions, and even the ones I still didn't have when I saw the video, but sure I was going to have later on. Thak you so much dude!.
Unrelated question: I have a gallery that breaks the words of some text I'm trying to memorize using the split function. Then I'm using Set(hint01,Concat(FirstN(Gallery1.AllItems.Title3,5),Title3&" ")) as a variable that becomes the text for a label to give the first five words of the text I'm trying to memorize. Any tips how to get code for the next five words and then for the next five words after that?
The With() fonction... I did not know it existed :( Now I do! I wanted to work with temporary variables for so long like I did with python in Dynamo. Declaring a global variable just to use in formula was a waste. Thank you!
Hi Shane, always liking the video's you create. Keep them coming! That said, i want to know if there is a possibility to shown the relationship between grandparent > parent > child relationship. Basically showing all the "grand children" in one view based on that one grandparent. BR Rob!
Rob this video talks about parent/child. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-DylxsXIUyDc.html Take the concept and yes you can add grand parent :)
You said that the primary key field is the same name as the entity. For almost all cases that is true. However, it is possible to have created the entity with the key field text being different than the entity name. In fact, you can edit the key field name. Just something to be aware of. Having them named the same makes the dot notation confusing too. If you want to compare records by GUID you might write Account.Account which means AccountRecord.AccountGUID. Fun stuff. 😂
Hi Shane, In the dropdown you created. The item was 'Chewy Toys'. How did you tune the dropdown to pick the 'toy name" and not something else like 'toy description'
Hi Shane, I'm from Brazil and always followed your videos. I am always learning something new from them. Do you think about doing some content about integrating power apps with smarthome?
Hi Shane, Thanks for these videos in CDS powerapps Could you please share us few more videos of CDS & PowerApps Role base management using both How to create a record/request once an entity/ table created in cds Limitations, performance etc etc
Hi Shane!, thanks for the video... just a question, how can I have a default selected item using relationship? because I can´t just use a value because is different and as I save it, It doesn't work.. "value must be a data entity record"
hello, Mr. Shane young I am a big fan of your videos. I always prefer to follow your videos when I get a problem in Power Apps. But can you tell the what is the name of the back-end language that we use in Power Apps?
Shane could you please do one video showing how to make one app using two different PowerApps templates? May be it’s little difficult but just wanna see what sort of things we need to take care while doing same.
Love your channel, Shane! I have been STRUGGLING to figure out how to filter a table on the 1 side of a 1:M relationship. The scenario in a nutshell: I have a table VacationRequests that has a lookup field to table Employees (i.e the employee who made the request). I want show Employees in a gallery that DO NOT have a VacationRequest scheduled on a given day. I have tried too many combinations of FILTER and LOOKUP to list but still can't quite get it. Do you have any suggestions or functions/patterns that I could research?
Great as always! One question: I have a big report with over 100 columns. I want to have it splitted in different tabels. But then i need a relationship one-to-one (as each record hold data for one test report ). How to solve it in best practice? Any video about that?
@@djpowerage Not straight forward. I cannot find a way to use one-to-one so I had to use one-to-many. Works OK for me. I just use one column in "main" table as a reference in other tables.
Don't have an "Entities" option under Data. Having a hard time creating a relationship with 2 SharePoint lists. For example, the app is displaying ID number 3 (ThisItem.CUST_ID) instead of pulling the actual name from the 2nd table. It should be accomplished with Filter function right?
Hi Shane and thanks for this video, very interesting and unveils the mystery of CDS, for me at least. I have a M365 E3 license, don't have a standalone Power Apps license, and I could follow along this video's tasks, but, will it be deleted at some point of time where Microsoft decides it's time enough of CDS testing without a standalone license, whether single apps or unlimited apps? Maybe it's a question for Microsoft directly.
Great video to get started. One question that really bothers me: If in this case Chewy trackers has a 1:N relationship with Toy (so you could have multiple toys in one record) can I use patch function like 'The Toy' : toygallery, where toygallery is a gallery that has records of toys in it?
@@ShanesCows Great to know. The syntax is also a bit odd to me (been coding with C# and I am trying to use syntax from there constantly :D). Thanks for the great tutorials!
Hello Shane, thanks for sharing this video. I would like to ask if you have a video showing how to transform and sync data between Dynamics CRM 365 online and SharePoint online list using Dataflows.
I do not have one that specific. I do talk about Dataflows and SharePoint a bit in this video if it helps ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-BhLqg1jsbTI.html
This didn't work for me at all. I have Table1 that has a many to many relationship to Table2. I wanted to show all of the related image columns on my canvas app where there was a match between Table1 and Table2 only. There is no specific column in Table1 that stores a value. It is only in Table2. And, I only have the relationship to work with in order to get that result but I can't seem to get it. In your example, it seems that you have a specific lookup column in one table that connects to another table. I don't have that.
Hey Shane! I have seen lots of your videos and you explain things in a really easy way to understand. I have two big sharpoint sites using complex workflows that send custom tasks to our users (where they need to fill in custom fields, using content types). Nothing fancy, but users can do the tasks and I can save their responses to a list and act depending on what they filled. How can I do that with powerapps/power automate?
Create an app that asks for the input you want. Maybe combine deep linking ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-A5Pi5P2YKds.html to send them to the exact item you want to input?
Shane Young no kidding, I watched your deeplinking video just 2 hrs ago and it gave me that idea. I am working on my app and I am using galleries (repeating tables) just as your videos showed. I have a sharepoint list that has a choice column that I need in that gallery. How can I connect the drop down control in the gallery to the choice column in my sharepoint data source so it has the same choices?
Hi Shane, thanks for these awesome videos! They've been helping me a lot! I'm creating an app using existing related data out of Business Central. I've created entities in CDS which sync both ways with Business Central to the respective tables. My question is, how do I create relationships between these entities using the existing keys and thus keeping the relationships already there?
Yikes. Not saying it isn’t possible but I have never done it. You have the is field so I think you could remake the connection indirectly with using the Lookup function
Great video, with a lot of nice little tricks ;) But, how would you go around to filter a gallery, to only shows records, that has related (child) records. I.e. only show 'parent records' that has related 'child records' - where the relationship is: parent 1 : m child.
I'm a bit confused, when you use the word "Record" to describe a field of an Entity (28:46 and so on). What exalcty is the record you are referring on this precise moment?
Hi, Video is great for learning and when the data is new but has anybody got any guidance on how to relate multiple data tables that already have a unique column created in Excel, other than using Lookup in the Power App so that I can make use of the dot notation?
Hi Shane, thanks for sharing this video. Question: Have you tried filtering lookup field for null or empty value? I have tried IsBlank function but power apps is giving me a delegation warning.
@shane, I have noticed the 500/2000 record limit for a Powerapp in Teams. I have a Prospect Spreadsheet with about 5,000 rows that I would like to expose to a Business Development Team to help curate and enhance the data. Ideally I would do this with a Power App but the record limit seemingly prevents this. Do you have any suggestions?
David look at this video on Delegation for a deeper explanation. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-UaBmVUQx_Fk.html 5,000 items does limit you. Just have to work smart.
Hi shane can you please let me know after loading table structure from sql server can you write back the data using power apps in sql server empty table using model driven power apps ? if so could please post some video on that
Shane - Have you talked about the Relate and Unrelate functions? Would to see your take on when and how to use them. docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-relate-unrelate