Michael Alex
Michael Alex
  • 131
  • 2 145 874
How to Generate Multiple Records in Power Apps with ForAll & Sequence
How to Generate Multiple Records in Power Apps with ForAll & Sequence
Learn how to quickly and efficiently generate multiple records in Power Apps using the ForAll and Sequence functions. In this step-by-step tutorial, I’ll show you how to create duplicate records based on a user-specified input value. Whether you're building dynamic apps or automating data entry, this method will save you time and effort!
📌 What You'll Learn:
How the ForAll function works in Power Apps
Using the Sequence function to create a numeric range
Combining these functions to generate multiple records dynamically
🚀 Perfect for beginners and advanced Power Apps developers alike!
💬 Questions or Feedback? Drop a comment below-I’d love to help!
👍 Don’t forget to Like, Subscribe, and hit the 🔔 notification bell for more Power Apps and SharePoint tutorials.
#PowerApps #ForAll #SequenceFunction #PowerPlatform #Microsoft365
Переглядів: 350

Відео

How to Archive SharePoint List Data Using Power Automate | Step-by-Step Guide
Переглядів 694Місяць тому
🌟 How to Archive SharePoint List Data Using Power Automate 🌟 In this video, I’ll guide you step-by-step on how to create a data archive for your SharePoint list using Power Automate! Learn how to set up automated workflows to back up your data efficiently, ensuring that your list stays organized and your critical information is stored safely for future reference. 📌 What You’ll Learn: Why archiv...
How to Update & Add Rows in SharePoint From Excel Using Power Automate | Step-by-Step Guide
Переглядів 3,7 тис.Місяць тому
Are you looking to automate your SharePoint list management with Power Automate? 📊✨ In this tutorial, I'll show you how to update existing rows and add new rows to a prepopulated SharePoint list automatically! 🚀 In this step-by-step guide, you'll learn how to set up a Power Automate flow to efficiently handle your SharePoint data, ensuring that your lists are always up to date. Whether you're w...
How to Add or Remove Records from a Collection in Power Apps | 2024 Tutorial
Переглядів 6432 місяці тому
In this step-by-step tutorial, you'll learn how to easily add or remove records from a collection in Power Apps, a vital skill for managing data within your apps. Whether you're building a form, creating a shopping cart, or tracking user inputs, understanding how to manipulate collections is key to improving your app's functionality and user experience. 💡 What You’ll Learn: Adding Records: Lear...
How to Apply Unique Permissions to a Folder or File in SharePoint | 2024 Tutorial
Переглядів 6964 місяці тому
🔐 Take Control of Your SharePoint Security! In this tutorial, we'll show you how to apply unique permissions to folders and files in SharePoint, giving you the power to control who can access specific content within your organization. 🌟 What You’ll Learn: Step-by-Step Instructions: Follow our easy guide to applying unique permissions to any folder or file in SharePoint. Customizing Access: Lear...
How to Patch Any Column Type Effortlessly in Power Apps | 2024 Tutorial
Переглядів 9035 місяців тому
In this in-depth tutorial, we'll guide you through the process of patching different column types in Power Apps, making it easy to update your data seamlessly. Whether you're working with text, numbers, dates, choice fields, or complex data types, we've got you covered! 🔧 Comprehensive Guide: Learn how to handle various column types in Power Apps with confidence. We'll break down the patching p...
How to Identify If an Item was Created or Modified in Power Automate | 2024 Tutorial
Переглядів 2,5 тис.5 місяців тому
In this detailed tutorial, we'll walk you through the steps to identify if an item was created or modified in Power Automate, helping you streamline your workflows and improve your automation processes. 🔄 Master Power Automate: Learn how to leverage the capabilities of Power Automate to detect and differentiate between newly created items and modified items in your workflows. 📊 Enhance Workflow...
How to Allow Users to Edit Their Submitted Microsoft Forms | 2024 Tutorial
Переглядів 2,1 тис.7 місяців тому
Hi Everyone, Unlock the full potential of Microsoft Forms by enabling users to edit their submissions even after they've been submitted! In this step-by-step tutorial, we’ll show you how to set up and configure your forms so that respondents can easily make changes to their answers. 🔧 Step-by-Step Guide: Follow our clear, detailed instructions to enable editing for submitted forms, making the p...
How to Quickly Upload Excel Data to a SharePoint List Using Power Apps
Переглядів 7 тис.8 місяців тому
Hi Everyone, In this tutorial, I'll show you how to streamline your data management workflow by leveraging the power of Microsoft Power Apps to swiftly upload Excel data to a SharePoint list. 🚀 Simplify Data Migration: Say goodbye to manual data entry and tedious copy-pasting! Learn how to automate the process of transferring data from Excel spreadsheets to SharePoint lists with just a few clic...
How to Combine Two SharePoint Lists into a Collection Using an ID | Power Apps | 2024 Tutorial
Переглядів 14 тис.8 місяців тому
Hi Everyone, 🔗 Unleash Data Fusion: Learn How to Combine Two SharePoint Lists into a Collection Using an ID in Power Apps! 🔗 In this comprehensive tutorial, you'll discover the powerful capabilities of Power Apps as we delve into the process of combining two SharePoint lists into a unified collection using a shared ID. By harnessing this technique, you'll unlock new possibilities for data integ...
How to Use a ComboBox With Over 500 Items in Power Apps | 2024 Tutorial
Переглядів 3,3 тис.8 місяців тому
Hi Everyone, 🚀 Unlock Power Apps Mastery: Mastering ComboBoxes with 500 Items for Seamless Efficiency! 🚀 In this comprehensive tutorial, you'll learn invaluable tips and tricks for effectively working with ComboBoxes containing over 500 items in Power Apps. Managing large datasets within Power Apps can be challenging, but with the techniques shared in this video, you'll streamline your workflow...
How to Automate Email Alerts for Deleted List Items with Power Automate! 2024 Tutorial
Переглядів 6768 місяців тому
Hi Everyone, 📧 Streamline Your Workflow: Learn How to Automatically Send an Email When a SharePoint List Item is Deleted Using Power Automate! 📧 In this comprehensive tutorial, you'll discover how to enhance your workflow automation by configuring Power Automate to automatically send an email notification when a SharePoint list item is deleted. By leveraging this powerful functionality, you'll ...
How to Store a New SharePoint Item ID in a Variable in PowerApps | 2024 Tutorial
Переглядів 1,4 тис.8 місяців тому
Hi Everyone, Formula: Set( varNewContractorID, Patch( 'Contractor List', Defaults('Contractor List'), { 'First Name': input_first_name.Text, 'Last Name': input_last_name.Text } ).ID ); If( !IsBlank(cmb_job_site.Selected), Patch( 'Master Contactor Site', Defaults('Master Contactor Site'), { Contractor: { Id: varNewContractorID, Value: varNewContractorID }, 'Job Site': { Id: LookUp( 'Job Sites', ...
How to Patch a Lookup Column in PowerApps | 2024 Tutorial
Переглядів 10 тис.8 місяців тому
Hi Everyone, 🔍 Learn How to Patch a Lookup Column in PowerApps! 🔍 In this detailed tutorial, you'll discover how to effectively patch a lookup column in PowerApps, unlocking new capabilities for data management and app development. Lookup columns are powerful tools for creating relationships between different data sources, and learning how to patch them is essential for building dynamic and int...
How to Create Dynamic Colors for Buttons Based on Text in Power Apps | Switch() | 2024 Tutorial
Переглядів 1,4 тис.9 місяців тому
Hi Everyone, Switch Function Documentation: learn.microsoft.com/en-us/power-platform/power-fx/reference/function-if Color Documentation: learn.microsoft.com/en-us/power-platform/power-fx/reference/function-colors 🎨 Unlock the Power of Dynamic Color: Learn How to Create Dynamic Button Colors Based on Text in Power Apps! 🎨 In this comprehensive tutorial, you'll discover how to elevate your Power ...
How to Send Automated Past Due Date Emails Using Power Automate | DateDifference() | 2024 Tutorial
Переглядів 13 тис.9 місяців тому
How to Send Automated Past Due Date Emails Using Power Automate | DateDifference() | 2024 Tutorial
How to Send a Collection of Data from PowerApps to Power Automate | PowerApps (V2) | 2024 Tutorial
Переглядів 13 тис.9 місяців тому
How to Send a Collection of Data from PowerApps to Power Automate | PowerApps (V2) | 2024 Tutorial
How to Create a Chat System in Your PowerApp | 2024 Tutorial
Переглядів 11 тис.9 місяців тому
How to Create a Chat System in Your PowerApp | 2024 Tutorial
How to Create a Simple Admin List for Your PowerApp Using a SharePoint List | 2024 Tutorial
Переглядів 1,9 тис.9 місяців тому
How to Create a Simple Admin List for Your PowerApp Using a SharePoint List | 2024 Tutorial
How to Safely Remove Records from a SharePoint List Using PowerApps | 2024 Tutorial
Переглядів 3,3 тис.10 місяців тому
How to Safely Remove Records from a SharePoint List Using PowerApps | 2024 Tutorial
How to Track Changes to SharePoint List Items | 2024 Tutorial
Переглядів 8 тис.10 місяців тому
How to Track Changes to SharePoint List Items | 2024 Tutorial
How to Change the Output of Yes/No Column Type in CSV Reports Using Power Automate
Переглядів 66410 місяців тому
How to Change the Output of Yes/No Column Type in CSV Reports Using Power Automate
How to Switch to the Classic Designer in Power Automate | 2023 Tutorial
Переглядів 3 тис.Рік тому
How to Switch to the Classic Designer in Power Automate | 2023 Tutorial
Easy Way to Center Anything Perfectly in PowerApps | 2023 Tutorial
Переглядів 6 тис.Рік тому
Easy Way to Center Anything Perfectly in PowerApps | 2023 Tutorial
How to Concatenate a Person Column Email String in Power Automate | 2023 Tutorial
Переглядів 6 тис.Рік тому
How to Concatenate a Person Column Email String in Power Automate | 2023 Tutorial
How to View Large Collections of Data Easily in PowerApps | 2023 Tutorial
Переглядів 9 тис.Рік тому
How to View Large Collections of Data Easily in PowerApps | 2023 Tutorial
How to Add Gallery Headers to Your Power App | 2023 Tutorial
Переглядів 8 тис.Рік тому
How to Add Gallery Headers to Your Power App | 2023 Tutorial
How to Send an Email Using Power Apps and Power Automate | 2023 Tutorial
Переглядів 63 тис.Рік тому
How to Send an Email Using Power Apps and Power Automate | 2023 Tutorial
How to Create a Drop Down Menu in Power Apps | 2023 Tutorial
Переглядів 41 тис.Рік тому
How to Create a Drop Down Menu in Power Apps | 2023 Tutorial
How to Send a Microsoft Form Approval to a Manager Using Power Automate | 2023 Tutorial
Переглядів 83 тис.Рік тому
How to Send a Microsoft Form Approval to a Manager Using Power Automate | 2023 Tutorial

КОМЕНТАРІ

  • @AmelieCyr-j1e
    @AmelieCyr-j1e День тому

    Very nice and helpful. I have a question. Are we able to get the response details in English as well as in French in the same email? I was able to create English version in the Body section and added required fields (they appears only in English). However, I added French version under the English one, but when adding the fields, the response details are provided in English in the French version despite the form is completed in French or in English.

  • @RobsS100
    @RobsS100 День тому

    Amazing dude, just what I needed. Never touched powerapps before and you made this really easy

  • @tecnicoscasur
    @tecnicoscasur 4 дні тому

    Hi michael, How I can to set value in Blank, i was try it but i can´t . Can you help me, I´m from Nicaragua

  • @taraklein5080
    @taraklein5080 4 дні тому

    In my filter array I'm pulling in my unique identifier field - for me it is "details", but when I hoover over it after I've selected it, it says "items()?['Field_3']" instead of ['Details'] - when I try to write this it keeps pulling the field from my excel instead of my SharePoint site. I'm wondering if this is my problem?

  • @SathyaPriya-g9w
    @SathyaPriya-g9w 5 днів тому

    Please tell me how to patch the attachment field

  • @jacquelinewilliams7654
    @jacquelinewilliams7654 5 днів тому

    This was so clear, concise and helpful! Thanks so much!

  • @marzaj17
    @marzaj17 5 днів тому

    Thanks for the demo!

  • @SlickStreams
    @SlickStreams 7 днів тому

    use the first display port in the graphics card. Only thing that worked for me. I have a 4060 with these problems. I can only assume the last display port is for older model monitors with 1.2 or 1.1 settings. First computer i had that did this by the way. Any others i could all ports no problem

  • @vinodadepu8171
    @vinodadepu8171 7 днів тому

    I have 40000 rows in my List and when i'm trying to add rows from excel to Sharepoint list Get action only reading at a time 1000 records. Do you have any solution for it

  • @MoonShine-bs6cl
    @MoonShine-bs6cl 8 днів тому

    While using update a row, I want to use email ids available in excel and it should dynamically match with the form responders email adress and then update the form responses in excel how do I do that. Pls help it would be great

  • @eppnator
    @eppnator 9 днів тому

    Thank you! This also got me up and running again... I was starting to get pretty frustrated.

  • @clairevoyance26
    @clairevoyance26 11 днів тому

    Hi michael, how do you patch the lookup column if its a combo box instead of a dropdown? I noticed that SubmitForm doesnt work in patching a look up column as well.

  • @jijindaniel8138
    @jijindaniel8138 12 днів тому

    What about a due date or timeline?

  • @duyanhnguyen9640
    @duyanhnguyen9640 12 днів тому

    that's help, tks alot mate

  • @Alif-b8g
    @Alif-b8g 13 днів тому

    Thanks for the great video. How to remove with filter and using select All check box ? Trims

  • @Alif-b8g
    @Alif-b8g 13 днів тому

    Great Video. How to remove with filter criteria and using select All ( after filter )...trims

  • @dipakap
    @dipakap 18 днів тому

    Worked for me. Thanks.

  • @mattnorthrip
    @mattnorthrip 19 днів тому

    Hi Michael. How would you deal with Null values in your date rented column?

  • @robpawlikowski4020
    @robpawlikowski4020 22 дні тому

    This was excellent! One question - how would you handle columns with Date-Time values?

  • @chuaricky3465
    @chuaricky3465 22 дні тому

    Hi Michael, Thank you so much for this. However, i have an email with signatures and it is also getting the images and storing into the SharePoint site. Is there a workaround for this?

  • @coffmancollection
    @coffmancollection 22 дні тому

    Great technique, thanks for sharing!

  • @AsrarMehraj-g5r
    @AsrarMehraj-g5r 22 дні тому

    can you create a VIEW in SharePoint that combines data from three or more LISTS, like sql server table joins

    • @michaelalex2322
      @michaelalex2322 22 дні тому

      @@AsrarMehraj-g5r not that I'm aware of. your best bet is making an export in power automate to excel

  • @darynnguyen9825
    @darynnguyen9825 24 дні тому

    Works with reference 6800xt in Dec 2024.

  • @ur1el554
    @ur1el554 27 днів тому

    windows key + p saved me thank you sir

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

    Oh my gosh! Thank you so much! I've searched everywhere for something like this! I have a form that branches off with different answers and I couldn't find anything that did what this does. Maybe add #branching to the description or something on here so other people know because this seriously is a question I found several times, but nobody had an answer. Thank you again!!

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

    Thanks so much! I was struggling with updating choice fields with Power Automate. You may get more views by noting that this can help ppl using Choice fields.😊 if you can figure out something for updating calculated fields and/or managed metadata, I'd appreciate that too.

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

    Hello, @Michael Alex, thanks for sharing. I would really appreciated if you could advise us how to send sharepoint images using power automate to an Gmail account. I tried but Gmail is not showing the image because it seems it wont work with base64. Thanks in advance...

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

    Dude. Thanks!!!! Saved myself so much time. I was pulling my hair out there for a second.

  • @HollyWhite-g7t
    @HollyWhite-g7t Місяць тому

    Hi, thanks for the easy step by step video, but I keep getting failed flows at the apply to each and then the condition? Could you help please? Thanks

    • @taraklein5080
      @taraklein5080 5 днів тому

      I'm having the same issue. I'm failing after "get items" on the first apply to each.

    • @josecarlosbenitezmeyer645
      @josecarlosbenitezmeyer645 19 годин тому

      I'm having the same issue, did you solved ?

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

    Thanks, I couldn't figure out what to do with a number field.

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

    my gallery keeps blanking out data as i scroll through the gallery

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

    Been struggling with this forever. Making scheduled flows based on calculated columns just wont work. I will try your way. Is there an updated version of this. Would love to see it. I have a calculated column that is just a date dd/mm/yyyy and i want to send reminders 20 days before that calculated date. I havent got it to work. The flow actually tried to run and has no sent me over 1000 emails and then 1000 failed reminder emails . A nightmare

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

    thank you

  • @ALACRITYSERVICES-l6z
    @ALACRITYSERVICES-l6z Місяць тому

    I noticed your Title field is not required. This is required under Update item in my flow. What should you select for Title?

  • @MoonShine-bs6cl
    @MoonShine-bs6cl Місяць тому

    Hi I don't have azure so how do I group up the list and get the managers name. Pls help or would be helpful if you create a new video on this please and I need approvals from different managers employees are assigned to.

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

    wow that worked thanks. and same here woke up and it did not work.

  • @emmaventrice-v3n
    @emmaventrice-v3n Місяць тому

    Fire🔥🔥🔥🔥

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

    Thank you for this great content

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

    If I have a Master Copy of a project list created in Lists, can I Export to Power Bi, then create a copy of this master copy for a different project checklist using Power Bi? Would I then add the Sharepoint link to the new copy to select my new list?

  • @SandyZhao-Sunshine
    @SandyZhao-Sunshine Місяць тому

    Thanks, Michael, That's really what I want. May I have a question, we both know that the collection does not support delegation. Can I directly use the AddColumns instead of using the ClearCollect. I tried but failed. Do I miss something?

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

    RX 6950XT Reference version working

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

    excelente

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

    Super helpful!

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

    thank you for the video. now still 500 item showing in the selection area. is it possible to have all items (over 500) displaying in the combo box? so customer want to find a name with Z, could drag down the scroll and find them in the bottom.

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

    Hello Micheal... while I opened my shared list link, the share point opened instead could you support

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

    This is great. Thanks!

  • @Gaminghf-v3d
    @Gaminghf-v3d Місяць тому

    Hi, how to add the calendar on the front page in sharepoint

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

    Why ist the "unique identifier of item to be updated" in the "apply to each 1" not item()?[WorkerID] ? Isnt die WorkerID the identifier in both excel and SP list? The ID u chose only exist in SP List and not in your excel? thx ;)

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

    Hello, nice video👍, does it work the same for when a file is created or modified ?

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

    THANK YOU FOR THIS