- 131
- 2 145 874
Michael Alex
Приєднався 5 січ 2022
Professional Power Platform user making tutorials to help others learn and troubleshoot!
✨Support My Channel✨
If you enjoy my content and would like to support my work, consider buying me a coffee! Your support helps me create more videos and keep the channel going. ☕💖
buymeacoffee.com/michaelalex
🪙BTC🪙: 3LpmcBaJB537RweJu2tRjSqT6NhnQDDBWy
⛓️ETH⛓️: 0xbAEb6d6Df7CE5cfC55797B3133342e165B78A444
🐕DOGE🐕: DNKNUduorzBWMJ4XTSRqUSsUKk3ZiehHin
Business Contacts: michaelalexsolutions@gmail.com
✨Support My Channel✨
If you enjoy my content and would like to support my work, consider buying me a coffee! Your support helps me create more videos and keep the channel going. ☕💖
buymeacoffee.com/michaelalex
🪙BTC🪙: 3LpmcBaJB537RweJu2tRjSqT6NhnQDDBWy
⛓️ETH⛓️: 0xbAEb6d6Df7CE5cfC55797B3133342e165B78A444
🐕DOGE🐕: DNKNUduorzBWMJ4XTSRqUSsUKk3ZiehHin
Business Contacts: michaelalexsolutions@gmail.com
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
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
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.
Amazing dude, just what I needed. Never touched powerapps before and you made this really easy
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
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?
Please tell me how to patch the attachment field
This was so clear, concise and helpful! Thanks so much!
Thanks for the demo!
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
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
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
Thank you! This also got me up and running again... I was starting to get pretty frustrated.
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.
What about a due date or timeline?
that's help, tks alot mate
Thanks for the great video. How to remove with filter and using select All check box ? Trims
Great Video. How to remove with filter criteria and using select All ( after filter )...trims
Worked for me. Thanks.
Hi Michael. How would you deal with Null values in your date rented column?
This was excellent! One question - how would you handle columns with Date-Time values?
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?
Great technique, thanks for sharing!
can you create a VIEW in SharePoint that combines data from three or more LISTS, like sql server table joins
@@AsrarMehraj-g5r not that I'm aware of. your best bet is making an export in power automate to excel
Works with reference 6800xt in Dec 2024.
windows key + p saved me thank you sir
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!!
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.
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...
Dude. Thanks!!!! Saved myself so much time. I was pulling my hair out there for a second.
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
I'm having the same issue. I'm failing after "get items" on the first apply to each.
I'm having the same issue, did you solved ?
Thanks, I couldn't figure out what to do with a number field.
my gallery keeps blanking out data as i scroll through the gallery
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
thank you
I noticed your Title field is not required. This is required under Update item in my flow. What should you select for Title?
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.
wow that worked thanks. and same here woke up and it did not work.
Fire🔥🔥🔥🔥
Thank you for this great content
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?
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?
RX 6950XT Reference version working
excelente
Super helpful!
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.
Hello Micheal... while I opened my shared list link, the share point opened instead could you support
This is great. Thanks!
You're welcome!
Hi, how to add the calendar on the front page in sharepoint
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 ;)
Hello, nice video👍, does it work the same for when a file is created or modified ?
THANK YOU FOR THIS