Power Apps working with SharePoint List Relationships

No video

Power Apps working with SharePoint List Relationships

Рет қаралды 197,968

Күн бұрын

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

Пікірлер: 555

@BigLeafDropper86 3 жыл бұрын

The fun never ends! I'm amazed everyday with the capabilities of powerapps

@RezaDorrani 3 жыл бұрын

The fun never ends

@michaelmurillosr657 2 жыл бұрын

Incredible! I love how you are straight to the point and concise in your direction. Very easy to follow, understand, and learn. Thank you.

@RezaDorrani 2 жыл бұрын

Glad to hear that! Thank You for watching

@EpicBizHero 2 жыл бұрын

This is a TRUE CAREER SAVER... Thank you so much Reza and God Bless!!!

@RezaDorrani 2 жыл бұрын

Thank You for watching and supporting my channel 🙏

@chrisproctor2854 Жыл бұрын

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!

@RezaDorrani Жыл бұрын

Thank You for the support and appreciation for the videos.

@elieclaudon7299 3 жыл бұрын

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 !

@RezaDorrani 3 жыл бұрын

You're very welcome!

@user-nv2iu6be3d Жыл бұрын

This might be my first time leaving a comment on any KZfaq video anywhere, but this was so incredibly helpful to my office. Thank you for creating such a detailed and thoughtful walk-through!

@RezaDorrani Жыл бұрын

You are so welcome!

@vhinduphilco5670 2 жыл бұрын

Reza as well as Daniel...my two powerapps heroes. Keep it up guys. Love lots from Philippines. :)

@RezaDorrani 2 жыл бұрын

Awesome! Thank you!

@sagarjoshi6070 2 жыл бұрын

finally found solution at your video...no one can beat you in powerapps training video...thanks man!

@RezaDorrani 2 жыл бұрын

Wow, thanks man.

@OneDSystems Жыл бұрын

Reza, the way you explain this is amazing! I learn from you as if I were thinking with you. Thanks for your video!

@RezaDorrani Жыл бұрын

Happy to hear that! Thanks so much for watching and learning.

@cpbittner 11 ай бұрын

Thanks!, I have been learning and mastering Power Apps thanks to your videos!

@RezaDorrani 11 ай бұрын

Great to hear and thanks so much!

@jennyeaton68 3 жыл бұрын

Thank you so much. This is what I have been looking for in my next step of playing with power apps.

@RezaDorrani 3 жыл бұрын

You are welcome!

@Pedexman 2 жыл бұрын

Reza, your content is just amazing!!, well thought out and explained. Cannot thank you enough for educating me on my PowerApps Journey.

@RezaDorrani 2 жыл бұрын

Thank You so much! Makes me so happy to know the videos are useful and being appreciated.

@benbanurji1727 3 жыл бұрын

One of the best videos I’ve seen on power apps... thank you!

@RezaDorrani 3 жыл бұрын

Thanks Ben

@maciejfrydrych1298 Жыл бұрын

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.

@RezaDorrani Жыл бұрын

Glad to hear that! Thanks for watching

@mohadesehasadi2077 2 жыл бұрын

Very good. Thank you from showing all examples for relation with different lists...

@RezaDorrani 2 жыл бұрын

Your most welcome

@ckane824 2 жыл бұрын

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, <a href="#" class="seekto" data-time="453">7:33</a> 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 <a href="#" class="seekto" data-time="138">2:18</a> but, never gave any other info on the "Ref ID' lookup. Thanks again!

@RezaDorrani 2 жыл бұрын

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

@kevindiaz-zr3xy Жыл бұрын

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!

@simonhey3063 6 ай бұрын

Hello there, I have the same issue where I want to prepopulate a lookup column, did you find a solution ?

@kamozzi1 2 жыл бұрын

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.

@RezaDorrani 2 жыл бұрын

Glad to heat that. Thanks for watching.

@yannis18 2 жыл бұрын

Watching this after the recent dataverse video. Will try this approach next only with a lookup column. Thanks Reza

@RezaDorrani 2 жыл бұрын

Excellent! Thanks for watching. Remember Dataverse is truly a relational database. SharePoint is not :)

@yannis18 2 жыл бұрын

