Mastering SharePoint List Relationships in Power Apps | Create Responsive Repeating Tables

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

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

50% 1

In this step-by-step tutorial video, we will learn how to build related SharePoint Lists using Lookup columns and work seamlessly with multiple related lists within Power Apps.
🚀 What You'll Learn 🚀
🔹 Power Apps working with List Relationships
🔹 Establishing a 1:N relationship between projects and tasks in SharePoint/Microsoft Lists.
🔹 Creating a fully responsive Canvas Power App connected to your Main List.
🔹 Leveraging Power Apps Galleries to craft an Editable Grid experience similar to InfoPath Repeating Tables.
🔹 Performing CRUD (Create, Read, Update, Delete) operations effortlessly.
🔹 Saving Grid Updates to your data source with a single, efficient Patch function.
🔹 Sorting grid data
🔹 Horizontal scroll for Vertical Gallery in Power Apps
🔹 Sticky Header for Grid/Gallery/Repeating Table
🔹 and much more!
If you're looking to enhance your skills and create Excel-like Grid experiences with multiple related SharePoint Lists in Power Apps, this tutorial has you covered.
⬇️ Download sample Power App shown in video:
Exclusive for Channel Members (Silver 🥈 & Gold 🥇 Club)
Find the download link in the Community Tab for Members.
To become a member, click here: ru-vid.comjoin
Power Apps Editable Grid / Table playlist:
• Power Apps Grid
#PowerApps #SharePoint #PowerPlatform
Table of Contents:
00:00 - Introduction to working with SharePoint List Relationships in PowerApps
00:49 - Demo of Power App connected to multiple related SharePoint Lists
02:59 - Connect SharePoint Lists using Lookup column
06:42 - Build a Responsive Canvas Power App connected to SharePoint List
08:02 - Editable Grid experience using Gallery in Power Apps
20:43 - Add a new row to Grid
23:26 - Power Apps Gallery as an editable grid
24:10 - Set Grid Menu buttons
25:36 - Power Apps Grid show latest data from related SharePoint list
26:26 - Horizontal scrollbar for a Power App Vertical Gallery
29:24 - Sort Gallery/Repeating Table/Grid
29:50 - Delete row from Power Apps Gallery
30:44 - Sticky header with horizontal scroll for Power Apps
32:29 - Subscribe to Reza Dorrani Channel
🤝 Let’s connect on social:
🔗 Reza Dorrani LinkedIn: / rezadorrani
🐦 Reza Dorrani Twitter: / rezadorrani

Наука

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

8 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@gregcalvert4645 9 месяцев назад

Reza the mind reader....! 😎

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

😊

@leoriosan4860 9 месяцев назад

Right??? I was literally googling and mulling this over for a project yesterday. Reza to the rescue!

@user-bv7ri4wc1w 9 месяцев назад

This is it. I have several SharePoint list that I wanted to create a relationship to. Reza you are the best. Thanks.

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

Glad it was helpful!

@Robot-Rising 9 месяцев назад

This video could not have come at a better time! Currently building an app that requires an entry of multiple users that are associated with a top level item on another list (ideally). Your video came just in time! 👏👏🍻

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

So happy to hear the video is useful and will come in handy for real world scenarios.

@simonball5602 9 месяцев назад

Amazing - just the video I’ve been looking for. You’re the master Reza.

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

Wow, thanks.

@JorgeRuiz14 2 месяца назад

I been working on a project where I was having issues figuring out the relationship issue between lists. This is a lifesaver! I just signed up as a Silver Member....Great content 👍👍👍

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

Welcome onboard!

@nickfaulkner6161 9 месяцев назад

Rezza, another great video. The information in this video is great! The more videos I watch, things are just starting to click more and more!

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

Great! Step by step, video by video, we keep learning together.

@AhmedBalfaqih День назад

Wow. What a fantastic tutorial. Certainly not for beginners, but it is packed with tips and tricks. Thank you, Reza.

@RezaDorrani День назад

Most welcome! Video description has details to download entire solution (members only) in case someone wants to learn in detail.

@AhmedBalfaqih День назад

I will join for sure soon once I get my momentum.

@RahulPatil-mh4qc 9 месяцев назад

Was struggling with lookup columns from a very long time. Hope this helps. Thanks Reza ❤

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

Most welcome

@oluwatobipaul6171 9 месяцев назад

This came in at the right time. Thank you Reza

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

Most welcome

@dougydoe 9 месяцев назад

Another Info-Packed video. Really great insights. Loving the responsive tips along side as it's helping me finetune a Responsive App I'm working on now which is coming along nicely. I always look forward to your videos and I'm yet to be disappointed. Thanks for sharing.😀

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

Awesome! Thank You so much. So happy to hear the responsive aspects of the video are being appreciated.

@dougydoe 9 месяцев назад

@@RezaDorrani Yes, I'm actually enjoying building the Responsive App.

