- 179
- 2 099 166
KeaPoint Tech Tips
United Kingdom
Приєднався 22 січ 2020
Welcome to Keapoint Tech Tips, your ultimate destination for mastering Microsoft 365 technologies! Whether you're a beginner or an experienced professional, our channel offers in-depth tutorials, tips, and tricks focused on SharePoint and the Power Platform. Join our community to unlock the full potential of these powerful tools, streamline your workflows, and enhance your productivity. Subscribe now and start your journey towards becoming a Microsoft 365 expert with Keapoint Tech Tips!
🔴 *** BE OUR FRIEND - SUBSCRIBE & SHARE ***
✅ Website: keapoint.com
✅ LinkedIn: www.linkedin.com/company/18782324/
✅ Twitter: Kea_Point
✅ Facebook: keapointuk/
🔴 *** BE OUR FRIEND - SUBSCRIBE & SHARE ***
✅ Website: keapoint.com
✅ LinkedIn: www.linkedin.com/company/18782324/
✅ Twitter: Kea_Point
✅ Facebook: keapointuk/
Power Pages Explained: Best Uses, Key Benefits, and When to Avoid Them
Power Pages Explained: Best Uses, Key Benefits, and When to Avoid Them!" In this tutorial, we’ll cover the key benefits of Power Pages and the best practices for using them effectively. Discover when to use Power Pages for your business and avoid common mistakes! Whether you're a developer or business professional, you'll learn practical insights, use cases, and limitations. This guide also explores Power Pages examples, advantages, and when not to use this tool. Tune in to get the most out of Microsoft Power Pages.
⌚ TIMESTAMPS
00:00 - Introduction
00:37 - Power Pages Brief Introduction
01:25 - When to Use Power Pages
04:21 - When to Avoid Power Pages
06:30 - Conclusion
🔽 CONNECT WITH US
✅ Website: keapoint.com
✅ LinkedIn: www.linkedin.com/company/18782324/
✅ Twitter: Kea_Point
✅ Facebook: keapointuk/
🔎 HASHTAGS 🔎
#powerpages
#website
#webdevelopment
⌚ TIMESTAMPS
00:00 - Introduction
00:37 - Power Pages Brief Introduction
01:25 - When to Use Power Pages
04:21 - When to Avoid Power Pages
06:30 - Conclusion
🔽 CONNECT WITH US
✅ Website: keapoint.com
✅ LinkedIn: www.linkedin.com/company/18782324/
✅ Twitter: Kea_Point
✅ Facebook: keapointuk/
🔎 HASHTAGS 🔎
#powerpages
#website
#webdevelopment
Переглядів: 117
Відео
How to Auto Archive SharePoint List Items with Attachments
Переглядів 18914 днів тому
Looking to auto-archive SharePoint list items, including attachments, effortlessly? In this step-by-step tutorial, I'll show you how to automate SharePoint list archiving using Power Automate. Whether you're dealing with large data sets or looking to organize your SharePoint environment, this guide will help you set up an efficient archiving process that includes attachments. Learn how to strea...
Master Dataverse Transactions & Rollbacks with Power Automate
Переглядів 8414 днів тому
In this tutorial, "Master Dataverse Transactions & Rollbacks with Power Automate," you'll discover how to efficiently handle Dataverse transactions and ensure rollback consistency in your workflows. Learn the step-by-step process of implementing Power Automate rollbacks and maintaining data integrity using transaction management in Dataverse. Whether you're looking to automate Dataverse process...
How to Bulk Export & Email Images from SharePoint Library in Minutes!
Переглядів 5821 день тому
In this tutorial, you'll learn how to bulk export and email images from a SharePoint library in minutes. We’ll walk you through the steps to automate SharePoint image exports, ensuring a fast and seamless process. Whether you're looking to send bulk images from SharePoint or simply need export tips for SharePoint libraries, this guide has you covered. By the end of this video, you'll be able to...
Effortlessly Save Power BI Data to CSV in SharePoint with Power Automate
Переглядів 23428 днів тому
In this tutorial, you'll learn how to effortlessly save Power BI data to a CSV file in SharePoint using Power Automate. Whether you're looking to automate Power BI exports, manage Power BI data more effectively, or integrate it with SharePoint, this video has you covered. We’ll walk through a step-by-step process to ensure you can streamline your data management, from creating the Power Automat...
Streamline SharePoint Document Reviews with Planner Automation | Save Time and Stay Organised
Переглядів 154Місяць тому
In this tutorial, you'll learn how to streamline SharePoint document reviews with Planner automation using Power Automate. By setting up automated workflows, you’ll save time, stay organized, and ensure tasks are automatically created in Microsoft Planner whenever a new document is uploaded or edited in a SharePoint library. This integration is perfect for improving document review processes an...
I Tried Power Automate - Fetching Website Data Became a Breeze
Переглядів 112Місяць тому
Tired of manually collecting website data? In this tutorial, I tried Power Automate and fetching website data became a breeze! Learn how to automate web scraping, fetch news articles, and streamline your workflow in just a few simple steps. Whether you're a beginner or an experienced user, this video will guide you through the Power Automate process for automating website updates and data extra...
Create a Free Power BI Gantt Chart for Better Project Visibility
Переглядів 130Місяць тому
In this tutorial, you'll learn how to create a free Power BI Gantt Chart for improved project management and project visibility. By using Power BI for task tracking and project timelines, you'll be able to boost your workflow efficiency without needing additional software. I’ll show you step-by-step how to build a Gantt chart in Power BI, ideal for enhancing your project tracking and ensuring b...
Simple Trick to Instantly Make Your Power BI Reports Look Stunning
Переглядів 321Місяць тому
Want to improve Power BI visuals and make your reports stand out? In this video, we reveal an easy trick to make Power BI reports visually appealing, with practical tips on Power BI report design and Power BI dashboard aesthetics. Whether you're a beginner or an experienced user, these design techniques will help you create reports that are not only functional but also visually impressive. Watc...
10 Power Automate Mistakes to Avoid for Efficient, Scalable Workflows
Переглядів 264Місяць тому
Are you making common Power Automate mistakes that could hinder your workflow efficiency? This video will cover the top mistakes to avoid and provide valuable Power Automate tips for creating scalable Power Automate flows. By applying these simple but powerful best practices, you'll optimise your automation process and enhance your workflow. Whether you’re just getting started or looking to fin...
Master PowerApp Toolbar Control: Guide to Boost Your App Efficiency
Переглядів 160Місяць тому
Unlock the full potential of PowerApps with our PowerApp toolbar control guide! In this tutorial, you'll learn how to efficiently use the new PowerApp toolbar control to enhance your app's user interface. From adding controls to understanding properties like Items and OnSelect, this video will take you through the PowerApp toolbar features explained in detail. We’ll cover step-by-step instructi...
20 Power Automate Tips to Boost Your Productivity
Переглядів 183Місяць тому
Looking to supercharge your productivity? In this video, we’ll cover 20 Power Automate tips to boost your productivity, helping you streamline your daily tasks and save valuable time. Whether you’re just starting with Power Automate for beginners or you're looking to boost workday efficiency, these tips will take your automation skills to the next level. Do you ever feel like there’s just not e...
How to Instantly Post Webhook Messages to Microsoft Team - Easy Guide
Переглядів 1,5 тис.Місяць тому
Looking to simplify how you post webhook messages to Microsoft Teams? In this easy guide, we'll walk you through automating webhook processing steps and how to efficiently set up and capture webhooks using Power Automate. With these strategies, you’ll streamline your Teams notifications and improve your workflow. In this video, we cover everything from webhook integration into Teams to testing ...
SharePoint Lists vs Dataverse: Which One is RIGHT for You?
Переглядів 4682 місяці тому
Are you developing an app with PowerApps and wondering whether to use SharePoint Lists or Dataverse Tables as your data source? In this video, we break down the key factors you need to consider when making this critical decision. We'll cover: Data Volume: Which option handles more data efficiently? Security: Advanced security features vs. basic permissions. Document Storage: Ideal solutions for...
The Secret of Easy PowerApps Gallery Sorting & Filtering
Переглядів 2502 місяці тому
In this video, we’ll unlock The Secret of Easy PowerApps Gallery Sorting & Filtering! Learn how to quickly master PowerApps gallery filtering and PowerApps sorting functionality to improve your app’s user experience. We’ll explore dynamic filtering and the PowerApps filter function, giving you the tools to create custom filters and efficiently sort gallery items. Whether you're new to PowerApps...
How to Schedule Azure Virtual Machine On/Off with Power Automate
Переглядів 1772 місяці тому
How to Schedule Azure Virtual Machine On/Off with Power Automate
Revolutionising PowerApps: The Ultimate Vertical Gallery Upgrade!
Переглядів 3883 місяці тому
Revolutionising PowerApps: The Ultimate Vertical Gallery Upgrade!
From MS Forms to Word & PDF: The Easiest Automation Ever
Переглядів 2,1 тис.3 місяці тому
From MS Forms to Word & PDF: The Easiest Automation Ever
Revolutionise Your Workflow: Automate Email Data Extraction to Dataverse with AI
Переглядів 5423 місяці тому
Revolutionise Your Workflow: Automate Email Data Extraction to Dataverse with AI
Simple Steps to Create a Compact Side Menu in PowerApps
Переглядів 2253 місяці тому
Simple Steps to Create a Compact Side Menu in PowerApps
Transform Your Workflow: Effortlessly Process Data From Receipt Images to SharePoint with PowerApps
Переглядів 2863 місяці тому
Transform Your Workflow: Effortlessly Process Data From Receipt Images to SharePoint with PowerApps
Generate Realistic Test Data for SharePoint Lists with Chat GPT
Переглядів 2083 місяці тому
Generate Realistic Test Data for SharePoint Lists with Chat GPT
Generate Barcodes and QR Codes in SharePoint List for Free
Переглядів 1 тис.3 місяці тому
Generate Barcodes and QR Codes in SharePoint List for Free
Save Hours & Eliminate Stress: Automate Receipt Data Entry to SharePoint
Переглядів 2913 місяці тому
Save Hours & Eliminate Stress: Automate Receipt Data Entry to SharePoint
Unlock Viewer Engagement: Embed Stream Videos in PowerApps Seamlessly!
Переглядів 4733 місяці тому
Unlock Viewer Engagement: Embed Stream Videos in PowerApps Seamlessly!
Unlock the Secret: Effortlessly Extract Numbers from Strings with Power Automate!
Переглядів 3673 місяці тому
Unlock the Secret: Effortlessly Extract Numbers from Strings with Power Automate!
Effortlessly Archive SharePoint List Items-Keep Timestamps & Creator Intact!
Переглядів 9594 місяці тому
Effortlessly Archive SharePoint List Items-Keep Timestamps & Creator Intact!
Create Multi-Table Power App with Microsoft Copilot - Step-by-Step Guide
Переглядів 2004 місяці тому
Create Multi-Table Power App with Microsoft Copilot - Step-by-Step Guide
How to Use JSON in Power BI Reporting
Переглядів 1964 місяці тому
How to Use JSON in Power BI Reporting
Easily Extract Text From Images And Pdfs With Power Automate
Переглядів 1,1 тис.4 місяці тому
Easily Extract Text From Images And Pdfs With Power Automate
Well explained thank you!
Thank you for your kind words! I really appreciate your support!
Thank you so much ! This video is very helpful
I'm really glad to hear that you found the video helpful! Your support means a lot to me.
Hi - it's working for me but attachments are not getting saved in SharePoint...any idea?
Attachments should be part of email file.
Thanks, helped a lot
Glad it helped
Hi sir I have got json error expected string instead of array how to solve this And will this works if data is more than 10k rows????
This won't work if you want to bulk create 10k records in single go because of the Power automate limits.
@@KeaPointTechTips ok sir powerautomate limits thats ok How to resolve expected string instead of array issue in parse json flow step ?
@@KeaPointTechTips your input is really helpful for me at this time Actuall some of the columns has blanks So its causing error
Thanks, this worked. I have no experience and I was able to set this up! Appreciate you sharing this!!
I'm so glad to hear that it worked for you! It's always great to see beginners getting things set up successfully. Keep it up!
Hi , How can we change the display name of the message sender to custom name?
Sorry, can you elaborate it.
@@KeaPointTechTips I think he wants to change the name of the user who posted the card in MS Teams. Like in your video it says "Rashid Aziz via Workflows" because the configuration was to post as "Flow bot" and he wants to customize that name. Thank you for the video though, really helped me out here :)
What if instead of dropdown for email, if the user types in the email, what changes should we do?
Pass Textbox text to the query, instead of drop box selected item value
Thank you very much for this video. It's brilliant. It has really helped me a lot!
I'm so glad to hear that you found the video helpful! Your support means a lot to me!
Hi! Thanks! And When drop, or edit data on the list?
You are welcome. edit or delete list item sync with streaming dataset is not possible with this method.
Perfect video, extremely helpful and well put together
Thank you so much for your kind words! It motivates me to keep creating content that helps!
Thank you for the tutorial. I followed all the steps and was able to get the attachments. However, I’m not able to open the attachments. What could be the reasons for this?
Note: Please select "Include Attachments" option to "Yes", under advanced option of first workflow step "When a new email arrives". Thanks
@@KeaPointTechTipsthat did the trick. Thanks so much.
How to post the complete file in teams chat
You can upload file to SharePoint Library (teams channel folder ) and add a link to teams chat.
Thank you so much. God bless you for this video.
You're very welcome! I'm glad you found the video helpful. Your support means a lot!
If it is not available in the new designer,is it going to deprecate?
Not sure, it does not says deprecated at the moment.
@ 6:31 When I go to "Get Data" Power BI dataset does not show up for me. Is there anyway to get it to appear?
Do you have access to the dataset? Try using the dataset ID
@@KeaPointTechTips How do i check if I have access? I did everything exactly how you showed it. Power BI datasets still will not appear for me nor dataset ID.
try adding the dataset ID as custom value.
@@KeaPointTechTips I am fairly knew to this software and don't understand how to add dataset ID as a custom value without you throughly explaining/showing me.
how do I sort based on mutlitple columns whth each one having a seperate button
From UI point of view, use dropdowns if filtering on multiple columns is required. You can also configure search box to filter on multiple columns
Get attachement content: The 'inputs.parameters' of workflow operation 'Get_attachment_content' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'itemId' is required to be of type 'Integer/int64'. The runtime value '"%252fLists%252fACTIVIDADES_DB%252fAttachments%252f1928%252f48-FO-PYD-06%2bFormulario%2bHoja%2bde%2bReporte%2bde%2bActividades%2bConv.%2bColegio%2bSan%2bRoque.docx"' to be converted doesn't have the expected format 'Integer/int64'.
Looks the you are not providing the correct value in the Item ID column. it has to be list item id and in integer format.
What if i want to change it to a different list in the same site?
You can do this by changing the source URL in the edit query screen
This is so straight to the point and educational, thank you for the tutorial, I was wondering if you could make a video on how to archive SharePoint news with power automate
I'm glad you found the tutorial helpful! Archiving SharePoint news with Power Automate sounds like a great idea for a future video. I'll definitely consider it!
Nice video sir but kindly request you sir about make new video in power automate old design.
I recommend avoiding the old Power Automate design moving forward. It's best to get accustomed to the new designer.
THANK YOU !!!!!!!!!
You're very welcome! I'm glad you enjoyed the video!
Worked great, thanks!
I'm glad to hear it worked well for you! If you have any other questions, feel free to ask!
Hello. I would like to create unique ID : country (based on a choice of 5 country in à column, year YYYY, month MM, number xxxx. And this number starts again at 1 at the beginning of month. Thanks a lot
capture the numbers with country name in a separate lists for each country, update it's counter via flow every time it is used, reset the list item counter on first day using a different flow. year and date stuff you can retrieve form the current date.
wonderful tutorial. Would it be possible to also bring over the attachments/
Yes, use "get attachment" action then use "apply to each" action and use "add attachment" action to copy to the new list. I will try to make video on this topic next week.
@erenatis: I have just published a new video as promised. ua-cam.com/video/MMNdW5b1xPI/v-deo.html
This video was so helpful, thank you so much! I combed through the comments to see if anyone had asked about email replies and I found one but it didn’t quite help me. Of course the emails automatically upload to the library through the flow, but any replies to that email (usually we have a long thread of replies for each email) uploads as a separate entry. Is there any way to update each entry once replies are sent?
Hi Alex, this solution can be developed in many different ways. Generally new email response include the old thread, one way is that you can replace the existing document with new one as it will contain the email history.
what is the best way to create a flow to copy any added or updated item in one site library to another site library?
you can create flow, set trigger on item added or updated, then add copy file action to copy to another site.
Nice video
Thanks for watching! I’m glad you enjoyed it!
@@KeaPointTechTips .. What if I want to send it as an attachment via outlook? What changes do I make in the flow?
just add another action "send email", and select csv file content from previous step (Create File action) in the send email action's attachment.
Sir will it truncate the data
im etting an error in the lasts step: A type named 'SP.Data.ClientsListItem' could not be resolved by the model. When a model is available, each type name must resolve to a valid type
make sure your list internal name is Clients, or change the above code to reflect correct list name
Absolute beauty, but how do you copy between different tenant?
I have already made a video on how to copy cross tenant ua-cam.com/video/xSySOCTsrLM/v-deo.html
@@KeaPointTechTips Thanks a lot
Is it possible to make an self-updating auto-incrementing year-based reference number? Thank in advance!
Yes, it is possible. You can create a separate list to store the year counter. Then, use a Power Automate flow to increment the counter by one for each new entry. The flow will update the counter in the list and combine it with the current year to generate a unique reference number.
Okay so instead of saving to a list i saved mine to a folder in the document folder. I have the same exact step. But my issue is that I want to prevent the same email being saved twice. If two persons get the same email, i only want one to be saved. How can i do this?
You can create an action in Power Automate to retrieve a file by its name by applying a filter on the filename. If no results are returned, you’ll know the file doesn’t exist, allowing you to create it. If the file is found, the process can be ignored.
Thank you so much! This is a great video, wonderful content.
I really appreciate your kind words! I'm glad you enjoyed the video!
Hi Thank you for the video. Have you uploaded a video on realtime update/delete data in sharepoint list with power automate similar to this one.
Thanks for watching! I haven't created a video on real-time updates/deletes in SharePoint with Power Automate yet, but it's a great idea! I'll consider making one in the future.
is it possible to make each folder have a column formatted with the Abbreviation of the folder name e.g Project Control (PC), Information Management (IM)
Yes, you can add metadata to folder same way you add metadata to a document inside a library
Easliy understood....... thanks for simple explaination
I’m glad you found the explanation easy to understand! That’s always my goal!
still helpful in 2024 👍
I'm glad to hear that! It's always great to know the content remains relevant and useful.
Hello - I have a share point list that has a date column. I want to look at that date column and if any dates are more than 30 days from today I want it to update an item in my share point list.
Write a schedule flow, use, get items action in flow with filter addDays(utcNow(), -30, 'dd-mm-yyyy') , you will only get the records more than a month old. You can then loop through them and update items.
Hi! How would I write "does not equal" rather than "@equals"?
Use not(equals()) function.
please mention the data so that we can practice it and tag you after making it \
It is just a test data that you can create easily or can import from your project excel file.
For those of you who needed to change the date here is what he typed: if(empty(item()?['Start Date']),null,addDays('1899-12-30',int(item()?['Start Date']),'yyyy-mm-dd'))
Thanks for the input.
This is great, all the examples were useful and the video was short, to the point. Thank you very much for sharing your knowledge!!
I'm really glad you found the examples useful! Keeping it short and to the point is always the goal. Thanks for watching!
Fantastic series. This was very helpful.
I'm so glad you found the series helpful! Your feedback means a lot to me.
Exactly What I was looking for... but the background music made it impossible for me to watch all the way through. So unfortunately no help to me. Its a me issue, i know this! But just feedback for future content :)
Thanks for the feedback. I am actually thinking of removing the background image completely from my upcoming videos
This is so helpfull! Thank you!
I'm so glad you found it helpful! Your support means a lot to me.
This is the best Sharepoint tutorial I've ever seen. Going to check out all of your other videos.
I'm so glad you found the tutorial helpful! I hope you enjoy the rest of the videos too!
Perfect. Thanks for the explanation and this great content . 🙏🏽
I'm glad you found the explanation helpful! Your support means a lot.
Do you need to copy a product list from recent lists. It does not list a product list for me. How can you get the iD from one developed from scratch. this is a perfect solution for me to create a list of my QR codes (with unique reference number) which will be part of the graphic. Just need to get on to right track. Any hints or tips.
Go to list settings page. In the URL you will see the id like List=%7B661fb415-2f00-43fa-a569-2bea5ed16471%7D. ignore %7B and %7D as they are html tags, in-between these tags you have the list ID, in my case it is 661fb415-2f00-43fa-a569-2bea5ed16471
thanks!!!
Thank you for watching! Your support means a lot to me!
❤
Thanks!