Power Apps working with SharePoint List Relationships
ฝัง
- เผยแพร่เมื่อ 15 มิ.ย. 2024
- In this beginners video tutorial on Power Apps working with SharePoint List Relationships we will learn how to connect PowerApps to multiple SharePoint lists which are related. We will showcase the related SharePoint Lists in Power Apps galleries and forms and relate the lists together using the internal identity (ID) column of SharePoint Lists. The SharePoint lists will be related to each other in a one-to-many relationship. We will create/update tasks in the related list for reach item created in the main list.
Table of Contents:
00:00 - Intro
00:26 - SharePoint List Relationships Setup & Planning
02:43 - Create Forms for multiple SharePoint Lists (related lists)
10:22 - Show SharePoint List Item related tasks in a Gallery
14:26 - Create an item in the main SharePoint list & add related items
17:46 - Show related tasks for a selected SharePoint list item
19:14 - Create/Update a related item for a selected list item in SharePoint
22:20 - Subscribe
#PowerApps #SharePoint #Lists - วิทยาศาสตร์และเทคโนโลยี
The fun never ends! I'm amazed everyday with the capabilities of powerapps
The fun never ends
This is a TRUE CAREER SAVER... Thank you so much Reza and God Bless!!!
Thank You for watching and supporting my channel 🙏
Incredible! I love how you are straight to the point and concise in your direction. Very easy to follow, understand, and learn. Thank you.
Glad to hear that! Thank You for watching
Reza, thanks for another amazing tutorial. You make it so clear and bring the good level of detail. It creates such nice opportunities to change the way we work today !
You're very welcome!
I just binged about 30 of your videos during my flights this last weekend. The information you provide is unbelievable...how do you not have 1M+ subscribers?! Thank you for taking the time to make the videos that you make!
Thank You for the support and appreciation for the videos.
One of the best videos I’ve seen on power apps... thank you!
Thanks Ben
This might be my first time leaving a comment on any TH-cam video anywhere, but this was so incredibly helpful to my office. Thank you for creating such a detailed and thoughtful walk-through!
You are so welcome!
Reza, the way you explain this is amazing! I learn from you as if I were thinking with you. Thanks for your video!
Happy to hear that! Thanks so much for watching and learning.
Reza, your content is just amazing!!, well thought out and explained. Cannot thank you enough for educating me on my PowerApps Journey.
Thank You so much! Makes me so happy to know the videos are useful and being appreciated.
Thank you so much. This is what I have been looking for in my next step of playing with power apps.
You are welcome!
Reza as well as Daniel...my two powerapps heroes. Keep it up guys. Love lots from Philippines. :)
Awesome! Thank you!
Thanks!, I have been learning and mastering Power Apps thanks to your videos!
Great to hear and thanks so much!
finally found solution at your video...no one can beat you in powerapps training video...thanks man!
Wow, thanks man.
Your videos are so great - incredibly helpful, thankyou!
Glad to hear that! Thank You for watching
Your solutions are always incredible!!!
Thank You :)
Thanks so much, you have amazing content on these programs!
Glad you like them!
Absolutely fantastic tutorial Reza :) You saved me with this one. Thank you!
Happy to hear that! Thanks for watching.
This is great Reza, i have been working on a risk register with actions as a separate list and this will help me big time. thanks mate. much appreciated. great work.
Glad to heat that. Thanks for watching.
Very good. Thank you from showing all examples for relation with different lists...
Your most welcome
Reza, Another great video. Thank you!
You are most welcome
Your're the special one Reza!
Thank You 😊
This is brilliant to sort and manage the data.. thank you for the tutorial
Awesome
this is so cool Reza ...thanks again for showing how easy to connect 2 SharePoint lists within Power Apps with your excellent explanation. Kudos to you brother!
Thanks Aroh
@Reze this is brilliant, I have been looking for this solution for months!
Looks like I would have to go thru the video a few more times in order to get it right.
Once again! thanks for sharing!
Glad to know the video is useful. Thanks for watching.
Another brilliant and informative video. Helping us learners build our skills and knowledge. Thank you again Reza.
Most welcome
Exactly what I needed, Thank you Raza!
You're welcome 😊
This video solved many my issues i had with SPO relationships and provided lots of ideas how can i improve my app. As always, many thanks for your work :D.
Glad to hear that! Thanks for watching
Wonderful Reza!! Thanks for sharing your very useful experience!!
Glad it was helpful! Thanks for watching.
You explained this wonderfully. Well done.
Glad you liked it
The way you explain is amazing.
Thank You
Hi Reza, Awesome, I've learned so much to your lecture's... -->>direct and precise explanation. Thank you!
You are most welcome and thanks for the feedback
Great work, thank you for your great ideas and work
Glad you like them!
awesome! This will work perfectly for tracking revisions.
Great!
Nice and useful video. Inspired by your video when figuring out how to use Power Apps & Power automate.
Looking forward to watching your upcoming videos!
Great to hear! Thank you for watching.
Many thanks for such useful tutorial, Reza! It's help a lot and I'm more confident to use Power Apps.
Glad to hear that! Thank You for watching.
@@RezaDorrani most welcome 🌹
Good stuff! Thank you Reza!
Your most welcome
Hi, Reza. You are brilliant and have excellent representation skills. I am very new to power apps, but when I watch your videos, It feels very interesting. I have watched your other videos also and liked those. Thanks a lot sir.
Happy to hear that! Thank you for watching and following my channel.
Excellent explanation I enjoyed watching.
Thanks for watching
More awesome stuff Reza. You’re a very good educator. Please keep it up.
Much appreciated
Hi @Reza Dorrani,
Thank you very much for your video, it is very well explained and easy to follow.
Most welcome and thanks for watching
This was good! Can't wait to implement
Thanks
Thanks Reza excellent video
My pleasure!
explained very good thanks a lot
Glad you liked it!
You’ve got great kit!
Thanks
Nice tips.. You made SP Relations very simple using PowerApps
Thank you
This is exactly what I am looking for to assist me with a work project. Thank you for your thorough explanation of the process.
Glad to know the video is useful. Thanks for watching.
Hello Reza. I don’t suppose you would put together a video to demonstrate how to use a repeating “child” form (e.g., like your editable grid videos,) that links to the parent record? As an example, extending this concept keeping content as the parent but having related tasks as the child with repeating editable rows?
@@geoffmckeon5902 I will add this request to my backlog but chances are very low since I make videos once I have many folks requesting a particular topic.
I would recommend you check on the forums at powerusers.microsoft.com
@@RezaDorrani I am also interested in the topic Geoff McKeon mentioned above.
Its in my backlog
Thank you. I really love your channel.
😊
@@RezaDorrani I would like to subscribe to your channel. For some reason I didn't see any button or area to do so. Thanks.
@@gideon17you Try th-cam.com/users/rezadorrani link and see if it works.
@@RezaDorrani I just did. It works! Thank you.
Wow so informative...it helped me alot ...you are of great help ..best of luck ...keep posting always
Thank you :)
Just what I needed.
Great!
I've got a good one for ya. Do a video on the MS To-do connector. I don't see any it it seems to have some upside.@@RezaDorrani
@@MichaelDeBlasis1369 Very few requests on that topic and hence did not invest time in it.
Very good video !
Thanks
Woww . I will modify it to be my "Store Distribution" process. Thank a lot . (One Request to Many items)
You are most welcome
Thanks!
Thank You
Watching this after the recent dataverse video. Will try this approach next only with a lookup column. Thanks Reza
Excellent! Thanks for watching.
Remember Dataverse is truly a relational database. SharePoint is not :)
@@RezaDorrani yes one could say that sharepoint is intended to be the gateway "drug" for dataverse.
@@yannis18 :)
Great vídeo!!
Thank You
¡Gracias!
Welcome
Hi Reza
You are awesome !, This your video very useful for everyone starting develop power apps and understanding how both power apps working with share point online. Well, the demo case can apply to many use cases in the future and good reference to make it easily for new developer.
Well, I wanna say supper thank you here.
Glad to hear that! Thank You so much for watching and liking the videos.
Reza,
First, I want to thank you for your continued contributions to the Power platform community. Second, in this video I have all the parts working completely until, 7:33 when you display the "Ref Id" on the actions form. My varRecord is working perfectly on Content form but for some reason with the following formula i cannot populate the "Ref Id" field in the tasks form: If(taskFrom.Mode = FormMode.New, varRecord.ID, ThisItem.'Ref Id'. The only difference is that on my SharePoint list my 'Ref Id' is a lookup column that points to the 'ID' column of the Content List. You mentioned using a lookup in your video at 2:18 but, never gave any other info on the "Ref ID' lookup. Thanks again!
Thanks for watching and liking my videos.
The lookup column I mentioned is also an option. But my video does not cover that pattern. I showcase it differently.
I will have to look at your App in action to provide guidance and know more about your issue. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
hey, I have the same issue you had. just wondering if you found the way to solve it. If you did, could you please tell me how or where to find the solution. Thanks in advance!
Hello there,
I have the same issue where I want to prepopulate a lookup column, did you find a solution ?
Useful video as always, I wished the video included an explanation of adding row number in gallery. Thanks for sharing, keep it up
Thanks for watching.
Great work Reza. This is excellent. I have been struggling with this concept of repeating table. What if i need to maintain the main form with data and a subform, in a tabular view, where new rows are created for each new entry in the subform (in that case a table) and make one commit to store all records both for the main form and subform without the user moving back and forth.
Here the key is to get the ID of the main form before user starts adding sub forms. You could just patch the main form first and then in same function start patching subforms but if main form submission fails for some reason, then user will be left in an inconsistent state. There is no rollback feature in Power Apps with relation to SharePoint.
In this video, after user submits main form, I redirect user to home page. Instead of that you can keep user on the same form page, where they can straight away start adding subforms.
great explanation
Thanks
@@RezaDorrani I am doing your excercise, but when I create the form, for the field "Ref ID" i get a dropdown column.. I tried to change it to a text box column, but i cannot, could you please give me a piece of advice?
@@marcovilla2112 I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/
@@RezaDorrani thanks! will do it
Hi, thank you for the brill tutorials. I have learnt so much from them. I was wondering how this would work in power automate with relationship lists. I have managed to figure out ID to ID but can not figure out how to send a html table to the manager allocated in list 1 that is responsible for those items in list 2 as the only thing that connects them is the ID? Thank you :)
I do not have a specific video on this use case. Answer would be through filter queries.
Check my video on odata query using flow - th-cam.com/video/yeAnuTB85eg/w-d-xo.html
Hi Reza. Thank you very much for your videos, they are incredibly useful. I had a question though. What if instead of a single screen form you need to relate the gallery to a multiple-screen form (using patch instead of submitForm)? When I use patch the ID of the main form doesn't transfer anymore to the "Task Ref ID" column in the task form. Without the ID I can't seem to properly filter the gallery. Any idea what I am missing? Thank you very much.
Definitely possible. I will have to look at your App in action to know more about your formulas & provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
Nice
Thanks
great one, thanks.
Thanks Eman
@@RezaDorrani, am trying to use your method, but I have a problem with passing (id) to the other table, the (items) property is something like (Choices([@tablename].cr285_fieldname)), how can I solve it?
I think the problem is that I am passing the "ID" value to a combo box, how can I do that?
@@emantrabelsee7799 Not sure. I would have to look at your App. I will recommend you post your issue with screenshots on the forums at powerusers.microsoft.com
@@emantrabelsee7799 Try posting your issue on the forums at powerusers.microsoft.com
Hi, Reza! This is exactly what I’m looking to do. I like the look of this content scheduler.. can you share other videos related to build up to this? Would be much appreciated.
th-cam.com/video/25_bdexevGk/w-d-xo.html
Reza, thank you for this demo! Have you ever done one for Risks where the parent list is an "if..then.." statement and probability of occurrence and consequences (potential impacts to cost, schedule, or performance) and the children lists would be the mitigation steps to reduce the probability or impacts? I can see how this demo could be used to show the Risk item and its associated mitigation steps. I'm also curious if it's possible to show a graph (waterfall) of the progress of the mitigation steps over time. Again, this is a wonderful demo!
I have not done any specific video on Risks scenario but the technique in video could very well be used.
Power Apps is limited in terms of graphs or charts. Power BI would be a good option for that. You can add Power BI Tiles and reports in power apps.
I will also recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Thank you. Another amazing video. This was a bit of a general review for me, but lots of important basic principles and best practice for moving records between screens.
Glad you enjoyed it!
Thank you very much - I find your videos very easy to follow! and so useful! I would like to bring in an additional field to the Task list. How would I bring in an additional choice field - say the status field? I am using the concept to build a project status update form and I am wanting to copy in the Current status so that it stays with the comment but because it is a record it is not coming across correctly, I need to make it to a text field I think
If its a record of a list item.
You can directly get all column values using (assuming record is called x) x.columname.
I would also recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
@Reza this is insanely amazing !
Just wanted to know , can we also use a third List with ref ID pointing to first and second ?
Thanks!
Possible but will get more and more complex with more lists :)
Hi, Reza. This is an excellent tutorial. Please assist instead of performing a (1-to-many) filter on tasks. I have two separate apps in which tasks can be assigned to multiple users. However, I would like a gallery to filter many-to-one. Show all tasks assigned to the user. These tasks can be from different project items. Therefore, App 1 creates an item and allows the user to assign tasks to multiple users. App 2 lists user tasks from different items/projects created in App 1. I hope this makes sense. Thanks
Will add your request to my backlog but this is the first request on this topic. I will need a lot more requests on this topic to give this a higher priority.
Hi, Reza. Another great video. Thank you for sharing. Please, do you have a sample with "table/related table" where the App is working off-line ?
Thanks.
I do not have any videos on offline. I did it for a client project but I cannot share that :)
I have a video idea on offline in my backlog.
Hi Raza, thank you for the very helpful videos!
I have a similar situation as the one you are showing except from the fact that I have lookup columns for the ID instead. When I try to change the Default it does not work for me. Is it a different way to do it in that case?
I will have to look at your App in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
Thanks for the great tutorial. one question please, how can you do the same when using 'Ref ID' as Lookup type instead of number type?
I will have to try it out to provide the exact formula. You would need to use something like lookupcolnamw.value to do the lookup.
Thanks Reza for another great video. Is it possible to use look up column as the ref Id? Thanks
Possible
Reza thank you for this video. How would set this up if your Ref ID field was a Lookup column in Sharepoint?
Steps would be similar but code would be different. I would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Great video, do you know if I can get values (number) from the tasks and the sum of these values be saved in the main list?
Use Sum function.
Hello Reza,
Your videos have been so useful for my work. Thank you so much
Do you have any video on styling gallery similar to what you have here. I cant get much help online . Please
Here it is th-cam.com/video/bnC8u3gdWss/w-d-xo.html
Hi Reza - Fantastic video - I have used your system to make a one-to-many. Can you suggest a way that you can tell the main SharePoint list that there is a task set? Then I want to count the number of records in the original SharePoint list that have no tasks set. Cheers!
th-cam.com/video/25_bdexevGk/w-d-xo.html
Hi Reza. That's great video. So cool! I have seen lot of your videos to learn Power apps.
But I have question. I also use filter function to show related gallery, why do I get delegation warning? In your video, I didn't see it. Can you help me to explain it?
You must be using a query in your filter function which is not delegable.
Cannot help without knowing what your query is and on what column type is it being fired on.
Thank you for sharing this very useful feature. I have lists that I would like to set up this way, but I already have set it using the lookup column. How does the step differ when setting up the task form on Power Apps in this case pls?
In that case you would need to query on lookup column.
I did another video on this topic th-cam.com/video/1Qsf2RPyp8s/w-d-xo.htmlsi=R0_Q7xqEFHlob2h2
Thanks reza for your great efforts to explain the powerapp with relationship sharepoint lists. Could you please explain how to set varID for my main data source ID column. Your response will be much appreciated.
Which part of the video was this showcased in? Can you share the timing please?
Reza, Thanks! Quick question..Can this work with a Library be the main source (uploading a document with metadata that is pulled from SharePoint list) then also adding tasks associated with the document?
Possible
Hi Reza this is a great video for a novice Power Apps user like me. Your HomeScreen tables are they customize gallery? I cannot find it in the standard gallery and I want to use it in the app I'm building. Thank you.
Those are customized galleries.
Check th-cam.com/video/bnC8u3gdWss/w-d-xo.html
Very nice video. Thanks reza. Only thing I didn't understand was, how did you set up the variable varRecord?
On Gallery items selection, OnSelect code Set(varRecord,ThisItem)
Great video! Thank you. Reza! Do you have a video on how to making gallery row selectable and change color when selected? I can add columns in the row but I cannot select the row. I can only click the arrow to navigate to another screen and open a new form.
Never mind. I found out that I need to insert labels (not textinput) in template cell.
Looks like you got the answer :)
nice
Excellent video...
I need some help with implementing Accordion collapsible , I tried using Nested galleries but I am facing performance issue as you said, I have a case like there are questions and Sub questions to be displayed, when clicked on question, it's related sub questions to be displayed, just below question.
I will be grateful if you can help me out..
Thanks In advance 😄
I would recommend you post your issue on the forums at powerusers.microsoft.com with screenshots. Solving issues on TH-cam chat is not a viable option.
Hello Reza, thanks for this video. I want to ask if we can add a filter or search function on this.
Yes
Reza, you are a super star! I'm learning so much thanks to you. In case you have a filter in the main screen, is it possible to hide the gallery (or not to show the data) and show them only after you search by Title or Status (whatever the filter is)?
You can check if any of the filter controls have values and accordingly show hide the gallery.
@@RezaDorrani thanks a lot. I added and IF function at the beginning of the sort and it worked :)
If(IsBlank(TextInput2.Text) || IsBlank(CountryDropdown),Blank(), If(IsBlank(TextInput2.Text) && IsBlank(CountryDropdown),Blank(), sort....)
Hi Reza: I have been following your video to the "T" for my App. It has been a blessing for me. Many thanks. I however have an additional requirement. I need to duplicate the reoccurring tasks on demand. My Ref ID is giving me trouble during Patch. Do you have any guidance video to help resolve the related Task "copy" and "edit" functionality for the reoccurring tasks? If so, can you point me to that please?
Glad to hear!
I do not have any other video references related to reoccurring tasks.
I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
this helps me a lot. however, I got lost in the setting of a varRecords. do you have a separate video on this? how did you set the variables?
th-cam.com/video/25_bdexevGk/w-d-xo.html
Hi Reza, this is a great tutorial, and I'm going to use this for my next project. Can you please guide me on how to link filtered items to detail content similar to 3.20
I have done many videos on filtering. Idea is to filter records in gallery based on selection of main gallery item.
Thx so much for sharing, Reza!!!! Very helpfull!!!! If you use list for storing data you got a limitation about 2000 records .. . Is that right? Thx in advance!!! Greetings from germany Christoph 👏 👏 👏 👏 👏
That limitation can be addressed if delegation is taken care of.
th-cam.com/play/PLTyFh-qDKAiE6ia-D94Qk5-AzpN4dqOmD.html
Wow this is great! Thanks for demonstrating all of this. At work, we have a spreadsheet with about 7 worksheets, each containing a list of all employees and the dates at which they completed certain types of training. Some worksheets contain as many as 20 columns (all different training modules). The issue is, when an employee leaves or is recruited, we need to go into all worksheets and make he same adjustments and people are neglecting to do this.
Do you think powerapps could help in simplifying this?
Possible. You may want to look at data sources that support relational data like SQL or Dataverse.
I would also recommend you check on the forums to see if anyone has done something similar at powerusers.microsoft.com/
@@RezaDorrani thanks so much!
Reza, great video as I have come to expect on your channel! Loving it. Question though, on the scenario, you have tasks added separately once the Content was submitted to Sharepoint. Is there a possibility or way, to give the user the ability to complete they tasks without having to navigate away. I was thinking setting up a Content Info screen that would capture the details and generate the unique ID, but in stead of navigating back to the home screen, navigating to the Content Info Screen with the Tasks lists now active, and of course, linked to the ID. Is that possible?
Thank You 🙏 for liking my videos.
Your use case is possible. Challenge is the main list needs to have the item generated to get the item ID for the sub tasks.
I did a video related to Microsoft Dataverse (NOT SharePoint), but the concept applied there should work for SharePoint as well.
th-cam.com/video/8BUxeYb-SX0/w-d-xo.html 15:46 onwards
@@RezaDorrani Man! I love you more every day! I just skimmed through it and I think you are right. I think this looks like its exactly what I need. Going to watch the whole vid now and let you know asap. Keep it up, Reza!
@@CaptMAGpie Awesome 👍
Hello Dorrani, I am very happy that your video is of great help, but I have a small problem, at the moment when I try to compare the REF ID with the ID I have a problem with these columns it is not possible to compare, because my The REF column is now in multi-select mode, and you know something to change multi select to text? or do you have something to compare a record to the numeric value? Thanks a lot
I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza! Is there a video about adding multiple tasks at the same time like a repeating row? Does that require a collection? I’m wondering what’s the best approach. Thanks in advance!
Ive done videos on bulk adding updating data. Look through videos on my channel.
Reza you show me so many cool things.
One question - How can I control the "Item" property on the edit form so I can add task items from the New Mode? I've attempted it, but anytime I add a new task, the form reloads and always has "Gallery.Selected" as the Item. The data integrity is there (Ref ID on the task items match the master record), but the form gets confused after adding a task and does NOT display the new master record.
Thanks!
Check for the sample app on my GitHub repo.
I would also recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hello, 5:45 you're talking about item is variant VarRecord. But I don't understand where specifically did you define a variant in this video, and what does the variant do? I have 2 sharepoint lists, I need to link them so that when I click an item in main table, it would select the items with the same reference in the second table.
Check formula at 14:40, varRecord is a variable that holds context of selected item in Gallery.
Hey Reza, this has been a very helpful how-to. How do I do this with lookup Instead of text? Set lookup value which would be an ID to Parent item.
For Lookup column, you would need to set default value using lookup column syntax. I have done a video on Patch function which shows that syntax. Also, when querying data on home screen related list gallery, you would need to filter on lookup column. I have done a video on that as well.
Reza, I'm amazed with what you do with PowerApps, and wish I could QUICKLY become that good! How can I?
I learn by reading documentation (Microsoft docs.microsoft.com) and try and implement them in apps & flows.
@@RezaDorrani I guess I was hoping that I could attend a week-long Reza Bootcamp! Fully immersed for a week. Thank you for the great online tutorials that you provide!!!! They are the best!
@@cromagnon71 I have started channel memberships. If you are on a web browser on my channel, you will see a Join option. I plan to add more membership types in future. One would be training related!
Check channel memberships. I have gone live with a training tier that you can sign up for now.
th-cam.com/users/rezadorranijoin