- Видео 127
- Просмотров 1 859 168
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 Apply Unique Permissions to a Folder or File in SharePoint | 2024 Tutorial
🔐 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: Learn how to customize access levels, ensuring that only the right people have the right permissions.
Real-World Examples: We’ll walk you through practical scenarios where unique permissions are essential, helping you understand when and why to use them.
💼 Why It’s Important:
Applying unique permissions is cr...
🌟 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: Learn how to customize access levels, ensuring that only the right people have the right permissions.
Real-World Examples: We’ll walk you through practical scenarios where unique permissions are essential, helping you understand when and why to use them.
💼 Why It’s Important:
Applying unique permissions is cr...
Просмотров: 222
Видео
How to Patch Any Column Type Effortlessly in Power Apps | 2024 Tutorial
Просмотров 364Месяц назад
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
Просмотров 9372 месяца назад
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
Просмотров 8474 месяца назад
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
Просмотров 4,9 тыс.5 месяцев назад
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
Просмотров 9 тыс.5 месяцев назад
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 месяцев назад
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
Просмотров 3685 месяцев назад
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
Просмотров 9795 месяцев назад
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
Просмотров 6 тыс.5 месяцев назад
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
Просмотров 9505 месяцев назад
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
Просмотров 8 тыс.5 месяцев назад
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
Просмотров 9 тыс.6 месяцев назад
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
Просмотров 7 тыс.6 месяцев назад
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,6 тыс.6 месяцев назад
Hi Everyone, 🚀 Unlock the Power of PowerApps: Learn How to Create a Simple Admin List Using SharePoint! 🚀 Are you ready to take your PowerApp development skills to the next level? In this step-by-step tutorial, you'll discover how to create a simple yet powerful admin list for your PowerApp using SharePoint. 💡 What You'll Learn: Setting Up Your SharePoint List: First, we'll walk through the pro...
How to Safely Remove Records from a SharePoint List Using PowerApps | 2024 Tutorial
Просмотров 2,3 тыс.7 месяцев назад
How to Safely Remove Records from a SharePoint List Using PowerApps | 2024 Tutorial
How to Track Changes to SharePoint List Items | 2024 Tutorial
Просмотров 6 тыс.7 месяцев назад
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
Просмотров 4927 месяцев назад
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,4 тыс.9 месяцев назад
How to Switch to the Classic Designer in Power Automate | 2023 Tutorial
Easy Way to Center Anything Perfectly in PowerApps | 2023 Tutorial
Просмотров 4,2 тыс.10 месяцев назад
Easy Way to Center Anything Perfectly in PowerApps | 2023 Tutorial
How to Concatenate a Person Column Email String in Power Automate | 2023 Tutorial
Просмотров 6 тыс.11 месяцев назад
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
Просмотров 7 тыс.Год назад
How to View Large Collections of Data Easily in PowerApps | 2023 Tutorial
How to Add Gallery Headers to Your Power App | 2023 Tutorial
Просмотров 7 тыс.Год назад
How to Add Gallery Headers to Your Power App | 2023 Tutorial
How to Send an Email Using Power Apps and Power Automate | 2023 Tutorial
Просмотров 55 тыс.Год назад
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
Просмотров 36 тыс.Год назад
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
Просмотров 69 тыс.Год назад
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
Просмотров 12 тыс.Год назад
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
Просмотров 9 тыс.Год назад
How to Upload Images, Video, and Audio to Your PowerApp | 2023 Tutorial
Automatically Rename Meeting Recordings From LongDate to ShortDate Using Power Automate
Просмотров 294Год назад
Automatically Rename Meeting Recordings From LongDate to ShortDate Using Power Automate
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?
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?
THANK YOUU !!!!!!
Great video! Short and to the point. Is there a good time when the apply to each would not be useful or not something you want? Since it gets automatically applied, how would you remove it, if you wanted to and the effect of that?
Thanks. I would like to learn how to use power automate to delete a shared folder in One Drive after 30 days.
its not detecting my device
You're the man. Sorry you had to go through this mess "for the team" to eventually figure it out to to save us. Took me only 5 minutes to fix this because your video came up first in my search. Thank you.
Hi Michael - would the tags be visible to users
May god keep you in his glory my friend, I literally had tried everything else in the book and it was as simple as a Windows+P solution, god bless
Thank you Mike, Just to share, IMC, cause, SP Online has upgraded now, few steps in this video seem to be redundant. I had to export the list as CSV with Schema, and import it at destination site to achieve the above (Copy A SharePoint List with Data to Another SharePoint List). Still The steps were quite intuitive to understand the process.
Thanks so much Alex. Your Videos helped me to create fully automated processes within a few hours and I had no experience at all. One question: If have a very long MS forms and not everything has to be filled in it might happen that the person who is supposed to approve my request has to look quite while for the filled in content because "link to item" just shows you every row even if there is not filled in content. Do you know a way that the manager can only see the filled in content ? Best regards from germany.
Is there a way to 'Get Item' details? Mine keeps breaking the flow. We need to know whats being deleted from the list.
Can you add more than one 'Assigned To' person for approval? (We have a 4 person approval team)
Great video! Any way you could show how to do this with a list that has multiple columns and you want to connect to the master and pull in all the columns.
Hey Michael! Thanks for the tutorial! I have 1 question. When I enter text (more than 1 paragraph) into the body input box, I'll get the email with run-on sentences even though I hit enter to start a new paragraph. What would you suggest to resolve that issue? If anyone else has a suggestion, please let me know. I would appreciate any help I can get. Thanks!
In your opinion whats the advantage/disadvantage of having a list of projects as shown in the video versus having a site dedicated to individual projects?
first of all… Great and Many Thanks! How is it possible to put the selected items into an other table in excel? comboboxvalue.Selected.Tablename does not work.
This video helped me so much! Thank you!!
Great job. I was wondering if this would be applicable to just scale this up for an organization spanning 6 states for regional supervisors
Great job. I was wondering if this would be applicable to just scale this up for an organization spanning 6 states for regional supervisors
can you explain how will we add attachments to each row
This is the method I use but it's a pain in the neck if you have 50 or 60 columns. Any quicker method than this?
I would not use 50-60 columns in the gallery. That is a lot of data to show at once. Try breaking out the data in separate screens
apologies on 4:30 how do you make it possible to leave the input box blank? I tried to just leave it blank but it won't let me save
Hi Alex, thank you for the video, I got stuck to create a loop where I have 10 images in share point and I want all the images on one PDF. Could you please suggest. Your help is much appreciated. Thank you in advance.
hi michael, this approval is done by 1 user, is it possible if the approval is done by 2 users?
TYhank you for this tutorial., it looks more complicated to understand the licenses than creating the flow. is this flow still within free tier?
Hi Michael, I’m working on something very similar to what you’re doing and was wondering if you could provide a tutorial on sending approvals to multiple managers. My process requires approvals from 4 managers sequentially: the approval goes to Manager 1 first, and only after they approve it, does it move on to Manager 2, and so on. Could you guide me on how to set this up?
Thank you for sharing :)
Excellent tutorial. Thank you... I made my switch statement as follows for a simple navigate to 4 different screens. Switch( ThisItem.Value, "Screen 1", Navigate(scr_Screen1), "Screen 2", Navigate(scr_Screen2), "Screen 3", Navigate(scr_Screen3), "Screen 4", Navigate(scr_Screen4) )
Does this work if this file would be overwriting a file of the same name in the share point?
I've found several of your vids helpful for my use cases! Thanks! QUESTION: Do you have any insight on how to do your birth month and day filter against today's month an day as an OData Filter in the initial Get Items step rather than waiting for it to be a condition? Thanks for any help you can provide!
🥰🥰🥰🥰
This question might not make sense but I have a page on Sharepoint that has a bunch of profile pages for people who work at the company. Some have left so I don't want there profiles anymore but I still want to save their information on the backend. How do I remove them from the page without deleting the profile?
Great Work. Can you make like when more than 10 item deleted when send the email? (just like unusual deleted item)
Is PowerApps the best way to do a count of items in multiple lists, and if so, can filters be applied to that count?
Thanks for the video this will save me a bunch of time!
Nice video! What if we would reverse the modified field? Let's say we are interest in just the editing of field Title and put back the previous text or whatever?
Michael, you have helped me a several times. This is another one. Thank you!
You saved me haha thank you. Subscribing now
Hi, my powearpps teams doesnt have self.searchtext. Is there any other function to overcome the limitations. thanks
Worked really well. Saved me hours of work
Please create video if someone will raise sharepoint access request via email so it will auto approve on some time