@cmarkbernal 9 месяцев назад

You're so awesome Reza! I got your video message from conference. Thank you for taking the time to send it! I'm a total fan girl. I shared it on FB and tagged your page too! 🤗😍

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

Oh awesome! 😊 You are most most welcome

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

Great video Reza!

@spen2431 9 месяцев назад

Hide the buttons - then add a select....... who would have thought ! Nice 💥💥 (I always pick up something new in each of your videos!) - Thank You

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

Boom!

@TheLikerofPie 9 месяцев назад

Amazing video - thank you so much!

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

Most welcome

@olisaemekaaghabuilo8688 9 месяцев назад

Thanks Raza for this wonderful teaching.

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

My pleasure

@meng-shanwu4475 6 месяцев назад

It is such a great channel! Thank you!

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

Thanks so much

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

Thank you, it’s veryyyyy useful VDO

@carlw 9 месяцев назад

Awesome thanks for the video!! 👍🏼👍🏼👏👏 I'm going to implent this in a number of my apps.

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

Great 👍

@villagevihari3332 9 месяцев назад

Awesome Content 👏, actually im looking for it , Thank you Reza ❤🎉🎉🎉

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

You're welcome 😊

@huynhleg 27 дней назад

Thank you for this fantastic video. The way you explained and gave examples was very easy to understand.

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

You're most welcome

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

Reza tq so much, this help a lot

@5Lax 9 месяцев назад

This is great Reza! I may use this video as a demo for my management team to invest more into power apps.

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

Please do!

@hamytube 9 месяцев назад

Great video 🎦 @reza, Your videos are helpful for the Power Platform community. Thanks

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

Glad to hear that!

@liamanon 6 месяцев назад

Hi Reza, thanks for posting this super video - really informative and interesting!!! 👏😃👍 Looking forward to trying something like this out for a Lessons Learnings system at work.

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

Glad it was helpful!

@shaikhfirdos2723 9 месяцев назад

Awesome video..🎉🎉❤ Thanks Reza

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

Glad you liked it!

@ali4solutions 6 месяцев назад

Brilliant Job Reza, Need more on Master detail relationship.

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

Thanks

@ali4solutions 6 месяцев назад

Struggling with UpdateIf() , It is not allowing me to update LookUp Columns no sure why. @@RezaDorrani

@vibhanshutripathi20 8 месяцев назад

no doubt you are a mind reader.

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

😉

@nihar4713 6 месяцев назад

this is amazing

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

Thanks

@kamalakarreddyuppala3772 9 месяцев назад

Thanks Reeza

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

Most welcome

@mkavo 8 месяцев назад

Hey Reza this is great, wasn't too sure about using the modern controls but more confident about them now. Have you ever done anything on cloning/copying records were list relationships are involved, such as if you wanted to use a project with its tasks as a template for people to get quickly up and running?

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

I have not tried cloning records with relationships.

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

Hey Reza, thank you for this video and all your videos (of which I have watched many :D)! At the moment I'm looking into changing 4 dataverse tables into Lists as my users will not have a Power Apps Premium license. Which is incredibly expensive, even for education. There are a lot of mixed opions online about whether or not using SharePoint Lists as a relational database (like in this video) is bad. To be honest I still can't see the big issue for regular apps. In my example I'll have about 100-150 "projects" maximum in 1 Projects List and each project has about 5 Tasks itself, so 750 max in total. There will be different Teams with their own projects = multiple Projects Lists with their own Tasks. All in seperated lists with their own List Permissions (Read/write). Honestly I think it's manageble with Lists. Though the internet seems to push me towards Dataverse (which we cannot pay for user to write to the dataverse tables). Do you think I should go for SharePoint Lists? Is it doable?

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

Dataverse is the preferred option from a scalability perspective but for lightweight scenarios SharePoint can do the work

@JamesUnited88 8 месяцев назад

Hi Reza, this is fantastic thank you so much as always! I have built something for work which replaces projects with risks and tasks with treatments to lower the risk which works great but I have been wondering if there is a way to assign the tasks (or treatments in my case) to multiple projects? When I allow multiple selections on my list, it creates an incompatible comparison so is there a way I can get round this? Any help would be much appreciated!

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

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

@EasyProj 9 месяцев назад

Awesome👍👍 Expect Project Timesheet Management App if possible...

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

Thanks! I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.

@myatix1 9 месяцев назад

Hi Raza, Thanks for sharing this! It’s really helpful as always such detailed steps that make it so clear. Can I ask if there are any delegation issues as this has been an issue in the past. Also is there a way of dynamically getting data from multiple sharepoint sites which have the same list structure?

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

There are no delegation issues here. Unless you have more than 2000 tasks for a specific project. Dynamically getting data will run into delegation challenges and not something I have done any work on.

@yuki-manthonee0101 9 месяцев назад

Hi Reza, great video! Curious, is there a possibility to show a gantt or visual timeline? And/or ability to see overlapping projects?

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

