![Enea Liçaj](/img/default-banner.jpg)
- 104
- 491 225
Enea Liçaj
Germany
Приєднався 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
Power Automate - Pin Actions Update
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: ua-cam.com/channels/Pjs69d9ahFE0P-edf5chYQ.html
Feel Free to follow me on other social media platforms as well:
linktr.ee/EneaLicaj
Buy me a pizza 🍕- bmc.link/enealicaj
#sharepoint #sharepointonline #powerautomate
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: ua-cam.com/channels/Pjs69d9ahFE0P-edf5chYQ.html
Feel Free to follow me on other social media platforms as well:
linktr.ee/EneaLicaj
Buy me a pizza 🍕- bmc.link/enealicaj
#sharepoint #sharepointonline #powerautomate
Переглядів: 63
Відео
Power BI - How to Mass filter your data
Переглядів 3789 годин тому
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🛠️
Переглядів 53814 днів тому
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 🛑
Переглядів 19128 днів тому
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: ua-cam.com/play/PLNsXDj3270fvUGZDU1fNiJeZUPfL9EEHv.html&jct=An2islEsAFAZAVCxHds8SQ Feel Free to follow me on other ...
Power Apps Canvas - Trigger Output
Переглядів 575Місяць тому
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: ua-cam.com/channels/Pjs69d9ahFE0P-edf5chYQ.html Feel Free to follow me on ot...
Power Apps Canvas - Icons in Buttons
Переглядів 293Місяць тому
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: ua-cam.com/channels/Pjs69d9ahFE0P-edf5chYQ.html Feel Free to follow m...
How to Instantly Duplicate SharePoint List Items
Переглядів 2,2 тис.2 місяці тому
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
Переглядів 4702 місяці тому
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
Переглядів 1473 місяці тому
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
Переглядів 9643 місяці тому
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! 😮
Переглядів 4683 місяці тому
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
Переглядів 3553 місяці тому
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
Переглядів 2,8 тис.5 місяців тому
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!
Переглядів 2,2 тис.5 місяців тому
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?🔍
Переглядів 6865 місяців тому
In this short video I am showcasing how to find the user that triggered the Flow. This can be helpful in many scenarios. Enjoy and thanks for watching! 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: ua-cam.com/channels/Pjs69d9ahFE0P-edf5chYQ.html Feel Free to follow me on other social media...
Customize SharePoint Lists with Plumsail Forms 🤩
Переглядів 5186 місяців тому
Customize SharePoint Lists with Plumsail Forms 🤩
How to Preview Power BI Reports in SharePoint and OneDrive
Переглядів 7376 місяців тому
How to Preview Power BI Reports in SharePoint and OneDrive
3 SharePoint Mistakes you must avoid
Переглядів 1806 місяців тому
3 SharePoint Mistakes you must avoid
Talking about Future Tech. With Vesa Nopanen and Ami Diamond
Переглядів 326 місяців тому
Talking about Future Tech. With Vesa Nopanen and Ami Diamond
Interview with Andre Lage & Ami Diamond
Переглядів 716 місяців тому
Interview with Andre Lage & Ami Diamond
All you need to know about the NEW Power Automate Designer!
Переглядів 2427 місяців тому
All you need to know about the NEW Power Automate Designer!
Get SharePoint Version History with Power Automate
Переглядів 4,5 тис.7 місяців тому
Get SharePoint Version History with Power Automate
From Plumsail Public Forms to SharePoint List
Переглядів 1,2 тис.7 місяців тому
From Plumsail Public Forms to SharePoint List
When a Microsoft FTE, a Microsoft MVP and a Microsoft Business Consultant sit together for a chat...
Переглядів 597 місяців тому
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"
Переглядів 1179 місяців тому
Book Review & Givaway: "Automate Testing for Power Apps"
Power BI: How to Combine Multiple Excel Files in one table
Переглядів 7 тис.9 місяців тому
Power BI: How to Combine Multiple Excel Files in one table
Generate & Merge PDF from Microsoft Forms
Переглядів 8719 місяців тому
Generate & Merge PDF from Microsoft Forms
How to Trigger a Flow from a SharePoint List Item
Переглядів 8 тис.9 місяців тому
How to Trigger a Flow from a SharePoint List Item
Sync Item Attachments between two SharePoint Lists
Переглядів 1,3 тис.10 місяців тому
Sync Item Attachments between two SharePoint Lists
This is exactly what i need for work, but i cannot allow the automate to delete any of the data after its mined into excel. How do i go about that?
Hi - This is such a cool method to filter by list instead of each values. But if we want to sync mass filter across other pages how can we achieve this?
Not possible as standard like with the slicer. You can create a measure which contains the selectedvalue of the mass filter and then place mass filters everywhere on your screens, hide them and place the measure in their fields. Not tested though, just an idea
Tolles Video! Besteht auch die Möglichkeit, wenn ich von Liste A ein Element (zB. Mehrzeiliges Textfeld), in Liste B kopiere und dieses Element in Liste B schon vorhanden ist, dass dieses Element in Liste B nicht neu angelegt wird, sondern das bestehende Element aktualisiert? Bei mir geht es um ein Besprechungsprotokoll, welches mehrere Besprechungen in Folge haben könnte. Und wenn in Liste A neue Datensätze für Liste B dazukommen, dann soll das in Liste B auch aktualisiert werden. Vielen Dank!
Danke, für den Usecase habe ich ein anderes Video. Schau dir das "Sync two SharePoint Lists: A quick and easy guide" bei mir an :)
@@Enea Mach ich, danke dir! 🙂
this is Awesome! found this on linkedIn
Thanks! :)
Is there a way to sync 10 different SharePoint lists to one master list?
There is, but that thing will hunt your dreams
Hi, thanks for the clear guidance, I'm stuck on the append array variable step on power automate workflow. It says enter a valid JSON. I'm though having pretty much the string you showed in video: { "Name":@{item()?['DisplayName']} "ContentBytes":@{body('Get_attachment_content')} } any ideas?
There are JSON validators online, check out if there is an error first. I am currently on vacation, cannot check, sorry
Is there a way to get the Microsoft Forms submitted response URL similar to the "Send me an email receipt of my responses" option. Thank you for sharing.
I have used this tutorial but I cant seem to bring over drop down list fields where mutiple options can be selected into the secondary list. It only brings over 1option. How is this done?
Thank you ❤
Nice. Thank you.
Hallo, sehr gut, du hast das Video bzw. Beschreibung auch in Deutsch ? Danke und Gruß
Danke! Nein, leider nicht, Englisch nur
Can you make a tutorial also on how to highlight duplicate values on the Microsoft list?
thank you it was so helpful have a nice day
I am getting an error when trying to change to API 14. "DataSource.Error: SharePoint: Request failed: The remote server returned an error: (409) Conflict. (Conflict)". Do you know how to fix this?
Hello Enea, In the monitor of my apps I see this error and I couldn't find why, any ideas? Thanks you. “Failure of Office365Outlook.CalendarGetItems: The function ‘CalendarGetItems’ received an invalid value for the parameter ‘table’ because an empty value was passed where it was not expected. Ensure that a valid argument is passed to the function.” that office365Outlook.CalendarGetItems connector is in your dd_Calendar control. I have the same thing and I recieve that error when starting my app.
So helpful. Thank so much.
Hi Enea, Thanks for that video. I tried to play with the command Bar but wasn't able to set any submenu with "ItemHeader" and "ItemParentKey" properties. Did you have chance to build a 2-level command bar yet ?
Thanks! No I also played around with the features before recording and it looks like the funcionality is still pretty limited
@juliens5420 check out this link, the CommandBar with lazy-loading menus looks promissing. developer.microsoft.com/en-us/fluentui#/controls/web/commandbar
Thanks for sharing your knowledge! It was of great help. You gained another subscriber!
Thank you so much!
Great video! Is there a solution to ad several attachments?
Its the same solution, just add more attachments and test it out
Is there any way to synch a SharePoint 2016 OnPrem list with a SPO list in the same way as above ?
Don’t know, not that familiar with SharePoint OnPrem. I guess with a getway and a custom connector everything is possible
Good afternoon. Great and clear process thank you. My list has a lot of columns so I have added the dynamic for each column. However, I'm getting an error - 'Error: Required parameter 'templateId' is missing when I try to use the flow. Is there anything I can check please? I'm fairly new to PA but believe I copied the process correctly, the icon appears etc, but I get the error. Thank you
Did you place the ID of your Flow in the Formatted JSON?
Never mind - I redid it step by step and all sorted. Thank you so much!
Had no idea about the advanced editor! This is a game changer
Very helpful
I have a report created on sharepoint list and the members are present in the list. But when they access the report , it is asking them to upgrade the license. The users are not pro users. To view this does the user needs to be pro user?
Yes! All viewers need at least a Power BI Pro license
Nice! Cheers, Enea. :) Also, there is (hidden) Microsoft Forms at play in the Approvals infrastructure, too. :)
That sounds interessting! Any link for me? :)
@@Enea Just dig into Approvals, maybe doing a web tools on the teams webapp is the best way here. :-)
Thanks for the video.Can we create the powerpoint slide using the same approach?
How to add new table to the source? Like teachers4 Table.
you can create a duplicate of teachers3 Table and change the ID in the advanced editor. You can take the ID from the URL of the List. Then you can add this to the merged list. This is one quick way, there are many ways you can do this.
great. this is what i am looking for to trace changes
Hi, can you link the video where you show how to prompt users to update a field (comment)?
Sorry, I do not understand what you mean? 🤔
Is it possible to start any flow with a flow identifier, and can we send a sharepoint record to the triggered flow from sharepoint
The trigger needs to be the same as in the video. The ID you place in the format column JSON can also be dynamic. All you need is a list of IDs for the user to select from before clicking the button to trigger it
@Enea but if I have 3 sharepoint sites that are using the same flow, is there another trigger that I could use? I want to create a global flow, that could be used by different sharepoint sites
there are workarounds for this. Google and something will come up. Its a bit complicated for a comment
@@lachmankrishen there are workarounds for this. Google and you will find something. I dont have a video for this usecase and explaining it here is impossible
Thanks for the detailed explanation... I tried to create a new flow by following the steps you have mentioned in the video. However, I am getting only one error. Request you to help me to resolve this error (Get_tables --> body --> value is coming blank). Thank you. unable to process template language expressions in action "Set_variable_2" inputs at line '0' and column '0': 'The template expression 'outputs('Get_tables')?['body/value'][0]['Name'] cannot be evaluated because array index '0' cannot be selected from empty array.
It looks like your Excel has no tables. Have you formatted you data in Excel in a table format?
@@Enea Thank again for your swift response. Exactly, I have done the same mistake. I have formatted the data in Excel in a table format and it's working fine now. This video is very helpful :)
it worked. Thanks
Hi, Thank you for the tutorial. I am getting an error - type/format Number/double is not convertible
It looks like you are trying to convert a double type of column to something else. What exactly are you trying to achieve?
Thank you Enea fr saving my life from thorn rose
Dont know who that is but happy I could help
Input parameters: "$filter": "558 eq SyncedID", "viewScopeOption": "RecursiveAll" } Output body: body { "value": [] } Followed this from your video 1 year ago, everything went to shaite since then.
And now?
Very helpful. Thank you!
Bro you just saved me from a helluva lot of work. Seriously, thank god you shared this.
Hi, I have been following this flow you created however Name field in append to string variable is set to be on read only mode. What could be the reason?
I have a question that ive been banging my head against the wall. I have a Ticket # columns that is formula generated in Sharepoint, we have a flow set up to push this formula into a field Text Field in a different sharepoint list. But then i need to update certain fields back in Original List and the update doesnt run when i do the filter query + the lenght portion.
Do you get any results from the filter query response?
@@Enea no it doesnt even trigger the modify action even when i manually trigger a change in the list.
In my case the attachment is true false ... Did I something wrong? or may I change the type? Thx in advance ... Christoph P.S.: I choosed the wrong column ... I have to choose AtachmentFiles :-) Thx for sharing your vid :-)
Happy you could solve it by yourself! :)
Nice content @Enea, I would like to ask How to connect the powerapps to Azure sql database via AAD and my tenancy in Azure is guest account. I am having problem like Login failed for user '<token-identified principal>'. The server us bit currently configured to accept this token.
Great, thank you very much!
Amazing, thank you for sharing!
Hi Enea. Ich hab ein kleines Problem. Und zwar habe ich dein Tutorial mit den 2 synced Sharepoint Lists verfolgt. Funktioniert alles wunderbar, nur habe ich ein kleines Problem. Ich habe bei einem Reiter eine Dropdown Auswahl, also mehrere Elemente. Für das wird je eine column erstellt, z. B. Test A mit Abz Department Und Test A mit Exz Department Wie kann ich das fixen? Kannst du mir helfen? Ich hab dich auch via linked In angefragt. Kann dir da auch ein Abbild zukommen lassen.
Hi! Ich dachte die Frage war bezüglich dieses Video. Ja meld dich auf LinkedIn und ich schaue mir das an. Kann aber nichts am Rechner testen, bin gerade im Urlaub
Hi Enea. Danke für deine Rückmeldung. Ich glaub ich hab’s gefixed. Jedoch werden die Daten nicht richtig angezeigt warum auch immer. Melde mich via LinkedIn 🙏🏽
@@Enea
Hi! is it possible to add action button for each row in table? I need to perform some action when click button (send POST request or trigger PA flow)
Check out this video: Power BI Table to HTML & PDF ua-cam.com/video/ROGmHdAYFH8/v-deo.html , one of the responses from Power BI integration allows you to do a per row action. Remember you only get 1000 rows
@@Enea Thanks!
It worked perfectly, thanks a lot
This helped me realised it was Outcome I needed to use for the Conditions Thank you very much
I'm finding it an issue to transfer the text now from the input to a SharePoint file. If I don't wait long enough or move to another part of the app, it will only partially upload the text or nothing at all.
Have you tried using one of the other properties? The key press option should transfer the text immediately as you see in the video
is there a file upload option available ?
Unfortunately not yet, only via the „old way“ over Forms and then transferring the data via Power Automate