Enea Liçaj
Enea Liçaj
  • Видео 97
  • Просмотров 418 748
How to extract Excel File *DATA* from SharePoint List Item into Power BI
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 items. Tricky!
Link to community solution: community.fabric.microsoft.com/t5/Power-Query/Get-and-Transform-Excel-files-from-SharePoint-list/td-p/2161750
Enjoy!
If you want to learn more about Power BI, you are welcome to follow the channel and subscribe to the Power BI playlist here:
ruclips.net/p/PLNsXDj3...
Просмотров: 62

Видео

Learn How to Add Up Values in a For-Each Loop
Просмотров 6514 часов назад
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
Просмотров 429День назад
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 and Power Automate break up!
Просмотров 31914 дней назад
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
Просмотров 16714 дней назад
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
Просмотров 1,3 тыс.2 месяца назад
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!
Просмотров 9192 месяца назад
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?🔍
Просмотров 2942 месяца назад
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: ruclips.net/channel/UCPjs69d9ahFE0P-edf5chYQ Feel Free to follow me on other social media pl...
Customize SharePoint Lists with Plumsail Forms 🤩
Просмотров 3813 месяца назад
Todays video is all about @Plumsail Forms for SharePoint Online! Last video we tried out Plumsail Public Forms and saw how you can create a custom Form to share with employees or customers and gather data in a way that fits your organization 100%. After setting up the Forms UI for the target audience, we went and built a SharePoint list to save the responses. Typical scenario. The special part ...
How to Preview Power BI Reports in SharePoint and OneDrive
Просмотров 4073 месяца назад
Last year Microsoft presented a new feature in preview, the ability to view Power BI Reports in full interactive mode in SharePoint or OneDrive. We have always been able to embed a Power BI Report in a SharePoint Page or in Teams, but with the file saved in a SharePoint library or OneDrive folder, you always had to download the file to open it in Power BI Desktop. Now you can easily click on th...
3 SharePoint Mistakes you must avoid
Просмотров 1483 месяца назад
In todays episode Ami and I invited Dougie, a Microsoft MVP and SharePoint expert to speak about his journey to becoming an MVP, his career and his amazing RUclips Channel. Stick around to find out what 3 mistakes you must avoid when working with SharePoint and the Power Platform. Where you can find Dougie: LinkedIn: www.linkedin.com/in/dougie-wood-sharepoint-consultant/ RUclips: ruclips.net/ch...
Talking about Future Tech. With Vesa Nopanen and Ami Diamond
Просмотров 303 месяца назад
On the next episode, Ami and I invited Vesa to talk about Microsoft Teams, Microsoft Metaverse and of course Microsoft Power Platform. Enjoy! Kanalmitglied werden und exklusive Vorteile erhalten: ruclips.net/channel/UCPjs69d9ahFE0P-edf5chYQjoin
Interview with Andre Lage & Ami Diamond
Просмотров 653 месяца назад
In this episode @SharePointWizard and myself are hosting André Lage, one of the most experienced SharePoint guys of the community out there. We are talking about Microsoft #copilot, the #powerplatform and of course #sharepoint. Especially SharePoint, since André is a master on column formatting and has been doing some amazing stuff which he is showcasing in the call. Enjoy! Kanalmitglied werden...
All you need to know about the NEW Power Automate Designer!
Просмотров 2074 месяца назад
The new Power Automate Designer has been out for a while now and I always wanted to record a comparison video between the two. What to expect: - Intro to the new Power Automate Designer - What is new - What is missing - What it can do better and what not Enjoy and thanks for watching! If you want to learn more about Power Automate in cooperation with SharePoint, you are welcome to follow the ch...
NEW Forms Live Data to Excel!!! 🤯
Просмотров 4804 месяца назад
Microsoft just announced a new feature in #microsoftforms allowing you to create a live connection to an #excel file in your #onedrive and instantly view the submitted data. When I say instand, it is instant! Pretty amazing stuff. In todays video I am showing you how to use it and also sharing my thoughts when you compare it to a feature we already had for a long time, to start a Form from Exce...
Get SharePoint Version History with Power Automate
Просмотров 2,4 тыс.4 месяца назад
Get SharePoint Version History with Power Automate
From Plumsail Public Forms to SharePoint List
Просмотров 7504 месяца назад
From Plumsail Public Forms to SharePoint List
When a Microsoft FTE, a Microsoft MVP and a Microsoft Business Consultant sit together for a chat...
Просмотров 574 месяца назад
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"
Просмотров 1156 месяцев назад
Book Review & Givaway: "Automate Testing for Power Apps"
Power BI: How to Combine Multiple Excel Files in one table
Просмотров 3,5 тыс.6 месяцев назад
Power BI: How to Combine Multiple Excel Files in one table
Generate & Merge PDF from Microsoft Forms
Просмотров 6916 месяцев назад
Generate & Merge PDF from Microsoft Forms
How to Trigger a Flow from a SharePoint List Item
Просмотров 5 тыс.6 месяцев назад
How to Trigger a Flow from a SharePoint List Item
Sync Item Attachments between two SharePoint Lists
Просмотров 9037 месяцев назад
Sync Item Attachments between two SharePoint Lists
Skip Apply to Each Loop from Parse JSON Action
Просмотров 1327 месяцев назад
Skip Apply to Each Loop from Parse JSON Action
Power Automate: How to Automate SharePoint File Indexing
Просмотров 6757 месяцев назад
Power Automate: How to Automate SharePoint File Indexing
Check if a SharePoint folder exists, generate share link
Просмотров 2,7 тыс.8 месяцев назад
Check if a SharePoint folder exists, generate share link
Save Forms in Teams Channel with Attachment
Просмотров 1,3 тыс.8 месяцев назад
Save Forms in Teams Channel with Attachment
Power BI - Load Multiple SharePoint Lists In one table!
Просмотров 3,8 тыс.8 месяцев назад
Power BI - Load Multiple SharePoint Lists In one table!
Create a Custom Dynamic Index Column in SharePoint 🧾
Просмотров 1,4 тыс.8 месяцев назад
Create a Custom Dynamic Index Column in SharePoint 🧾
📊Power BI: SharePoint List - Image Columns
Просмотров 4,7 тыс.10 месяцев назад
📊Power BI: SharePoint List - Image Columns