Not something I have attempted so not sure. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

@prosperkamana7146 9 месяцев назад

Many to you Reza Dorrani for sharing power apps using related lists(1:N), The video will help a lot on the project I want to work on. Is there a way to to auto number rows in editable grid? Thank you for your continous knowledge sharing.

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

Most welcome! Probably possible but not something I have attempted.

@gregkinne4177 9 месяцев назад

Hi Reza...great app! Will these type fields (Lookup and Choice fields) work just the same with a SQL table storage instead of SharePoint List? Thanks for all your professional and amazing apps!

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

SQL uses FK and PK type true relationship. Behavior would be similar.

@davidsimoneta8513 9 месяцев назад

Amazing, Reza...👍 I have a case in which many projects must be tracked saving all tasks, approvals, notes, files... Must they be separated in different related lists and concatenate collections of max 2000 rows to avoid delegation problems?

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

Too many collections and too many relationships will hit performance of App. For lightweight use case SharePoint is good but beyond that you should consider Dataverse or SQL

@mutantlabor 8 месяцев назад

Reza, thank you so much. Why don’t you have to include the Priority choice/drop-down field under ShowColumns in your Patch function? Yours seems to still update the choice column in SharePoint but mine does not. 20:17

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

You will have to. Check 22:56 Always best to see entire video. Sometimes we do miss certain things.

@user-ox7gp7bf5f 4 месяца назад

Hi @Reza Dorrani, Great video! However, I am getting a little stuck when updates are made to the grid. For example, with an already created record, if I update the values and select 'Save', the previous values are retained in the fields. How can I get the updates to stick when Save is selected?

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

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

@thanakorntuti496 6 месяцев назад

Hi Reza, I think it very good and it’s helpful and I follow your instruction to create an application. But Would you please help me a little bit to show how to add a row number in the dynamic gallery ?

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

Most welcome! I do not have a video reference for dynamic row number and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

@user-jf3ci5gj2o 7 месяцев назад

Hi Reza, thanks for the video. Quick question on this. Given that multiple projects could have the same title in theory, is there a way to lookup to project ID rather than project title? I'm doing a similar 1:N app for a ticket system with comments, and I had it working when the ticket title was the lookup field in the comments list, but when I realized the duplication issue and switched to ID, I'm having issues getting the linked formulas to work. Wondering if the ID column has specific rules/attributes that make this problematic, but then not sure how to work around it to avoid the duplicate title issue. Thanks again for your videos. Very helpful.

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

You can decide which column you want to lookup on.

@wernermosimann7673 8 месяцев назад

Hello Reza, thank you very much for this great tutorial. I have the challenge of creating a trust relationship between an entry in a SharePoint list and a document in a folder/subfolder in a document library. Unfortunately, I haven't got the hang of it yet. Do you have a tip for me here?😉

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

Most welcome! I do not have any video references with folder/sub-folder scenario and not something I have attempted.

@londonengland2309 9 месяцев назад

Many thanks Reza, I need to watch this fully. But in the intro I did not see a link to the submitted documents for each project. Can it be added.

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

The video use case is projects and tasks. It’s purely focused on list relationships.

@user-yl8zm3uk1p 6 месяцев назад

Hi Reza, great video, is it possible to add/insert a new record with the same data type column from another sharepoint list to destination sharepoint list, something like in sql, insert into existing table from new table.. thank you

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

Probably possible but not something I have tried.

@PhuongTran-bh8rj 8 месяцев назад

HI Reza, thank a lot for great presentation. I'm interested in Patch function in 20:06 minute, I want to apply with Person column in Microsoft list, but it doesn't work as your way. Is there any thing needed here?

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

rezadorrani.com/index.php/2020/05/04/power-apps-patch-function-with-sharepoint/

@sibidi894 6 месяцев назад

The lookup column option is good if the number of items in the list is not expected to exceed 5000 items. Otherwise, it's best to use dataverse or SQL tables.

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

Column indexing may help

@disturbedcarrot 6 месяцев назад

What happens with lookups if you exceed 5000 records? That's not a lot of records. Is there a better alternative to lookups?

@SmartLearningAI 7 месяцев назад

Nice Demo, Can you do one using Dataverse with model-driven apps to build the same thing.

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

I have done Dataverse table relationship video.

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

Hello Reza ! Jason Here! Quick Question ; How many Sharepoint List as Lookup is recommended to have into a canvas apps. its performance being affected ? Glad for showing me this amazing resource in order to advance in my learning path Blessings

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

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

@mizbhakhanum3974 5 месяцев назад

Hi Reza, This video is extremely helpful. I have created an Application using this as reference. I have a requirement here to display sum of values in a column in the tasks gallery in the label. Anything you can suggest to help on this?

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

1 - Explore documentation on sum function. 2 - Bring this up during live Q/A on Feb training call

