Vipul Jain
Vipul Jain
  • 94
  • 151 649
Using PATCH in optimized way in Power Apps | With function
In this video, I have explained how to use Patch function in optimized way in Power Apps using "With" function. I have used "Users" Dataverse standard table in this video. Also. it is recommended to use Power Apps Monitor tool to check duration of your queries execution.
"With" function in Power Apps - learn.microsoft.com/en-us/power-platform/power-fx/reference/function-with
🚩 Connect with me on social:
- LinkedIn: www.linkedin.com/in/vipul0309/
- Twitter: jainvipulcs
🔔 Subscribe to my UA-cam channel
ua-cam.com/users/VipulJainEducation
#powerplatform #powerautomate #powerapps #patch #queryoptimization #with
Переглядів: 129

Відео

Setup Power Platform Governance | Power Platform Well Architected
Переглядів 2112 місяці тому
In this video, I have explained how to setup Power Platform governance and various considerations for the same. I have also explained about Power Platform well architected. Useful Links - learn.microsoft.com/en-us/power-platform/well-architected/ learn.microsoft.com/en-us/power-platform/well-architected/what-is-power-well-architected learn.microsoft.com/en-us/power-platform/guidance/coe/starter...
PowerDocu - Generate technical documentation for Power Apps Canvas Apps and Power Automate Flows
Переглядів 4763 місяці тому
After creating a Flow in Power Automate or a canvas app in Power Apps, you might want to document it. This helps others understand how it works, keeps specific configurations recorded elsewhere, and saves time compared to manual documentation. PowerDocu helps in generating the technical documentation within seconds. The documentation can be generated as a Word document or in Markdown format. Th...
Power Automate HTML Table Formatting | Styling using CSS
Переглядів 4363 місяці тому
Power Automate can be used to send an email with a formatted and styled HTML table. With the help of the "Select" and "Create HTML Table" actions, SharePoint list items can be quickly converted into an HTML table. In this video, I have shown how HTML Table can be styled in Power Automate. 🚩 Connect with me on social: - LinkedIn: www.linkedin.com/in/vipul0309/ - Twitter: jainvipulcs ...
Create SharePoint Group and add User using Power Automate | Ensure User in SharePoint Online
Переглядів 2933 місяці тому
In this video, I have explained how to create a SharePoint group, ensure the user in SharePoint and add user to the SharePoint Online group. For creating the group, "Send an HTTP request to SharePoint" action is used with POST method and Uri: _api/web/SiteGroups For adding the user, I have used the URI as _api/web/SiteGroups('GroupID')/users NOTE - You can extend the functionality by checking i...
Power Apps Component Framework (PCF) - Part 4 - Usage of React JS (Dataset template)
Переглядів 3766 місяців тому
In this video, I have explained how to use Dataset template and React JS in Power Apps Component Framework (#pcf) . Part 1 Video URL - ua-cam.com/video/xmULGPDqNxs/v-deo.html Part 2 Video URL - ua-cam.com/video/wkQb9osKLm4/v-deo.html Part 3 Video URL - ua-cam.com/video/sGOiZZTKc6Y/v-deo.html 🚩 Connect with me on social: - LinkedIn: www.linkedin.com/in/vipul0309/ - Twitter: jainvipul...
Power Apps Component Framework (PCF) - Part 3 - Package PCF Code Component
Переглядів 2776 місяців тому
In this video, I have explained two ways to package Power Apps Component Framework (#pcf) code component. You can either use the pac pcf push command for testing purposes or in development environment. For production, you can generate a solution.zip file and can import this file in different Dataverse environments. Part 1 Video URL - ua-cam.com/video/xmULGPDqNxs/v-deo.html Part 2 Video URL - ua...
Power Apps Component Framework (PCF) - Part 2 - Create first PCF component
Переглядів 3496 місяців тому
In this video I have explained how to create #pcf component using Power Platform CLI (I have used Field template in this video). Also, explained different file types created in the project and how you can build and debug PCF component. PCF (Part 1) URL - ua-cam.com/video/xmULGPDqNxs/v-deo.html GitHub URL - github.com/vipulj03/PCFDemo1 Visual Studio 2022 build tools - visualstudio.microsoft.com/...
Overview of Power Apps Component Framework (PCF) - Part 1
Переглядів 9696 місяців тому
Power Apps component framework empowers professional developers and app makers to create code components for model-driven and canvas apps. These code components can be used to enhance the user experience for users working with data on forms, views, dashboards, and canvas app screens. In this video, I have explained about what is Power Apps Component Framework (PCF), different types (templates),...
How to solve I can't see the environment issue in Power Platform
Переглядів 2628 місяців тому
Are your familiar with that sentence? I hear user complain that they can’t see environments, as well as admins that they can’t see user in the environments user list. If you want a user to work on an environment there are three things to consider (depending on the kind of environment, but basically it’s like this): Licensing Security groups Security roles Official documentation - learn.microsof...
OpenAI Image Generation Custom Connector for Power Platform | Power Apps & Power Automate
Переглядів 5068 місяців тому
This video showcases how to build a custom connector in Power Automate that calls the OpenAI Image Generation API endpoint to create Images Power Apps. By the end of this video, you'll have a good understanding of how to use the ChatGPT API in Power Platform via Custom Connector. Image Generation API Endpoint - platform.openai.com/docs/guides/images/introduction?context=node 🚩 Connect with me o...
Custom Connector in Power Platform | Overview | Power Apps | Power Automate
Переглядів 4,8 тис.9 місяців тому
A custom connector allows you to connect your custom APIs to the Microsoft Power Apps or Microsoft Power Automate and Azure Logic Apps. A Custom Connector is a wrapper around an API that allows communication. Custom connectors act as bridges between PowerApps and external services (APIs) or data sources. They enable you to access, retrieve, and manipulate data, expanding the capabilities of you...
Center of Excellence (CoE) Starter Kit in Power Platform | Overview
Переглядів 1,4 тис.9 місяців тому
The Microsoft Power Platform CoE Starter Kit is a collection of components and tools that are designed to help you get started with developing a strategy for adopting and supporting Microsoft Power Platform, with a focus on Power Apps, Power Automate, and Power Virtual Agents. Microsoft Power Platform CoE Starter Kit - learn.microsoft.com/en-us/power-platform/guidance/coe/starter-kit 🚩 Connect ...
Embed Power BI Report in Power Apps
Переглядів 13 тис.11 місяців тому
In this video, I have shown how you can embed a Power BI Report in Power Apps using Power BI Tile control which is available in Power Apps. Additionally, I have also shown how you can add an external filter to filter the data in Power BI Report. 🚩 Connect with me on social: - LinkedIn: www.linkedin.com/in/vipul0309/ - Twitter: jainvipulcs - Facebook: VipulJain0309 🔔 Sub...
Dataverse Development Tools with Power Platform CLI
Переглядів 440Рік тому
In this video, I have given overview of Dataverse Development Tools with Microsoft Power Platform CLI. I have explained how to install different Dataverse development tools i.e. Configuration Migration tool (CMT), Package Deployer (PD) and Plug-in Registration tool (PRT). What is Power Platform CLI - learn.microsoft.com/en-us/power-platform/developer/cli/introduction Dataverse Development Tools...
Overview of Power Platform CLI | Installation
Переглядів 823Рік тому
Overview of Power Platform CLI | Installation
Check user permission in Dataverse table before Patch | DataSourceInfo function in Power Apps
Переглядів 1,5 тис.Рік тому
Check user permission in Dataverse table before Patch | DataSourceInfo function in Power Apps
Create Reusable Components in Power Apps | Don't reinvent the wheel
Переглядів 907Рік тому
Create Reusable Components in Power Apps | Don't reinvent the wheel
New features in Power Apps | Version 3.23053.23
Переглядів 540Рік тому
New features in Power Apps | Version 3.23053.23
ChatGPT Overview | What is Prompt Engineering ?
Переглядів 80Рік тому
ChatGPT Overview | What is Prompt Engineering ?
Variable and Collection viewer in Power Apps | Variable and Collection directly in Canvas Designer
Переглядів 387Рік тому
Variable and Collection viewer in Power Apps | Variable and Collection directly in Canvas Designer
Host object in Power Apps
Переглядів 228Рік тому
Host object in Power Apps
Overview of Modern Controls in Canvas App (Power Apps)
Переглядів 386Рік тому
Overview of Modern Controls in Canvas App (Power Apps)
Microservices Roadmap for Beginners | Monolithic v/s Microservices Architecture
Переглядів 171Рік тому
Microservices Roadmap for Beginners | Monolithic v/s Microservices Architecture
How to create User Declaration / Consent Screen in Power Apps
Переглядів 622Рік тому
How to create User Declaration / Consent Screen in Power Apps
Build a professional Image Carousel / Slider in Power Apps | Gallery, Image and Timer Control
Переглядів 3,3 тис.Рік тому
Build a professional Image Carousel / Slider in Power Apps | Gallery, Image and Timer Control
Build a customizable Summary Dashboard in Power Apps | Chart Control
Переглядів 19 тис.Рік тому
Build a customizable Summary Dashboard in Power Apps | Chart Control
Stepper control (multi-step form indicators) in Power Apps | Tabbed Control
Переглядів 2,3 тис.Рік тому
Stepper control (multi-step form indicators) in Power Apps | Tabbed Control
Create Child Flows in Power Automate
Переглядів 3,9 тис.Рік тому
Create Child Flows in Power Automate
Send email via REST API in Power Automate | Different ways of sending email in Power Automate
Переглядів 1,4 тис.Рік тому
Send email via REST API in Power Automate | Different ways of sending email in Power Automate

КОМЕНТАРІ

  • @naoki1849
    @naoki1849 17 днів тому

    Very interesting, thank you

  • @user-zh8rp5xu9o
    @user-zh8rp5xu9o 22 дні тому

    Sir will you teach microservice

  • @user-bu6sj4tf7v
    @user-bu6sj4tf7v 24 дні тому

    thank you so much for this video 👌 , Chioma from Nigeria

  • @salaroenterprises
    @salaroenterprises 29 днів тому

    Very nice job.Really understood from Kenya.

  • @my-toon-city4974
    @my-toon-city4974 Місяць тому

    Wonderful- Thanks alot for detail video

  • @TopTop55-bs3bf
    @TopTop55-bs3bf Місяць тому

    Great videos! Do you have any online course? Like in udemy for instance.

  • @TopTop55-bs3bf
    @TopTop55-bs3bf Місяць тому

    I assume its possible in the opposite way too. ...To embed Power App slicers, filters, nav. menus into power bi and its visuals, data. Am i right? :) :) What I mean: Power app slicers, filters, nav menus would control the power bi Cards, Charts, Tables and navigations(swipe gesture menu). (Because power app gives modern webpage, more versatile solutions.

  • @pavankumar-cu9no
    @pavankumar-cu9no Місяць тому

    Excellent, thank you for the detailed explanation 🙂

  • @inesaoues5464
    @inesaoues5464 Місяць тому

    Hello thank you so much for this video please how can i do the same but in power portals

  • @ansl1026
    @ansl1026 2 місяці тому

    Is there a way to create a refresh button for the embedded powerbi report within PowerApps?

    • @VipulJainEducation
      @VipulJainEducation 2 місяці тому

      Embedded Power BI reports in Power Apps can't be refreshed directly. If you want to refresh the Dataset (Data) then we need to use Power Automate. In Power Automate, we have an action/step called "Refresh a dataset". And call Power Automate from PowerApps.

  • @oloruntobatemitope2229
    @oloruntobatemitope2229 2 місяці тому

    Hello Vipul i am working on a SharePoint site and spool report just like you did in the video, but i have an amount column and i want to have the total of the cost and display it on the table too is this possible?

    • @VipulJainEducation
      @VipulJainEducation 2 місяці тому

      Yes. You can calculate the total amount, save it in a column and show in the HTML table in email.

  • @pradeepjamkhandi143
    @pradeepjamkhandi143 2 місяці тому

    Hi Vipul, is it possible to create a header and footer for the pdf's which are running more than one pages?

    • @VipulJainEducation
      @VipulJainEducation 2 місяці тому

      With default PDF function, its not possible. If header & footer is required, then you need to create/generate PDF in a dynamic way using custom code and by using some third part libraries (like Muhimbi or iText7). You can also use some premium connectors in Power Automate for the same.

  • @fts800
    @fts800 2 місяці тому

    Hi, thank you for your video it's very helpful! Do I need to export my Power Automate flow to generate the specs with PowerDocu? The only option I see is the Export > Get flow identifier.

    • @VipulJainEducation
      @VipulJainEducation 2 місяці тому

      Keep your flow in a Solution and export the solution package in a zip file. Give this zip file to PowerDocu.

  • @asheerhasan5680
    @asheerhasan5680 2 місяці тому

    Thanks for making

  • @asheerhasan5680
    @asheerhasan5680 3 місяці тому

    This is awesome

  • @aducaale328
    @aducaale328 3 місяці тому

    Thank you amazing content

  • @ravijaganathan1231
    @ravijaganathan1231 3 місяці тому

    Useful content and real time scenario. Very clearly explained

  • @renukasiddaiah4702
    @renukasiddaiah4702 3 місяці тому

    Thanks , i want to create pdf for two screens can you pls wxolain me how to do for two screens

    • @VipulJainEducation
      @VipulJainEducation 3 місяці тому

      If I understand it correctly, you want to create one PDF from the data which is residing in two different screens in the Power Apps - this is not possible. Currently PDF function supports creating the PDF for a screen, container or gallery. Please check official documentation for details and limitations - learn.microsoft.com/en-us/power-platform/power-fx/reference/function-pdf Now the possible alternatives - 1. Check if you can get the data in Power BI and then generate PDF via Power BI. 2. Call a custom .NET Core based API via Custom Connector. This API wrapper will take the input (e.g. - byte array) from Power Apps and will convert into PDF. For this you might need to use some libraries in .NET (like DynaPDF, PDFClown, iText7, Muhimbi etc.) to convert / generate the PDF.

  • @shareqkhan7319
    @shareqkhan7319 3 місяці тому

    Good video

  • @iamdeepshekhar
    @iamdeepshekhar 3 місяці тому

    Thank you so much for such an informative post

  • @Soulebi03
    @Soulebi03 3 місяці тому

    why are you not getting delegation warning to your colRequestCount formula ?

  • @jray1429
    @jray1429 3 місяці тому

    Thank you for taking the time to make this video - It was informative

  • @jray1429
    @jray1429 3 місяці тому

    Great job! Thank you. Do you happen to have a video on how to link to that file to download without going to the sharepoint site? Thanks again for your work!

    • @VipulJainEducation
      @VipulJainEducation 3 місяці тому

      I don't have a video on this, thanks for this idea - I will create one and share the link. However for now let's assume the PDF file is in SharePoint Library and you want to get it downloaded in Power Apps screen. Then you can use this special URL to bypass the SharePoint document viewer and download the file. <tenantname>.sharepoint.com/sites/<site collection title>/_layouts/15/download.aspx?SourceUrl=/sites/<site collection title>/<file path with the library name>

  • @Rational1234
    @Rational1234 4 місяці тому

    Not working. Getting error code 400 .

    • @VipulJainEducation
      @VipulJainEducation 3 місяці тому

      Error 400 suggests Bad Request. Kindly check again about your endpoints.

  • @priyankagorkhe2870
    @priyankagorkhe2870 4 місяці тому

    Thank you so much❤❤

  • @santoshkumar-sj6ef
    @santoshkumar-sj6ef 4 місяці тому

    Very nicely explained.... A big thanks..

  • @imran002ali
    @imran002ali 4 місяці тому

    Hi Vipul, great video, it was easy and very informative, thank you for your knowledge sharing 👍

  • @wendymeyer1250
    @wendymeyer1250 4 місяці тому

    Thank you for this very useful video. Please can you also demo how to add files to an existing Document Set? Also, how to view what Document Sets already exist and the files which have already been uploaded?

  • @ferphioli781
    @ferphioli781 4 місяці тому

    Hello Vipul Nice and clean video and useful. I have a question about the Out put of your flow. What is the output of your flow (Table or json) and du you use it in Power Apps?

  • @EuropasOcean
    @EuropasOcean 5 місяців тому

    Thank you so much for making this useful tutorial!!

  •  5 місяців тому

    Cristal Clear. Thank you for the video. Just wondering if you have a idea to pause the carousel and timer

  • @user-yx3ld3nx5e
    @user-yx3ld3nx5e 5 місяців тому

    Hi, i tried this function with vertical gallery and container all these are working fing with expand containers but if i tried a horizontal gallery the expand containers are not working and it is not scrollable horizontable. Is that a bug or we have any other ways?

    • @VipulJainEducation
      @VipulJainEducation 5 місяців тому

      It could be a known limitation as horizontal gallery can be treated as nested gallery and these are not supported. You can proceed with vertical gallery. FYI - The ExpandContainers statement is only for expanding a container or gallery, not text or other controls.

  • @henriquedelafonte283
    @henriquedelafonte283 6 місяців тому

    great video, thanks for sharing!

  • @ravijaganathan1231
    @ravijaganathan1231 6 місяців тому

    @vipul Very useful and informative session 🎉

  • @aiasker1
    @aiasker1 6 місяців тому

    This was a great explanation. Now I understand how child flows work. After watching many videos, yours made the most sense. Thank you!

  • @laurynedwards2483
    @laurynedwards2483 6 місяців тому

    Hello! This is a great video, but I'm wondering how I'm meant to connect the second collection? Also, where do I connect the status so that the app knows what step I'm on? Also, do I need to create a patch somewhere? Also, I'm confused on how the continue button works. Thank you!

  • @travelkare
    @travelkare 6 місяців тому

    Thanks! Can we embed power apps into power bi ?

    • @VipulJainEducation
      @VipulJainEducation 6 місяців тому

      Yes, we can embed a Power Apps visual in Power BI Report. Refer this official documentation - learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-powerapp

    • @travelkare
      @travelkare 6 місяців тому

      Thank you, It worked @@VipulJainEducation

  • @kamalakarreddyuppala3772
    @kamalakarreddyuppala3772 6 місяців тому

    can you explain function apps .web apps .hosted apps in sharepoint $ power apps

  • @devaraprudviraj5896
    @devaraprudviraj5896 6 місяців тому

    what to do if there is a timeout error while calling external api? any suggestion please let me know.

    • @VipulJainEducation
      @VipulJainEducation 6 місяців тому

      1) Please set some time out at API level (E.g. - IIS) and check the condition in Power Automate. 2) In Power Automate settings, you can check for time out also.

  • @obsoquasi
    @obsoquasi 7 місяців тому

    An important fact about child flows is, that the flow actually continues running after the "Respond to a PowerApp or flow" action, which can pose a problem. So it may be good practise to add a Terminate (success) after the respond action if it's somewhere in the middle of the flow. Because although from the parent's view the flow is finished with the respond action, if the child flow continues running, it may cause some problems. At the end of the flow, of course, you don't need a terminate (success) action - it's implicitly terminating with success anyway at the bottom.

    • @obsoquasi
      @obsoquasi 7 місяців тому

      this can be used for example to catch a failed action in the child flow and pass a status message to the parent. And the parent can then react accordingly to the status message.

  • @subodhbaid8619
    @subodhbaid8619 7 місяців тому

    Hi Vipul, very useful - have been looking for this for a while. Thanks. What are the restrictions in setting up flows in a solution. I am unable to replicate your example exactly as within the solution the user name and user email are not me! (U3Vic2RoIEJhaWQ=, U0JBSURBQVZJVkFHUk9VUC5DT00=). What's going on here?

    • @VipulJainEducation
      @VipulJainEducation 7 місяців тому

      Hi. In this video, I tried to explain about Child Flows in Power Automate. For more details, you can refer - powerautomate.microsoft.com/en-us/blog/helpful-tips-for-using-child-flows/

  • @ShubhamGupta-zd3hy
    @ShubhamGupta-zd3hy 7 місяців тому

    Hi Vipul just want to ask you one thing here. Suppose I have three boxes states , county and city . In that I have all the states of USA. But as there are more than 2000 records I cannot see all the states. Can you help me out?

    • @VipulJainEducation
      @VipulJainEducation 7 місяців тому

      This is because of the hard limit wherein PowerApps can only retrieve 2000 records from a datasource in a single query. You could consider using the Collect() function to store all the items in a collection. Then display the collection within the Drop-Down.

  • @sumeetshome
    @sumeetshome 7 місяців тому

    Hi Vipul, thanks for sharing the vide. Ask in PowerApps is not visible to me inside Compose. Do you know why?

    • @VipulJainEducation
      @VipulJainEducation 7 місяців тому

      I assume your flow has Power Apps V2 trigger. "Ask in PowerApps" should be visible as Dynamic Content. Please take a try to clean the cache of Browser and re-create the flow again to check if the issue still exists.

  • @Pobrenascryptos
    @Pobrenascryptos 7 місяців тому

    Do you have any video show how to set the permissions, I’m try to share a app and this error appears, I tried to give permission to the user to access dataverse and I don’t know if I’m doing right

    • @VipulJainEducation
      @VipulJainEducation 7 місяців тому

      Not sure about your specific requirement. However would recommend you to go through this video - ua-cam.com/video/0JwmC8S2g2w/v-deo.html

  • @rajathmk
    @rajathmk 7 місяців тому

    Does this requiring pro license for users who would be accessing the app?

    • @VipulJainEducation
      @VipulJainEducation 7 місяців тому

      To view the report in Power Apps which is developed in Power BI, the users should also have access on Power BI Workspace. I have also created a video to develop directly Summary Dashboard kind of functionality in Power Apps (without Power BI). I highly recommend you to watch that video - ua-cam.com/video/-SeepZcPoE4/v-deo.html

    • @prasannadubey9516
      @prasannadubey9516 6 місяців тому

      You need corporate emails id

  • @mohitmishra962
    @mohitmishra962 8 місяців тому

    Thanks for explanation. Nicely done. Just a query, can we have dataveese canvas app in German only language?

    • @VipulJainEducation
      @VipulJainEducation 8 місяців тому

      Yes, definitely. You can set the default browser language as German.

    • @mohitmishra962
      @mohitmishra962 8 місяців тому

      @@VipulJainEducation But the app development will only be in English or that can be in German for developers ?

  • @arunn87
    @arunn87 8 місяців тому

    Thanks for the Video 👏👏, One doubt brother, May I know if this scenario works in the Sharepoint integrated power app, i tried but in DocumentsetName, the Dynamic value (Asktopowerapp) is not populating. A response concerning my question is much appreciated.🤝

    • @VipulJainEducation
      @VipulJainEducation 8 місяців тому

      Yes it should work! I also tried with SharePoint Online as data source.

    • @arunn87
      @arunn87 8 місяців тому

      @@VipulJainEducation ThankYou , Its worked 👍👍

  • @ericbeaudin3741
    @ericbeaudin3741 8 місяців тому

    Hello Sir, thank you for those video ..very instructive :) ..At 22:17 , instead of name "test.pdf" , I want to save it as item title , who do we do it ?

    • @VipulJainEducation
      @VipulJainEducation 8 місяців тому

      You can save it in a textbox and take the value from it.

  • @harsh.mscrm991
    @harsh.mscrm991 8 місяців тому

    very informative (y)

  • @iyengar007
    @iyengar007 9 місяців тому

    Thanks Vipul Jain. New learning... could you please keep sharing your expertise on these snippets and some use case we can use