Power Apps working with SharePoint List Relationships

Подписаться 130 тыс.

Просмотров 196 тыс.

50% 1

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

Наука

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

21 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 557

@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

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

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

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

@user-nv2iu6be3d Год назад

This might be my first time leaving a comment on any RU-vid 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!

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

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

@vhinduphilco5670 2 года назад

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

@RezaDorrani 2 года назад

Awesome! Thank you!

@benbanurji1727 3 года назад

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

@RezaDorrani 3 года назад

Thanks Ben

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

@sagarjoshi6070 2 года назад

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

@RezaDorrani 2 года назад

Wow, thanks man.

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

@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

@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

@cpbittner 10 месяцев назад

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

@RezaDorrani 10 месяцев назад

Great to hear and thanks so much!

@simonball5602 Год назад

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

@RezaDorrani Год назад

Most welcome

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

@god_hacker581 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 2 года назад

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

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

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

@rachelharkin2190 2 года назад

Your videos are so great - incredibly helpful, thankyou!

@RezaDorrani 2 года назад

Glad to hear that! Thank You for watching

@Empriction Год назад

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

@RezaDorrani Год назад

Happy to hear that! Thanks for watching.

@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

@MsRodrovisk 3 года назад

Your solutions are always incredible!!!

@RezaDorrani 3 года назад

Thank You :)

@zerocool200380 3 года назад

Reza, Another great video. Thank you!

@RezaDorrani 3 года назад

You are most welcome

@simonball5602 Год назад

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

@RezaDorrani Год назад

Much appreciated

@mohadesehasadi2077 Год назад

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

@RezaDorrani Год назад

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, 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 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 5 месяцев назад

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

@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 2 года назад

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

@RezaDorrani 2 года назад

Its in my backlog

@YohanesOktavianusSiagian 2 года назад

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

@RezaDorrani 2 года назад

Awesome

@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

@husainkoolarzadeh4367 3 года назад

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

@RezaDorrani 3 года назад

Thank you :)

@aarongayah2358 3 года назад

You explained this wonderfully. Well done.

@RezaDorrani 3 года назад

Glad you liked it

@nouriairbah2334 2 года назад

Exactly what I needed, Thank you Raza!

@RezaDorrani 2 года назад

You're welcome 😊

@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 Год назад

Good stuff! Thank you Reza!

@RezaDorrani Год назад

Your most welcome

@shaikmohammedabdulsamad4280 3 года назад

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

@RezaDorrani 3 года назад

Thank you

@DavideGalloni 2 года назад

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

@RezaDorrani 2 года назад

Glad it was helpful! Thanks for watching.

@vidabailey16 Год назад

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

@RezaDorrani Год назад

Glad you like them!

@anshulbhardwaj7477 Год назад

The way you explain is amazing.

@RezaDorrani Год назад

Thank You

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

@cs9181 Год назад

awesome! This will work perfectly for tracking revisions.

@RezaDorrani Год назад

Great!

@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

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

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

@thermant8452 3 года назад

This was good! Can't wait to implement

@RezaDorrani 3 года назад

Thanks

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

@mohanadalhiti4300 2 года назад

Great work, thank you for your great ideas and work

@RezaDorrani 2 года назад

Glad you like them!

@gideon17you Год назад

Thank you. I really love your channel.

@RezaDorrani Год назад

😊

@gideon17you Год назад

@@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 Год назад

@@gideon17you Try ru-vid.com link and see if it works.

@gideon17you Год назад

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

@muhannednidal3647 3 года назад

Excellent explanation I enjoyed watching.

@RezaDorrani 3 года назад

Thanks for watching

@anjorinmanuwa2885 2 года назад

Your're the special one Reza!

@RezaDorrani 2 года назад

Thank You 😊

@sp0ng007 28 дней назад

Thank you for amazing video this was very informative

@RezaDorrani 28 дней назад

Glad it was helpful!

@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 - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-yeAnuTB85eg.html