@MaeC77 23 дня назад

Great video! Thank you! I became a member so I could purchase, customize, and deploy quickly, as well as gain more knowledge & experience w/power apps so thank you! Quick question why does the search bar on Main screen not function? It seems like a simple straightforward function but for some reason I cannot get it to search my “projects” list in the side container . Is it possible the hidden button that is in the search box area causing issues w/the search functionality? Thanks again.

@RezaDorrani 23 дня назад

Most welcome! Did you download and try the app?

@MaeC77 23 дня назад

@@RezaDorrani Thank you for getting back to me. Yes, I did. It’s up and running and I customized it for my specific need but the search function does not work. I have a similar app set up just the same as the main screen of your app and the search function works great no problem. I just can’t figure out why it won’t search. The 🔍 icon does nothing. I’ve checked all possibilities. Thank you!

@MaeC77 23 дня назад

I decided to watch another video of yours for setting up my search function. My lists are not large now but they will grown very quickly so I need to set it up accordingly. Thanks.

@catieg5659 5 месяцев назад

Hi Reza, this tutorial was fantastic! It helped so much with my app creation. Would you be able to go into further detail about this functionality with a Person column? I would like to do exactly this but am having trouble displaying my Person chosen in a ComboBox after adding items or deleting rows from my gallery. How can I replicate these things with a selected Person?

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

Glad to hear that! I have not tried with a person column so not sure about that. No current plans to explore it. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

@catieg5659 5 месяцев назад

@@RezaDorrani I have been looking on the forums (and posted my question) with no luck. Hopefully someone can find a solution soon. Thanks for sharing your knowledge!

@elajujoseph2746 9 месяцев назад

Thx Reza, do you have any video on employee recruitment app in power Platform? Or SharePoint

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

Most welcome! I do not have any related to employee recruitment app in power Platform Or SharePoint

@TheMustseevideo 5 месяцев назад

Hi Reza, I always enjoy your videos, the examples and explanations are great and I appreciate that! Yesterday I became a member but when I try to access any link (Silver club) I get a Password request, until now I have note received any, does it takes a few days or how does it work? Thanks

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

Silver club gives access to apps/flows shared in last 90 days. This video was done over 4 months ago.

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

Hey Reza, great video it's very informative! I was wondering if you happen to know if you can update the different choices in a choice field within a power app. As in add or remove a choice from a choice field column, which you usually do via microsoft Lists itself.

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

I do not have a video reference on this scenario and have not tried it so not sure. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

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

@@RezaDorrani Alright, thank you!

@tluu8501 2 месяца назад

I believe you can update choice field with power automate. An alternative is to create a sharepoint list that will capture your choices. Then in power app link the drop down to the Sharepoint list instead. Then you can create a screen that display the Sharepoint list and have use add new or edit “choices”

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

Hi Reza, I have a performance question for you. To connect projects and tasks screen, wouldn't be better to Navigate to Tasks screen and pass by context the selected item from your gallery, instead of calling gallery.selected from tasks as you do in 11:26? I got use to doing all navigations passing context variables among screens, but I don't know if it is a best practice or not.

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

Yes, that is a better option. I have done many videos on performance and best practices.

@duvangomez8700 9 месяцев назад

Hello Reza!!, great job mate. I don't know what happened to one of my SharePoint list, in this I have an image column and an attachments column (default column), for some reason when a user creates a row and uploads an image this is duplicated in the attachments column. It is as if SharePoint creates a copy of this image in the attachaments column, which is not desirable because other documents have to be loaded in the attachements column. Do you know what could be happening?

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

Welcome! I have not experienced the issue.

@SoniaW316 6 месяцев назад

Reza - as always great video - I'm struggling with the PowerFX on the add button for the grid, I have this - Patch( 'Item Details Receiving', Defaults('Item Details Receiving'), {'Item/SKU': "New Item/Sku"}, 'PO#':{Value:RecordsGallery1.Selected.'PO#', Id:RecordsGallery1.Selected.ID}}) - it likes everything except the PO#. The internal column name is PO_0023_, but it doesn't like that either. That is my lookup column.

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

Most welcome! I have not come across the mentioned issue and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

@SoniaW316 6 месяцев назад

@@RezaDorrani finally got it after playing around a bit. This is working great! Thank you!

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

I appreciate all your videos very much! I have built a wonderful app using this tutorial and now fine tuning. If I create a new parent item (which would not have any child records associated with it) and then go to the child screen to create a child record, is it possible to make the child gallery with the repeating table already have a blank row ready to fill in? So that I wouldn't have to click the "Add" button until I wanted to make a second child item?

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

Thanks for sharing!

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

@@RezaDorrani Any thoughts on how I could make first row of the repeating tables already be on the second screen when the parent item does not already have a child item associated with it? I tried writing an if statement for the OnVisible of the screen, saying that if there were 0 rows, Select the Add button, else Select LoadGrid. That isn't working. What am I doing wrong? If( CountRows( Filter(Dec4RezaChild, RecordsGallery1.Selected.ID) ) = 0, Select(btnAdd),Select(btnLoadGrid))

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