@@RezaDorrani yes one could say that sharepoint is intended to be the gateway "drug" for dataverse.

@RezaDorrani 2 жыл бұрын

@@yannis18 :)

@sp0ng007 Ай бұрын

Thank you for amazing video this was very informative

@RezaDorrani Ай бұрын

Glad it was helpful!

@YohanesOktavianusSiagian 2 жыл бұрын

This is brilliant to sort and manage the data.. thank you for the tutorial

@RezaDorrani 2 жыл бұрын

Awesome

@aminabintiali-470 2 жыл бұрын

Many thanks for such useful tutorial, Reza! It's help a lot and I'm more confident to use Power Apps.

@RezaDorrani 2 жыл бұрын

Glad to hear that! Thank You for watching.

@aminabintiali-470 2 жыл бұрын

@@RezaDorrani most welcome 🌹

@house102 2 жыл бұрын

@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!

@RezaDorrani 2 жыл бұрын

Glad to know the video is useful. Thanks for watching.

@anshulbhardwaj7477 2 жыл бұрын

The way you explain is amazing.

@RezaDorrani 2 жыл бұрын

Thank You

@rachelharkin2190 2 жыл бұрын

Your videos are so great - incredibly helpful, thankyou!

@RezaDorrani 2 жыл бұрын

Glad to hear that! Thank You for watching

@MichaelDeBlasis1369 4 ай бұрын

Just what I needed.

@RezaDorrani 4 ай бұрын

Great!

@MichaelDeBlasis1369 4 ай бұрын

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

@RezaDorrani 4 ай бұрын

@@MichaelDeBlasis1369 Very few requests on that topic and hence did not invest time in it.

@bestyapper 2 жыл бұрын

Thanks!

@RezaDorrani 2 жыл бұрын

Thank You

@simonball5602 Жыл бұрын

More awesome stuff Reza. You’re a very good educator. Please keep it up.

@RezaDorrani Жыл бұрын

Much appreciated

@MsRodrovisk 3 жыл бұрын

Your solutions are always incredible!!!

@RezaDorrani 3 жыл бұрын

Thank You :)

@simonball5602 Жыл бұрын

Another brilliant and informative video. Helping us learners build our skills and knowledge. Thank you again Reza.

@RezaDorrani Жыл бұрын

Most welcome

@god_hacker581 3 жыл бұрын

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.

@RezaDorrani 3 жыл бұрын

Happy to hear that! Thank you for watching and following my channel.

@kevinjoseph9023 2 жыл бұрын

You’ve got great kit!

@RezaDorrani 2 жыл бұрын

Thanks

@akkaradechsrithongchai7766 2 жыл бұрын

Woww . I will modify it to be my "Store Distribution" process. Thank a lot . (One Request to Many items)

@RezaDorrani 2 жыл бұрын

You are most welcome

@ArohShukla 3 жыл бұрын

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!

@RezaDorrani 3 жыл бұрын

Thanks Aroh

@geoffmckeon5902 3 жыл бұрын

This is exactly what I am looking for to assist me with a work project. Thank you for your thorough explanation of the process.

@RezaDorrani 3 жыл бұрын

Glad to know the video is useful. Thanks for watching.

@geoffmckeon5902 3 жыл бұрын

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?

@RezaDorrani 3 жыл бұрын

@@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

@vsomareddy 3 жыл бұрын

@@RezaDorrani I am also interested in the topic Geoff McKeon mentioned above.

@RezaDorrani 3 жыл бұрын

Its in my backlog

@Empriction Жыл бұрын

Absolutely fantastic tutorial Reza :) You saved me with this one. Thank you!

@RezaDorrani Жыл бұрын

Happy to hear that! Thanks for watching.

@gideon17you 2 жыл бұрын

Thank you. I really love your channel.

@RezaDorrani 2 жыл бұрын

😊

@gideon17you 2 жыл бұрын

@@RezaDorrani I would like to subscribe to your channel. For some reason I didn't see any button or area to do so. Thanks.

@RezaDorrani 2 жыл бұрын

@@gideon17you Try kzfaq.info link and see if it works.

@gideon17you 2 жыл бұрын

@@RezaDorrani I just did. It works! Thank you.