@kevinjoseph9023 2 года назад

You’ve got great kit!

@RezaDorrani 2 года назад

Thanks

@mattiafoschetti6876 2 года назад

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 2 года назад

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

@kwmotion1922 2 года назад

explained very good thanks a lot

@RezaDorrani 2 года назад

Glad you liked it!

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

@margiopetra 2 года назад

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 2 года назад

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

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

@sundrapillay6668 3 года назад

Thanks Reza excellent video

@RezaDorrani 3 года назад

My pleasure!

@MichaelDeBlasis1369 3 месяца назад

Just what I needed.

@RezaDorrani 3 месяца назад

Great!

@MichaelDeBlasis1369 3 месяца назад

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 3 месяца назад

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

@kerriejarman1447 2 года назад

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

@RezaDorrani 2 года назад

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

@ranjanroy1623 10 месяцев назад

@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 10 месяцев назад

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

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

@bestyapper 2 года назад

Thanks!

@RezaDorrani 2 года назад

Thank You

@frenamakenson9844 2 года назад

Very good video !

@RezaDorrani 2 года назад

Thanks

@mariorgutierrezleal 2 года назад

Great vídeo!!

@RezaDorrani 2 года назад

Thank You

@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 Год назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-25_bdexevGk.html

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

@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 RU-vid chat is not a viable option.

@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 Год назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-25_bdexevGk.html

@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

@davealejo8050 Год назад

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 Год назад

Those are customized galleries. Check ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bnC8u3gdWss.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....)

@user-mq9xk4sc8y 5 месяцев назад

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 5 месяцев назад

In that case you would need to query on lookup column. I did another video on this topic ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-1Qsf2RPyp8s.htmlsi=R0_Q7xqEFHlob2h2

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

@umariqbal568 2 года назад

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

@RezaDorrani 2 года назад

Possible

@lradasme Год назад

¡Gracias!

@RezaDorrani Год назад

Welcome

@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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bnC8u3gdWss.html

@SirAbaba 26 дней назад

thank you for sharing

@RezaDorrani 26 дней назад

My pleasure

@ppei2012 3 года назад

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.

@ppei2012 3 года назад

Never mind. I found out that I need to insert labels (not textinput) in template cell.

@RezaDorrani 3 года назад

Looks like you got the answer :)

@RezaDorrani 3 года назад

nice

@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

@tommytian4017 3 года назад

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

@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 Год назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-25_bdexevGk.html

@msaleemeng 2 года назад

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.

@RezaDorrani 2 года назад

Which part of the video was this showcased in? Can you share the timing please?

@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 Год назад

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

@printprint5583 2 года назад

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.

@RezaDorrani 2 года назад

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.

@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 10 месяцев назад

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 10 месяцев назад

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

@finnpower92 2 года назад

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 2 года назад

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

@NicoLabajo Год назад

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

@RezaDorrani Год назад

Yes

@GoSlowToGoFastOG Год назад

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 Год назад

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 Год назад

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

@RezaDorrani Год назад

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

@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

@Lukesta0 3 года назад

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?

@RezaDorrani 3 года назад

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/

@Lukesta0 2 года назад

@@RezaDorrani thanks so much!

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

@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 2 года назад

Check ru-vid.com/group/PLTyFh-qDKAiFUEgsXoQ9E-LJu4lcS0iMI

@mkavo 4 месяца назад

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 4 месяца назад

I have not tried this.

@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

@DavideGalloni 2 года назад

Hi Reza, thanks for this useful video. I have a similar situation in my project, my difficult is that I need to filter data in a sharepoint list, based on value in another sharepoint list. Using your example: How can I filter "Content gallery", starting for "Complete Task" status?? For example, I have a combo box that contains Task Complete chioice "true" and "false". If I select one of combobox value (false for example), I would like to see which "Content" have task in "complete status" = false. Have you do a video that explain this situation??? Thanks!!

@RezaDorrani 2 года назад

I do not have a video reference on this scenario and 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