@@caroltasseff1827 Not sure about this. I would have to try it out to know the options.

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

@@RezaDorrani , thanks! It isn't a big deal. I thought you'd maybe have a quick fix.

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

@@caroltasseff1827 I wish it was a quick fix

@dbosset 7 месяцев назад

Thanks, Reza. My text input control doesn't have a "Value" property and I can't find that in documentation. Is the "Default" property the same thing? Are we working with different versions?

@dbosset 7 месяцев назад

Never mind. I just saw that you answered this earlier and said that Classic and Modern have different properties and Default is the same. Additionally, under Default, I needed to state the value as "ThisItem.'Project Lookup'.Value" rather than "ThisItem.Title" in order to get a result. I then turned on Modern to avoid similar issues ahead.

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

Great

@Shmank 6 месяцев назад

Hi Reza. You've taught me a ton since I started watching your channel a few months ago. I finally joined your channel as a silver member. If time permits, would you consider posting a follow-up video to this? Starting from the "Projects" list standard Board view in SharePoint (not in the Canvas App), I want to: 1) Click the "New" button, which starts editing a new Project item directly in the Canvas App. 2) Click an existing Project item, which starts editing that item directly in the Canvas App. I created the Canvas App the same way you did (i.e., NOT created via Integrate>Power Apps>Customize Forms in the header menu of the Projects list). So, this has created a challenge to figure out how to link them from the list interface. Thanks again!!

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

Most welcome! I have no plans for a follow up on this video. I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.

@Shmank 6 месяцев назад

@@RezaDorrani I was able to get it working thanks to another one of your videos: "Power Apps Deep Linking to Screen | App StartScreen & OnStart". Thanks again for all you do!

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

@@Shmank Awesome!

@Matt-rq6wz 4 месяца назад

Hi there, thanks for the excellent video. Is it possible to reference a sharepoint lookup column on the tasks screen? What might the updatetask button syntax look like?

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

Yes possible. For giving the syntax, I would have to try it out :)

@Matt-rq6wz 4 месяца назад

@@RezaDorrani If I had paid more attention, you answered my question in the video. I adapted the choices(Tasks.Priority) to the lookup field and it worked perfectly. I used the combobox control and its ideal for the number of choices vs dropdown. Its crazy how much time you can spend on basic solutions - ya dont know what ya dont know. Thank you for your awesome video!

@JohnJoe131 6 месяцев назад

How would u add a time picker to the grid? I have a column of the type date/time. So I need to be able to edit both

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

I have done multiple grid based videos on my channel. Have shown date in one of them.

@user-ll3tw6zs9l 7 месяцев назад

Hi Reza, I was wondering if you could demonstrate how to create an app helps manage the schedule of employees and tasks they are assigned to

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

I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.

@user-bv7ri4wc1w 9 месяцев назад

This video rocks and is very useful when creating a power app form for related sharePoint list. I also ran into a challenge. The save option does not work when a record is edited. How can we resolve this. Not, this is display immediately on the initial screen genterated automatically by the process.

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

Glad it was helpful! Video description has link to download entire solution (members only - check description for details) I have not come across the mentioned issue and hence not sure what the reason is. You may want to try and post your issue on forums at powerusers.microsoft.com

@izzatiyusof6853 2 месяца назад

Hi Rezza. Great video! Would like to know how do I assign a person to the task in the Tasks screen when I already have the person name in sharepoint list as i could not use the ThisItem function. Thanks

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

Depends on what control you are using for it. I don’t think I have done a video on this scenario.

@izzatiyusof6853 2 месяца назад

@@RezaDorrani thank you very much! Will look forward for your other videos 👍

@lukejones2819 2 месяца назад

Hi Reza. Great Video. Very New to Power Apps and have got to the step of creating the save button. When I create the Update IF whenever I add .Value etc the code generates an error ?

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

Most welcome! Video description has link to download entire solution (members only - check description for details)

@lukejones2819 2 месяца назад

@@RezaDorrani I signed up and the Downloaded example showed me what i was doing wrong. I have built my own version now and it works great !!. One final question I have is on my Tasks sharepoint list I have a Person column how do I bring that into the Gallery on my tasks screen ?

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

@@lukejones2819 Glad to hear that! I have not tried with a person column so not sure. I have done 4-5 grid videos and may have shown person in one of them. Try checking those.

@shaunwillmott3278 9 месяцев назад

Hi Reza, I have followed this step-by-step and the app is working, except the Grid Screen scroll bar - I just can't seem to get this to show on a tablet (even when testing in the browser), any ideas how to get the scroll bar to show or what to check?

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

Video description has link to download entire app (members only - please check details in description) I have not come across the mentioned issue and hence not sure what the fix could be.