@cs9181 Жыл бұрын

awesome! This will work perfectly for tracking revisions.

@RezaDorrani Жыл бұрын

Great!

@shaikmohammedabdulsamad4280 3 жыл бұрын

Nice tips.. You made SP Relations very simple using PowerApps

@RezaDorrani 3 жыл бұрын

Thank you

@kwmotion1922 2 жыл бұрын

explained very good thanks a lot

@RezaDorrani 2 жыл бұрын

Glad you liked it!

@beryl.chu1992 3 жыл бұрын

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!

@RezaDorrani 3 жыл бұрын

Great to hear! Thank you for watching.

@anjorinmanuwa2885 2 жыл бұрын

Your're the special one Reza!

@RezaDorrani 2 жыл бұрын

Thank You 😊

@nouriairbah2334 3 жыл бұрын

Exactly what I needed, Thank you Raza!

@RezaDorrani 3 жыл бұрын

You're welcome 😊

@dan.7997 3 жыл бұрын

Hi Reza, Awesome, I've learned so much to your lecture's... -->>direct and precise explanation. Thank you!

@RezaDorrani 3 жыл бұрын

You are most welcome and thanks for the feedback

@maricarmenjimenez4877 Жыл бұрын

Hi @Reza Dorrani, Thank you very much for your video, it is very well explained and easy to follow.

@RezaDorrani Жыл бұрын

Most welcome and thanks for watching

@aarongayah2358 3 жыл бұрын

You explained this wonderfully. Well done.

@RezaDorrani 3 жыл бұрын

Glad you liked it

@frenamakenson9844 2 жыл бұрын

Very good video !

@RezaDorrani 2 жыл бұрын

Thanks

@marcovilla2112 Жыл бұрын

great explanation

@RezaDorrani Жыл бұрын

Thanks

@marcovilla2112 Жыл бұрын

@@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?

@RezaDorrani Жыл бұрын

@@marcovilla2112 I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/

@marcovilla2112 Жыл бұрын

@@RezaDorrani thanks! will do it

@SirAbaba Ай бұрын

thank you for sharing

@RezaDorrani Ай бұрын

My pleasure

@thuthukamhlongo918 2 жыл бұрын

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

@RezaDorrani 2 жыл бұрын

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.

@mohanadalhiti4300 2 жыл бұрын

Great work, thank you for your great ideas and work

@RezaDorrani 2 жыл бұрын

Glad you like them!

@mariorgutierrezleal 2 жыл бұрын

Great vídeo!!

@RezaDorrani 2 жыл бұрын

Thank You

@MrPsith 2 жыл бұрын

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.

@RezaDorrani 2 жыл бұрын

Glad to hear that! Thank You so much for watching and liking the videos.

@versidus 2 жыл бұрын

Good stuff! Thank you Reza!

@RezaDorrani 2 жыл бұрын

Your most welcome

@vidabailey16 Жыл бұрын

Thanks so much, you have amazing content on these programs!

@RezaDorrani Жыл бұрын

Glad you like them!

@husainkoolarzadeh4367 3 жыл бұрын

Wow so informative...it helped me alot ...you are of great help ..best of luck ...keep posting always

@RezaDorrani 3 жыл бұрын

Thank you :)

@muhannednidal3647 3 жыл бұрын

Excellent explanation I enjoyed watching.

@RezaDorrani 3 жыл бұрын

Thanks for watching

@zerocool200380 3 жыл бұрын

Reza, Another great video. Thank you!

@RezaDorrani 3 жыл бұрын

You are most welcome

@thermant8452 3 жыл бұрын

This was good! Can't wait to implement

@RezaDorrani 3 жыл бұрын

Thanks

@lradasme Жыл бұрын

¡Gracias!

@RezaDorrani Жыл бұрын

Welcome

@DavideGalloni 2 жыл бұрын

Wonderful Reza!! Thanks for sharing your very useful experience!!

@RezaDorrani 2 жыл бұрын

Glad it was helpful! Thanks for watching.

@alzaimoor79 3 жыл бұрын

Useful video as always, I wished the video included an explanation of adding row number in gallery. Thanks for sharing, keep it up

