- Видео 105
- Просмотров 554 509
Enea Liçaj
Германия
Добавлен 2 фев 2021
In my channel, I showcase solutions for problems that aren't easily found online to help as many people as possible and share my knowledge. Although it's something I do during my free time, it requires a lot of work, and I put in many hours to create quality content.
Feel free to follow me on other social media platforms as well: linktr.ee/EneaLicaj
Feel free to follow me on other social media platforms as well: linktr.ee/EneaLicaj
How to Instantly Duplicate SharePoint Library Files + Metadata
In todays video we will see how to instantly duplicate a SharePoint Library File directly from the File item row. For this very simple Flow we are going to utilize the same JSON Formatting Code we have been using in multiple previous videos showcasing how to trigger a Flow from a SharePoint List Item or Library File Row.
Code for the JSON Column Formatting:
{
"$schema": "developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "button",
"customRowAction": {
"action": "executeFlow",
"actionParams": "{\"id\": \"Your-Flow-ID\"}"
},
"attributes": {
"class": "ms-fontColor-themePrimary ms-fontColor-themeDarker--hover"
},
"style": {
"border": "none",
"background-color"...
Code for the JSON Column Formatting:
{
"$schema": "developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "button",
"customRowAction": {
"action": "executeFlow",
"actionParams": "{\"id\": \"Your-Flow-ID\"}"
},
"attributes": {
"class": "ms-fontColor-themePrimary ms-fontColor-themeDarker--hover"
},
"style": {
"border": "none",
"background-color"...
Просмотров: 282
Видео
Power Automate - Pin Actions Update
Просмотров 4742 месяца назад
This short video will present you the latest Microsoft Power Automate update, the option to pin two actions next to each other to be able to easily copy information from a previous action to a new one. Hope this helps! Enjoy :) If you want to learn more about Power Automate in cooperation with SharePoint, you are welcome to follow the channel and subscribe to the playlist here: ruclips.net/chan...
Power BI - How to Mass filter your data
Просмотров 1,3 тыс.3 месяца назад
Todays video is about a special Power BI Visual that you can download for free from the Visuals Store and use it to mass filter your data. Instead of using the conventional Slicer to select the values you want to filter one by one or have to hold down control to be able to select many values, you might have already a list of values you want to filter by. Thats where this awesome slicer comes in...
New Power Apps Control - Toobar🛠️
Просмотров 7833 месяца назад
In todays short video we will explore the newest update from @Microsoft #microsoft in #powerapps, a new control called Toolbar 🛠️. Here you can read a bit more about the new control: learn.microsoft.com/en-us/power-platform/guidance/creator-kit/commandbar Enjoy the video! If you want to learn more about Power Apps in cooperation with SharePoint, you are welcome to follow the channel and subscri...
Microsoft Forms Restrictions 🛑
Просмотров 6173 месяца назад
Todays video is about a new feature in Microsoft Forms, restricions. You now have more control over the answers your users are allowed to enter in your forms. If you want to learn more about Microsoft Forms, you are welcome to follow the channel and subscribe to the playlist here: ruclips.net/p/PLNsXDj3270fvUGZDU1fNiJeZUPfL9EEHv&jct=An2islEsAFAZAVCxHds8SQ Feel Free to follow me on other social ...
Power Apps Canvas - Trigger Output
Просмотров 9524 месяца назад
In todays short video we will explore the newest update from @Microsoft #microsoft in #powerapps, a property Trigger Outputs in Text Input Modern Control. Enjoy the video! If you want to learn more about Power Apps in cooperation with SharePoint, you are welcome to follow the channel and subscribe to the playlist here: ruclips.net/channel/UCPjs69d9ahFE0P-edf5chYQ Feel Free to follow me on other...
Power Apps Canvas - Icons in Buttons
Просмотров 8434 месяца назад
In todays short video we will explore the newest update from @Microsoft#microsoft in #powerapps, a property called Icons in Buttons from the new Modern Controls. Enjoy the video! If you want to learn more about Power Apps in cooperation with SharePoint, you are welcome to follow the channel and subscribe to the playlist here: ruclips.net/channel/UCPjs69d9ahFE0P-edf5chYQ Feel Free to follow me o...
How to Instantly Duplicate SharePoint List Items
Просмотров 4,8 тыс.5 месяцев назад
In todays video we will see how to instantly duplicate a SharePoint List item directly from the item row. For this very simple Flow we are going to utilize the same JSON Formatting Code we have been using in multiple previous videos showcasing how to trigger a Flow from a SharePoint List Item or Library File Row. Code for the JSON Column Formatting: { "$schema": "developer.microsoft.com/json-sc...
How to extract Excel File *DATA* from SharePoint List Item into Power BI
Просмотров 8215 месяцев назад
Todays use case is dedicated to #sharepoint List Attachments and #powerbi . It is very common, that SharePoint lists might also contain files, attached to them. In this use case scenario the files are all of type #excel and have the same structure. Now we need to somehow connect our SharePoint list to Power BI and extract the data from each of the excel files in each of the SharePoint list item...
Learn How to Add Up Values in a For-Each Loop
Просмотров 2666 месяцев назад
In this video we are going through a couple of concepts. First we will learn how to count how many items are returning when you do a get items or send a get request over the http connector to SharePoint. This is usefull to validate if the request is sending any items at all and if yes to see how many. It can be used in varius occasions. Second we will learn how to add values from each loop run ...
How to Trigger a Flow from a SharePoint Library File
Просмотров 1,8 тыс.6 месяцев назад
In this video we will do something similar like the one a while back, where we learned how to trigger a Flow from a SharePoint list item sending its data and Attachments via Email. Only this time, we are doing it in a SharePoint library. To achieve that we are going to use the "For a specific File" trigger, this will allow as to send the data when we manually select a specific file in the libra...
Microsoft Forms directly from SharePoint Online List! 😮
Просмотров 8336 месяцев назад
In todays video we are going to explore the new feature in SharePoint online called "Forms". What this allowes us is to directly create Forms from our SharePoint list that are automaticaly synced with the list and all submitted data is instantly in the list. This new feature makes the need of creating a Form outside of SharePoint unecessary if you are using it for internals. As for externals th...
Power BI Table to HTML & PDF
Просмотров 6866 месяцев назад
In todays video we will explore how to export data from a Power BI Report to Power Automate, convert it into HTML to then be able to covert it to an Email body or a PDF file. This idea came to me as I was preparing for the 2024 ColourCloud event where I presented this topic. The Power Automate connector in Power BI still after over 2 years has many limitations and I hope @Microsoft will show it...
Copy Data from Multiple Lists into One
Просмотров 4,3 тыс.8 месяцев назад
Welcome to my next video! Today we are going to see how we can write from 2 SharePoint lists data into a third one in the same row! Imagine writing data in different #sharepoint lists for an onboarding process. List 1 is about the devices the employee is going to get and list 2 is about software or maybe a company car, whatever. You need that data to be consolidated into one Master List but of ...
Power BI - Show Multiselect Column Values in 1 Row!
Просмотров 3,1 тыс.8 месяцев назад
Todays video is a follow up on a previous video of mine where I showcase how to show People Picker columns from SharePoint lists in Power BI. This time we show not only People Picker but also multiselect Choice Columns and we spice it up by showcasing all values inside a single row, to eliminate the creation of duplicates. Here is the code for expanding the table row from the People Picker colu...
Power Automate - Who triggered the Flow?🔍
Просмотров 1,4 тыс.8 месяцев назад
Power Automate - Who triggered the Flow?🔍
Customize SharePoint Lists with Plumsail Forms 🤩
Просмотров 6609 месяцев назад
Customize SharePoint Lists with Plumsail Forms 🤩
How to Preview Power BI Reports in SharePoint and OneDrive
Просмотров 1 тыс.9 месяцев назад
How to Preview Power BI Reports in SharePoint and OneDrive
3 SharePoint Mistakes you must avoid
Просмотров 1989 месяцев назад
3 SharePoint Mistakes you must avoid
Talking about Future Tech. With Vesa Nopanen and Ami Diamond
Просмотров 349 месяцев назад
Talking about Future Tech. With Vesa Nopanen and Ami Diamond
Interview with Andre Lage & Ami Diamond
Просмотров 829 месяцев назад
Interview with Andre Lage & Ami Diamond
All you need to know about the NEW Power Automate Designer!
Просмотров 26610 месяцев назад
All you need to know about the NEW Power Automate Designer!
Get SharePoint Version History with Power Automate
Просмотров 7 тыс.10 месяцев назад
Get SharePoint Version History with Power Automate
From Plumsail Public Forms to SharePoint List
Просмотров 1,7 тыс.10 месяцев назад
From Plumsail Public Forms to SharePoint List
When a Microsoft FTE, a Microsoft MVP and a Microsoft Business Consultant sit together for a chat...
Просмотров 6310 месяцев назад
When a Microsoft FTE, a Microsoft MVP and a Microsoft Business Consultant sit together for a chat...
Book Review & Givaway: "Automate Testing for Power Apps"
Просмотров 119Год назад
Book Review & Givaway: "Automate Testing for Power Apps"
Power BI: How to Combine Multiple Excel Files in one table
Просмотров 11 тыс.Год назад
Power BI: How to Combine Multiple Excel Files in one table
Generate & Merge PDF from Microsoft Forms
Просмотров 999Год назад
Generate & Merge PDF from Microsoft Forms
How to Trigger a Flow from a SharePoint List Item
Просмотров 10 тыс.Год назад
How to Trigger a Flow from a SharePoint List Item
Thanks a ton
great~ it works! However, is there any solution so that the image can display on PBI embed PPT?
That should work if the PP Viewers have access to the SP where the images are saved.
Keeep post
i keep getting Action 'Get_items' failed: The expression "eq MasterID" is not valid. Creating query failed. PS i have made the correction you mention at the end so the get Items is pointed at the master list
Hi, did you write the Dynamic Value for the ChildList MasterID eq MasterID? How is your column named?
@@Enea yes ive used the dynamic value from the get items and double checked the colomn names for errors, im stumped ! ive sent you some screenshots :)
@@sambowles79 I'm getting the same thing - I am so close to having this work!! Action 'Get_items' failed: The expression "eq MasterID" is not valid. I even renamed my unique column to MasterID. I watched the whole video too. @sambowles79 any update? @enea
Hi! thank you for the detailed explanation I keep on getting error on the Get Tables action, since I didn't find any "Id" dynamic values I tried putting "body/Id", however I keep on getting bad request and when I try the flow, the file created is not an excel file can you help me on how to resolve this error? Thank you!
Lassen sich die Kommentare auch syncen? Grüße
Mit Sicherheit
@@Enea in dem bestehenden Flow? Oder bedarf es einen Neuen? Habe schon alles versucht. Vielen Dank für deine Videos und Hilfe.
Perfect, thanks for sharing!
Awesome , I Liked it, You are Genius
Hi, nice video 👍🏼 Can you help me? I created a flow in Power Automate. It is called "Create Order". The flow looks like this: A user creates an order in my SharePoint list "Create Order". He also provides his information, such as company details, items, etc. After that, my flow creates a Word document based on a Word document template. Later, this document is also converted to a PDF. Now to the problem: All information is inserted into the word document via quick entry blocks. For example, under one quick block "Items", all items that were entered under the orders are entered. BUT this is not done with paragraphs separating the information, so it looks like (1. Article 2. Article 3. ARTICLE) instead of: 1. Article 2. Article 3. Article Is there a function to separate the information with paragraphs or another solution?
Thanks for the tutorial. I got the flow to work, but I can’t get it to appear in Power Apps because it’s not an ‘instant flow’. I have spent hours trying to work it out and I can’t. What can I change to get this flow to work in Power Apps so I can view the version history in the app?
You need to change the trigger to be „Power Apps“ and at the end of the flow, „Respond to Power Apps“. You also might need to send the ID of the Item you want the Version History from the App
Great video, but how would you transfer the value from the drop-down box or from the list?
Nice overview. Has this version of forms updated yet to include metadata columns. I noticed they are missing on the form if you have them on the list.
Not that I know! Even uploading files is still not possible which I cannot understand why
Is it possible to link the destination list (Second list) with another source list (Master list) just changing the PowerAut flow and mantaining the previous data already syncronized in the destination list? Thank you very much for the video.
It should be possible, you need to be cautious with the ID, if you are bringing data from another list.
@@Enea I'll try it! Thank you
@@Enea Hey! sorry to bother you again! i'm trying to follow step by step your video, i think however it doesn't work with choice columns, can you confirm it?
@@PietroMatteoSalvia I dont know why it should have a limitation based on the column type. What is the problem?
Bhaaiii...!! absolutely genius. Nothing but respect 🫡
Thanks for the great tutorial, it helped me a lot! I have a question, this method still sincronizes the sharepoint list data with the power bi dashboard?
You are welcome. Yes 👍🏻
Would you happen to have a video that sort of reverse engineers this process? I have a policy management tool hosted on a SharePoint Lists. It holds policies for 3 different teams (Team A, Team B, and Team C). Each team is called a segment. I need the data from the Master List to filter into each segments individual Sharepoint List. I have a column on the Master List that identifies the segments. Sometimes a policy can apply to multiple segments. Is this possible?
This video is awesome, however, no matter what I do, I get an error "Action 'Get_items' failed: The expression 01eq MasterID" is not valid. Creating query failed" I used the MasterID dynamic content option, 01 is the naming convention I used for testing purposes. Please help.
Hi Enea. Thanks for this video! Would you know by any chance how to create different conditions to initiate approvals? I.e. for 3 different sectors approval to be requested from 3 different people. For the last sector I even need the split by countries and there different people.
Or change where model exists in data view top left
I find using the drop down in priorities on model view is easier than dragging
You don’t know how much I love you, literally every problem I had using PBI you had a video for it!
Thank you :)
I'm glad you made this video, and it's good that they've done this ... but ... ... I could open ALL my items in the V2 editor ... 😩😓
This was very useful. Thank you.
Thanks for the video - Is there a way to make this work when a column type is 'choice' and you have multiple selections in a single item? When I work through this, the automation turns each separate selection from the 'choice' column into its own item, rather than duplicating them into a single item as they are originally/
You have to combine it with something like this: Power Automate - Update a Multi-Person-Column 👨👩👦👦 ruclips.net/video/xY97aIsEf6Q/видео.html
Huge waste of time, impossible to see his screen and he mumbles. Just incredibly stupid. don't waste your time. There is no help here. Just piss poor
sadly this hasn't worked for me, i'm unsure if its a restriction by my company or something i'm doing wrong, i followed your video entirely but it keeps failing at the get file path using onedrive content i get the following error on the output log { "status": 404, "message": "The resource could not be found.",
Make sure you select the correct path/folder. It looks like you are looking for the file in the wrong location
I am still receiving the same error as mentioned earlier. Could you please perform a test run on your end to check this?
Thank you for the information. Is there anyway to put together data in this manner with folders that have excel files with multiple sheets of the same data but for different projects? The sheets need to have different names, and the tables have to have different names within that excel file. So I am not sure if this is possible. Currently I am bringing them in all individually then merging, but this looks more automated.
It its the same data, then why is it in multiple sheets? 🤔
Same data structure but specific to different projects. Each tab is a different projects tracking data.
Does this work for syncing folders as well? I want to make sure that once I add a file in a folder on one sharepoint site, that it gets added to another folder on another sharepoint site
Sure 👍🏻
Hi the video was super useful but i have a doubt how to handle the scenerios where we delete the items from master list and we want to delete those items in copy list as well
This should be a separate flow with a „When an item is deleted trigger“
Hi, Thanks for this tuto it was very clear and useful I just have a problem, my flow was not found (when I click), I double check and guid is correct. The specificity is this flow is not in default environment but in a specific environment (belonging to main environment). Is there something to add to specify this env? Or another idea why my flow is not found? Thanks Regards Hervé
Hi All, I answer to my question, maybe it can help someone else, you just have to go to your Flow, Export/Get Flow Identifier and paste this (it contain the environment...)
i cant find anything called parentweb url just my parentlist . is there a way around this step
Not that I am aware of
Expand ParentList first
Hallo Enea! Danke für deinen Tipp aus dem anderen Video. Dieses Tutorial hat mich sehr weitergebracht und die Umsetzung hat funktioniert. In meinem Fall verwende ich +10 SP-Listen die alle untereinander kommunizieren sollen. Ich möchte vermeiden, dass sich zwei unterschiedliche Themen miteinander aktualisieren, nur weil sie die gleiche SyncedID haben. Reicht es, wenn ich den Filter erweitere und überprüfen, ob die ID und der Titel identisch sind? In meinem Fall würde der Filter so aussehen: @{triggerBody()?['ID']} eq SyncedID and '@{triggerBody()?['Title']}' eq Title LG
Hi Manuel, das freut mich! Sowas in der Art sollte funktionieren. Allerdings musst du es testen, mit der Anzahl an Listen habe ich es nie getestet und können unvorhergesehene Fehler auftreten
@@Enea da der Filter zwei Regeln hat, die erfüllt sein müssen, denke ich, dass die Einstellung so passen wird und hoffe nicht auf unerwartetes zu stoßen 😀
Ooh, I've been needing flicon io for a while ... thank you for showing it!
nice trick! thank you!
Awesome bro. I spent 2 days trying to figure out a solution to this problem and ultimately found your video that explained it so well. Just one request, can you please explain how does this method work, it worked but I am unable to understand the logic behind the working of SELECT action and then also why did we mention CLAIMS in select action, we could have mentioned anything else.
Happy it worked! The select action is needed because the multipeople picker control in SharePoint expects a table. By using select you create a table in a JSON format with key:value pairs. In this case the key is claims and the values are dynamically populated from the array items. Why we use claims is because the control needs some kind of unique identifier to find the user and that is claims. Havent tested it with display name but I imagine it wont work since display name can be similar between multiple employees, claims cannot. Hope this helps
Great work, very helpful and easy to follow.
how can you set up a flow to delete an item on your destination list when you delete that same item from the source list?
you need to create a separate flow for that with the trigger "When an item is deleted". The rest is similar to this tutorial, find the item with the saved ID from the source list and delete it
Great video. I found a quicker way to do this though. By creating a text column and entering the link to the SharePoint list entry into it. Then changing the column's the data category for the column in Power BI to a URL. It worked for me.
You created the text column in SharePoint? How did you populate it with the link?
@@Enea Right click on the item in the SharePoint List and "Copy Link" then paste it into the text column.
Have fun doing that for thousands of rows...
@@Enea Well I didn't have thousands of rows. Sorry I could not solve your specific problem.
No worries, what I meant is that if you have thousands of rows, this solution is not sustainable. It has to be dynamic otherwise you can directly go to SharePoint and search, takes less time
Lifesaver
Do you have a suggestion on how to include a feature that handles deleting list items? So that when an item is deleted in one of the original lists, the item is also deleted in the overall list.
When an Item is deleted needs to be a separate flow. Might record a video on this since it has been asked too many times. Actually a very straight forward solution
Hi. Thank you for the video. I have a multiple SharePoint lists with at more than 20 choice each… so it is too time consuming. Any other alternative?
What is too time consuming?
In addition to this, I need to extract the date and time from version history, us there a way get it ?!
Sure, anything else?
Is there any way to visualise images in the same row in case there is more than 1 image per entry on Lists?
Not that I know
How can I do that for the version history?
I have videos on SharePoint Version history if that is what you mean
Hi, I need help setting up a real-time sync between two SharePoint libraries using Power Automate. I want to ensure that any changes (edits, new files, deletions) made in one library are automatically reflected in the other. Could you guide me on how to configure this with triggers and actions for seamless integration? Do you have a video on this?
All I read was „I need this“ , „I want that“. No „please“, no „thank you for the work you do“ no nothing… Yes I could guide you to configure this Kimberly and it would take me 35min tops to do it. But I wont
@@Enea Hi Enea, thank you for your time and for the resources you provide. I apologize if my previous message came off the wrong way. I would really appreciate your guidance on how to set up a real-time sync between two SharePoint libraries using Power Automate. I’m new to this, and your expertise would be invaluable. Please let me know if you have any videos or resources that could help. Thank you!
@@Enea I really have been trying my best with my system i wrote steps and it’s still not syncing if you have feedback that would be helpful because i know this is your expertise and your videos are always so excellent. Steps to Create a Sync Flow: 1. Create a New Flow in Power Automate: - Go to [Power Automate] and select "Automated cloud flow” 2.Set the Trigger: - Use the trigger **“When a file is created or modified (properties only)”** for "Library 1". 3. Add Action - Get File Content: - Add the action **“Get file content”** from "Library 1" using the file identifier from the trigger. 4. Add Action - Create File: - Add a **“Create file”** action to "Library 2" using the same file name and content from "Library 1". 5. Set Up Reverse Sync: - Repeat the process, but use "Library 2" as the trigger and "Library 1" as the destination. 6. Test and Adjust: - Test the flow to ensure both libraries sync properly. Once i do this it’s not properly syncing i don’t understand what i could be doing wrong and no one has any tips on this as i looked on RUclips.
Hi, I need help setting up a real-time sync between two SharePoint libraries using Power Automate. I want to ensure that any changes (edits, new files, deletions) made in one library are automatically reflected in the other. Could you guide me on how to configure this with triggers and actions for seamless integration? Do you have a video on this?
awesome - it worked :) many thanks for this great tutorial.
Awesome! Subscribe if you like 😊
Thank you for making this video
You are welcome! Subscribe for more if you like 😊
Hello Enea, Great video on how to remove duplicates. I am trying to remove all instances of duplicates from an excel table from a certain column. For example: example1 example2 example3 example2 And I want to create a flow that will output: example1 example3 how am I able to achieve this?
@Licag : May I request you to have a similar solution to move a Document Library record ( with meta data) to another library as a new item
Just finished the solution, will record the video and publish it this week 👍🏻