@MarcelKorver 8 месяцев назад

hi reza, do you take small projects, directly related to your examples?

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

Define “small” :) About tab has my email address for business enquiries

@joshuacurtis3972 9 месяцев назад

If only it had a multi-select people combo box in the grid 😅 haven’t had much luck via the forums

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

Complex - it would make the video complex. I will cover those scenarios in Power Platform Training sessions where I have hours of time.

@nagarjun572 9 месяцев назад

Great and good informative video. And i noticed one issue that onchange function cannot be written for checkbox controls. I have recently tried by watching your previous edit grid power apps video. How to overcome it? I hope this will be useful to others too😊

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

You will need to be specific. Which checkbox modern or classic? Modern has options for OnCheck and OnUncheck now which can be used.

@nagarjun572 9 месяцев назад

@@RezaDorrani I have used Modern check box . I tried both properties onCheck and onUnCheck. But for others controls onchange working fine. But for Modern check box it was not working 😕 any solution?

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

@@nagarjun572 It should work but not something I have tried hence not sure.

@jennusi8317 2 месяца назад

Hi Reza, newbie here. I have a column of type lookup in sharepoint which is represented by a combo box in power apps. How do i add the selected value of that combo box to a collection?

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

combobox.selected.value should give you that value.

@Robot-Rising 9 месяцев назад

For my use case of this I am using a people picker column for the first column in the "tasks" list. It appears when patching to a lookup (people picker in my case) the btnUpdate gets selected by the onchange property in the people picker column after saving which causes the gridupdates collection to fill back up making it impossible to add a new "task". Is the lookup field causing an extra onchange by refilling its information?

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

I believe the culprit is combo box. But should work with this technique. Il have to recreate your scenario to know more. May be try posting your issue on forums powerusers.microsoft.com

@Robot-Rising 9 месяцев назад

@@RezaDorrani I downloaded your reference app and put a people picker instead of text and sure enough it broke the solution. Changed mine to text and it works. I will need to recreate the people picker control using one of the methods like office connector and then pass the information to a text field and populate the people picker on the list by patching it after. Definitely going to post this to the forums to see if anyone else has seen this with onchange in a combo box/people field

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

@@Robot-Rising The reference app does not include people picker. A change may or may not be accurate + sometimes there could be workarounds. Forums will be a good option.

@syssslllik 8 месяцев назад

Hi @@Robot-Rising, in case you've opened the thread, would you mind to share link to it?

@Robot-Rising 8 месяцев назад

@@syssslllik I haven't opened a thread but I ended up as a work around making a people picker of my own (just a o365 user search using a text control) and passing the email address/display name/claim from that to a people picker field.

@hitasajil3869 5 месяцев назад

This is awesome. 🤔🤔However, if there is no lookup table, how do we add a Parent ID to the child list column to create a relation ..🤔🤔

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

Without a related table - how would we get information?

@hitasajil3869 5 месяцев назад

@@RezaDorrani in this case, your child list is in SP, what if we want to have different data sources for the child list eg; SQL, the only way to make a relationship is to save the parent id in the child list while doing a patch; Q? Is there a way to get the parent ID and patch in child list? and still have editable grid exp

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

@@hitasajil3869 Ya that is different. Possible but not something I have done or have a reference for. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

@earnviautubeaccount7165 9 месяцев назад

Hey Rez, Thanks for sharing beautiful insight. As of now I am getting an error while applying Patch function for Add button it is saying "Missing Column. Your formula is missing a column Id with a type of Number". Please suggest. Thanks in advance.

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

Video description has link to download sample app (members only - check description for details) I have not come across the mentioned issue and hence not sure what the fix for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

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

same, I'll reply if i find a solution

@zachwelding4996 7 месяцев назад

Does anyone have any concerns with this approach if the projects list in this example would be close to 40k item after 18 months and the tasks list could be 100k after 18 months? Trying to revamp an ordering system thats already in SP.

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

No - as Dataverse is a relational database and can handle large data.

@dhraw 8 месяцев назад

Hi Reza, any idea why instead of "Value" i see Default property when editing "Text Input" box using Gallery.? Is this related to this that I don't see classic or modern? Thx for your answer

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

Classic and Modern have different properties

@dhraw 8 месяцев назад

Great, thank you found it 🙂@@RezaDorrani

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

Reza, how can I enable de modern controls, i've the trial version of power apps, and the option in Upcoming features for modern controls and themes, isn't avalible now.

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

Check in General tab for Settings

@paolopale 2 месяца назад

Hi Reza, what can I do if I work with two Excel sheets instead of the two Sharepoint lists? As I am missing the ID for the respective collections.

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

Im not sure about that.

@jamiechampagne1306 2 месяца назад

Reza, I'm working on the Choices column for priority...when I run the formula up top, I get the right values, however, when I run the application, the choices container is blank. Any ideas?

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

No idea

