Thank you, Reza. I guess I'm becoming more comfortable using Power Apps and SharePoint together. Your hard work and dedication have made a significant difference, and I truly appreciate all the effort you've put into helping the community understand and navigate these tools. Your support has been invaluable.
Reza, you have a genuine talent for teaching. I have been watching many PowerApps vids and your ability to clearly explain through these steps is extremely helpful.
Everybody said it and I agree... WONDERFUL and really HELPFUL video (as usual). You share it so nicely that : 1. I really want to start to build this kind of app 2. I really want to share my knowledge to my colleagues like you 😍 Thank you very much Rezza, you are one of the best Microsoft Dev RU-vidr 🙏🏾
I am following you for 4 years now. You were great , 🎉 for the 100k. Videos like Power Automate Expressions 1,2,3,4 , Power Apps Patch etc. 1-2 years ago been wonderful ❤. Back then, I even wanted to pay for a subscription, but then it was not available. In the last year i have to admit , that I don't see the same deepness you had in the past. The "New" stuff , is not more deepness. I don't need to re-learn issues, or to get full applications - so I don't feel subscription is right for me though I really wanted it in the past. I understand this approach is right for the channel "Statistically". Right for the broader crowd. Anyway, you will always be considered as great teacher for all I have learned from you. Congratulation 🎉 again.
Thanks for following along the journey and thanks for the good wishes. “New” stuff relating to new features - depends on the topic. A header control can only cover so much. I am doing a mix of videos. I am asking for topic suggestions at all times. I want to build content for the audience and hence I am listening to what my audience wants. Subscription is optional. I am sharing everything I am making in videos. App, flow, table etc. I have already shared over 20 solutions and growing.
Cant' accept with you more. I see heaps of your videos that I can learn for free. But still subscribe just to 100% following you @@RezaDorrani - Thank you for all your great videos and sharing!
The implementation of this new table feature has been long-awaited. Its inclusion is a significant and positive addition. I followed the process of creating your “Full CRUD” custom gallery table to program this feature accordingly. The introduction of this new table control is a game-changer. From now on, every application that I develop will benefit from its incorporation.
Those modern controls getting more and more functional. 2 weeks ago I could set the ValidationState If(locSubmit And IsBlank(Self.Value), "Error","None") when Patch my fields to DV. Have not play with Modern Form. Thanks for showcasing it.
Thank you for this video, and using dataverse as the data source this time! I finally got IT to work with me and give premium access to dataverse. I am working on my data model right now. I will build a model driven app, AND a modern canvas app. This is going to help me tremendously.
Excellent presentation as always. Simple, straightforward, and easy to follow for new developers and even us old developers to keep up on Power Platform changes. Nice to see the new layout in action.
@@RezaDorrani There is a video you created sometime ago that I'm having trouble locating. It is in regards to building a responsible power app form that will patch multiple screens (my environment uses a SharePoint list as the data source. My example links to a 10 page research and development form with about 25-30 choice fields and corresponding singleline text fields). Thank you in advance.
You've become so good at this I must say. Excellent presentation and easy to understand. Going forward, I'll only be using Modern controls. With co-pilot, they seem to be making it much easier and quicker to get things done. Awesome content and thanks for sharing consistently. 👌👌👍
@@RezaDorrani Awesome guide, Reza! But I have a question: We are not using Dataverse yet, we're still using SharePoint lists. Is there any way I can replicate the table which is only dataverse at the moment?
@@alexandrubirsan7608 Its a control that works best with Dataverse and supports collections. It also works with SharePoint but will not yield best results. Its a preview control, so lets give it time.
Very informative video. Precise and no unnecessary talking. I wonder, have you setup a custom theme? Your dropdowns, text inputs, font etc are all different..
@@RezaDorraniI tried the steps of😢 your video today rather than downloading , to learn how you do stuff, I was able to complete it successfully with same look and feel. The only issue I had is data table is not able to display the SP List column value which is a choice column. ( looks it still doesn’t support complex data type) , have you faced it! In your video, you connected to dataverse table. So I have revert back to gallery view with tiles .
Fantastic demo, Right to the point, beautifully cut to save viewer's time, The amount of knowledge transferred is up to the roof And your accent is lovely. All together I really loved the whole video. Continue on the great work and Congrats on 100K! 🥳🥳
Thank you Reza for indeed a great video again. A couple of things that I look forward to Microsoft release is Galley in modern control and also how we can customize the theme based on the org. Kudos to you and your efforts.
Excellent Video Raza as always. It would be great if you can publish Video with Parent Child relationship tables like Invoice and Invoice items on the Modern Power App.
A video I did on list relationships in SharePoint 5 weeks ago - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-1Qsf2RPyp8s.html I have also done a video on Dataverse table relationships ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-byUuEoDQjiU.html
I request you to kindly explain on how can we create the power app to automate the Tool Intake process, where it involves the approvals from the business team and after that Notification will be sent to the requestor, Business teams members and when the request is approved it must create a feature in Jira for the development of the tool, after its all done it must enter our Tool Intake software as well. Kindly Create a video on this one, I follow you everywhere to learn stuff. Kudos 🎉. Big Fan from India.
Thanks for watching and liking the videos. My rule for creating videos is set - "" 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.
@@nikitahinduja6792 If you open my channel on web browser, you will see a tab for community. Please note you can only post topic suggestions when I make the post for it. Next one will probably be in Nov end.
Hi Reza, great video as always, love that you are helping with all the new modern features. i am having an issue with filter at 21.07 time of your video and getting an error saying "incompatible types for comparison. these types cannot be compared: record , text. the field i am using is choice in sharepoint list. any advice on how to fix that?
i found a solution. you need .Value for what ever the choice column is. in my case it looks like this: Filter('Project - Tracking PA', 'Team'.Value = TabList1.Selected.Value)
So glad to see those amazing updates that came lately. What an amazing work. I can't wait to see the next features on the modern controls, especially on the tab control that's already amazing but needs to accept complex fields Thank you so much for keeping us informed of all these developments.
Amazing video Reza. So helpful. One question, how do you get those cool icons in the text property of a button? I can get a plus icon but have to use the + key. The edit icon with the pencil looks great
Hi Reza, your videos are very useful and more helpful thank you. Did you saw 'Use versioning for solution cloud flows' if possible can you please explain power automate versioning
Hi Reza thanks for the video it’s been really helpful. I’m trying to change the date format of a column in the modern table but I can’t. In your table you have the long date displayed but I’m not sure how to implement that.
NIce! But is there any way to show the actual text value of a status column and not the integer value in a modern table control? Thank you. Awesome content.
Sir, thank you for this video, lot of learning. Just wanted to ask, you write some code on top sometimes under fx, what language is it? I dont have coding experience so please guide.
I can't use that table control like, since only normal columns are supported😅- some of the stuff I work with have relationships [lookup columns] and showing those columns, editing, etc. doesn't work. Still, fascinating video. Thanks for for the great explanation.
@@RezaDorrani, now that's good news. It'd really be a game changer. Just like the "formula" data type on the Dataverse Columns is [also, still in preview, though] Thanks for keeping us up-to-date, Reza.
So great examples. Thank you. Do you know how to search users in a modern combobox control? It just give me a few users, and I cannot search for all users like the classic combobox.
Another awesome video Reza!! Question, I noticed the Table control does not seem to support column sorting (yet), have you ever got column sorting working with the Modern Table control?
I am quite new to PowerApps and have zero coding experience. Even so, I am really excited by the possibilities of what could be for those I support. One question that did not seem obvious to me. As the app admin, I'm guessing you see everyone's submissions. What about the end user requesting time off? What do they see after they submit their request? Do they see only their submissions, or do they see everyone's submissions? Sorry if this should have been obvious but I didn't catch it.
SharePoint as a data source offers less flexibility with regards to security. You could add filters in app to show user only their records or use flow to set item permissions. I have done some videos showcasing how to do that.
@@JoelAkoun data source would be name of connected table or SharePoint List, selected item would be same as shown in video. I would suggest giving it a try and in case of issues posting screenshots of it on forums at powerusers.microsoft.com/
Hi Reza, great vid as usual. I notice on the table control headers that there is a "Filter By" option (below the sorting options) which is disabled/greyed-out any news on when/whether this will be available?
This is a great tutorial, but I'm having a problem with a calculated field in SharePoint. I have a Summary Date field, which is a Date and Time field. The calculated field is Days Past. When I use either =Today() - [Summary Date] or =DATEDIF([Summary Date], TODAY(), "d"), I get several decimal places (eg., 37.00000000) showing in the PowerApps table instead of the simple count of days expected. In Sharepoint I choose the output as a number with 0 decimal places. I don't see any way to modify the table control to round this to a whole number. Any suggestions, from anyone would be appreciated.
Workaround was to create a text column DateText in SP and concatenate an empty string thus =[Summary Date] & "", something I don't particularly like doing because it is confusing to anyone having to follow up your work.
Many thanks for another great video tutorial. By the way, how can you restrict access of active user to his own data only? Can we use Power Automate to automate the approval process?
Best option would be to secure the data at data source level. Dataverse offers row level security. Would recommend checking documentation on Dataverse security.
Thanks for this great video. Is there any way to correct 'Departure Date' or 'Return Date' not showing time zone? The grid is showing like: Mon 30 Oct 2023 08:00:00 GMT+0700(In...)
Reza, this is awesome! Thank you. I am using the modern Table control with a SP List, and I can't find a way to rename the Column headings within Studio. When I change it in SPO its feels buggy since some updated while other column names didn't. Is there a way to update this in Studio?
Awesome video Reza! Quick question though. When I switch to Edit View on my desktop, everything's fine, but when I try it on my phone, the selected item doesn't go through. Any idea why this could be happening? Thanks!
Hi Reza. Great stuff, again. Really enjoying the modern controls. Takes some getting used to. I am using the Table (Dataverse only) control to display a dataverse table that has a lookup column, "ProductCategory" and the column only displays [object Object] in the Table control. My understanding is that this is because the lookup field, "ProductCategory", data type is table. Any workarounds for that issue? Thanks.
Lookup is a limitation for now. You could build a collection where you grab the name of the lookup and place as text for now but I would recommend to wait until Table supports it out of the box.
Hi Reza, great video as usual. Just want to ask if Modern Table available for SharePoint? It shown for dataverse only, but when I tried using SharePoint it it able to connect. Is there any limitation or something happen?
Good morning Reza, it is possible to create a group of instructions to execute together e.g.: Set(x,"aaaa"); Set(y,"bbbb"); Refresh(source1);Refresh(source2); Reset(Field1);Reset(Field2) to be able to execute them in various screens of the app. Thank you. Michele.
You forgot to hide the id for approval status in the Table, but other than that, very good example of modern controls. Thanks for making and sharing it.
Hi, Reza! Nice video!!! Could you help with something? I have a modern table but the Sorting of the table doesnt work. It comes as a table function but doesnt work here. The property "EnableSorting" is "yes" but when i click on the table's header to reorganize the data by smallest to largest or vice versa, it does not filter. Does it happen with you as well?
Modern controls are nice, however are still missing a lot of features and attributes the classic controls have..which I’m assuming will eventually be available, given it’s still “experimental “. Example, text input does not have a number format option, and color, font size etc for many of the controls can’t be modified. Plenty of other small details as well, such as the ability to reference Self.Text for a button.
Modern controls are in Preview! Color and font size have been added to most controls now in the latest app authoring version. A new spin button control is added (latest authoring version) which is ideal for numbers.
Thank you for an excellent presentation. I have created an App using the modern text controls and the browser autofill feature intermittently suggests values for the fields. Is this something that you have come across and is there anyway to disable this other than turning off 'autofill' in the browser?
Thanks for replying @@RezaDorrani. Unfortunately that probably means I'll have to go back to the old text controls as I can't tell 80 people that they have to turn off their autofill feature.
Thanks Reza!! I’m having a hard time making the form show the actual username from a SP list people column. It only displays a 5 character number. Any suggestions?
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
Thanks Reza, looks like for some reason the person datacard dropdown was not populating the Fields property. After I clicked Edit and Add Field, got the choose a field (claims, Department, email, DisplayName). After choosing DisplayName the dropdown works.
Hi, Good one! I have replaced text box in data card with modern drop down . But its not showing default value when i try to view or edit record. Any workaround for this
I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
At 10:40 you are showing the drag & drop of data cards on the form. Mine absolutely will not do that. I wanted to re-order my fields, and when I did it made them all the full width of the container and listed them down the left edge of the form. I turn off 'Width Fit' and it makes them the standard size again, but they're all basically in column 1. Is there no way to put the data cards back into rows without having to Set the X & Y value for each data card? Strange that we had drag/drop when this video came out but now it's gone.
Great video! Question: I followed your tutorial to a T and can't get new entry submissions to display in the table. I think it's because the default value of the "Approval Status" column is not set to Pending, Approved, or Rejected. It's just blank. How can I fix this?
Video description has link to download entire app (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
@@RezaDorrani Thanks. As I had not yet worked with Data Tables, only MS Lists, I didn't know where to find the table for this app. I found it and just had to change the default choice for that column to "Pending." It works like a charm now.
Hi Reza, can we set up a maximum size for the responsive app? While the responsive app looks okay on most screen sizes, the gaps between the controls are too large to look nice on 4K monitors. I wonder if you ever played a responsive app on a 27 inch 4K monitor, the app looks so ugly.
Can I still show two fields in a modern combobox? I can't seem to find that. Also, are the modern comboboxes incapable of showing a calculated column? It's just empty if I put that first and it works fine with the classic ones.
Currently that is not supported. Please note modern controls are preview. So best to continue using classic for such scenarios until feature parity comes in.
Using modern date picker controls and SQL Server data, I keep getting an error message : Expected value '2024-03-18T00:00:00' to be a valid RFC 3339 'full-date' or 'date-time' format. Allowed ISO 8601 formats(s): 'YYYY-MM-DD', 'YYYY-MM-DDT00:00:00' . Any idea what that is? Is that an SQL issue or a Powerapps issue, and how would one go around this?
I have not done any work with sql server hence not sure about this. Check documentation of modern controls to see if there is any limitation with sql called out.
Hi Reza, great video. I just created an app using the latest version and 'modern controls', looks super cool. But after saving it I get an error when trying to open the file. I can run it but not edit. Could this be due to the version and do you have an idea how to fix it? Thx
Might be with authoring version. Best to use recommend version. One option would be to revert to a previous version of the Power App from versions page.
Hi Reza, If I click on the EDIT button it Navigates to Form Screen and displaying the previously selected items even though there is no current selection in the Table. Could you please provide a solution for this. Due to this the Visible property of the EDIT button is still visible because the PowerApp holds the last selected item.
I have not come across this issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Thank you for the video. I want to ask, i made the same edit button and when user click it, it will navigate the screen that will be edited. But, when user submit it, it create new submit not update previous one. Can you help me with that?
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 for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hello Reza, I have watched this video several times and appreciate your instruction. I do have a question though. I have created a similar app for employee absences based on this video. My issue is that the data card values for Status and Employee Name do not fill in when clicking on the Edit button. What happens is the app does navigate to the Edit screen and most of the selected row values are pulled in from the record. However, for Status and Employee Name they do not populate and the default message appears ("Find Items"). Since they are derived from lookup columns, is there another step that needs to be built into the app?
I have not experienced any issue related to it so not sure. Video description has link to download entire solution (members only- check description for details)
Hi Reza, I am getting the error Filter('MOCTasks,' 'Status' = TabList2.Selected.Value) Tilde sign under = (Issue = Incompatible type for Comparison. These types can't be Compared: Tecord, Text. Any suggestion, Please
I have not come across this issue and hence not sure what the cause for it could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hey Reza, thanks for your super helpful video! I have encountered a problem will following your video. My approval status is named Status in FieldDisplayName (named Status1 in controls), and when I followed your code for the tab list (Choices('Travel Requests'.'Status')), it didnt work. I assume its a problem with the Status name, as Travel Request was highlighted in colour, but I didnt know what exactly I should do? I have tried both 'Status' and 'Status1', or 'Travel Requests' and 'Table1', but none of them have worked.
I have not come across this issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
The 'Not(IsBlank(' seems to be not working for me. Table comtainer seems to have an item its defaulting to.. unable to solve it and getting frustrated:(
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
Hi Reza, when I am trying to use the Table control for a table with lookup columns, the cell value is not being displayed for the column of Lookup type, It is showing [Object Object]. Do we have any solution for this? Thanks in advance.
Lookups and choice column values are not displayed in Table today. The fix for the same will be coming soon. Please note modern controls are a preview feature.
Great video. Q:Does changing the version to the latest make it more unstable? I've made a couple of apps following your technique, however I'm getting error messages when I attempt to load them for edit later. The apps work fine in monitor & play, but I can't edit. It's odd.
1 - Latest authoring version is not the most stable version. There is always a recommended version. 2 - modern controls are in preview 3 - within 2 weeks the version shown in video would become the latest 4 - I did not run into any issues related to editing in this version
Hi Reza! Can you pl make one video on Power Apps Pipelines to export the Development Environment to the Production Environment? Currently, I'm downloading and importing into diff Envi.