Комментарии

  • @louisetayler8090
    @louisetayler8090 2 дня назад

    Why can't I get this to work - I've followed it to the letter. I am getting "apply to each" for yes and no - which I notice didn't happen with your demo.

    • @Enea
      @Enea 2 дня назад

      Make sure you use the dynamic values from the right outputs. Sometimes when they are named the same, but come from different outputs in your flow. This might be causing the unwanted apply to each…

  • @jsacht4275
    @jsacht4275 3 дня назад

    Hi I am getting an error message “enter a valid JSON” when trying to use the schema function. Also when I run my test and view the output I don’t see the specific outputs with their input alone I only see the body section.

    • @Enea
      @Enea 3 дня назад

      Where are you copying the JSON from? In my tutorial I am taking it from the upload file question.

    • @jsacht4275
      @jsacht4275 2 дня назад

      @@Enea I am also taking it from the upload file question. It seems that when I copy the upload files questions JSON it is giving an error as all the copied text shows up red.

    • @Enea
      @Enea 2 дня назад

      @@jsacht4275 sorry but I cannot tell from here what you are doing wrong. Check out the video again, what I am doing is, I am copying the whole response from the upload file question. Otherwise paste it in ChatGPT and tell it to fix your JSON. Probably you are missing a bracket or something

  • @ericalborgers
    @ericalborgers 4 дня назад

    thank you so very much. This is exactly what i have been searching for in order to complete a work task.

  • @yungga2281
    @yungga2281 5 дней назад

    Can i do from words to sharepoint list?

    • @Enea
      @Enea 3 дня назад

      Yes you can, try converting the file to an xml file (just change the ending from .docx to .xml via Power Automate) and then you can extract the values with a xml function in a compose action in Power Automate. After you have the values you can save them in a SharePoint List

    • @yungga2281
      @yungga2281 3 дня назад

      Thank you!

  • @elymeireles2417
    @elymeireles2417 6 дней назад

    Que top, resolvido meu problema, obrigado

  • @babhiemiao
    @babhiemiao 6 дней назад

    I'm integrating a sharepointlist that was used as a file repository and I need powerBI to pick up the excel file so that powerBI can do transformation to the data in the Sharepoint List attachment and create an output file. What would you recommend I can do?

    • @Enea
      @Enea 3 дня назад

      Check out my newest video coming out tomorrow 9AM (Europe Timezone) ;)

  • @janicemendoza376
    @janicemendoza376 9 дней назад

    Hi! Great work! 🎉🎉🎉 Will this work with a flow with multi person column as approvers in terms of updating if an approver on this column is away based on another SP list called delegation? Appreciate ypur help!

    • @Enea
      @Enea 9 дней назад

      Can you explain a bit more? Not sure if I understood it right

    • @janicemendoza376
      @janicemendoza376 8 дней назад

      @@Enea Thanks for your reply! :) I have 2 SP Lists, main list is a Request and the other Delegation list (approvers log their time away here). I have a flow that triggers when a new item is created or modified (on the main list) sends approval to the approvers (multi-select person column) in the order their names where added. I use Start and Wait for Approval - first to respond. I want to check if the first approver is away using the Delegation list (columns here are delegate to single-person column, start date, end date, crated by). If yes get the assigned backup and update my main list multi-person column. Repeat this step for all the next approvers. Appreciate your help! I’m stuck here. 🙏

    • @Enea
      @Enea 8 дней назад

      @@janicemendoza376 of course you can do that. I am not sure how to help you though, since doing a video about such a (more or less) complicated and very specific use case, wont be much of a use to the majority on my channel…

    • @janicemendoza376
      @janicemendoza376 8 дней назад

      No worries. It does sound possible just haven’t found the right formula just yet. Thanks for sharing knowledge on your channel!

    • @Enea
      @Enea 8 дней назад

      @@janicemendoza376 I might do a video on a topic that goes on that direction though, not sure when to be honest, a lot going on at the moment. Stay tuned :)

  • @kwilliams1130
    @kwilliams1130 10 дней назад

    What is the Filter Query at 12:14, file ref?

    • @Enea
      @Enea 9 дней назад

      FileLeafRef

  • @Trysomieflexntjes
    @Trysomieflexntjes 10 дней назад

    Thank you for this. You helped me with a solution for a client i got.

  • @sandeshkhilari1990
    @sandeshkhilari1990 11 дней назад

    I'm using similar data its working but when i'm using data with appended data then owners detail coming as blank. I have 10 shp where owners data coming but 1 tsharepoint using people format to update name which is not coming. Can you try with your same data and append data with another shp and try owner name is coming or not

  • @pallavis3675
    @pallavis3675 11 дней назад

    Hey, I have written same logic in my flow. However the date adding in the form was 1 day back. Any idea?

    • @Enea
      @Enea 11 дней назад

      No sure, but I would quick fix it in Power Automate by adding on day 🤷🏻‍♂️

  • @JO-fr7jt
    @JO-fr7jt 12 дней назад

    Hi, can you please advise if this works like the below; User submits form Form creator gets notified and link provided and stored in the applicable teams folder User saves file to PDF OR is the PDF created automatically on submit? User then saves or drags PDF to a workflow sequence held in a HR system from which the form is generated from via a link?

  • @chairattangthong
    @chairattangthong 15 дней назад

    you are the best.. thank you so much Teacher.

  • @gregcapoferri5055
    @gregcapoferri5055 15 дней назад

    Delete the column in the list to remove the question from the form. You're working with a list now, not a form.

    • @Enea
      @Enea 15 дней назад

      I did, was still there. Think its a bug

  • @bitchybhayia6066
    @bitchybhayia6066 16 дней назад

    What it is want to change something in secondary list and sync changes in master list and lets say i have multiple secondary list and one master list and which has all the data of all the other list and which ever secondary list i modify will synch changes in master list or the other way around?

    • @Enea
      @Enea 16 дней назад

      Doable, but you need multiple such flows. And you need to make sure they dont trigger each other infinitely

  • @benedikt8731
    @benedikt8731 17 дней назад

    Will this method work if I am trying to have mutiple lists feeding updates into a single main list?

    • @Enea
      @Enea 17 дней назад

      I have another video about this use case. Check out it must be unter the latest videos

  • @ukm365
    @ukm365 17 дней назад

    Huh. Well, I can make them ... but I can't seem to actually use the form that I made. :(

    • @Enea
      @Enea 17 дней назад

      What do you mean you cannot use them?

    • @ukm365
      @ukm365 11 дней назад

      @@Enea I'm not sure, but essentially, the form gets made, but is not shareable. Not to worry, though, I think I have a workaround. ;-)

    • @ukm365
      @ukm365 11 дней назад

      @@Enea Also, I've noticed that my Lookup Columns are basically pointless in these forms. 😩

    • @Enea
      @Enea 9 дней назад

      @@ukm365 I know :(

  • @moyura2
    @moyura2 18 дней назад

    Thanks for sharing.

  • @julianatabosa2399
    @julianatabosa2399 18 дней назад

    Hey Enea, Thank you so much for the video, very insightful. However, I'm having some difficulties... I created an app in powerapps to submit information in a form format, the user is able to upload pictures, which are saved as attachments. I want o connect my online SP list to PBI, and display my pictures in a table... since the pictures are saved as attachments but not in a column in the List, PBI is not reading the data. Do you know what I could do to fix this?

  • @brightideasagency
    @brightideasagency 18 дней назад

    Great overview

  • @paulordonez5266
    @paulordonez5266 20 дней назад

    Hi @Enea great video, this worked perfect. One question, what about if the item is deleted in the parent list? Do I need to create a separate flow?

    • @Enea
      @Enea 20 дней назад

      Hi, thanks, happy it worked! Yes, in that case you would need a separate flow with the “when an item is deleted” trigger

  • @crosnerd
    @crosnerd 24 дня назад

    Everything saves correctly, but when I try to run the flow, I get a MethodNotAllowed error on the HTTP action, with error code 405. Do you have any idea why this error might be showing up or how to fix it? Thanks

  • @bernadettealvarado6804
    @bernadettealvarado6804 26 дней назад

    Awesome video! Saved me from doing some trial and error. Thank you so much!

  • @user-jm8mf5nt3p
    @user-jm8mf5nt3p 26 дней назад

    how we do when we delete item?

    • @Enea
      @Enea 25 дней назад

      Deleting needs a separate flow since you need the „When an item is deleted“ trigger

    • @eduardocapaneli1141
      @eduardocapaneli1141 10 дней назад

      @@Enea CAN YOU MAKE A VIDEO EXPLAINING IT?

    • @Enea
      @Enea 9 дней назад

      @@eduardocapaneli1141 I dont think that is necessary. It might be the simplest flow in the world. 1. Step: When an item is deleted 2. Step: Get item (here you use the item ID from the trigger, the one that was deleted, to find the same item in the second list. 3. Step: Delete item by using the ID from the Get item action

    • @eduardocapaneli1141
      @eduardocapaneli1141 4 дня назад

      @@Enea obligatory, it worked perfectly

  • @yoleus
    @yoleus Месяц назад

    Hi, This solution results in a dynamic data source which cannot be refreshed by the Power BI service as a scheduled refresh. Is there a way around this?

  • @user-mq9xk4sc8y
    @user-mq9xk4sc8y Месяц назад

    Hi, do you know how I can add the visualisation as a report in a SharePoint web part. Basically, on another page within the same SharePoint site, I want to add the PowerBI integrated to a SharePoint list as a web part. Any advice would be much appreciated

    • @Enea
      @Enea Месяц назад

      You cannot add it as a webpart in a SharePoint List. Only in a SharePoint Page. There is a webpart called Power BI. You need to copy the embed link from Power BI service first

    • @user-mq9xk4sc8y
      @user-mq9xk4sc8y Месяц назад

      @@Enea yes indeed. I intend to add it as a web part, but I can’t cause I can’t get a report link that works if the Power BI report was generated directly from the SP list integration

  • @user-zw2hl3pv8n
    @user-zw2hl3pv8n Месяц назад

    I don't have ParentWebURL...?

    • @user-zw2hl3pv8n
      @user-zw2hl3pv8n Месяц назад

      Oh weird, I had ParentList, I have to expand that, and then I had it in there... The way you show it in the video, it looks like it's in the items drop down, but you expand it and then expand again...

  • @FareedAhmed-hg9is
    @FareedAhmed-hg9is Месяц назад

    Thanks for the video, but if the document is not uploaded, the workflow is failed, any idea how to fix it?

    • @Enea
      @Enea Месяц назад

      You can add a condition to check the length of the body where the document is supposed to be. If its 0 then there is no doc there and you can do something else. If is greater than 0 then do the upload process

    • @FareedAhmed-hg9is
      @FareedAhmed-hg9is Месяц назад

      @@Enea Thanks for the swift reply. Can you please share more details, where and how can I put this condition as I am new to this platform. Thanks

  • @ChinpoSamurai-ih9rk
    @ChinpoSamurai-ih9rk Месяц назад

    Thanks. This worked perfectly.

  • @careyjohnson6630
    @careyjohnson6630 Месяц назад

    This is a great lesson. I learned a lot from this. Thank you for explaining all the fundamentals while you go along.

    • @Enea
      @Enea Месяц назад

      Thanks for your comment! Happy I could help! Subscribe if you like

  • @rovanmohamed9280
    @rovanmohamed9280 Месяц назад

    You are Genuious

  • @sasesi
    @sasesi Месяц назад

    The "add row into a table failes, due ´to the "A value must be provided for item. clientRequestId: 1ca8dc9d-5dab-4bec-9ee8-a960dd37f219" Does it mean this will fail if there are some empty values?

    • @Enea
      @Enea Месяц назад

      Probably, you can add a condition checking if the value is empty first to catch the error

  • @AbhishekGuptaDoha
    @AbhishekGuptaDoha Месяц назад

    I am struggling. Only one sheet shows in the new table and not both sheets

  • @PeterPannekoek1850
    @PeterPannekoek1850 Месяц назад

    Pro tip: watch in Speed 2x

    • @Enea
      @Enea Месяц назад

      Amazing life hack

  • @jbjk445
    @jbjk445 Месяц назад

    I have a flow that does the same thing but inside it has an array that contains members of a list field of type person, I need to know which users were added new in the last edition, how can I do that? Thank you so much.

  • @alondraespinal5115
    @alondraespinal5115 Месяц назад

    Hello, thank you for the video. Do you have any tips on how to add the results of the version history to a second sharepoint list ? The second SP list will be like a tracker of all changes.

    • @Enea
      @Enea 19 дней назад

      You can create an item in that SharePoint List for every version you get back in your power automate flow. Keep in mind that the list will grow very fast and might become even unusable. Consider saving only the necessary things and maybe in a proper database

  • @chrisl8592
    @chrisl8592 Месяц назад

    What about autosyncing different libraries (one-way) each in a seperate sharepoint site ?

  • @Shmank
    @Shmank Месяц назад

    Thank you Enea! This is the second time you have solved a problem for me. I appreciate your teaching style. Cheers!

    • @Enea
      @Enea Месяц назад

      Love to read this! Happy I could help (again) 😊🙏🏼

  • @houcinecharbouni633
    @houcinecharbouni633 Месяц назад

    Many thx

  • @NaveenKhanna-lh9qb
    @NaveenKhanna-lh9qb Месяц назад

    What is this 'Claims'?

    • @Enea
      @Enea Месяц назад

      Similar to email

  • @heenamulla8637
    @heenamulla8637 Месяц назад

    Hi.. Will this work for folder structure?

    • @Enea
      @Enea Месяц назад

      Not familiar with your folder structure, but this works in libraries same like in lists

  • @lacho3710
    @lacho3710 Месяц назад

    Love this, is there a same way to excel?

    • @Enea
      @Enea Месяц назад

      Yes, there is an excel connector in Power Automate for this use case 👍🏻

  • @completelygulible
    @completelygulible Месяц назад

    Hi I’m having an issue at 11:03 I follow each step exactly and make sure my column on share point is a rich text column. However when the “get comments” column loads, Al I get is errors. The text in advanced editor is correct and the prompts are all correct as well. The message that pops up if I click on the error is “ Expression.Error: We cannot convert a value of type Table to type Function.Details: Value=[Table] Type=[Type] “ Any solutions you can think of?

  • @bangerasiddharth
    @bangerasiddharth Месяц назад

    Getting the error: DataSource.Error: Web.Contents failed to get contents from ...... (404): Not Found. Could you please help?

  • @misskk111
    @misskk111 Месяц назад

    When one of the fields is empty or should i say null, it obv cannot extract and gives an error. How do you fix that? Can you set an if statement?

  • @nooreldali7432
    @nooreldali7432 Месяц назад

    Thank you so much :))

  • @baselabuobeid3801
    @baselabuobeid3801 Месяц назад

    Bull Shit ... all I can see in the attachment column is the word "true"

    • @Enea
      @Enea Месяц назад

      All I read is bullshit (btw thats how you write it)

    • @analysico
      @analysico Месяц назад

      @@Enea Hi, this happens because you are using version 2.0 of the 'SharePoint List Connecto'r, the problem with using version 1.0 is that it is too slow to update data.

  • @mohammedouahi7188
    @mohammedouahi7188 Месяц назад

    Thank you Illias , it's very hlelpful. I have one question please , is there a way to create a list when a file with a specific content type is created anywhere in sharepoint (with all the metadata ) ?

  • @thommas09
    @thommas09 Месяц назад

    thank you for this!

  • @maheshgupte1495
    @maheshgupte1495 Месяц назад

    Hi Thank for sharing this tutorial, please share second part of the video to patch the attachment data to a share point list