@jamiechampagne1306 2 месяца назад

@@RezaDorrani I figured it out...my "add field" data was pre-populated...once I deleted all of them and followed what you had shown, it worked perfectly. Don't know why it pulled everything over.

@dbosset 7 месяцев назад

If I click the Add button and for whatever reason decide to click the Back button without filling in the new item and clicking the Save button, the empty new item remains in the Task gallery and since it is already patched, the empty task is also in the data source. I tried adding an If statement in the OnSelect property of the Back button check whether the Save button had been clicked using variables and the Remove function but have not gotten that to work. How would you resolve it?

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

I would resolve it by patching the new item with default values to begin with or disabling the back button if fields are not filled out. This is not something I have tried so do not have any references for it.

@dbosset 7 месяцев назад

Thanks for the response! @@RezaDorrani

@MaeC77 10 дней назад

Hi Reza! I am having an issue that I cannot find an answer for and I was hoping you might be able to assist me. I added a people field column with a classic choice box to my grid/gallery view. When I update in the app everything updates in my SPL accordingly and saves in the app too, however, my add button stays disabled from the point of hitting the save button on and I only have my save button available to me from that point on. I can continue to make changes to the fields and hit save all I want & it will save and update in my SPL too but the add button stays disabled after that point going forward and all I have is my save button. I can not add any new rows to my grid. I have no errors and everything seems to working except for the add button disabling after I make 1 change. I don’t know why it’s happening but I do know it has something to do with my combo box field for my people column and I know this b/c I spent hours testing it and figured out it does not do this and everything works perfectly in the app when I don’t use, change or even remove the combo box field all together but surely I should be able to have a combo box people field/column?!? I mean after all it updates & works correctly in my SPL but for some reason the combo box disables my add button. Please please any help or thoughts is greatly appreciated. Maybe it’s the way I have my combo box people field coded in my save patch function or btnupdate. I believe every thing is correct on the combobox properties (items, display fields & search fields etc.) I’ve spent hours trying to figure out why. I don’t want to have to go w/out a people field. Thank you in advance for any help you can offer.

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

I cannot guess what the cause of the error is without reproducing your scenario. Forums will be the best place to post your issue in case someone has experienced something similar powerusers.microsoft.com

@kevinstrachan741 6 месяцев назад

This is an awesome video. But the step at 23:06 where you move the "Clear" command to the "btnLoadGrid" button, breaks my setup. So I had to leave it as part of the Save button instead.

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

Thanks! As for the clear step - I have not come across the mentioned issue and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

@Mrinal600 9 месяцев назад

Can you add filters on the headers of each items? For filtering purpose it would be useful.

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

I have done other videos on grids where I think I did show filtering as well.

@Mrinal600 9 месяцев назад

@@RezaDorrani I have seen those but for each header I wanted to implement filter like SharePoint list.

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

@@Mrinal600 That is also possible but not something I have tried.

@Magpiekit 2 месяца назад

I have a list that contains all the training events my company is running, including dates, times and who the trainer is. I want a view for trainees to pick a course, date and time to book on too. Is that the same concept to this?

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

As long as 2 lists are involved and connected as shown in video

@kag0920 Месяц назад

Hi Reza, great work! I'm a new subscriber. I'm stuck where we are using the btnUpdate button, I'm receiving an error stating "Name isn't valid. 'Value' isn't recognized". Any thoughts on what can be contributing to this error?

@RezaDorrani Месяц назад

Video description has link to download entire solution (members only - check description for details) I have not faced any issues with it hence not sure about this error

@alvarovillachica-fk9oz 7 месяцев назад

Hello Reza, I hope you're doing well. I tried to follow your tutorial but why the function Filter(Tasks, 'Project Lookup'.Value is not been recognized :( minute 12:49. Thks I am learning.

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

Video description has link to download entire app + data source (members only - check description for details) I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

@mohamadshahfiq5979 7 месяцев назад

Hi Reza, this is great, but i have some question here, example i want to set only 5 task under 1 project, then they only can add the task for only 5 then after that the button disable because already limit task. Is it possible to do that?

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

You could check count of items in tasks gallery or collection and if 5 then disable the button. So ya it is possible

@mohamadshahfiq5979 7 месяцев назад

Thank you Reze.. i did it.. but i have 1 more question..for my apps. Example.. i have 1 project.. under 1 project have many tasks.. and inside the tasks i have task status.. so i want to make if all tasks is “close” i want the project status automatically “close” also.. can u guide me how can i did this?

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

@@mohamadshahfiq5979 I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

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

How can I update a lookup control (combobox) instead of a choice column? I'm really having trouble with that

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

I did 2-3 videos on grids (all in a playlist on my channel) Check and see if I covered lookup column (I do not remember)

@Obiwan-ik2tw 4 месяца назад

