- Видео 140
- Просмотров 1 928 687
KeaPoint Tech Tips
Великобритания
Добавлен 22 янв 2020
We are certified Microsoft SharePoint and Office 365 consultants based in the UK, and provide end-to-end Microsoft Office 365 and SharePoint Consulting Services to companies worldwide. We are specialists in business process automation and employee portal customisation, digital transformation and user adoption. We also offer a business intelligence aspect to data-driven platforms.
🔴 *** BE OUR FRIEND - SUBSCRIBE & SHARE ***
✅ Website: www.keapoint.com
✅ LinkedIn: hwww.linkedin.com/company/18782324/
✅ Twitter: Kea_Point
✅ Facebook: keapointuk/
🔴 *** BE OUR FRIEND - SUBSCRIBE & SHARE ***
✅ Website: www.keapoint.com
✅ LinkedIn: hwww.linkedin.com/company/18782324/
✅ Twitter: Kea_Point
✅ Facebook: keapointuk/
Power Automate Error The File is Locked for Shared use by
Welcome everyone! In today’s video, I'll guide you through a workaround for fixing the "File is Locked for Shared Use by" error in Power Automate.
I recently faced this problem while working on a client's workflow. The process seemed simple: a user sends a document for review, but things go awry when the reviewer opens the file in their browser, approves it via email, and then closes it. Despite the approval, the workflow believes the approver still uses the file, causing it to fail when trying to update file properties.
★ TABLE OF CONTENTS ★
• 00:00 Intro
• 0:18 Reproduce Power automate error: File is Locked for shared Use by
• 03:30 Workaround: File is Locked for Shared Use by error
• 10:26 ...
I recently faced this problem while working on a client's workflow. The process seemed simple: a user sends a document for review, but things go awry when the reviewer opens the file in their browser, approves it via email, and then closes it. Despite the approval, the workflow believes the approver still uses the file, causing it to fail when trying to update file properties.
★ TABLE OF CONTENTS ★
• 00:00 Intro
• 0:18 Reproduce Power automate error: File is Locked for shared Use by
• 03:30 Workaround: File is Locked for Shared Use by error
• 10:26 ...
Просмотров: 48
Видео
Create Reusable Content Types for SharePoint Online Environment
Просмотров 73811 месяцев назад
This video will walk through how to create content types in SharePoint which can be used on multiple sites across SharePoint online environment. A content-type hub is a collection where you can manage and publish your content in SharePoint online environment. We will discuss how to add a content type to the "SharePoint online" list or document library. To make essential content types more consi...
How to Use CSS Styles With PowerApps Controls - Workaround
Просмотров 8 тыс.Год назад
This video will walk through how you can define CSS style in PowerApps and how you can apply them to your "Power Controls" also you have seen that once applied to one control you can copy the control and you can create as many controls as you want within Power App. You can create "CSS" by creating an object on PowerApps on the "App start function" and then defining the style value. We can then ...
How to Format and Filter Modern List Calendar View In SharePoint Online
Просмотров 6 тыс.Год назад
This video will walk through how to the format SharePoint modern list calendar view and how to format and filter the modern list calendar view in the SharePoint list. There is a way to create a modern calendar view of any list in SharePoint! Demonstration of this functionality and calendar concepts within SharePoint. There is a way to create a modern calendar view of any list in SharePoint! Dem...
How to Format Hyperlinks in HTML Table using Power Automate
Просмотров 13 тыс.Год назад
This video will teach how to add hyperlinks and format them inside an HTML table using power automation. The power automate action lets you create an HTML table that allows you to display data in an easy-read format but the hyperlink didn’t get formatted automatically. We will use "Power Automate" flows to create the HTML table from SharePoint list items using the flow "Create HTML Table" actio...
Filter Query Based on SharePoint List Person Field in Power Automate
Просмотров 14 тыс.Год назад
This video will walk through how to apply a query filter on a SharePoint list person field using Power Automate flow. I have used the "Get items" action of Power automate to retrieve data from the SharePoint list. The OData filter query in power automate can't filter person objects instead it can only filter on the specific attributes of the person field. In this example, I will be using the Em...
Request Approval for a Selected SharePoint List Item using Power Automate
Просмотров 16 тыс.Год назад
This video will walk through how to set up Power automate flow to initiate request approval for a selected SharePoint List item. You can create the Power automate flow from scratch and add approval logic. Alternatively, you can use the Request Approval template of Power automate to achieve the same. This video will show you how easy you can configure and request approval templates and set up an...
How to Join SharePoint Hub Site Automatically using Power Automate
Просмотров 1,5 тыс.Год назад
This video will walk through how to automatically join the SharePoint Hub site using Power automate. There are different ways you can attach a SharePoint site to the hub. You can use PowerShell to achieve this but if you would like to do it as part of Power automate processes, there are two ways to achieve this. First, you can use the "Send HTTP request" action of Power Automate and the second ...
Copy Files Between SharePoint Online Site in Different Tenants using Power Automate
Просмотров 13 тыс.Год назад
In this video, we'll show you how to copy files between SharePoint tenants using Power Automate. This can be a great way to quickly and easily move files between environments for testing or development purposes. We'll start by creating a new flow in Power Automate, and then we'll use the Get Files action to select the files we want to copy from the source tenant and then we'll use the Copy File...
Copy Documents from SharePoint to Azure Storage using Power Automate
Просмотров 22 тыс.Год назад
Power Automate is a Microsoft 365 service that helps you automate tasks across your applications and services. With Power Automate, you can copy documents from SharePoint to Azure using an Azure blob storage connector. The first step is to create an Azure blob storage account. Next, you will need to create a container in the blob storage account. Once the container is created, you can add a con...
Send an Email as MS Teams Email Address using Power Automate
Просмотров 9 тыс.Год назад
This video will walk through how we can use Power Automate to send email as an Office 365 group Teams email address. You probably rely on sending email as your own account or service account while configuring send email action in power automate flow. We can quickly solve that problem by using our Office 365 group Teams email address as our default sending account. YOu can send as Teams email ad...
Automate Teams Provisioning using Power Automate and Microsoft Forms
Просмотров 3,7 тыс.Год назад
This video will walk through how you can use Power Automate and Microsoft Forms to quickly create Microsft teams in your organisation. By using these tools, you'll be able to automate new Microsoft Teams creation and save yourself time and make it easier for MS Teams admins. 🔴 BE OUR FRIEND ✅ Website: www.keapoint.com ✅ LinkedIn: hwww.linkedin.com/company/18782324/ ✅ Twitter: Kea_Po...
Copy SharePoint Library Files Including Nested Folders Structure using Power Automate
Просмотров 21 тыс.Год назад
In this video, I will show you how to copy the SharePoint library documents with nested folder structure from one SharePoint site to another. This can be useful if you need to move documents or data between different sites as part of SharePoint template provisioning to include contents/files automatically or purely for testing purposes. 🔴 BE OUR FRIEND ✅ Website: www.keapoint.com ✅ LinkedIn: hw...
How to Delete a SharePoint List using Power Automate
Просмотров 4,8 тыс.2 года назад
In this video, you will learn how to use Power Automate to delete a SharePoint list. Deleting a list can be an important task if you need to clean up your site or remove data from your system. The process of deleting a list is straightforward and easy to follow, so let's get started. 🔴 BE OUR FRIEND ✅ Website: www.keapoint.com ✅ LinkedIn: hwww.linkedin.com/company/18782324/ ✅ Twitter: twitter.c...
Combine SharePoint Lists Data Using Power BI
Просмотров 15 тыс.2 года назад
Combine SharePoint Lists Data Using Power BI
Migrate MS Forms Between Microsoft 365 Tenants
Просмотров 4,2 тыс.2 года назад
Migrate MS Forms Between Microsoft 365 Tenants
Realtime Data Reporting using Dataverse & Power BI
Просмотров 9 тыс.2 года назад
Realtime Data Reporting using Dataverse & Power BI
PowerApps Auto Suggest Search Text using SharePoint List Data
Просмотров 10 тыс.2 года назад
PowerApps Auto Suggest Search Text using SharePoint List Data
Update SharePoint List Source URL in Power BI Report
Просмотров 8 тыс.2 года назад
Update SharePoint List Source URL in Power BI Report
Quickest Way to Bulk Delete Dataverse Table Records
Просмотров 11 тыс.2 года назад
Quickest Way to Bulk Delete Dataverse Table Records
How to Recover MS Forms After Owner Leaves the Organisation
Просмотров 10 тыс.2 года назад
How to Recover MS Forms After Owner Leaves the Organisation
PowerApps Gallery Search Based on Multiple Columns
Просмотров 14 тыс.2 года назад
PowerApps Gallery Search Based on Multiple Columns
Power Automate Approval Set SharePoint Document Level Permissions
Просмотров 3,2 тыс.2 года назад
Power Automate Approval Set SharePoint Document Level Permissions
Build Canvas PowerApps Based on Dataverse Table
Просмотров 15 тыс.2 года назад
Build Canvas PowerApps Based on Dataverse Table
Managing Metadata in SharePoint Document Library Effectively
Просмотров 6 тыс.2 года назад
Managing Metadata in SharePoint Document Library Effectively
Power BI Realtime Reporting on SharePoint List Data
Просмотров 79 тыс.2 года назад
Power BI Realtime Reporting on SharePoint List Data
Create Dataverse Table Views & Connect to PowerApps Gallery
Просмотров 9 тыс.2 года назад
Create Dataverse Table Views & Connect to PowerApps Gallery
Save Data to SharePoint List from an External System API using Power Automate
Просмотров 15 тыс.2 года назад
Save Data to SharePoint List from an External System API using Power Automate
Copy SharePoint List Structure and Contents to Dataverse Table
Просмотров 13 тыс.2 года назад
Copy SharePoint List Structure and Contents to Dataverse Table
☑️Update SharePoint Hyperlink Field using Power Automate Flow
Просмотров 21 тыс.2 года назад
☑️Update SharePoint Hyperlink Field using Power Automate Flow
Can we also copy the meta data of the documents (custom column information) from Sharepoint to Azure blob storage ?
You can create a CSV file via flow to store metadata in Azure Blob.
Tom cruise didin't answer my call...
You can create a CSV file in flows to store meta data in Azure Blobs
Thank you , you really helped me
Glad I could help!
Hello, is we need to map the column once. Or everytime when we upload a excel.
Hi, if table name and column structure stays teh same then it should work with existing mapping.
Thank you so much for this video. I came across this video just at the right time i am in so much in need of it. I need more help however. How do i perform other Read operation on SharePoint Library using Power Automate. I want to display the list of all SharePoint Document Libraries present in a SharePoint site in a gallery in PowerApps How do i perform the Delete operation to
Such a straightforward solution, and clearly articulated. Thank you for the upload. I know the video is 3 years old, but it's still relevant to those just learning the basics of Power Apps. Thanks again!
EXTERNAL USERS: I found it !!! to make it work for externals/anonymous you have to move/drag the email (V2) part into position 3, and delete conditions parts all together. In the email ensure "to" is set up to an "email address" field that you are asking submitter to enter inside the form. Works like magic!
is there a way to be able to pick up email address from the form so that email becomes "responder email". I need to use MS form with internals and externals
Can i etl bofore load?
This is awesome, however, I need to do this for an Azure Blob.
I have done a video on copying documents on Azure Blob storage. Have a look.
Thank you
You are welcome
Hi thanks for the video, it is very useful for me. Question: How do I display the edit form? Because when I preview the app (F5), there is no item to display for Form1 in Screen1. Others works well.
1. Disable New Designer. 2. if(empty(item()?['Start Date']),null,addDays('1899-12-30',int(item()?['Start Date']),'yyyy-MM-dd')) if(empty(item()?['Due Date']),null,addDays('1899-12-30',int(item()?['Due Date']),'yyyy-MM-dd'))
Thanks
Amazing thank you
what is the difference between get items and get item in the flow
is it possible to schedule the posts as one per day?
Like @bi-ome has mentioned, this is not CSS, it's just a convenient way to manage global styles. Please change the title so that people are not misled.
Is it possible to group attachments by list item, like in subfolders in the library?
Great video!
Thank you a lot ❤❤❤❤
Welcome :)
Hello thank you for sharing the useful content. Is it advisable to add a new connection from a different domain(organisation) which is having a guest user access
Does anyone know how I would replace "Permalink" within the first row of code below with the Project Name item from the second row? Each row within the data source has a Project Name and associated Permalink URL. concat('<a href=\"',item()?['PM Header Data[Permalink URL]'], '\">Permalink</a>') item()?['PM Header Data[Project Name]']
Thank you ! Helpful video!
Can you apply restrictions to access this? For example the admin has full authority and access, the HR group can edit existing data and add new data then the others can only view it?
Bro super nice thanks a lot, super simple the solution but with a high value 🥳🥳🥳🥳🥳
Happy to help
This is brilliant. Thank you for sharing!
You're very welcome!
Great video. exactly what i needed. 5 stars!
Glad it helped!
very nice video thank you please how we can deal with different languages in power apps create an application that supports (french, english, chinese)
Can you please create similar video for cascading dropdown using modern controls?
So if we wanted to make that automatic do I just follow same steps but at the start select the automated flow option?
Thank you, Can we use this method to copy SharePoint site pages to another tenant site?
THANK YOU SO MUCH
You're welcome!
Explanation is very clear. I have different scenario - I have coupon issue column in share point (which is updated manually with the issued date) and when emp apply for again using Form, Power automation shld check whether the last coupon issued is greater than 6 months from the current applied date, if yes create an new entry and if no reject email.
Thank you!
You're welcome!
Nice work as always. A few quick question, if I edit a document in the source Document Library, will this copy the edited version of the document replacing the old one?... Also, this flow will only copy across new documents and folder and skip other folders and files if they exist in the destination DL, is that correct?
solid tutorial with no bloat - great work!
Exactly what I needed THANK YOU!!
Glad it was helpful.
Will it copy if there is update in the file in share point?
If you only want to copy the folder structure, it works. But if you want somethihng to copy files and folders in the same structure as the source, can you do it with one flow?
This is awesome
I see that you allowed 2 apps sharepoint and forms. I want to do the same but only certain users to be able to access and not everyone. how can I do that?
Thanks this was amazing! I did all the steps but I don't see any data in Power Bi. what's the issue?
hello thanks for your video what do you think about this error : A type named 'SP.Data.Photos_Catalogue_FIListItem' could not be resolved by the model. When a model is available, each type name must resolve to a valid type. clientRequestId: acc78967-61f7-435f-9a8c-cf289473cd07 serviceRequestId: d5ac14a1-903c-8000-54a8-23bd4a30cda8 "Photos_Catalogue_FI" is my sharepoint list
Thank you very much Sir for this incredible video. Silly question. WIll this method works up to 2000 delegation limit in ShaPoint ? Or I can Add a Collection with more items against the search fucntionally? Thanks in advance. The reason for my question is beveause I need to filter first by the US States, then by Cities. I wan the cities under your concept but vould be many many cities
how to sort the elements?
Wonderful video. Can you make such video for moving folders instead of copying? Or let me know how to do it
Thanks, I will add that to my to do list.
@@KeaPointTechTips have you created any video on copy folder from default sharepoint library to other tenant ? if yes please let us know
How do we create a meetings calendar in the list app from an excel sheet?
This is possible but I don't have a video to explain this in detail.
Fantastic video. Made my day as my team was struggling with this issue after migrating to another system. Thank you!
You're welcome!
Sir how to integrate MIS with power BI for real time data??
What MIS system are you trying to connect via Power BI, check if teh connector for Power bi is available for teh targeted MIS.