Enea Liçaj
Enea Liçaj
  • 104
  • 491 225
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
Переглядів: 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!
NEW Forms Live Data to Excel!!! 🤯
Переглядів 5637 місяців тому
NEW Forms Live Data to Excel!!! 🤯
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

КОМЕНТАРІ

  • @nickbadalamenti3854
    @nickbadalamenti3854 4 години тому

    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?

  • @laxminayak2641
    @laxminayak2641 День тому

    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?

    • @Enea
      @Enea 10 годин тому

      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

  • @Manuel00109
    @Manuel00109 День тому

    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!

    • @Enea
      @Enea День тому

      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 :)

    • @Manuel00109
      @Manuel00109 День тому

      @@Enea Mach ich, danke dir! 🙂

  • @Tech2188
    @Tech2188 3 дні тому

    this is Awesome! found this on linkedIn

    • @Enea
      @Enea День тому

      Thanks! :)

  • @andrewmaybir352
    @andrewmaybir352 4 дні тому

    Is there a way to sync 10 different SharePoint lists to one master list?

    • @Enea
      @Enea 4 дні тому

      There is, but that thing will hunt your dreams

  • @MikkoKemppainen-p2s
    @MikkoKemppainen-p2s 6 днів тому

    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?

    • @Enea
      @Enea 6 днів тому

      There are JSON validators online, check out if there is an error first. I am currently on vacation, cannot check, sorry

  • @moyura2
    @moyura2 8 днів тому

    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.

  • @moniquefoy997
    @moniquefoy997 10 днів тому

    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?

  • @newstown2741
    @newstown2741 11 днів тому

    Thank you ❤

  • @SierraSlopes
    @SierraSlopes 14 днів тому

    Nice. Thank you.

  • @stefanwolff1337
    @stefanwolff1337 15 днів тому

    Hallo, sehr gut, du hast das Video bzw. Beschreibung auch in Deutsch ? Danke und Gruß

    • @Enea
      @Enea 15 днів тому

      Danke! Nein, leider nicht, Englisch nur

  • @ronamyzacarias4110
    @ronamyzacarias4110 16 днів тому

    Can you make a tutorial also on how to highlight duplicate values on the Microsoft list?

  • @alifathi6072
    @alifathi6072 17 днів тому

    thank you it was so helpful have a nice day

  • @AmaEliggi
    @AmaEliggi 17 днів тому

    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?

  • @kuroilotus
    @kuroilotus 17 днів тому

    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.

  • @PennyDillon-c3f
    @PennyDillon-c3f 17 днів тому

    So helpful. Thank so much.

  • @juliens5420
    @juliens5420 18 днів тому

    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 ?

    • @Enea
      @Enea 17 днів тому

      Thanks! No I also played around with the features before recording and it looks like the funcionality is still pretty limited

    • @Enea
      @Enea 17 днів тому

      @juliens5420 check out this link, the CommandBar with lazy-loading menus looks promissing. developer.microsoft.com/en-us/fluentui#/controls/web/commandbar

  • @prfogaca100
    @prfogaca100 18 днів тому

    Thanks for sharing your knowledge! It was of great help. You gained another subscriber!

  • @henriquedh
    @henriquedh 20 днів тому

    Thank you so much!

  • @s.m.7374
    @s.m.7374 24 дні тому

    Great video! Is there a solution to ad several attachments?

    • @Enea
      @Enea 21 день тому

      Its the same solution, just add more attachments and test it out

  • @bashyarajanaravazhi5634
    @bashyarajanaravazhi5634 24 дні тому

    Is there any way to synch a SharePoint 2016 OnPrem list with a SPO list in the same way as above ?

    • @Enea
      @Enea 24 дні тому

      Don’t know, not that familiar with SharePoint OnPrem. I guess with a getway and a custom connector everything is possible

  • @lisakirkland7391
    @lisakirkland7391 25 днів тому

    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

    • @Enea
      @Enea 25 днів тому

      Did you place the ID of your Flow in the Formatted JSON?

    • @lisakirkland7391
      @lisakirkland7391 24 дні тому

      Never mind - I redid it step by step and all sorted. Thank you so much!

  • @therealjohnshelburne
    @therealjohnshelburne 25 днів тому

    Had no idea about the advanced editor! This is a game changer

  • @shubhabratadey
    @shubhabratadey 28 днів тому

    Very helpful

  • @DathaReddy
    @DathaReddy 28 днів тому

    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?

    • @Enea
      @Enea 28 днів тому

      Yes! All viewers need at least a Power BI Pro license

  • @ukm365
    @ukm365 29 днів тому

    Nice! Cheers, Enea. :) Also, there is (hidden) Microsoft Forms at play in the Approvals infrastructure, too. :)

    • @Enea
      @Enea 29 днів тому

      That sounds interessting! Any link for me? :)

    • @ukm365
      @ukm365 29 днів тому

      @@Enea Just dig into Approvals, maybe doing a web tools on the teams webapp is the best way here. :-)

  • @komailbutt2998
    @komailbutt2998 Місяць тому

    Thanks for the video.Can we create the powerpoint slide using the same approach?

  • @monikas7797
    @monikas7797 Місяць тому

    How to add new table to the source? Like teachers4 Table.

    • @Enea
      @Enea 28 днів тому

      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.

  • @Stevencyw88
    @Stevencyw88 Місяць тому

    great. this is what i am looking for to trace changes

  • @EmilyForristel
    @EmilyForristel Місяць тому

    Hi, can you link the video where you show how to prompt users to update a field (comment)?

    • @Enea
      @Enea Місяць тому

      Sorry, I do not understand what you mean? 🤔

  • @lachmankrishen
    @lachmankrishen Місяць тому

    Is it possible to start any flow with a flow identifier, and can we send a sharepoint record to the triggered flow from sharepoint

    • @Enea
      @Enea Місяць тому

      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

    • @lachmankrishen
      @lachmankrishen Місяць тому

      @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

    • @Enea
      @Enea Місяць тому

      ​​⁠there are workarounds for this. Google and something will come up. Its a bit complicated for a comment

    • @Enea
      @Enea Місяць тому

      @@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

  • @ManikanaRangaiah
    @ManikanaRangaiah Місяць тому

    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.

    • @Enea
      @Enea Місяць тому

      It looks like your Excel has no tables. Have you formatted you data in Excel in a table format?

    • @ManikanaRangaiah
      @ManikanaRangaiah Місяць тому

      @@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 :)

  • @Sandeepkumar-s2y8e
    @Sandeepkumar-s2y8e Місяць тому

    it worked. Thanks

  • @Akkkk855
    @Akkkk855 Місяць тому

    Hi, Thank you for the tutorial. I am getting an error - type/format Number/double is not convertible

    • @Enea
      @Enea Місяць тому

      It looks like you are trying to convert a double type of column to something else. What exactly are you trying to achieve?

  • @mfarzan-u3b
    @mfarzan-u3b Місяць тому

    Thank you Enea fr saving my life from thorn rose

    • @Enea
      @Enea Місяць тому

      Dont know who that is but happy I could help

  • @rolaogomes
    @rolaogomes Місяць тому

    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.

    • @Enea
      @Enea Місяць тому

      And now?

  • @MrDcdc2323
    @MrDcdc2323 Місяць тому

    Very helpful. Thank you!

  • @ViniciusBarbosa-yt8sj
    @ViniciusBarbosa-yt8sj Місяць тому

    Bro you just saved me from a helluva lot of work. Seriously, thank god you shared this.

  • @bintenasir7
    @bintenasir7 Місяць тому

    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?

  • @mxbcreative
    @mxbcreative Місяць тому

    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.

    • @Enea
      @Enea Місяць тому

      Do you get any results from the filter query response?

    • @mxbcreative
      @mxbcreative Місяць тому

      @@Enea no it doesnt even trigger the modify action even when i manually trigger a change in the list.

  • @christophmeirich5928
    @christophmeirich5928 Місяць тому

    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 :-)

    • @Enea
      @Enea Місяць тому

      Happy you could solve it by yourself! :)

  • @silencyo2353
    @silencyo2353 Місяць тому

    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.

  • @wtstara
    @wtstara Місяць тому

    Great, thank you very much!

  • @KrzysztofAchinger-y8z
    @KrzysztofAchinger-y8z Місяць тому

    Amazing, thank you for sharing!

  • @SpaceNerdUffi
    @SpaceNerdUffi Місяць тому

    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.

    • @Enea
      @Enea Місяць тому

      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

    • @SpaceNerdUffi
      @SpaceNerdUffi Місяць тому

      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 🙏🏽

    • @divyagoel8265
      @divyagoel8265 Місяць тому

      @@Enea

  • @seatconnect224
    @seatconnect224 Місяць тому

    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)

    • @Enea
      @Enea Місяць тому

      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

    • @seatconnect224
      @seatconnect224 Місяць тому

      @@Enea Thanks!

  • @arthurandrade98
    @arthurandrade98 Місяць тому

    It worked perfectly, thanks a lot

  • @Mo-.-man101
    @Mo-.-man101 Місяць тому

    This helped me realised it was Outcome I needed to use for the Conditions Thank you very much

  • @sojuturnip
    @sojuturnip Місяць тому

    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.

    • @Enea
      @Enea Місяць тому

      Have you tried using one of the other properties? The key press option should transfer the text immediately as you see in the video

  • @TateSpirit
    @TateSpirit Місяць тому

    is there a file upload option available ?

    • @Enea
      @Enea Місяць тому

      Unfortunately not yet, only via the „old way“ over Forms and then transferring the data via Power Automate