Power Apps working with SharePoint List Relationships

แชร์
ฝัง
  • เผยแพร่เมื่อ 6 พ.ย. 2024

ความคิดเห็น • 557

  • @BigLeafDropper86
    @BigLeafDropper86 3 ปีที่แล้ว +18

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

    • @RezaDorrani
      @RezaDorrani  3 ปีที่แล้ว +5

      The fun never ends

  • @chrisproctor2854
    @chrisproctor2854 ปีที่แล้ว +4

    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
      @RezaDorrani  ปีที่แล้ว +1

      Thank You for the support and appreciation for the videos.

  • @michaelmurillosr657
    @michaelmurillosr657 2 ปีที่แล้ว +8

    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
      @RezaDorrani  2 ปีที่แล้ว

      Glad to hear that! Thank You for watching

  • @EpicBizHero
    @EpicBizHero 2 ปีที่แล้ว +6

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

    • @RezaDorrani
      @RezaDorrani  2 ปีที่แล้ว +1

      Thank You for watching and supporting my channel 🙏

  • @elieclaudon7299
    @elieclaudon7299 3 ปีที่แล้ว +10

    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
      @RezaDorrani  3 ปีที่แล้ว

      You're very welcome!

  • @sagarjoshi6070
    @sagarjoshi6070 3 ปีที่แล้ว +1

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

  • @J.C-n3g
    @J.C-n3g ปีที่แล้ว +1

    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!

  • @vhinduphilco5670
    @vhinduphilco5670 3 ปีที่แล้ว +1

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

    • @RezaDorrani
      @RezaDorrani  3 ปีที่แล้ว +1

      Awesome! Thank you!

  • @OneDSystems
    @OneDSystems 2 ปีที่แล้ว +1

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

    • @RezaDorrani
      @RezaDorrani  2 ปีที่แล้ว +1

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

  • @rubenpuertosmartinez
    @rubenpuertosmartinez 2 ปีที่แล้ว +1

    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?

  • @ckane824
    @ckane824 2 ปีที่แล้ว +5

    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!

    • @RezaDorrani
      @RezaDorrani  2 ปีที่แล้ว +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
      @kevindiaz-zr3xy ปีที่แล้ว +2

      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
      @simonhey3063 8 หลายเดือนก่อน +1

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

  • @davealejo8050
    @davealejo8050 2 ปีที่แล้ว +1

    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
      @RezaDorrani  2 ปีที่แล้ว

      Those are customized galleries.
      Check th-cam.com/video/bnC8u3gdWss/w-d-xo.html

  • @Cleo23Blue
    @Cleo23Blue 8 หลายเดือนก่อน +1

    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
      @RezaDorrani  8 หลายเดือนก่อน +1

      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

  • @2pits540
    @2pits540 2 ปีที่แล้ว +1

    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?

  • @cpbittner
    @cpbittner ปีที่แล้ว +1

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

    • @RezaDorrani
      @RezaDorrani  ปีที่แล้ว +1

      Great to hear and thanks so much!

  • @maciejfrydrych1298
    @maciejfrydrych1298 ปีที่แล้ว +1

    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
      @RezaDorrani  ปีที่แล้ว

      Glad to hear that! Thanks for watching

  • @sueamin2788
    @sueamin2788 ปีที่แล้ว +1

    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
      @RezaDorrani  ปีที่แล้ว +1

      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

  • @zestern
    @zestern 2 ปีที่แล้ว +1

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

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

  • @jennyeaton68
    @jennyeaton68 3 ปีที่แล้ว +3

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

  • @sonial.8345
    @sonial.8345 3 ปีที่แล้ว +1

    Thank you so much for the video! I have a question wondering will you be able to see it and help me.... for the "Add Task", how can I make it conditional visible, like if I already have a task created, then don't show Add Task, if there is no task related, then show it.

    • @RezaDorrani
      @RezaDorrani  3 ปีที่แล้ว

      You can check the count of tasks created and accordingly show and hide button
      Your visible function would look something like
      CountRows(relatedtasks)=0
      If its 0, then button will be visible else hidden.

  • @Pedexman
    @Pedexman 2 ปีที่แล้ว +1

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

    • @RezaDorrani
      @RezaDorrani  2 ปีที่แล้ว

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

  • @ranjanroy1623
    @ranjanroy1623 ปีที่แล้ว +1

    @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
      @RezaDorrani  ปีที่แล้ว +1

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

  • @philippkowalski1105
    @philippkowalski1105 ปีที่แล้ว +1

    Awesome video @reza - I have a few questions though: for some strange reasons, I cannot filter the tasks lists on the home page, because Power Apps complains that I am comparing a number ('Ref ID') to a control (the SharePoint ID of the selected item). Have you ever come across this? Or am I missing a major part?
    Additionally, what would be really great if a user sets up a new content piece, he will not be navigated back to the home screen (e. g. through a 2nd button "submit and stay") but instead stays on the content info screen so he / she can immediately start adding tasks. Do you have an idea, how something like this could be done?
    Again, great video, thanks a lot!

    • @RezaDorrani
      @RezaDorrani  ปีที่แล้ว +1

      1 -I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
      2 - Possible but not something I have tried.
      I would need to investigate to know more. Try checking on forums if someone has done something similar

    • @philippkowalski1105
      @philippkowalski1105 ปีที่แล้ว +1

      @@RezaDorrani found the solution for question number 1: I had another "label" called ID and that caused some problems. Simply renamed it and it worked.

  • @mohadesehasadi2077
    @mohadesehasadi2077 2 ปีที่แล้ว +1

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

  • @aminabintiali-470
    @aminabintiali-470 2 ปีที่แล้ว +1

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

    • @RezaDorrani
      @RezaDorrani  2 ปีที่แล้ว

      Glad to hear that! Thank You for watching.

    • @aminabintiali-470
      @aminabintiali-470 2 ปีที่แล้ว +1

      @@RezaDorrani most welcome 🌹

  • @benbanurji1727
    @benbanurji1727 3 ปีที่แล้ว +1

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

  • @geoffmckeon5902
    @geoffmckeon5902 3 ปีที่แล้ว +1

    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
      @RezaDorrani  3 ปีที่แล้ว

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

    • @geoffmckeon5902
      @geoffmckeon5902 3 ปีที่แล้ว +2

      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
      @RezaDorrani  3 ปีที่แล้ว +1

      @@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
      @vsomareddy 3 ปีที่แล้ว

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

    • @RezaDorrani
      @RezaDorrani  3 ปีที่แล้ว

      Its in my backlog

  • @jc5510
    @jc5510 ปีที่แล้ว +1

    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
      @RezaDorrani  ปีที่แล้ว

      th-cam.com/video/25_bdexevGk/w-d-xo.html

  • @melc8895
    @melc8895 2 ปีที่แล้ว +1

    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
      @RezaDorrani  2 ปีที่แล้ว

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

    • @melc8895
      @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
      @RezaDorrani  2 ปีที่แล้ว +1

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

  • @NicoLabajo
    @NicoLabajo ปีที่แล้ว

    Hello Reza, thanks for this video. I want to ask if we can add a filter or search function on this.

  • @rachelharkin2190
    @rachelharkin2190 2 ปีที่แล้ว +1

    Your videos are so great - incredibly helpful, thankyou!

    • @RezaDorrani
      @RezaDorrani  2 ปีที่แล้ว

      Glad to hear that! Thank You for watching

  • @YohanesOktavianusSiagian
    @YohanesOktavianusSiagian 2 ปีที่แล้ว +1

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

  • @kamozzi1
    @kamozzi1 2 ปีที่แล้ว +1

    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
      @RezaDorrani  2 ปีที่แล้ว

      Glad to heat that. Thanks for watching.

  • @akkaradechsrithongchai7766
    @akkaradechsrithongchai7766 2 ปีที่แล้ว +1

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

    • @RezaDorrani
      @RezaDorrani  2 ปีที่แล้ว +1

      You are most welcome

  • @aniketkulkarni4486
    @aniketkulkarni4486 3 ปีที่แล้ว +1

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

    • @RezaDorrani
      @RezaDorrani  3 ปีที่แล้ว

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

  • @shoaibmalik392
    @shoaibmalik392 3 ปีที่แล้ว +1

    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
      @RezaDorrani  3 ปีที่แล้ว +1

      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.

  • @simonball5602
    @simonball5602 ปีที่แล้ว +1

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

  • @bitterscotchLove
    @bitterscotchLove 2 ปีที่แล้ว

    Hi, which video in your collection shows how you created the screens? Just beginning to learn power apps. I would like to recreate this style.

    • @RezaDorrani
      @RezaDorrani  2 ปีที่แล้ว

      Check th-cam.com/play/PLTyFh-qDKAiFUEgsXoQ9E-LJu4lcS0iMI.html

  • @margiopetra
    @margiopetra 3 ปีที่แล้ว +1

    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?

    • @RezaDorrani
      @RezaDorrani  3 ปีที่แล้ว

      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

  • @god_hacker581
    @god_hacker581 3 ปีที่แล้ว +2

    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
      @RezaDorrani  3 ปีที่แล้ว

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

  • @anshulbhardwaj7477
    @anshulbhardwaj7477 2 ปีที่แล้ว +1

    The way you explain is amazing.

  • @MarconiPereira
    @MarconiPereira ปีที่แล้ว

    What is the video before this one, which creates the very first screen with elements from the Sharepoint list? I'd like to create something similar to this. Thank you!

    • @RezaDorrani
      @RezaDorrani  ปีที่แล้ว

      There is no video for the home screen. I have done many other videos showcasing how to build galleries, forms, etc. which may help in designing the home screen.

  • @marceldorr2734
    @marceldorr2734 2 ปีที่แล้ว

    hi reza, i have a question. why don't you use a "lookup column" in sharepoint. isn't that okay? Or are there other problems in Powerapp that I don't know about? thank you very much for your great videos

    • @RezaDorrani
      @RezaDorrani  2 ปีที่แล้ว

      I mentioned in video that both options are open. You could use lookup as well.
      There are some limits to consider. I covered a few here - th-cam.com/video/AkyW8cWDVoc/w-d-xo.html

  • @house102
    @house102 2 ปีที่แล้ว +1

    @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
      @RezaDorrani  2 ปีที่แล้ว

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

  • @kristoffercaumban3752
    @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
      @RezaDorrani  ปีที่แล้ว

      th-cam.com/video/25_bdexevGk/w-d-xo.html

  • @almalleshi16
    @almalleshi16 ปีที่แล้ว +1

    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
      @RezaDorrani  ปีที่แล้ว

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

    • @almalleshi16
      @almalleshi16 ปีที่แล้ว +1

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

  • @Sunny-rp9rz
    @Sunny-rp9rz 4 หลายเดือนก่อน

    Hey Reza,thank you for your video.If I only want to have content info and task page how can I connect them as I found that the ‘varRecord’ didn’t work,hope you can give me some guidance.Also,once I submit the content info and add new task I want the content info shown on the page but it will turn to blank again ,how can I improve it?Thank you!

    • @RezaDorrani
      @RezaDorrani  4 หลายเดือนก่อน

      I did this video a while ago and do not remember the specifics. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

  • @octanuxdem
    @octanuxdem 2 ปีที่แล้ว

    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

    • @RezaDorrani
      @RezaDorrani  2 ปีที่แล้ว

      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

  • @MsRodrovisk
    @MsRodrovisk 3 ปีที่แล้ว +1

    Your solutions are always incredible!!!

  • @thuthukamhlongo918
    @thuthukamhlongo918 3 ปีที่แล้ว +1

    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
      @RezaDorrani  3 ปีที่แล้ว

      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.

  • @yannis18
    @yannis18 2 ปีที่แล้ว +1

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

    • @RezaDorrani
      @RezaDorrani  2 ปีที่แล้ว

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

    • @yannis18
      @yannis18 2 ปีที่แล้ว +1

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

    • @RezaDorrani
      @RezaDorrani  2 ปีที่แล้ว

      @@yannis18 :)

  • @shaikmohammedabdulsamad4280
    @shaikmohammedabdulsamad4280 3 ปีที่แล้ว +1

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

  • @mikegc3816
    @mikegc3816 2 ปีที่แล้ว +1

    Hi Reza, when I set the datasource for a form, the fields and labels from SharePoint are massive whereas yours are a reasonable size, any idea what might cause this? Also in your content gallery how did you create the columns and column headers, unless I missed it in your gallery video. I guess its a case of moving fields around and adding labels above the gallery and resizing? Thanks - Mike

    • @RezaDorrani
      @RezaDorrani  2 ปีที่แล้ว

      Might have to do with you changing app from tablet style to mobile or something.
      Columns and headers are in my other videos (grid-based videos).

    • @mikegc3816
      @mikegc3816 2 ปีที่แล้ว +1

      @@RezaDorrani Yes tablet was my guess, I just manualoly adjusted everything in the end - thanks

  • @RahulPatil-mh4qc
    @RahulPatil-mh4qc ปีที่แล้ว

    Hi reza, can you please tell how does your content gallery looks like a table?

    • @RezaDorrani
      @RezaDorrani  ปีที่แล้ว

      th-cam.com/video/bnC8u3gdWss/w-d-xo.html

  • @maricarmenjimenez4877
    @maricarmenjimenez4877 ปีที่แล้ว +1

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

    • @RezaDorrani
      @RezaDorrani  ปีที่แล้ว

      Most welcome and thanks for watching

  • @simonball5602
    @simonball5602 2 ปีที่แล้ว +1

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

  • @umariqbal568
    @umariqbal568 2 ปีที่แล้ว

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

  • @marcovilla2112
    @marcovilla2112 ปีที่แล้ว +2

    great explanation

    • @RezaDorrani
      @RezaDorrani  ปีที่แล้ว

      Thanks

    • @marcovilla2112
      @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
      @RezaDorrani  ปีที่แล้ว +1

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

    • @marcovilla2112
      @marcovilla2112 ปีที่แล้ว +1

      @@RezaDorrani thanks! will do it

  • @beryl.chu1992
    @beryl.chu1992 3 ปีที่แล้ว +1

    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
      @RezaDorrani  3 ปีที่แล้ว

      Great to hear! Thank you for watching.

  • @marieraymond6512
    @marieraymond6512 2 ปีที่แล้ว

    Hey Reza, Would this solution work if I was creating a task in a SharePoint library or does the Task list have to be another list?

    • @RezaDorrani
      @RezaDorrani  2 ปีที่แล้ว

      You can create tasks in a doc lib. Doc libs are for files only. You would need to create a separate task list.

  • @christophmeirich5928
    @christophmeirich5928 2 ปีที่แล้ว +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
      @RezaDorrani  2 ปีที่แล้ว +1

      That limitation can be addressed if delegation is taken care of.
      th-cam.com/play/PLTyFh-qDKAiE6ia-D94Qk5-AzpN4dqOmD.html

  • @wojciechwsap993
    @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
      @RezaDorrani  ปีที่แล้ว

      th-cam.com/video/25_bdexevGk/w-d-xo.html

  • @EdCrousore
    @EdCrousore ปีที่แล้ว +1

    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
      @RezaDorrani  ปีที่แล้ว

      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.

    • @EdCrousore
      @EdCrousore ปีที่แล้ว

      @@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
      @RezaDorrani  ปีที่แล้ว

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

    • @EdCrousore
      @EdCrousore ปีที่แล้ว

      @@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
      @RezaDorrani  ปีที่แล้ว

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

  • @ArohShukla
    @ArohShukla 3 ปีที่แล้ว +1

    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!

  • @cromagnon71
    @cromagnon71 2 ปีที่แล้ว +1

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

    • @RezaDorrani
      @RezaDorrani  2 ปีที่แล้ว +1

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

    • @cromagnon71
      @cromagnon71 2 ปีที่แล้ว +1

      @@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
      @RezaDorrani  2 ปีที่แล้ว

      @@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
      @RezaDorrani  ปีที่แล้ว

      Check channel memberships. I have gone live with a training tier that you can sign up for now.
      th-cam.com/users/rezadorranijoin

  • @ravigandhi8575
    @ravigandhi8575 3 ปีที่แล้ว +1

    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
      @RezaDorrani  3 ปีที่แล้ว

      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.

  • @Empriction
    @Empriction 2 ปีที่แล้ว +1

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

    • @RezaDorrani
      @RezaDorrani  2 ปีที่แล้ว +1

      Happy to hear that! Thanks for watching.

  • @oricchannel2811
    @oricchannel2811 2 ปีที่แล้ว +1

    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
      @RezaDorrani  2 ปีที่แล้ว +1

      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.

  • @TheMKTube
    @TheMKTube ปีที่แล้ว

    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!

    • @RezaDorrani
      @RezaDorrani  ปีที่แล้ว

      Ive done videos on bulk adding updating data. Look through videos on my channel.

  • @tommytian4017
    @tommytian4017 3 ปีที่แล้ว +1

    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?

    • @RezaDorrani
      @RezaDorrani  3 ปีที่แล้ว

      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.

  • @dan.7997
    @dan.7997 3 ปีที่แล้ว +1

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

    • @RezaDorrani
      @RezaDorrani  3 ปีที่แล้ว +1

      You are most welcome and thanks for the feedback

  • @alzaimoor79
    @alzaimoor79 3 ปีที่แล้ว +1

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

    • @RezaDorrani
      @RezaDorrani  3 ปีที่แล้ว

      Thanks for watching.

  • @venukolar7999
    @venukolar7999 2 ปีที่แล้ว

    Hi Reza Dorrani, thank you for your video, it's very informative. I have a query from my end I am working on a leave management system in Power apps and I need to use the look-up column based on two share point lists which are User credentials and Leave balance. How can I write the logic in Power apps based on the above two Sharepoint lists so that my end user can able to LOGIN and submit the leave request? please help me with how to write this logic. thank you.

    • @RezaDorrani
      @RezaDorrani  2 ปีที่แล้ว

      To help I would have to see your use case in action. I do not have a video reference on your scenario either.
      I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

  • @dushyanthasanjeewa8983
    @dushyanthasanjeewa8983 ปีที่แล้ว +1

    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
      @RezaDorrani  ปีที่แล้ว +1

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

  • @myama9688
    @myama9688 หลายเดือนก่อน

    Hello Reza, thanks for this video, it helped to achieve what I need it, there is one point I'm struggling with , when I submit the form it goes back to the first record, how can I stay in the record that I've just created ?

    • @RezaDorrani
      @RezaDorrani  หลายเดือนก่อน +1

      Once form is submitted, you can set a variable on form success action to have context of record submitted. Then use that to set default value of gallery.

  • @MrPsith
    @MrPsith 2 ปีที่แล้ว +1

    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
      @RezaDorrani  2 ปีที่แล้ว

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

  • @i3oomiizz
    @i3oomiizz 3 ปีที่แล้ว +1

    Hi Reza, this is very helpful content for me. Let's me ask you something about Header Table & Details Table, If I want to give the user fill the new record form that combines from Header & Details table. What is the solution for Header ID (that not yet generated) for Detail Reference ID when submitting the form to record in the table? Thanks.

    • @RezaDorrani
      @RezaDorrani  3 ปีที่แล้ว +1

      You would need the parent item generated first in order to get that unique ID.
      Ideally disable related item creation until parent item is saved once (to generate than unique ID).
      OR
      Generate a random guid as ID (temporary) and then patch parent first (get the ID) and then patch the related data.

    • @i3oomiizz
      @i3oomiizz 3 ปีที่แล้ว +1

      @@RezaDorrani Thank you for your suggestion :)

  • @PaulSumpter-v9e
    @PaulSumpter-v9e ปีที่แล้ว

    Hi newbie, love the post. On your main screen you have a tabular list added. How/where do you add this control or did you adapt an existing gallery layout somehow. I am trying to replicate everything you have created here to train myself. Any help greatly appreciated (love the video by the way).

    • @RezaDorrani
      @RezaDorrani  ปีที่แล้ว +1

      Existing gallery. Check th-cam.com/video/bnC8u3gdWss/w-d-xo.html

    • @PaulSumpter-v9e
      @PaulSumpter-v9e ปีที่แล้ว +1

      @@RezaDorrani perfect, thank you!

  • @cheriewong9470
    @cheriewong9470 2 ปีที่แล้ว +1

    Reza, this videonis exactly what i needed for my project, except I dont need a home screen. However, I am stuck at the set varRecord variable steps as I have Sharepoint integration . Can you please give me some insight on how to set the thisitem variabls so I can link the parent and child list between 2 screens? In my parent's form item, there's already SharePoint integration formula and I dont have a home screen to set variable there.

    • @RezaDorrani
      @RezaDorrani  2 ปีที่แล้ว

      SharePointIntegrationObject has special properties for on new, on edit and on view. They get called when the app is loaded. You can set the varRecord in there.
      I would have to try it out your scenario to provide further guidance. I would also recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

    • @cheriewong9470
      @cheriewong9470 2 ปีที่แล้ว

      @@RezaDorrani Thanks so much for responding so quickly. So it's just like your example, I have a parent screen with parent's fields (on a form) for user to input information. I added a button on the parent screen for user to add children; the button will take the user to a second screen with the child form. Now in your example, you set the variable so the parent record ID can be carried over to the child's form and so to only display children that belong to this parent on the parent screen. How do I set that variable with sharepoint integration already in the item for the parents form?

    • @RezaDorrani
      @RezaDorrani  2 ปีที่แล้ว

      @@cheriewong9470 As I said, I would have to try it out to give exact guidance.
      I will recommend posting your scenario with screenshots on the forums.

  • @mikegc3816
    @mikegc3816 2 ปีที่แล้ว

    Hi Reza, did you create a previous video for the forms etc. Were they created from SharePoint or did you create from scratch? - thanks Mike

    • @RezaDorrani
      @RezaDorrani  2 ปีที่แล้ว +1

      Forms - th-cam.com/video/aVEaRpAlaTA/w-d-xo.html
      Galleries - th-cam.com/video/bnC8u3gdWss/w-d-xo.html
      Form + Gallery - th-cam.com/video/HHXKfB1iAH4/w-d-xo.html

    • @mikegc3816
      @mikegc3816 2 ปีที่แล้ว +1

      @@RezaDorrani Thanks Reza, I think I have figured it out, but will look at the videos as well

  • @hanalam6090
    @hanalam6090 2 ปีที่แล้ว

    Hi Reza,
    Amazing tutorial, however my Ref ID column, is coming up as a dropdown box. How do I change this to look like yours?

    • @RezaDorrani
      @RezaDorrani  2 ปีที่แล้ว

      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

  • @ky0105
    @ky0105 ปีที่แล้ว +1

    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
      @RezaDorrani  ปีที่แล้ว

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

    • @RezaDorrani
      @RezaDorrani  ปีที่แล้ว

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

  • @mkavo
    @mkavo 7 หลายเดือนก่อน

    Hey Reza, have you ever done a Summary screen where you would pull together all the data submitted in the list and related lists and be able put it into a doc and email it to the user? e.g.. a Project with multiple tasks and maybe multiple Resource info etc, summarise on one screen and email all the details (in pdf or Word) to a project manager...Just wondering best approach, maybe multiple galleries but how to snapshot that best from the screen

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      I have not tried this.

  • @aarongayah2358
    @aarongayah2358 3 ปีที่แล้ว +1

    You explained this wonderfully. Well done.

  • @oca5383
    @oca5383 3 ปีที่แล้ว

    heyy which video is talking about your content page? i wanted to learnd how to make like yours page

    • @RezaDorrani
      @RezaDorrani  3 ปีที่แล้ว

      The Landing screen? I haver multiple videos on forms and galleries in my Power Apps Playlist.
      Check th-cam.com/play/PLTyFh-qDKAiEIVlidnhELx5BusnzlDzkR.html

  • @nouriairbah2334
    @nouriairbah2334 3 ปีที่แล้ว +1

    Exactly what I needed, Thank you Raza!

  • @sureshpune6076
    @sureshpune6076 2 ปีที่แล้ว

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

    • @RezaDorrani
      @RezaDorrani  2 ปีที่แล้ว +1

      You could use Patch for that.

  • @CaptMAGpie
    @CaptMAGpie 2 ปีที่แล้ว +1

    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?

    • @RezaDorrani
      @RezaDorrani  2 ปีที่แล้ว +1

      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

    • @CaptMAGpie
      @CaptMAGpie 2 ปีที่แล้ว +1

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

    • @RezaDorrani
      @RezaDorrani  2 ปีที่แล้ว

      @@CaptMAGpie Awesome 👍

  • @cs9181
    @cs9181 ปีที่แล้ว +1

    awesome! This will work perfectly for tracking revisions.

  • @finnpower92
    @finnpower92 3 ปีที่แล้ว

    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.

    • @RezaDorrani
      @RezaDorrani  3 ปีที่แล้ว +1

      Check formula at 14:40, varRecord is a variable that holds context of selected item in Gallery.

  • @GoSlowToGoFastOG
    @GoSlowToGoFastOG ปีที่แล้ว +1

    This is relatively easy to follow and after a few hours I am pretty happy with what I have created for a workload tracker for our team. I just finished watching the creating tabs video, anyone know if it’s possible to create something similar to the task relationship list in this video as a tab to the main form? Where you can view the related tasks on a different tab.

    • @RezaDorrani
      @RezaDorrani  ปีที่แล้ว +1

      Thanks for watching.
      I would recommend checking or posting your query on forums in case someone has done something similar to the scenario you mentioned powerusers.microsoft.com/

    • @GoSlowToGoFastOG
      @GoSlowToGoFastOG ปีที่แล้ว

      @@RezaDorrani Thanks for the advise. I don’t know why but a Microsoft power user forum sounds intimidating. 🤷🏾‍♂️

    • @RezaDorrani
      @RezaDorrani  ปีที่แล้ว

      @@GoSlowToGoFastOG It's a place where over 100k users are plugged in.

  • @anjorinmanuwa2885
    @anjorinmanuwa2885 3 ปีที่แล้ว +1

    Your're the special one Reza!

  • @ImGumby49
    @ImGumby49 11 หลายเดือนก่อน

    Great Stuff! So in my case I have a "Project Form" with is equal to your "Content Info" form. I have added a related "Labor" form which is essentially equal to your tasks form. I would like to add a "Materials" form but I am having issues with the RefID. Does adding a second related form require a different process?

    • @RezaDorrani
      @RezaDorrani  11 หลายเดือนก่อน

      Thanks so much!
      Process would be the same. Not sure why you would be facing issues. I will recommend checking or posting your issue on the forums at powerusers.microsoft.com/

    • @ImGumby49
      @ImGumby49 11 หลายเดือนก่อน +1

      @@RezaDorrani Thanks for your response. I found my issue (i had entered incorrect info in the default properties)...duh!
      In your video, you use a "secondary" form to enter the tasks. Can the tasks be entered directly into the gallery or does that over complicate toe Power App?

    • @RezaDorrani
      @RezaDorrani  11 หลายเดือนก่อน

      @@ImGumby49It can be. Check my latest video on list relationships

  • @JacobRobles-i3e
    @JacobRobles-i3e ปีที่แล้ว

    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
      @RezaDorrani  ปีที่แล้ว

      th-cam.com/video/25_bdexevGk/w-d-xo.html

  • @dasajeeva6875
    @dasajeeva6875 3 ปีที่แล้ว +1

    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
      @RezaDorrani  3 ปีที่แล้ว

      Here it is th-cam.com/video/bnC8u3gdWss/w-d-xo.html

  • @GSoftagon
    @GSoftagon 2 ปีที่แล้ว +1

    Thank you. I really love your channel.

    • @RezaDorrani
      @RezaDorrani  2 ปีที่แล้ว

      😊

    • @GSoftagon
      @GSoftagon 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
      @RezaDorrani  2 ปีที่แล้ว

      @@GSoftagon Try th-cam.com/users/rezadorrani link and see if it works.

    • @GSoftagon
      @GSoftagon 2 ปีที่แล้ว +1

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

  • @mattiafoschetti6876
    @mattiafoschetti6876 3 ปีที่แล้ว +1

    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.

    • @RezaDorrani
      @RezaDorrani  3 ปีที่แล้ว

      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

  • @Heisshena
    @Heisshena ปีที่แล้ว +1

    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
      @RezaDorrani  ปีที่แล้ว +1

      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

  • @sandroe123
    @sandroe123 4 หลายเดือนก่อน

    Thank you so much for this video! I have 1 problem though: when I create a Task the Ref ID get's populated with the ID from the list but when I save the task the 'Ref ID' column doesn't get trough to the SharePoint list. So it creates a new task with all the columns except the Ref ID wich stays empty... Any thoughts? Big thanks!

    • @RezaDorrani
      @RezaDorrani  4 หลายเดือนก่อน

      Most welcome!
      I have not come experienced this issue and hence not sure what is the cause for it. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

  • @TylerMeverden
    @TylerMeverden 8 หลายเดือนก่อน

    Thanks so much Reza for the videos! I have one question about the main form. It appears that the Content Info screen has a form called "fromContent" and a form called "contentForm". Is this correct or is there only one main form? I looked through the comments but did not see this issue come up explicitly

    • @RezaDorrani
      @RezaDorrani  8 หลายเดือนก่อน

      I did this video years ago. Do not remember the specifics of the form name.

    • @TylerMeverden
      @TylerMeverden 8 หลายเดือนก่อน

      at 16:00 "contentForm" appears to be used for the first time, up to this point this form appeared to be called "fromContent"

    • @RezaDorrani
      @RezaDorrani  8 หลายเดือนก่อน

      @@TylerMeverden Its probably formContent
      Might simply be an editing error

    • @TylerMeverden
      @TylerMeverden 8 หลายเดือนก่อน

      Thanks so much for your quick reply!