Hello Reza, thank you for this video. Since we don't use Dataverse, using relational data with SP is very necessary. However, I found one l issue. When I first opened the app , it was fine. Once I clicked on an item in the gallery(for example, customer 1) , even though I attempted to create a new item, the gallery still selected the customer 1, causing the second page, which uses relational data, to display the details associated with the customer 1. When I click the new , I expect the second page to be empty but it doesn't. Do you know how to resolve this issue? Without resolving this issue, I can't use it at work.

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

Most welcome! I have not experienced that issue hence not sure. When new is clicked set a variable and accordingly set the grid on second screen.

@Obiwan-ik2tw 4 месяца назад

@@RezaDorrani Yes. When the app is open at first, there is no issue. But if you click one of existing items and then if you click new, you can see that the main gallery still selected the existing item that caused the second page which is the relational data page.

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

@@Obiwan-ik2tw Probably bcoz it gets some context. Im only guessing I have not come across this issue

@Obiwan-ik2tw 4 месяца назад

@@RezaDorrani Monday I will check out the form again since I have a meeting on Tuesday. Thank you for this video again. We don't use Dataverse, it is super helpful.

@user-ti7ds5wh5g 4 месяца назад

which version of PowerApps are you using?

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

You mean authoring version? Whatever was the latest one when I made the video.

@prabhurajaram 9 месяцев назад

hi rezza, i have a requirement to give access to the Sharepoint Site using Power Automate , if new item is created in SP List created in the same SP site. the list will have the email id for which access requested for. is that doable? and will it cause any security violations?

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

Possible. Item level permissions is supported by SharePoint

@prabhurajaram 9 месяцев назад

@@RezaDorrani thanks rezza, please share any link for reference

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

@@prabhurajaram I dont think I have a specific reference for this

@nikitapatel4192 6 месяцев назад

Hi Reza, I used a tabbed form since my form was quite long. However, now when I hit the +New button, the new request doesn't generate. What do I have to change?

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

I cannot guess without looking at how you have tried implementing it. Best to post your issue on forums.

@nikitapatel4192 6 месяцев назад

Ah, I figured it out! Thank you though :) appreciate your time and effort in creating these educational videos @@RezaDorrani

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

@@nikitapatel4192 Most welcome

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

Hi Reza how can we put a row limit on repeating table in powerapp like we want only 10 columns in editable table or repeating table .

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

Columns or rows? Check firstn function documentation

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

@@RezaDorrani rows .

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

@@pintu1502 firstn

@mukhayyarmohammed5874 9 месяцев назад

Hi Reza, I have some columns in SharePoint I want to maintain history like time stamp, user display name and changes as well I want to show in form also some columns are multiple lines of text some are single line of text and drop-down also please help me to achieve this or share me the link of your videos related this if availble Thanks

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

I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

@Mrinal600 9 месяцев назад

I'm still finding the proper search without delegation warning. Can't we made a full fledged search using SharePoint list as a data source?

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

I have done 4-5 videos on that topic. Please check those videos.

@Tom70898 9 месяцев назад

Hi Reza, love your videos they're very informative. I'm currently having an issue and have searched all over to find a solution but haven't succeeded, perhaps I'm searching the wrong thing. In my SharePoint List I have a status column that is either 'complete' or 'incomplete', and then I also have 5 other columns for example that get their inputs from a form that is already connected to the SharePoint. I want to be able to make it so that the status column will automatically update to 'complete' once all the other 5 columns have been completed with their inputs from forms. I have the form so the user can go back an update their entries and so eventually all 5 columns will say 'Completed' at which point i want the status column to automatically update to 'complete'. Any help would be massively appreciated as I'm struggling and very new to this haha. Thank you

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

@Tom70898 9 месяцев назад

@@RezaDorraniI have tried to find something similar on forums but the closest one is a calculation one based off what the number is, the status changes. I did try to use that one as a template and just change the number part of the expression to what i have in my columns however i could not get it to work. That could be due to me not knowing exactly what i am doing though or not, i'm not sure.

@Tom70898 9 месяцев назад

@@RezaDorrani I have also asked the question in forums but not received an answer as of yet

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

@@Tom70898 Until I try this scenario I wont be able to help. Forums would be your best bet. You can also follow up and post your issues there.

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

@@Tom70898 Forums is a platform where you may or may not get a response. If this is time sensitive, then I recommend you look at getting consulting help

@user-pw8em6rq2w 4 месяца назад

Hello, I have a slightly similar problem, can you help?

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

Which problem?

@ashleyharger5442 7 месяцев назад

I'm getting stuck on the Add button. When I click it, I receive this error message: "network error when using patch function the specified column is generated by the server". Any idea on how to fix this?

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

I have not come across the mentioned issue and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

@mce8183 8 месяцев назад

Hello Reza can you assist me in finding solution to his issue I am having. I entered all the information I need and when i click on the "save" button nothing shows on my list. Please advise. Thank you

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

Video description has link to download entire solution (members only - check description for details). I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com