Can be more Power Platform artefacts/concepts mentioned and showcased during one demo video? Solutions, Publisher, Dataverse, Tables, Power Apps, CRUD operations, Screen creation, Environments, Copilot, ALM, Canvas Studio, Data types, Relationships, PowerFx formulas, Canvas Controls, Control properties, Model-Driven App, Approval Flow process, Deep linking, Security Roles, Pipelines, Environment variables, Sharing Apps, Role assignment... Good job Reza. I can just imagine how much recording time it took to create 35 min video. 📽📺 Kudos!
@Reza at 18:44 'Expenses Gallery'. Selected isn't working for me, although I changed the default to that it still shows the lookup bar and not the selected expense, what have I missed?? Help :(
Video description has link to download entire solution (members only - check description for details) I would suggest giving that a try. As for the issue mentioned, I have not experienced it 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
Hi Reza.. When we share our canvas app to customer... first time when they are starting the app it's asking them for allow allow option from SharePoint... Can we remove that allow pop-up by which user can see the app directly...... please reply
That is asking user to consent to connect to SharePoint or any other connector that app uses. That is best practice. However, if you need to bypass consent you can do that as well. learn.microsoft.com/en-us/powershell/module/microsoft.powerapps.administration.powershell/set-adminpowerappapistobypassconsent?view=pa-ps-latest
Excellent! Finally a professional tutorial. Can you elaborate more on the best practice workflow when you are an outside Consultant building Power App Solutions, then want to export from your Dev Environment and Import to Client Org Dev->Test-> production environment. Assume I am remote during development and working 'At my own company', Then, when the App is ready what is the best method for 'delivering it' to the client organization. Talk about Export / Packages / Importing at the Client and then what to configure regarding security settings once the client accepts the solution. Thanks again for a great tutorial.
If you are just starting out with Power Platform this gives you a tour de force of Power App, Power Automate, Dataverse and Application Lifecycle Management. If you want a terrific overview this is the video for you.
This is an excellent video with great details and many insights. The use of solutions, security roles are very useful and informative. There is one part I would like you to explain more. At 23:00, there is the "submit for approval" button. Can you elaborate how it is created and how it is made in/visible and update the status value to pending? Thanks.
I have shared the entire solution exclusively for members. (Silver members and gold members of channel get access to it) I did a lot of work on this one and wanted to keep certain aspects for members only. All I did there was Patch the column Status when submitting for approval to pending and then accordingly changed visibility of certain fields.
Thanks for the awesome video. Regarding licensing, if I have Power Apps Premium, would that cover the usage of flows to update Dataverse records, or would I still need a separate Power Automate premium license? In order for a consumer to use this app you showcased, would they require both Power Automate Premium and Power Apps Premium?
You can associated an app with a flow as long as the flow is using the same data source as the app as in this case. Check documentation on "associating apps" to flows
A terrific end-to-end experience. I thought the new preferred solution feature is really cool making everything solution ready and no messing with the default environment. Thanks for sharing and always a joy to pick up tips from your videos. Adding this to my Reza environment. 🤣🤣
Great video, however I am wondering if anyone else is having an issue where when adding a new line item, after clicking save (tick button) the new line item doesnt show up in the line items list on the right hand side of the line items screen until I navigate back to the Expenses listing, select another expense, then select the expense I added the line item to and then go to the Line Items screen. Even just navigating back to expenese and then to line items doesnt refresh the line items listing. Everything else with the record linking seems to work
I don’t exactly remember this issue but one option can be to filter the gallery by using a variable which you can set to false and true after successfully adding new line item. This will ensure the gallery picks the latest update. Alternatively, you could also download the solution shown in video. Video description has link to download entire solution (members only - check description for details)
Hello, thank you for all your content, I have learned a lot thanks to you and I wanted to ask, can you integrate On-premise SQL Server to consult and modify some data in the table (customer order and order status) and dataverse to save all the new information ( parameters requested from the client, process sheet, etc.? It's compatible? What type of license do I need in addition to the Microsoft 365 Business Standard license that each of my users has? Greetings and thank you very much
Most welcome. Sql on prem is possible via data gateway. Sql, Dataverse etc. are all premium features. Every user running the app will need a premium license. Business standard will not suffice.
Hi Reza, nice videos I always learn a lot with your classes you are a master!, I have an issue on 20:22 , when I try to use the 'Expenses Gallery'.selected.'Line Items' the 'Line items' property is not displayed, so I cannot open only the related expense, thanks for your help!
I have not come across this 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 it seems that it is a bug, I changed the authoring version and reverted back to the original one, after that the property was displayed correctly, thanks again for your videos! greetings from Mexico
Thanks Reza. It is indeed a great video on end-to-end Power Apps implementation. However, I do have one question on pipeline. Do we need to have managed environment to leverage Power Apps Pipeline feature in dev environment as well?
@@RezaDorrani - yeah just basically X amount of line items from App to a section in a document , i'll search through old videos so if done before, thanks
Hi Reza, to avoid creating from scratch a new PowerApps Canvas form, I copied and saved an existing canvas form called 2024 Rental Deposit to 2025 Rental Deposit canvas form. The 2024 Rental Deposit canvas form used as SharePoint list called 2024 Rental Deposit. I also copied that SharePoint 2024 Rental Deposit list to a new SharePoint 2025 Rental Deposit list for the 2025 Rental Deposit canvas to use. The problem is that the Data Card (COMBO BOX) in the 2025 Rental Deposit canvas form will only reference the original SharePoint 2024 Rental Deposit list, even though the item name was changed from 2024 to 2025. Do you know why only COMBO BOX data card referred to the old 2024 list while the other fields (Text) did refer to the new 2025 list?
I apologize if it was confusing. All I did was to save a power apps form from an existing form. The new form was referencing fields from the old SharePoint list. Thank you for replying.
Should I go through the entire playlist to master power apps? WIll I be an expert and be able to do enterprise apps? Also is this still relevant in 2024 seeing MS keeps updating stuff? Thank you brother Reza.
These are tutorial videos that cover various aspects on app, flow, bot building. If you are interested in a training program - then you can join my channel membership in GOLD tier - This includes hands-on content with real-world examples and deep dives into each topic.
This was incredibly informative! I was curious about setting up approvals in Automate, and this video answered all my questions. Could you do a video on authentication using Microsoft Entra?
@Tasneem-e2e Why would you need to create one when entra is already there and set out of the box. I do not have a video reference on the mentioned scenario. I will recommend checking or posting your query on forums in case someone has done something similar community.powerplatform.com/
Video description has link to download entire solution (members only - check description for details) I have not faced any issues with it so not sure whats the cause or fix for your issue.
how did you made automatically the crud operation available in the screen which included all new , edit, search , delete options. can u plz share the youtube link
Hi Reza, Thank you! This taught me so much. Quick question: Can you set ItemDisabled in a Modern Toolbar based on the e-mail address, or security group of the current user?
Hey Reza, my colleague just signed up to the gold membership and are working through this video but we are struggling with setting a default value for the "Related Expenses" card. We have followed the video but default value is being added and we don't even seem to be able to select the correct value manually. We are working independently of each other in separate environments but have arrived at the same problem. What are we missing?
The link to download the entire solution is in community tab for members. Il recommend giving that a shot. I have not faced any issues with setting default value so not sure.
@@RezaDorrani Sorry but having trouble finding the download link in the community tab, first time using this training method, can you send a link please?
@@joecoffey5183 The link is in community tab. I just went 6 months back and got it. Il repost it on Community Tab for now so you get it right at the top. Request to please look through Community tab if you need any other old ones.
hello Sir, Could you please help me with an issue? In line Items screen there is lookUp field named as Related expense it is not showing correct values from expense gallery instead it shows item1 item2 item3..... what is the issue could you please help me with this
I have not experienced the mentioned issue and hence not sure what is the cause for it. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com in case someone has experienced something similar. Also, video description has link to download entire solution (members only)
Hi Reza, I am new to power apps and I also have a friend that does not have an IT background who wants to learn power apps. Do you know any that does one on one training or places we can sign up that can train us from start to finish with real life examples.
My power apps training program would be a good option (as per me) The program is available for channel members in GOLD tier. Channel membership details thepoweraddicts-my.sharepoint.com/:w:/g/personal/rdorrani_thepoweraddicts_onmicrosoft_com/EbvjdBY80QRGkT6svJEmzZwBz64PNYQDRvKHm8eRHEYe6Q?rtime=c5EBcvvn3Eg
Mr. Dorrani, can you help me with a issue? I'm beginner at PowerApps, I have a list in SharePoint as data source of my app, it's a list about projects and one of the rows is the person who is the owner of that project, so the row is type person. In the app I want to show the count of projects that the user is owner, I tried to put this formula on a label: CountIf('MyList', Owner = User().FullName) but don't compare the types, I tried this: Text(CountRows(Filter('MyList', Owner.FullName = User().FullName))) but it doesn't work as well. I'm struggling, can you help me? (Plus, is it possible to put this counter in a component that is my menu for every screen?)
Another great video @Reza. You are incredible. I made a similar app to track expenses (not even close in terms of the way you made it, but gave it a try). So far it has been garnering a lot of appreciation from my management and users as well. Thank you for such wonderful videos you make week after week. Kudos to you.
@@RezaDorranithe explanation of the how to setup things like: configuration of submit approval button, power automate, environment variables, email to approver and user etc, I think these are missing in this video or I am missing anything?
Video is focused on explaining the key points app makers must know while building apps. If you need the expense solution showcased in video, it is highlighted in video itself than link to download is for channel members and video description has the details needed.
is this posible without the dev envornment? im still waiting to get approved from IT to upgrade my license,. and i cant use copilot or create tables or an enviornment, is it posible to work around these set backs?
I have not experienced this issue and hence not sure what's the cause for it. I would suggest posting your issue on forums at community.powerplatform.com/
Great Video Reza! Thank you for such great content as always! I get a very weird behavior when add line items to a given header item. After updating the line item gallery to search for just the Header gallery's selected item, the gallery renders the correct list of items relevant for that header item. However when adding new item, it does not render the added line item right away. Instead when adding another line item, the gallery then realizes that the new line item plus the earlier item needed to render. I would expect the line item to render right away. Is this potentially due to a connection lag time?
Its because we are pointing to gallery.relationship and gallery has not refreshed. One option is to refresh datasource after onsuccess of form or for related gallery use filter formula and point to related table
@Reza I have 20000 items in my collection to load all the items to gallery its taking more time how to optimize my gallery so that it wont take more time is there a way we can load the data on scrolling the gallery.
@@harinathreddy3614 Did you check documentation on delegation in power apps? That will give you the answer. I have also done videos on delegation. I have a full playlist on it.
Actually reza we are developing an application which is need to be handle around 1lakh records what is the best way to retriev data from sharepoint list.@@RezaDorrani
Hi, I cannot access the make. power app. It asks me to sign up? how to get a professional email address for Microsoft when I'm just a student? I'm clueless from Pakistan
You would need to sign up for an M366 tenant. I do not have a video reference on how to do that. I would recommend checking documentation on how to setup an M365 tenant.
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
Thank you Reza. Wonderful video as always learning with you. Just one query. I have an approver app and I want to do that part of the link to the app with the item to approve. And if you managed to tie that in with the approver. Can you tell me the structure of the link?
I dont think I have a reference handy for this so not sure. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hi Reza, thanks for the great videos. Do you think using Azure DevOps pipelines and setup 4 environments(Dev/TST/UAT/PRD) is a overkill for low code development? I personally prefer the setup with 3 environments and in product pipeline, any thoughts?
Hi @Reza Dorrani I wanted to check if the Power Apps development environment is free for developers to use. I know there are paid plans for production environments, but wasn't sure if we need to pay for a separate dev environment as well. Could you please confirm if developers can access a free development environment in Power Apps without any additional charges?😁
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
hello mr. Reza Dorrani, may u can help me about power apps, i have trouble to make auto increment uniqe ID in my form pelase make a video about that, cause this is for my job, i need to finish it for the deadline
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.
I am looking for immediate support in creating a website utilzing power pages and power apps. Reza, please advise if you are taking clients. This is an immediate project offer. I will also accept support on these services. Thank you for offering such an amazing tutorial.
![Model Driven Power Apps FULL COURSE for Beginners [UPDATED 2024 Edition]](/img/1.gif)
Can be more Power Platform artefacts/concepts mentioned and showcased during one demo video? Solutions, Publisher, Dataverse, Tables, Power Apps, CRUD operations, Screen creation, Environments, Copilot, ALM, Canvas Studio, Data types, Relationships, PowerFx formulas, Canvas Controls, Control properties, Model-Driven App, Approval Flow process, Deep linking, Security Roles, Pipelines, Environment variables, Sharing Apps, Role assignment... Good job Reza. I can just imagine how much recording time it took to create 35 min video. 📽📺 Kudos!
Thanks so much! I did go all in on this one.
Has just been initial 6 minutes, everything has been share in so much detail and so relevant, great for beginner
Thanks so much!
So much great information in 35 minutes, Reza! Thank you for producing and sharing this video!
Thanks so much!
I really went all out on this video. I wanted to make this video the base experience for app developers.
around 7:47 , the "Preferred solution" setting , I am not able to see it any more in Env settings - is this changed?
Probably because it may have gone generally available.
The man!
The legend!
Thank you for all the amazing videos you have created!
Thank You so much 😊
@Reza at 18:44 'Expenses Gallery'. Selected isn't working for me, although I changed the default to that it still shows the lookup bar and not the selected expense, what have I missed?? Help :(
Video description has link to download entire solution (members only - check description for details)
I would suggest giving that a try.
As for the issue mentioned, I have not experienced it 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
Really like the demonstration of Security Roles and ALM
Thanks
Just Amazing ! Really a great content. Thanks a lot for sharing.
Glad you liked it!
Great video, Reza; thank you for creating and sharing!
My pleasure!
Excellent Video again !! Looking forward to more business use case apps :) Thank you for your effort !!
Thanks
Thanks for this video, Able to understand end-to-end process and power of co-pilots in power apps.
Glad to hear that! Thanks for watching Kishore
I don't have words to say amazing things about this video and your other videos. Top stuff!
Wow, thanks!
Hi Reza..
When we share our canvas app to customer... first time when they are starting the app it's asking them for allow allow option from SharePoint...
Can we remove that allow pop-up by which user can see the app directly...... please reply
That is asking user to consent to connect to SharePoint or any other connector that app uses.
That is best practice.
However, if you need to bypass consent you can do that as well. learn.microsoft.com/en-us/powershell/module/microsoft.powerapps.administration.powershell/set-adminpowerappapistobypassconsent?view=pa-ps-latest
Excellent! Finally a professional tutorial. Can you elaborate more on the best practice workflow when you are an outside Consultant building Power App Solutions, then want to export from your Dev Environment and Import to Client Org Dev->Test-> production environment. Assume I am remote during development and working 'At my own company', Then, when the App is ready what is the best method for 'delivering it' to the client organization. Talk about Export / Packages / Importing at the Client and then what to configure regarding security settings once the client accepts the solution. Thanks again for a great tutorial.
Most welcome!
Idea would be to build in your own dev.
Once done, export unmanaged solution to client dev. Then deploy to test and prod.
excellent video as usual. thanks for sharing.
Most welcome
These videos are EXCELLENT!
Thank you very much!
Amazing work! Congratulations
Thanks a lot!
If you are just starting out with Power Platform this gives you a tour de force of Power App, Power Automate, Dataverse and Application Lifecycle Management. If you want a terrific overview this is the video for you.
Awesome! Thanks so much
at 20:20
the line 'Expenses Gallery'.Selected.'Line Items' is not working for me. Can you tell me why it might not be working?
I cannot know why as I have not experienced an issue with it
@@RezaDorrani when I use the dot operator after .Selected 'line items' doesn't show up
@@abdelrahmankhaled8239 Im not sure why
Very good explanation. Thank you Reza.
You're most welcome
Thank you Reza. Would love to see more ALM with SharePoint.
I’ve already done a video on it
@Reza Amazing countless work again and again. Thank you so much
Most welcome!
Great as always. Thank you 😊
Most welcome
Thank you for creating this video.
Most welcome
Great content as always
Appreciate it!
Reza you champ! Keep going!
God bless you
Thank You so much
Thank you Reza. The pipeline deployment is a take home for me
Awesome
This is an excellent video with great details and many insights. The use of solutions, security roles are very useful and informative. There is one part I would like you to explain more. At 23:00, there is the "submit for approval" button. Can you elaborate how it is created and how it is made in/visible and update the status value to pending? Thanks.
I have shared the entire solution exclusively for members. (Silver members and gold members of channel get access to it)
I did a lot of work on this one and wanted to keep certain aspects for members only.
All I did there was Patch the column Status when submitting for approval to pending and then accordingly changed visibility of certain fields.
thank you, this is end to end, really needed this
Most welcome
Thanks for the awesome video. Regarding licensing, if I have Power Apps Premium, would that cover the usage of flows to update Dataverse records, or would I still need a separate Power Automate premium license? In order for a consumer to use this app you showcased, would they require both Power Automate Premium and Power Apps Premium?
You can associated an app with a flow as long as the flow is using the same data source as the app as in this case. Check documentation on "associating apps" to flows
A terrific end-to-end experience. I thought the new preferred solution feature is really cool making everything solution ready and no messing with the default environment. Thanks for sharing and always a joy to pick up tips from your videos. Adding this to my Reza environment. 🤣🤣
Great to hear!
Thank you for this video. I got stuck at the 12 min mark. How did you switch to the app from showing the table? sorry there is a gap there for me.
App was open in a separate tab. Steps prior to 12 mins.
Ahhh ok got it. Thank you for the fast response, I appreciate it.
Thank you Reza this is really helpful, it has also helped build a copilot environment
Thanks real time
Most welcome
Thank you dear Reza 😍
Most welcome 😊
Great video, however I am wondering if anyone else is having an issue where when adding a new line item, after clicking save (tick button) the new line item doesnt show up in the line items list on the right hand side of the line items screen until I navigate back to the Expenses listing, select another expense, then select the expense I added the line item to and then go to the Line Items screen. Even just navigating back to expenese and then to line items doesnt refresh the line items listing. Everything else with the record linking seems to work
I don’t exactly remember this issue but one option can be to filter the gallery by using a variable which you can set to false and true after successfully adding new line item. This will ensure the gallery picks the latest update.
Alternatively, you could also download the solution shown in video. Video description has link to download entire solution (members only - check description for details)
Simply impressive. AWESOME VOCAL AND TEACHING METHODS LOVE FROM PAKISTAN ❤
Thanks
Reza you are awesome 😎 man!
Your every video is full of knowledge and easy to understand.
Glad to hear that! Thanks so much
Hi reza, I have purchased the membership how can I view the content missing from the video. :D
Check membership tab for link
Hello, thank you for all your content, I have learned a lot thanks to you and I wanted to ask, can you integrate On-premise SQL Server to consult and modify some data in the table (customer order and order status) and dataverse to save all the new information ( parameters requested from the client, process sheet, etc.? It's compatible? What type of license do I need in addition to the Microsoft 365 Business Standard license that each of my users has? Greetings and thank you very much
Most welcome.
Sql on prem is possible via data gateway.
Sql, Dataverse etc. are all premium features.
Every user running the app will need a premium license. Business standard will not suffice.
brilliant work! sir are u uploading the advance power apps tutorial as well?
Thanks!
Not sure I understand your question
from india loved it.
Nice
Hi Reza, nice videos I always learn a lot with your classes you are a master!, I have an issue on 20:22 , when I try to use the 'Expenses Gallery'.selected.'Line Items' the 'Line items' property is not displayed, so I cannot open only the related expense, thanks for your help!
I have not come across this 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 it seems that it is a bug, I changed the authoring version and reverted back to the original one, after that the property was displayed correctly, thanks again for your videos! greetings from Mexico
@@miyattogan113 how can i change the authoring version? I'm having the same issue - thanks
Thanks Reza. It is indeed a great video on end-to-end Power Apps implementation. However, I do have one question on pipeline. Do we need to have managed environment to leverage Power Apps Pipeline feature in dev environment as well?
Thanks!
Pipelines only requires target environment to be managed. Its called out in the documentation
thanks your video really helped me get started on power apps
Awesome!
Hi Reza, another great video. If you wanted to print a report of the line items etc to Word or PDF have toy done something similar on that before?
Welcome!
I have done app to pdf but not word to pdf.
@@RezaDorrani - yeah just basically X amount of line items from App to a section in a document , i'll search through old videos so if done before, thanks
Hi Reza, to avoid creating from scratch a new PowerApps Canvas form, I copied and saved an existing canvas form called
2024 Rental Deposit to 2025 Rental Deposit canvas form.
The 2024 Rental Deposit canvas form used as SharePoint list called 2024 Rental Deposit. I also copied that SharePoint 2024 Rental Deposit list to a new SharePoint 2025 Rental Deposit list for the 2025 Rental Deposit canvas to use.
The problem is that the Data Card (COMBO BOX) in the 2025 Rental Deposit canvas form will only reference the original SharePoint 2024 Rental Deposit list, even though the item name was changed from 2024 to 2025.
Do you know why only COMBO BOX data card referred to the old 2024 list while the other fields (Text) did refer to the new 2025 list?
I have no clue about this
I apologize if it was confusing. All I did was to save a power apps form from an existing form. The new form was referencing fields from the old SharePoint list. Thank you for replying.
@MrSpartan-m1q I understand the question but have no idea why would combo box act weird.
Should I go through the entire playlist to master power apps? WIll I be an expert and be able to do enterprise apps? Also is this still relevant in 2024 seeing MS keeps updating stuff? Thank you brother Reza.
These are tutorial videos that cover various aspects on app, flow, bot building.
If you are interested in a training program - then you can join my channel membership in GOLD tier - This includes hands-on content with real-world examples and deep dives into each topic.
This was incredibly informative! I was curious about setting up approvals in Automate, and this video answered all my questions. Could you do a video on authentication using Microsoft Entra?
Thanks!
Auth for power platform is entra out of the box. Not sure what the video would showcase.
@@RezaDorrani How can we create login screen and authenticate the user. May be not with Entra
@Tasneem-e2e Why would you need to create one when entra is already there and set out of the box.
I do not have a video reference on the mentioned scenario. I will recommend checking or posting your query on forums in case someone has done something similar
community.powerplatform.com/
ok reza, thanks for tutorial
Welcome
Hi Raza,
I have issue with my App(Dataverse User Table) , when I publish the user dropdown fields doesnt show up.
Could you help to fix it.
Video description has link to download entire solution (members only - check description for details)
I have not faced any issues with it so not sure whats the cause or fix for your issue.
how did you made automatically the crud operation available in the screen which included all new , edit, search , delete options. can u plz share the youtube link
I dont have a video reference on it.
I have made the entire solution available for download (members only - check description for details)
Hi Reza,
Thank you! This taught me so much. Quick question: Can you set ItemDisabled in a Modern Toolbar based on the e-mail address, or security group of the current user?
Most welcome!
Possible - I have done videos on checking if user is part of SG.
Hey Reza, my colleague just signed up to the gold membership and are working through this video but we are struggling with setting a default value for the "Related Expenses" card. We have followed the video but default value is being added and we don't even seem to be able to select the correct value manually. We are working independently of each other in separate environments but have arrived at the same problem. What are we missing?
The link to download the entire solution is in community tab for members. Il recommend giving that a shot.
I have not faced any issues with setting default value so not sure.
@@RezaDorrani Sorry but having trouble finding the download link in the community tab, first time using this training method, can you send a link please?
@@joecoffey5183 I dont have the link handy. It was posted in community tab the day this video went live. You will need to look through it.
@@RezaDorrani been back over 10 months work of community content and cant find it, disappointing
@@joecoffey5183 The link is in community tab. I just went 6 months back and got it.
Il repost it on Community Tab for now so you get it right at the top. Request to please look through Community tab if you need any other old ones.
My organization has disabled the AI prompt functionality of Power Apps.
Could you make one similar app for this scenario if possible?
Thank you!
if org blocks it, there is no other option.
Excellent! I would love to see the same app with SharePoint instead of Dataverse!
Thanks!
I have no plans to build one with SharePoint as the scenario of expenses and line items demands a relational database which SharePoint is not.
@@RezaDorrani I understand, Thank you!
hello Sir, Could you please help me with an issue? In line Items screen there is lookUp field named as Related expense it is not showing correct values from expense gallery instead it shows item1 item2 item3..... what is the issue could you please help me with this
I have not experienced the mentioned issue and hence not sure what is the cause for it. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com in case someone has experienced something similar.
Also, video description has link to download entire solution (members only)
Hi Reza, I am new to power apps and I also have a friend that does not have an IT background who wants to learn power apps. Do you know any that does one on one training or places we can sign up that can train us from start to finish with real life examples.
My power apps training program would be a good option (as per me)
The program is available for channel members in GOLD tier.
Channel membership details
thepoweraddicts-my.sharepoint.com/:w:/g/personal/rdorrani_thepoweraddicts_onmicrosoft_com/EbvjdBY80QRGkT6svJEmzZwBz64PNYQDRvKHm8eRHEYe6Q?rtime=c5EBcvvn3Eg
Mr. Dorrani, can you help me with a issue? I'm beginner at PowerApps, I have a list in SharePoint as data source of my app, it's a list about projects and one of the rows is the person who is the owner of that project, so the row is type person. In the app I want to show the count of projects that the user is owner, I tried to put this formula on a label: CountIf('MyList', Owner = User().FullName) but don't compare the types, I tried this: Text(CountRows(Filter('MyList', Owner.FullName = User().FullName))) but it doesn't work as well. I'm struggling, can you help me?
(Plus, is it possible to put this counter in a component that is my menu for every screen?)
I would have to try it out to know the issue and provide the fix.
Best to post issues with screenshots on the forums at powerusers.microsoft.com
Is it only possible with Dataverse, or can the same functionalities be implemented with On-prem SQL Server as well?
A power app can connect to any data source
Another great video @Reza. You are incredible. I made a similar app to track expenses (not even close in terms of the way you made it, but gave it a try). So far it has been garnering a lot of appreciation from my management and users as well. Thank you for such wonderful videos you make week after week. Kudos to you.
Thanks so much the appreciation.
I’m very happy to hear the response for this video so far.
hello Raza good work, I believe you have skipped the video during demonstration how can we get full video ?
Demo of expense solution? Or something else?
@@RezaDorranithe explanation of the how to setup things like: configuration of submit approval button, power automate, environment variables, email to approver and user etc, I think these are missing in this video or I am missing anything?
Video is focused on explaining the key points app makers must know while building apps.
If you need the expense solution showcased in video, it is highlighted in video itself than link to download is for channel members and video description has the details needed.
@@RezaDorrani ok great thank you so much for your quick response keep teaching us ♥️
is this posible without the dev envornment? im still waiting to get approved from IT to upgrade my license,. and i cant use copilot or create tables or an enviornment, is it posible to work around these set backs?
Any environment is fine as long as it has dataverse and you can build in solutions
@RezaDorrani thank you, then why dont i have the option to "create a new list" in the canvas app? Must i create them manually in sharepoint first?
@@estefaniacantu8172 You cannot create a sharepoint list from a canvas app. Did I show that in the video?
@RezaDorrani i realized i do t have dataverse.. therefore dont see available some of the options you use in the video
@@estefaniacantu8172 Dataverse is needed for your environment.
hi , I tried to log in and get a free trial and I couldn't . My work account did not give me access to developer environment . Any advise?
It's probably because your admin has blocked creation of dev ends. You will need to reach out to your admin.
guys i just cant get through the form editting. I added collumns but they are not visible in power app
I have not experienced this issue and hence not sure what's the cause for it.
I would suggest posting your issue on forums at community.powerplatform.com/
Reza, its very good content and Nicely Presented.
Just would like to do Power Apps having Integration with SAP/ Any ERP After Expenses Approved?
Thanks!
There is a connector for SAP, but I have done no work with it.
@@RezaDorrani thank you for the insights
is all the videos are in sequence?
No
@RezaDorrani plss I request u to make it in sequence, so it will be really help us to learn step by step.
It's amazing to being taught from u Sir
@@gargishodangi2868 Sequential videos is my training content. My regular videos are made based on what I feel is best for that week.
Great Video Reza! Thank you for such great content as always! I get a very weird behavior when add line items to a given header item. After updating the line item gallery to search for just the Header gallery's selected item, the gallery renders the correct list of items relevant for that header item. However when adding new item, it does not render the added line item right away. Instead when adding another line item, the gallery then realizes that the new line item plus the earlier item needed to render. I would expect the line item to render right away. Is this potentially due to a connection lag time?
Its because we are pointing to gallery.relationship and gallery has not refreshed. One option is to refresh datasource after onsuccess of form or for related gallery use filter formula and point to related table
Hi..is this possible add 3 nested galleries in power apps
Not sure as I have not tried it
@@RezaDorrani thanks if any idea about that
@@yogeshm8344 I do not have any. I recommend posting your query on forums
powerusers.microsoft.com
@@RezaDorrani ok thanks
@Reza I have 20000 items in my collection to load all the items to gallery its taking more time how to optimize my gallery so that it wont take more time is there a way we can load the data on scrolling the gallery.
Loading 20k items in collection itself is not recommended. Look into documentation for power apps delegation.
@@RezaDorrani I Have 20 k reocrds in my list how to show all the data on the screen without collection.
@@harinathreddy3614 Did you check documentation on delegation in power apps?
That will give you the answer.
I have also done videos on delegation. I have a full playlist on it.
Ok thanks
@@RezaDorrani
Actually reza we are developing an application which is need to be handle around 1lakh records what is the best way to retriev data from sharepoint list.@@RezaDorrani
Hi, I cannot access the make. power app. It asks me to sign up? how to get a professional email address for Microsoft when I'm just a student? I'm clueless from Pakistan
You would need to sign up for an M366 tenant. I do not have a video reference on how to do that. I would recommend checking documentation on how to setup an M365 tenant.
When i swithed to the another teams accoount my power apps account is not swithing, its hold the old account. how can i resolved this issue.
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
Thank you Reza. Wonderful video as always learning with you. Just one query. I have an approver app and I want to do that part of the link to the app with the item to approve. And if you managed to tie that in with the approver. Can you tell me the structure of the link?
I dont think I have a reference handy for this so not sure. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Why am not able to see AI Copilot in Developer Environment????
Probably because your tenant admin may have blocked it or your dev environment is setup in a region where copilot is not available
Thank you!!!I am from India region can I set it to US Region. Will it work ???
@@gargimohanty5295 Try it and see
great vid brotha
Thanks so much
why do your videos always use sharepoint lists but never use a MS SQL databases?
Because 99% users have access to sharepoint and/or dataverse. Very few have access to sql including myself.
great video
Thanks!
Hi Reza, thanks for the great videos. Do you think using Azure DevOps pipelines and setup 4 environments(Dev/TST/UAT/PRD) is a overkill for low code development? I personally prefer the setup with 3 environments and in product pipeline, any thoughts?
It depends on the process. Environment strategy is different for different orgs.
Thanks for sharing your thoughts!@@RezaDorrani
Invincible !
I hope this video reaches out to everyone.
It covers a lot.
love it!
Thanks
Hi @Reza Dorrani
I wanted to check if the Power Apps development environment is free for developers to use. I know there are paid plans for production environments, but wasn't sure if we need to pay for a separate dev environment as well.
Could you please confirm if developers can access a free development environment in Power Apps without any additional charges?😁
Thats what I called out in video :)
Video description has link to documentation on dev environments.
Thank you so much Reza༼ つ ◕_◕ ༽つ
I'm facing "Invalid operation: division by zero", even I'm not used any division in the app.
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 Thank you
Hi I be a member .Butcan watch the chapter 1!!!!why?
Hi, I did not understand the question.
Chapter 1? You mean training?
All training chapters are open for gold members.
Thanks Reeza
Welcome
hello mr. Reza Dorrani, may u can help me about power apps, i have trouble to make auto increment uniqe ID in my form pelase make a video about that, cause this is for my job, i need to finish it for the deadline
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.
I am looking for immediate support in creating a website utilzing power pages and power apps. Reza, please advise if you are taking clients. This is an immediate project offer. I will also accept support on these services. Thank you for offering such an amazing tutorial.
Check about tab of my channel please. It should have an email there.
@@RezaDorrani i responded to you via linkedin. I am hoping that we can connect soon. Thank you
all in one video
Present Sir
Thanks