- 128
- 1 969 833
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 Add or Remove Records from a Collection in Power Apps | 2024 Tutorial
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: Learn how to dynamically add new items to your Power Apps collection with just a few clicks.
Removing Records: Master the process of deleting records from a collection based on specific conditions or user input.
Practical Examples: We'll showcase real-world examples to help you understand when and how to modify collections effectively in your apps.
Tips for Optimization: Discover best practices to manage collections efficiently and improve app performance.
🚀 Boost Your Power Apps Skills: Whether you're new to Power Apps or looking to refine your skills, this tutorial will provide you with everything you need to confidently manage collections in your apps.
Don’t forget to like, share, and subscribe for more Power Apps tutorials and Microsoft Power Platform tips. Empower your app development journey with us! 🌟📲💼
💡 What You’ll Learn:
Adding Records: Learn how to dynamically add new items to your Power Apps collection with just a few clicks.
Removing Records: Master the process of deleting records from a collection based on specific conditions or user input.
Practical Examples: We'll showcase real-world examples to help you understand when and how to modify collections effectively in your apps.
Tips for Optimization: Discover best practices to manage collections efficiently and improve app performance.
🚀 Boost Your Power Apps Skills: Whether you're new to Power Apps or looking to refine your skills, this tutorial will provide you with everything you need to confidently manage collections in your apps.
Don’t forget to like, share, and subscribe for more Power Apps tutorials and Microsoft Power Platform tips. Empower your app development journey with us! 🌟📲💼
Переглядів: 184
Відео
How to Apply Unique Permissions to a Folder or File in SharePoint | 2024 Tutorial
Переглядів 3572 місяці тому
🔐 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
Переглядів 5303 місяці тому
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
Переглядів 1,5 тис.3 місяці тому
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
Переглядів 1,3 тис.5 місяців тому
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
Переглядів 6 тис.6 місяців тому
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
Переглядів 11 тис.6 місяців тому
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
Переглядів 2,5 тис.6 місяців тому
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
Переглядів 4936 місяців тому
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,2 тис.6 місяців тому
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
Переглядів 8 тис.6 місяців тому
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,1 тис.6 місяців тому
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
Переглядів 10 тис.6 місяців тому
Hi Everyone, Formula: if(equals(outputs('CurrentDate'),outputs('DateRented')),0,int(split(dateDifference(outputs('DateRented'),outputs('CurrentDate')),'.')[0])) 📧 Automate Your Workflow: Learn How to Send Past Due Date Emails Using Power Automate! 📧 In this comprehensive tutorial, you'll discover how to streamline your workflow and enhance productivity by automating past due date emails using P...
How to Send a Collection of Data from PowerApps to Power Automate | PowerApps (V2) | 2024 Tutorial
Переглядів 11 тис.7 місяців тому
Hi Everyone, 🚀 Learn How to Send a Collection of Data from PowerApps to Power Automate! 🚀 In this in-depth tutorial, you'll discover how to seamlessly transfer a collection of data from PowerApps to Power Automate (also known as Microsoft Flow). Harnessing the power of these two Microsoft platforms, you'll unlock new possibilities for automating processes and streamlining workflows. 💡 What You'...
How to Create a Chat System in Your PowerApp | 2024 Tutorial
Переглядів 9 тис.7 місяців тому
Hi Everyone, 🚀 Learn How to Create a Chat System in Your PowerApp! 🚀 Are you ready to revolutionize your PowerApps with a fully functional chat system? In this comprehensive tutorial, you'll discover how to build a dynamic chat feature from scratch within your PowerApp. 💬 What You'll Learn: Setting Up Your Data Source: First, we'll explore how to set up a data source to store chat messages. Whe...
How to Create a Simple Admin List for Your PowerApp Using a SharePoint List | 2024 Tutorial
Переглядів 1,7 тис.7 місяців тому
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
Переглядів 2,7 тис.8 місяців тому
How to Safely Remove Records from a SharePoint List Using PowerApps | 2024 Tutorial
How to Track Changes to SharePoint List Items | 2024 Tutorial
Переглядів 7 тис.8 місяців тому
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
Переглядів 5818 місяців тому
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
Переглядів 2,6 тис.10 місяців тому
How to Switch to the Classic Designer in Power Automate | 2023 Tutorial
Easy Way to Center Anything Perfectly in PowerApps | 2023 Tutorial
Переглядів 4,7 тис.11 місяців тому
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
Переглядів 8 тис.Рік тому
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
Переглядів 59 тис.Рік тому
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
Переглядів 38 тис.Рік тому
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
Переглядів 75 тис.Рік тому
How to Send a Microsoft Form Approval to a Manager Using Power Automate | 2023 Tutorial
How to Use the Switch Action in Power Automate | Microsoft Form Submission | 2023 Tutorial
Переглядів 13 тис.Рік тому
How to Use the Switch Action in Power Automate | Microsoft Form Submission | 2023 Tutorial
How To Setup and Use a Flexible Gallery in PowerApps | 2023 Tutorial
Переглядів 5 тис.Рік тому
How To Setup and Use a Flexible Gallery in PowerApps | 2023 Tutorial
How to Upload Images, Video, and Audio to Your PowerApp | 2023 Tutorial
Переглядів 10 тис.Рік тому
How to Upload Images, Video, and Audio to Your PowerApp | 2023 Tutorial
Thanks Bro
I follow step by step but didn't found birthdayImage in parseJSON in my case, what is the missing point in this video
This shit was driving me crazy - thank youuuuuuu
After select, I used "Join" instead of "Compose", just put ";" in "Join on" field it's all.
It works like a charm!!!
THANK YOU!!! I've been struggling with how to patch my SP list ALL DAY!!!
Thank you Michael. Is it possible to implement this into a form that was built prior to this feature being released?
I dare not describe the gymnastics I have been trying to do in order to accomplish this thing that you made so simple. I just KNEW there was an easy way to do it. But, my google-fu failed me until I remembered SQL and used the word "Join." Thank you SO much for making this video!
@@onesoldierserving lol glad it helped!
My man, I follow a lot of people who do explainer videos for powerapps but I feel like I always find the most realiable, simple and easy way to my problems with you. Thank you and Keep up the good work!
@@Bit_surfer Try to make it easy to understand lol. Thank you!
wow thank you so much!!!
In my excel 40 columns, 3725 rows doesnt work... "body": { "status": 400, "message": "The argument is invalid or missing or has an incorrect format. clientRequestId: 79ad0d76-d15a-46339-89f4-2f634123312b4 serviceRequestId: 274dc3c3-d06d-44a6-a50c-5528ba8d82da;26c217bb6-5e68-4226-bc62-f3144a0dcfb1", "error": { "message": "The argument is invalid or missing or has an incorrect format." }, "source": "excelonline-cus.azconn-cus-001.p.azurewebsites.net" }
my days show -days over postive days
you are to fast in explanation
Buen vídeo! cheers from Perú :)
Thank you!
when I get to the "create item" step after "get manager" there are no approval options under parameters. What did I do wrong?
Thanks for the great video ! Can i use CSV table to send adaptive card on teams ?
Super helpful. I watched so many other videos and yours explained the steps so well. Appreciate your efforts!!
Glad it was helpful!
Thanks for the turorial, and its work, but newly i got the error running flow because Flow Run Failure: One or more fields provided is of type 'Null' in Get File Contents Can you help
Hello, I am receiving the same error as of Tuesday morning. I narrowed it down to the Output of the Send HTTP Request no longer including the serverRelativeUrl. I'm hoping the Michael has a fix. I will update here if I figure it out before he responds. Edit: I replied with the way I fixed my issue but it appears UA-cam deleted it. Here it is again. I changed Send HTTP Request to: _api/lists/getbyid('YOUR-SHAREPOINT-LIST-ID-NOT-SITE-BUT-NUMBERS')/items(@{triggerOutputs()?['body/ID']})/AttachmentFiles parse that, pull the ServerRelativeUrl from the parse, add in your sharepoint site to the parsed ServerRelativeUrl, [i did it through compose - concat('MY-SHAREPOINT-SITE.sharepoint.com', outputs('Compose_2')) ] then run that through Get file content using path, replace(replace(join(outputs('Compose_3'), ''), '["', ''), '"]', '') then <img src="data:image/png;base64,@{base64(outputs('Get_file_content_using_path')?['body'])}" /> That should do it. I am sure @michaelalex2322 has a better solution, but that works for me for now.
@@bpalenscar that was cool, i just fojnd the root cause it is because we check the enabled attachment is list setting, if we not check or disabled ot, the serverrelativeurl is back
This video is exactly what I needed. Thank you, Michael.
You're very welcome
This is the only sane and functional description of how to use PowerApps+Sharepoint Lists that I've ever seen. You basically saved my life with this one concise video.
Happy to hear lol
How if Attachment file name same?
Very helpful! Thanks for sharing this.
You bet!
Thank you very much
No worries
Your solution is not good because if you create an item and 1 second after you modify the same item, the flow will trigger only once and the version witll be "2" and so you will never get the creation e-mail.... The good solution is to use the "Since Version Number" and "Until Version Number" of the action "Get changes for an item or a file (properties only)".
I have a sharepoint list and an empty power apps canvas with 2 screens for the moment, I want to make with first screen to make add, delete and updates options (using buttons) , another screen to make only queries. are there any examples where I can guide myself? thanks in advance.
Perfect 👌 totally loved this, great work, defo gonna view more of your content...I'll subscribe too!
Thank you 🙌
Does this allow group members to view and edit the entries of other members in the group? I.e., row-wise security for groups?
Thanks for the video. Currently in SharePoint when someone makes a comment in a List (when you click into the line item and then post a comment), it does not update the modified by or modified date field. Is there a way to capture that information via SharePoint setting or through PowerAutomate? Thank you !
Are you still planning on putting out a commenting version of this? I’m pretty curious to see how you do that :) Using the append method vs creating a separate list/record for each comment?
Haha maybe I will soon. Basically have a separate list that stores the id for each comment to know what item it links up to
Amazing! thanks man
Happy to help!
any tips for DoD versions
Hi please can you do an update on this video for 2024
Thanks
How would this apply if you wanted to add an approval or rejections to the deleted item
Great vid - can you use lookup as a search with in the same list?
lost already after 10 secs
Hello. I have created sharepoint site in Office 365 and give two users to acces my shared Excel file. They easily click to link and can open file. Is there way to make authentification page when they try open the file?
Hi, this logic works for me , but i am receiving too many mails , from different users, what is the issue, i shared my flow- as " send a copy" eithers thats the issue
Thx for the Vid. But i´m unable to create a flow thats working . Doin it like in the vid but the get item step shows errors. I hate SP hate MS and all the stupid non existing simple make live easy steps.
Straight and simple explanation, thanks so much for the guidance, quick question; If the Sharepoint list has attachments, this procedure would be the same? Thanks in advance!
How to do the same but also power apps has multiple attachments
Thanks for the tutorial! I followed it play by play however when I get to the get file content step I do not have server relative url listed in my dynamic content and my second parse json is very short. I don't know what I did wrong.
Great video! Is there a way of using Power App to go the other way around? Create a SharePoint list from the master collection?
You could invoke a Power Automate flow from the Power App and pass in and iterate over the collection to create a list.
I have several lists and will continue to make more on a monthly basis. But I want to keep them. So if removed from the side bar, where do they go?
Hi man, do you have a video with this type of gallery but patching the attachment control? I need to upload and see attachments into the gallery, Thanks
how to make it work on rx6700xt ?
Thanks man
Hello Michael is there a way to output a default response to a column in SharePoint lists using Power automate flow if the user selects a response of either Yes or No to various questions? How can this be done with multiple-choice questions if one can select only one response from a MS form that has branched questions. Any help will be greatly appreciated.
Hello Michael, I have an weird issue here. For example, if I change 7 row's values, and then click submit. I will only see may be 3 out of 7 rows updated on powerapp. When I check the backend, all the rows are updated. Then I just have to refresh the dataset in powerapp, and I can see the changes. This happens 8 out of 10 times. I am not able to figure this one out. Can anyone of you help me
My form is shareable to people outside the organization, and people with non-microsoft account (like gmail account) should be able to fill the form, I see there is no way they can save and edit their forms. Am I missing something or this is how it behaves... Is there a way to achieve it?