@RezaDorrani 3 жыл бұрын

Thanks for watching.

@cromagnon71 2 жыл бұрын

Reza, I'm amazed with what you do with PowerApps, and wish I could QUICKLY become that good! How can I?

@RezaDorrani Жыл бұрын

I learn by reading documentation (Microsoft docs.microsoft.com) and try and implement them in apps & flows.

@cromagnon71 Жыл бұрын

@@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!

@RezaDorrani Жыл бұрын

@@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!

@RezaDorrani Жыл бұрын

Check channel memberships. I have gone live with a training tier that you can sign up for now. kzfaq.infojoin

@sundrapillay6668 3 жыл бұрын

Thanks Reza excellent video

@RezaDorrani 3 жыл бұрын

My pleasure!

@TheRemyRomano 2 жыл бұрын

Nice

@RezaDorrani 2 жыл бұрын

Thanks

@ky0105 10 ай бұрын

All your tutorials are very nice, i am learning simple tricks only. Here i am struck, how to delete the record using the same view form

@RezaDorrani 10 ай бұрын

Thanks so much. I did a new video on this topic. Its a better version of this one. Check my latest videos.

@RezaDorrani 10 ай бұрын

Thanks so much. I did a new video on this topic. Its a better version of this one. Check my latest videos.

@user-ne1gx7qo7b Жыл бұрын

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.

@RezaDorrani Жыл бұрын

kzfaq.info/get/bejne/aJuPlceW3cvad58.html

@christophmeirich5928 2 жыл бұрын

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 👏 👏 👏 👏 👏

@RezaDorrani 2 жыл бұрын

That limitation can be addressed if delegation is taken care of. kzfaq.info/sun/PLTyFh-qDKAiE6ia-D94Qk5-AzpN4dqOmD

@user-mq9xk4sc8y 6 ай бұрын

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?

@RezaDorrani 6 ай бұрын

In that case you would need to query on lookup column. I did another video on this topic kzfaq.info/get/bejne/Z7ejmZWDtd_UaKc.htmlsi=R0_Q7xqEFHlob2h2

@ganeshroyal7281 2 жыл бұрын

Hi Reza, its great video. I have a request from my end. I want to purchase SharePoint for learning purpose. Could you please make a video on how can anyone purchase SharePoint

@RezaDorrani 2 жыл бұрын

I will add your video request to my backlog but will need a lot more folks requesting this topic to give it a higher priority.

@ranjanroy1623 11 ай бұрын

@Reza this is insanely amazing ! Just wanted to know , can we also use a third List with ref ID pointing to first and second ?

@RezaDorrani 11 ай бұрын

Thanks! Possible but will get more and more complex with more lists :)

@zestern 2 жыл бұрын

Reza thank you for this video. How would set this up if your Ref ID field was a Lookup column in Sharepoint?

@RezaDorrani 2 жыл бұрын

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

@rubenpuertosmartinez 2 жыл бұрын

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?

@RezaDorrani 2 жыл бұрын

Use Sum function.

@davealejo8050 2 жыл бұрын

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.

@RezaDorrani 2 жыл бұрын

Those are customized galleries. Check kzfaq.info/get/bejne/mNRza9hkzMq7o6c.html

@nharzic9248 3 жыл бұрын

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.

@RezaDorrani 3 жыл бұрын

Glad you enjoyed it!

@emantrabelsee7799 3 жыл бұрын

great one, thanks.

@RezaDorrani 3 жыл бұрын

Thanks Eman

@emantrabelsee7799 3 жыл бұрын

@@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?

@emantrabelsee7799 3 жыл бұрын

I think the problem is that I am passing the "ID" value to a combo box, how can I do that?

@RezaDorrani 3 жыл бұрын

@@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

@RezaDorrani 3 жыл бұрын

@@emantrabelsee7799 Try posting your issue on the forums at powerusers.microsoft.com

@aniketkulkarni4486 2 жыл бұрын

Very nice video. Thanks reza. Only thing I didn't understand was, how did you set up the variable varRecord?

@RezaDorrani 2 жыл бұрын

On Gallery items selection, OnSelect code Set(varRecord,ThisItem)

@rkirk2k Жыл бұрын

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.

