- Видео 97
- Просмотров 418 748
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 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...
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
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.
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…
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.
Where are you copying the JSON from? In my tutorial I am taking it from the upload file question.
@@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.
@@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
thank you so very much. This is exactly what i have been searching for in order to complete a work task.
Can i do from words to sharepoint list?
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
Thank you!
Que top, resolvido meu problema, obrigado
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?
Check out my newest video coming out tomorrow 9AM (Europe Timezone) ;)
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!
Can you explain a bit more? Not sure if I understood it right
@@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. 🙏
@@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…
No worries. It does sound possible just haven’t found the right formula just yet. Thanks for sharing knowledge on your channel!
@@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 :)
What is the Filter Query at 12:14, file ref?
FileLeafRef
Thank you for this. You helped me with a solution for a client i got.
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
Hey, I have written same logic in my flow. However the date adding in the form was 1 day back. Any idea?
No sure, but I would quick fix it in Power Automate by adding on day 🤷🏻♂️
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?
you are the best.. thank you so much Teacher.
Delete the column in the list to remove the question from the form. You're working with a list now, not a form.
I did, was still there. Think its a bug
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?
Doable, but you need multiple such flows. And you need to make sure they dont trigger each other infinitely
Will this method work if I am trying to have mutiple lists feeding updates into a single main list?
I have another video about this use case. Check out it must be unter the latest videos
Huh. Well, I can make them ... but I can't seem to actually use the form that I made. :(
What do you mean you cannot use them?
@@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. ;-)
@@Enea Also, I've noticed that my Lookup Columns are basically pointless in these forms. 😩
@@ukm365 I know :(
Thanks for sharing.
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?
Great overview
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?
Hi, thanks, happy it worked! Yes, in that case you would need a separate flow with the “when an item is deleted” trigger
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
Awesome video! Saved me from doing some trial and error. Thank you so much!
how we do when we delete item?
Deleting needs a separate flow since you need the „When an item is deleted“ trigger
@@Enea CAN YOU MAKE A VIDEO EXPLAINING IT?
@@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
@@Enea obligatory, it worked perfectly
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?
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
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
@@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
I don't have ParentWebURL...?
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...
Thanks for the video, but if the document is not uploaded, the workflow is failed, any idea how to fix it?
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
@@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
Thanks. This worked perfectly.
This is a great lesson. I learned a lot from this. Thank you for explaining all the fundamentals while you go along.
Thanks for your comment! Happy I could help! Subscribe if you like
You are Genuious
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?
Probably, you can add a condition checking if the value is empty first to catch the error
I am struggling. Only one sheet shows in the new table and not both sheets
Pro tip: watch in Speed 2x
Amazing life hack
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.
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.
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
What about autosyncing different libraries (one-way) each in a seperate sharepoint site ?
Thank you Enea! This is the second time you have solved a problem for me. I appreciate your teaching style. Cheers!
Love to read this! Happy I could help (again) 😊🙏🏼
Many thx
What is this 'Claims'?
Similar to email
Hi.. Will this work for folder structure?
Not familiar with your folder structure, but this works in libraries same like in lists
Love this, is there a same way to excel?
Yes, there is an excel connector in Power Automate for this use case 👍🏻
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?
Getting the error: DataSource.Error: Web.Contents failed to get contents from ...... (404): Not Found. Could you please help?
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?
Thank you so much :))
Bull Shit ... all I can see in the attachment column is the word "true"
All I read is bullshit (btw thats how you write it)
@@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.
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 ) ?
thank you for this!
Hi Thank for sharing this tutorial, please share second part of the video to patch the attachment data to a share point list