- Видео 284
- Просмотров 20 691 352
Reza Dorrani
США
Добавлен 19 июн 2011
Hello everyone, Reza here!
Welcome to my RUclips channel, your go-to destination for all things related to the Microsoft Power Platform! Here, I share learning content on various aspects of the Power Platform ➡️ Power Apps, Power Automate (flow), Power BI, Virtual Agents ➕ SharePoint, Dataverse, Microsoft 365 and more.
My channel aims to provide you with practical insights, real world examples, no fluff and step-by-step guides to mastering these tools efficiently.
I work as a Principal Program Manager in CAT Team at Microsoft and am a Microsoft Certified Trainer and MVP alumni.
🚀 Don't forget to subscribe and hit the 🔔 bell icon to get notified when I publish my latest video
🎬 Video release cadence: Every Monday
📝 I do read and try to respond to every comment
🤝 Take your involvement to the next level & consider becoming a member to unlock access to exclusive perks
Welcome to my RUclips channel, your go-to destination for all things related to the Microsoft Power Platform! Here, I share learning content on various aspects of the Power Platform ➡️ Power Apps, Power Automate (flow), Power BI, Virtual Agents ➕ SharePoint, Dataverse, Microsoft 365 and more.
My channel aims to provide you with practical insights, real world examples, no fluff and step-by-step guides to mastering these tools efficiently.
I work as a Principal Program Manager in CAT Team at Microsoft and am a Microsoft Certified Trainer and MVP alumni.
🚀 Don't forget to subscribe and hit the 🔔 bell icon to get notified when I publish my latest video
🎬 Video release cadence: Every Monday
📝 I do read and try to respond to every comment
🤝 Take your involvement to the next level & consider becoming a member to unlock access to exclusive perks
How to Convert Your EXCEL Spreadsheets into POWER APPS | Tutorial
In this tutorial video, we will learn how to convert your Excel spreadsheets into Power Apps & Dataverse Tables in a matter of minutes with AI Copilot assistance in Power Apps. For scenarios with spreadsheets that include data relationships (multiple sheets / tables in Excel), I will show how you can create, relate and import data into multiple Dataverse Tables and build fully functional Model-driven Power Apps / Canvas Apps on top of it.
#powerapps #dataverse #copilot #powerplatform
0:00 - Get started with converting Excel files to Power Apps
0:38 - Create a Canvas Power App from Excel data with Microsoft Copilot assistance
3:28 - How to work with importing multiple Excel tables in Datavers...
#powerapps #dataverse #copilot #powerplatform
0:00 - Get started with converting Excel files to Power Apps
0:38 - Create a Canvas Power App from Excel data with Microsoft Copilot assistance
3:28 - How to work with importing multiple Excel tables in Datavers...
Просмотров: 5 485
Видео
Mastering Modern TABLE Control in Power Apps | Working with Multiple Related Tables
Просмотров 16 тыс.19 часов назад
In this Power Apps tutorial, we dive deep into utilizing the latest Modern TABLE control within Canvas PowerApps. Join me as we construct a fully responsive canvas app that seamlessly interacts with multiple related tables in Dataverse. Throughout this tutorial, we'll explore various aspect of the Modern Table control, empowering you to show your data in tabular, list format, style table data a...
Creating Multi-Step Forms in Power Apps | Tutorial
Просмотров 19 тыс.14 дней назад
In this Power Apps tutorial video, we will learn how to create a Multi-Step Modern Form control experience in Power Apps. Follow along as I guide you through the process of breaking up a modern Form control across multiple steps, including validation of form data within each step. Learn how to effortlessly navigate through various form steps using next and previous buttons & include a live stat...
How to build a Responsive Modern Gallery in Power Apps | Tutorial
Просмотров 17 тыс.21 день назад
This video is a step-by-step tutorial on how to build a Responsive Gallery with Modern controls in Power Apps. In this tutorial, we'll explore the new 'Header and Gallery' screen template, which provides a fully responsive Gallery with modern controls. We'll customize it and add modern controls to represent our data in unique ways. Key highlights of this video include: ➡️ Customizing Modern Scr...
Transform your SHAREPOINT Lists into DATAVERSE Tables & Copilot ready Power Apps
Просмотров 21 тыс.28 дней назад
In this step-by-step tutorial video, I will show how you can easily transform your SharePoint Lists into Dataverse Tables and Copilot ready Canvas Power Apps in a single experience. We will explore the advantages of leveraging Microsoft Dataverse over SharePoint for enterprise App development scenarios & talk about the differences between Dataverse and SharePoint. The new "Create with SharePoin...
How to Request an Approval Process from Power Apps | Full Tutorial
Просмотров 32 тыс.Месяц назад
In this Step-by-Step Tutorial, you'll discover how to trigger a sequential approval workflow process right from within Microsoft Power Apps. Learn how users can effortlessly select their approvers directly from the App interface and submit their requests. Learn how to build a Power Automate workflow to setup the serial approval process. Follow along as we explore how the status indicator in Pow...
The NEW Microsoft Planner: Overview + Planner Premium Features
Просмотров 46 тыс.Месяц назад
This video is an Overview of Microsoft's NEW Planner experience, where Microsoft To-Do, Planner, and Project for the Web seamlessly merge into a single powerhouse tool with added intelligence of Microsoft Copilot. The new Microsoft Planner is a simple, collaborative, and flexible work management solution that’s assisted by AI and integrated into the Microsoft 365 products we know and love. From...
Build Power Apps Faster with Modern Screen Templates
Просмотров 23 тыс.Месяц назад
Power Apps now includes NEW Modern Screen Templates which we can use to quickly create screens that contain mostly Modern Controls and are Responsive by default thanks to Containers. App Makers can easily customize these templates to tailor to their specific needs. The new set of screen templates have screens that are commonly built by makers and use modern controls and responsive containers. T...
VERSIONING and DRAFTS in Power Automate cloud flows
Просмотров 12 тыс.Месяц назад
Ever wished we had 'Version History' for Power Automate flows or the capability to hit 'save draft' on your work in progress? With cloud flow Versioning & Drafts feature now in Microsoft Dataverse, you can! This feature lets you save your flow at any stage, even if it's not perfect yet. Take your time, make changes, and when you're ready, hit 'publish' to make it go live. But that's not all - w...
NEW FORMS Experience for Microsoft Lists | Full Tutorial
Просмотров 32 тыс.Месяц назад
This tutorial covers the NEW Forms Experience in Microsoft Lists, within Microsoft 365 (work and school). The new List Forms experience makes it easier to collect and gather information directly into your lists (Microsoft Lists or SharePoint Lists) - saving you time and effort. With a modern design experience, Lists forms can be created quickly and shared via a link to anyone within your organi...
Power Apps MODERN Gallery Design | Step-by-Step Tutorial
Просмотров 35 тыс.Месяц назад
This video is a step-by-step tutorial on Power Apps MODERN Gallery Designs. You'll learn how to customize Galleries by leveraging Modern controls to represent your data your way. We will design our PowerApps Gallery like a table / list style or card style, add drop shadow effects, use various modern controls that respect app themes, explore modern style properties & a lot more. Whether you're a...
Named Formulas & User Defined Functions in Power Apps
Просмотров 23 тыс.2 месяца назад
Discover the game-changing capabilities of Named Formulas and User Defined Functions in Power Apps in this tutorial video. Introducing Named Formulas: A powerful concept that has been in Excel for a very long time, that is now available in Power Fx. With it, you can simplify your app’s initialization, reduce app load time, reuse logic, and improve the maintainability of your apps. A must learn ...
Create Dynamic PDFs with Tabular Data using Power Automate
Просмотров 34 тыс.2 месяца назад
In this step-by-step tutorial, learn how to Create Dynamic PDFs with Tabular Data using Power Automate. This powerful automation can be leveraged in various scenarios for document generation like Invoices, Expense Reports, Proposals, etc. The video showcases how to populate a template word document to create a file with dynamic data including Tables and then convert it to PDF. Follow along as I...
Populate a Word Template with Power Automate | How to Tutorial
Просмотров 28 тыс.2 месяца назад
In this step-by-step tutorial, learn how to dynamically populate a Microsoft Word template using Power Automate. This powerful automation can be leveraged in various scenarios for document generation like Invoices, Proposals, Onboarding, etc. Video showcases how to generate word document for certificates of participation for courses. Follow along as I guide you through the process of creating a...
UPLOAD files from Power Apps to SharePoint Document Library ➕ Set Properties
Просмотров 31 тыс.2 месяца назад
UPLOAD files from Power Apps to SharePoint Document Library ➕ Set Properties
How to Trigger a POWER AUTOMATE flow from EXCEL | For a selected row
Просмотров 17 тыс.3 месяца назад
How to Trigger a POWER AUTOMATE flow from EXCEL | For a selected row
CHART Controls in Power Apps | Line, Column, and Pie Charts
Просмотров 19 тыс.3 месяца назад
CHART Controls in Power Apps | Line, Column, and Pie Charts
DELEGATION in Power Apps | Must Know to build efficient Apps
Просмотров 30 тыс.3 месяца назад
DELEGATION in Power Apps | Must Know to build efficient Apps
How to use COPILOT in Microsoft Word | Tutorial
Просмотров 34 тыс.3 месяца назад
How to use COPILOT in Microsoft Word | Tutorial
How to Select MULTIPLE Items in Power Apps Gallery & PATCH
Просмотров 27 тыс.3 месяца назад
How to Select MULTIPLE Items in Power Apps Gallery & PATCH
COPILOT for Microsoft 365 | How to Enable & Get Started
Просмотров 100 тыс.3 месяца назад
COPILOT for Microsoft 365 | How to Enable & Get Started
How to build a Responsive Navigation Menu in Power Apps
Просмотров 27 тыс.3 месяца назад
How to build a Responsive Navigation Menu in Power Apps
Meet Microsoft Copilot App: Your Ultimate FREE AI Assistant!
Просмотров 16 тыс.4 месяца назад
Meet Microsoft Copilot App: Your Ultimate FREE AI Assistant!
Integrate GPT AI into Excel with AI Prompts in 10 minutes
Просмотров 15 тыс.4 месяца назад
Integrate GPT AI into Excel with AI Prompts in 10 minutes
Introducing Microsoft Copilot Studio: How to Build your first Copilot
Просмотров 73 тыс.5 месяцев назад
Introducing Microsoft Copilot Studio: How to Build your first Copilot
Exploring the NEW Cloud Flow Designer in Power Automate 🚀
Просмотров 24 тыс.5 месяцев назад
Exploring the NEW Cloud Flow Designer in Power Automate 🚀
Top 5 Must-Know GALLERY Features in Power Apps
Просмотров 26 тыс.5 месяцев назад
Top 5 Must-Know GALLERY Features in Power Apps
Power Apps Table Control Tutorial: From Beginner to Intermediate
Просмотров 48 тыс.5 месяцев назад
Power Apps Table Control Tutorial: From Beginner to Intermediate
Get started with Power Apps: A tutorial to Building Business Critical Apps the Right Way
Просмотров 46 тыс.6 месяцев назад
Get started with Power Apps: A tutorial to Building Business Critical Apps the Right Way
SharePoint Form Customization with Modern Power Apps Controls | Step-by-Step Tutorial
Просмотров 46 тыс.6 месяцев назад
SharePoint Form Customization with Modern Power Apps Controls | Step-by-Step Tutorial
Hey Reza Thank you for your videos. I learned a lot from you!
hi Reza, you da best. I use your same logic but my CSV only exports 9k and the info from the table is 25k, Do you have any idea why this is happening? I really appreciate any help you can provide.
Limit is on the size of the file exported not specifically on number of rows. You probably have a lot more columns.
I have delegation warning when placing dates in collector How can I remove that message?
I did not experience any warnings hence not sure. I will recommend posting your query on forums at powerusers.microsoft.com/
Hello Reza, thank you for publishing this video. I have been waiting for this video for a long time, but I have a problem: I followed all your instructions in the video, but I could not download the file in SharePoint. What is the problem? I ask you to help me solve this problem. Thank you
Video description has link to download entire solution (check description of video for details) I have not faced any issues with this so not sure.
Hello Reja....How to control sending the adaptive card multiple times...I have only once
I did not understand your question
Adaptive card is sending multiple times
I have not come across that issue
Hello all Does anyone know how to open excels from folder, 1 by 1 and rename them base on C2 cell of each excel file? Thank you
I have not tried this. I will recommend checking or posting your query on forums in case someone has experienced something similar powerusers.microsoft.com
I’m trying to upload a 135 mb file, and getting a 413 “payload too large” error in the app (flow never triggers). How can I account for this?
Power Apps cannot handle large files. Attachment control can accommodate max 20 MB.
Actually, we see it handling up to 70 mb. I’ve come up with a pretty slick workaround though.
@@dmvogan Great
Tried to use this component but I think they made it a premium feature.
This has always been a premium control
Hello Reza, your tutorial are really really interesting!! Thank you so much. One question relating to this flow: is there the possibility to modify the response in case of one task already created in the sharepoint list? I would like to add this form in power BI and in case of some new info to update the current response. I think power form is more easy to use if compared to power app. Thanks
Thanks! Not sure about the possibility of updating responses. I have not explored that scenario.
Hey Reza, is there anyway to show or hide buttons if a user is in a sharepoint group without creating an extra list? I know you went into the sharepoint site and created an extra list and added items and made changes to the permissions on the items. Not sure if anything has been changed with the process in the video since the video has been posted.
You would need to either use that technique or call a flow to use rest api to check.
Awesome! But unfortunately, I had some errors while pursuing the steps with you and I don't know what wrong, for example the patch function doesn't work with me in the 'Edit in grid' button it gives me: Network error when using patch function: the specified column is read-only and can't be modified could please help? @RezaDorrani
I have not experienced 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
How to create a task from flagged email
1:52 in video It lists out flagged emails
Thank you for such a n informative video, everything I wanted is done and it came out correctly. But the only issue I am facing is after I save the record it is collecting multiple duplicate entries in the collection and patching to data source if I enter only 1. Please provide a solution for this?
Most welcome! I have not experienced the duplicate 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
Hi Reza, I have a problem statement, if you help me it will be my pleasure. I have created a power app. I have a user list in share point. I want to provide power app access when ever add a new user in the list and revoke when user removed from the list.
I do not have a video reference on this scenario and would have to try it out to provide guidance. I will recommend checking or posting your query on forums in case someone has experienced something similar powerusers.microsoft.com
Hi Reza, wondering how to reset a modern drop down control, we don't seem to have the same varReset we could set on the classic?
You would need to reset them using the standard Reset function
@@RezaDorrani Thank you!
Hi Raza, This looks good and can you share how to get only the lookup value out of its metadata as the entire row comes as an output for lookup column.
You would need to use expressions to get value out of json object for lookup. I don’t have a specific video reference for it.
Hi Reza This was very helpful but I guess this techniques does not apply to the current PowerAutomate version unfortunately. It throws an error using this technique. I thought I should let you know. Cheers
As far as I know, 99.99% of the flows that work in old version is supported by new version. You can always swap to the earlier version.
why my customized form is not reflected on my sharepoint list :( i followed everything on your video. when i clicked the publish to sharepoint, i can't see the sharepoint link. i am not sure if that is the reason why it didn't reflect on the list.
It may be related to browser caching. Sometimes it takes a few mins. If after a few mins as well it does not show, then it must be some other issue on your side.
@@RezaDorrani i have full access on SP list and created a customized form in power apps. do i need to have full access for me to be able to publish it to SP?
@@ervincandare9990 No, edit permissions on list are enough.
When creating this app, like when you get to the "create app" step, does Power Apps create this in a solution automatically? (e.g., the new dataverse table along with the app in a prenamed or defined solution?)
If you have solution by default turned on then yes. Check this video ruclips.net/video/pp6wBvy9Wgs/видео.htmlsi=N6SxUwaMB5RL7Q6Y
@RezaDorrani how to make power automate flow run regardless of the user? I created a "When a file is created or modified (properties only)" trigger, which runs when I modify the sharepoint file but does not get triggered when another user modifies the file. Flow only runs when I share the same flow with that user.
When a file is created or modified is an automated flow. It will run whenever a file is added as long as you have min read access to it. I have not faced any issues with this so not sure what is the issue in your scenario
WARNING - This method does not fix the problem. The goal is to avoid delegation warnings for a specific reason. This is because delegation warnings mean PowerApps cannot filter a list > 2000 items. In the shown example, 2000 items will be loaded into PowerApps as gallery items, and only then will the "in" operator be checked to calculate the visible property. So the problem remains.
Thanks for the WARNING. Delegation is not just about filtering. It can be sorting or simply loading data in collections as well. Nothing can solve the delegation problem other than using delegable queries. Video simply does not apply any formula on the items property rather shows/hides items. So as you scroll down, it will load the data and hide the items based on the condition.
Hi Reza.. thanks for sharing. How to perform validations / disable other tabs if required fields are not filled in the first tab? Its a pain with tabs, if there is no way to do that!
Check my other videos on tabs and forms.
Hi Reza, After creating the checkboxes, i want to be able to make another field visible when one or two checkboxes are selected. how do I configure the Visible on that field? Tried several ways and it is not working for me. I hope you spare some time to answer this. Thank you.
You can always check the count of items in the collection for checkbox. If countrows(collection) > 1 then do something.
@@RezaDorrani what i meant was a field is dependent depending on the checkboxes I select. Example, if I checked Item A, ItemA1 should be visible.
@@redbug2011 You can check and see if collection includes that item. I dont have a specific video reference on it hence I can only guide. I would recommend checking on forums in case someone has done something similar powerusers.microsoft.com/
Great Tutorial M. Reza. I tried to reproduce the Multi Select Filter using Combo Box on a SharePoint List (starting at 6:04). For me, it only works when all choices are selected or none. Otherwise the filter returns nothing. What did I do wrong? Thanks.
Thanks! I have not come experienced 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 With the Index function it is not working, but with Last(FirstN(...)) it works perfectly as in your video. Thx!
I'm able to upload the files to my SP list. However, when I change the flow to include the JSON Form properties I receive a bad gateway error message from the API. The files are uploaded, but the flow can't reach them to add the properties. Any suggestions on how to adjust this?
Video description has link to download entire solution (members only - check description for details) I have not come experienced 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
Another banger, Reza. This is also a really good tutorial for some key Dataverse topics
Thanks so much!
Always up to date content! Thank you Reza!
Hello Reza, how would you utilize this same flow but using "Manually trigger a flow" and uploading the .xlsx file? I'm not sure how to connect "List rows present in a table" to the uploaded file with manual trigger. You did this using .csv file in another video but I'm unavle to use it in this flow.
I have not tried it but it would be a combo of the videos. I would recommend posting your query on forums in case someone has done something similar powerapps.microsoft.com/
@@RezaDorrani Thank you Reza, you're amazing and your videos are phenomenal.
I have used that image link which you used but I am not see images in mobile app Any help?
Video description has link to doc that calls out the limitations
@@RezaDorrani No, actually I am not using your component for viewing the images, I am using gallery to show the images I am able to see them in Desktop but not in mobile app what is the reason? ( I have multiple images for a single item) using attachments column of Sharepoint List
@@mustafahussainmohsin320 Im not sure why that would be the case
"Sir, can you please tell me how to add the modified date with the current date and time?
Where to add? You simply add those data cards to form (they are system fields though)
@@RezaDorrani "I need to add it to the SharePoint list.""When I add a new item to the share point list, I need to see the created date with time added after the new item is added."
@@shrutichavan3404 Change the view to include those columns.
@@RezaDorrani "Sir, what exactly are you saying? I don't understand." can you please sir explain me step's of the process. "Or if you've included any of your video, then plz provided its reference.
@@shrutichavan3404 I will recommend posting your query on forums powerusers.microsoft.com
Hey Reza. Than so much for all your videos. There are amazing and I always learn a lot. Would you mind drop me the link for the home screen for me?
Most welcome! I have done so many videos that I myself have lost track. I dont have a link handy.
Hi Reza, I've built a Sharepoint list form using Power Apps. However, When i click on edit(to edit a line item), the details vanish when the form window opens. Please help.
I have not faced this issue so not sure.
Great video Reza, clear and concise way to get started. Curious if you can continue with the canvas app instead of switching to the model driven.
Thanks so much! I have done videos on working with Dataverse table relationships in canvas apps. I will recommend checking them.
I do not see the options enabled to "create with excel" or "start with a blank table". Is that a copilot license issue?
Your environment admin might have disabled the feature
Reza your videos are Awesome! All facts! Thank you
32:28 i created a model driven app to dataverse and run the app. It didn't ask me for a premium license (i was suprised). But when i do this with a canvas app (with the same tables on dataverse) it ask me to start a premium trial. So my mind is not clear about model driven app license.
Both require user to have a premium license.
@@RezaDorrani In the MD app settings it says "Pass assignment: This app can be shared with users without a Per User plan."
@@kadirkkkk Power apps premium plans per user or per app. You need to have either one.
Hi Reza Dorrani, Everyday at work I am so grateful for your videos to be able to learn a lot of Microsoft Power Platform concepts with so much ease. You are the best! Have a great day!
I have not come across this issue hence not sure. Some folks did report it but later mentioned it worked fine on its own.
Hi ! I am currently working on power apps , I am stuck at a place that will be very helpful if you get me out of it , Actually I used Toggle in a gallery where I put a function which returns to make it checked (on toggle) if the condition meets and it collects the data into the collection, where I collected data over OnChecked Property. The issue is when I open the app it is collecting 3x of actual data multiple duplicates occur!! I guess it's because of the timing but won't be able to fix that
I have no clue about this. I will recommend posting your issue on forums at powerusers.microsoft.com/
Hi Reza thanks for the video! I'm having a problem tho, tha table rows sometimes are not updated even if the filtering/searching is correctly done (the row number on bottom sx shows the right number). Any idea on what could possibly cause the problem? thanks!
Video description has details on how to download entire solution (you can check all the logic I used in it)
Hi Reza, will you please show how to make powerapp of an excel present in SharePoint and refresh the data periodically?
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 idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
Amazing video Reza! Easy to follow, every complete and helpfull!
Happy to hear that!
Its an amazing addition. Its a bit disappointing to see the LookUp field type is not supported. I want to allow user to submit modification (only certain fields) of existing list item through a form. However without lookup filed it would be hard to match the item. @Reza or any one know of any workaround?
I am not aware of any workaround
@@RezaDorrani thanks for your reply. How about if I use Power Automate to read the unique values of the lookup field and create a choice column and use that instead? I think there is an way to dynamically add new choice values. So in theory I can use Power Automate to insert any new choice values when a new item is inserted to list. Do you that would work?
@@datique I have not tried it so not sure
@@RezaDorrani, thanks for your reply. For anyone having the same requirement, I have tested it and it works great.
What about sql ? Can we create a same like sharepoint for sql environment variables
I am not aware of sql options
Thank you Reza this really helps me a lot, once question though, how can I input text manually in case one of my dropdown is 'Others'? Thank you so much
I have not tried this scenario so not sure
@@RezaDorrani Thank you Reza, no worries 👍