@RezaDorrani Жыл бұрын

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

@2pits540 Жыл бұрын

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?

@RezaDorrani Жыл бұрын

Possible

@dushyanthasanjeewa8983 Жыл бұрын

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

@RezaDorrani Жыл бұрын

I have done many videos on filtering. Idea is to filter records in gallery based on selection of main gallery item.

@sueamin2788 11 ай бұрын

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?

@RezaDorrani 11 ай бұрын

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

@sureshpune6076 Жыл бұрын

This is amazing.. can we submit data of two forms to two different lists on one button click?

@RezaDorrani Жыл бұрын

You could use Patch for that.

@Heisshena Жыл бұрын

Hi Reza, your videos have helped me a lot, thank you!! I tried to recreate this tutorial, however it's slightly different and I can't seem to fix the issue I have. My content Info form has both save and edit button. When user creates new data in content form in edit mode, save button should be enabled. When user clicks on save button after adding new data, content form will be switched to view mode, save button disabled and edit button enabled. My issue is, when creating new data and clicking save button - the form does not show view mode when I preview the app, it shows 'No item to display'. But I can see the view mode when I exit the preview. The form property's DefaultMode is view. Please advise, thanks in advance!

@RezaDorrani Жыл бұрын

I would have to reproduce your issue to provide guidance. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

@shoaibmalik392 2 жыл бұрын

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?

@RezaDorrani 2 жыл бұрын

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.

@edcoffeebean Жыл бұрын

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!

@RezaDorrani Жыл бұрын

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.

@jc5510 Жыл бұрын

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!

@RezaDorrani Жыл бұрын

kzfaq.info/get/bejne/aJuPlceW3cvad58.html

@almalleshi16 Жыл бұрын

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)?

@RezaDorrani Жыл бұрын

You can check if any of the filter controls have values and accordingly show hide the gallery.

@almalleshi16 Жыл бұрын

@@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....)

@RadhikaNanaiah Жыл бұрын

Hi Reza, could you please make a video of how you created the content grid to start with please?

@RezaDorrani Жыл бұрын

Power Apps gallery designs kzfaq.info/get/bejne/mNRza9hkzMq7o6c.html kzfaq.info/get/bejne/gNBkjbyr2dS5gWQ.html

@doriangarschagen440 3 ай бұрын

Hi Reza, thanks for this great tutorial! :) Is it possible to download the content? :) Thanks and have a nice day

@RezaDorrani 3 ай бұрын

Most welcome! I did this one years ago and no longer have access to the content.

@doriangarschagen440 2 ай бұрын

Thanks for the answer! The download was my reason for the member payment 😅 does anyone has the download of this content for me? 🙏🏼😊

@RezaDorrani 2 ай бұрын

@@doriangarschagen440 The membership details page clearly defines last 90 days only. No one else has the download content because it was never an option for anyone.

@kristoffercaumban3752 Жыл бұрын

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?

@RezaDorrani Жыл бұрын

kzfaq.info/get/bejne/aJuPlceW3cvad58.html

@kahoumes 2 жыл бұрын

This is very nice but you use a PowerApp to build this. Is there another video where I can see how you can make a grid in combination with a form control. I have already seen the great editable grid video but this look like a simple version of table with a form control. But I don't know how I create this.

@RezaDorrani 2 жыл бұрын

You do not want to use Power Apps? I do not have any other technique for this without Power Apps. My grid videos are all I have. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

@dasajeeva6875 3 жыл бұрын

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

@RezaDorrani 3 жыл бұрын

Here it is kzfaq.info/get/bejne/mNRza9hkzMq7o6c.html

@umariqbal568 2 жыл бұрын

Thanks Reza for another great video. Is it possible to use look up column as the ref Id? Thanks

@RezaDorrani 2 жыл бұрын

Possible

@user-sv9bv2gp7u 11 ай бұрын

Very nice video tutorial Reza. It was easy for me to follow as I am very new to powerapps. I am using it for a Goal/Task environment. However, I havent been able to figure out a good way to search all task in the secondary list that refer to a specific goal in the primary list, and where if any task are not complete, to block the user from closing the goal in the status field, until all task are complete for that goal? Do you have any suggestion for accomplishing this?

@RezaDorrani 11 ай бұрын

Most welcome! I have not tried scenario around searching in related tasks. Delegation would definitely be a challenge with SharePoint lists. Dataverse would offer more flexibility.

@user-sv9bv2gp7u 11 ай бұрын

@@RezaDorrani Thank you for the reply. Both SP list should remain relatively small as it would be tough for our small organization to accumulate more than 1000 task in a quarter before the completed ones would be archived. I was thinking maybe setting a filter on the combo box from the main SP list, that if any associated task for that goal in the secondary list (gallery on bottom of screen in your example) statuses was not "completed", then do not show the status "Complete" in the combo box on the main form for the goal. The problem is, not sure if that makes sense to try or is even possible? Thanks in advance for any guidance!

@RezaDorrani 11 ай бұрын

@@user-sv9bv2gp7u Could be possible. Something like CountRows(filter(secondary list, condition status not completed))>0

@user-sv9bv2gp7u 11 ай бұрын

@@RezaDorrani Maybe as long as I could also filter the second list to pickup the ID of the primary list from the Goal Ref ID in the secondary list so I would only be counting the task associated with that particular goal. and not counting all rows in the secondary list. Would that be correct?

@RezaDorrani 11 ай бұрын

@@user-sv9bv2gp7u Honestly it depends. I would have to reproduce your scenario to know the accurate steps. You can try and post your scenario on forums.

@oricchannel2811 2 жыл бұрын

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 ?

@RezaDorrani 2 жыл бұрын

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.

@georgewahtaplah6128 3 жыл бұрын

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.

@RezaDorrani 3 жыл бұрын

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.

@emmaporter8449 2 жыл бұрын

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 :)

@RezaDorrani 2 жыл бұрын

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 - kzfaq.info/get/bejne/r8txodiFp56ZlZs.html

@ravigandhi8575 3 жыл бұрын

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 😄

@RezaDorrani 3 жыл бұрын

I would recommend you post your issue on the forums at powerusers.microsoft.com with screenshots. Solving issues on KZfaq chat is not a viable option.

@wojciechwsap993 Жыл бұрын

Hello, very helpful video, but I have a question. Is there a tutorial anywhere on how you create such nice content? Are you talking about the tables on the left without tasks? I will be grateful for answer. Regards

@RezaDorrani Жыл бұрын

kzfaq.info/get/bejne/aJuPlceW3cvad58.html

@annav8376 Жыл бұрын

I am new to power automate flows. I watched couple of your videos and finally able to create one flow. But now I want to use same flow for another list . How to use same flow for more than one Sharepoint list within one Sharepoint.

@RezaDorrani Жыл бұрын

1 - repeat the process manually (easy way) You cannot reuse same flow for multiple SP lists. 2 - johnliu.net/blog/2019/3/one-flow-to-handle-them-all-how-to-subscribe-to-multiple-sharepoint-lists-with-one-flow?format=amp

@melc8895 2 жыл бұрын

I am just learning PowerApps and your videos are fabulous. I think I'm missing a step in this video though. When you first create the Task form and are creating tasks from the Content screen, clicking Submit navigates back to the Content Screen. Toward the end of the video, when you create the ability to add a task from the Home screen, when you click on the Submit button on the Task Form, you navigate back to the Home screen not the Content Screen. Did you change the Submit button on the Task From to navigate to the Home screen rather than the Content screen at some point or do you have two Task form screens where each one navigates back to a different screen when clicking on the Submit button?

@RezaDorrani 2 жыл бұрын

It's the same button and form. I navigate user to home screen.

@melc8895 2 жыл бұрын

@@RezaDorrani First, thank you for responding so quickly. Ok, so if I understand correctly, the Submit button on the Task form was changed from navigating back to the Content screen as it did in the beginning to redirect to the home screen. So, even if someone clicks on the Add Task button on the Content screen, once they click Submit on they will be redirected back to the home screen rather than the Content screen. Thank you.

@RezaDorrani 2 жыл бұрын

@@melc8895 Im not sure I understood correctly. Here is link to sample app - github.com/rdorrani/PowerApps/blob/master/SPListRelationship_20210418121831.zip download and check the code.