Latest videos on my YouTube Channel

Learn How to Add Up Values in a For-Each Loop

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 with each other and get a total sum value ate the end. For example if the loop is going through 9 items and you want to add a value that is in each of those items with each other. This is super usefull for many use cases.

To make this video a bit more helpful, I am showcasing this with help of Microsoft Forms and am trying to figure out how to calculate the average time needed for completing this form.

After getting the data from all the submitted forms at once by using another solution I showcased a while ago (https://youtu.be/jjw52Jafl2o) we then count the items in the JSON response to see how many forms have been submitted in total. This is necessary for the calculation of the average time needed.

Before moving to the calculations we initialize 2 variables of type float, one for the duration of each form and one for the total. This is very important for saving the subtotal after each run of the loop.

Expression for calculating the number of items: length(outputs('Parse_JSON_-_Extract_data_from_HTTP_Request')?['body']?['value'])

Then the difference between the start and end time for the submition of the form are calculated and the timestamp is converted into a float number so that it can be used in the calculation later in the flow.

Expression for the time difference: dateDifference(item()?['startDate'],item()?['submitDate'])

Expression for the conversion from timestamp (string) to seconds (float): add(mul(3600, int(substring(outputs('Compose_-_Calculate_the_time_for_each_response'), 0, 2))), add(mul(60, int(substring(outputs('Compose_-_Calculate_the_time_for_each_response'), 3, 2))), float(substring(outputs('Compose_-_Calculate_the_time_for_each_response'), 6, 9))))

Then we set the calculated value from the previous expression in the variable for each run and add it to the variable with the total seconds. Expression for adding the values in the variable: add(variables('varTotalSeconds'),outputs('Compose_-_Convert_from_timestamp_to_seconds'))

At the end, outside of the loop the outcome of the total seconds is divided in a compose action by 60 to get how many minutes it took in total and then divided by the number of items returned: div(div(variables('varTotalSeconds'),60),outputs('Compose_-_Calculate_the_number_of_items_in_the_HTTP_Response'))

Thanks for watching!

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: https://www.youtube.com/channel/UCPjs69d9ahFE0P-edf5chYQ

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

How to Trigger a Flow from a SharePoint Library File

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 library and call the flow. Because in this use case we dont have a column with the recipient in the library, I added two manual input fields in the trigger, one for the user who triggeres the flow to enter the email of the recipient and a toggle button to select if they would like to receive a copy of the file as well.

Since we do not get the file content and its properties from the trigger, we need to add these 2 actions in the flow: - Get file properties - Get file content After doing so, I use the Office 365 connector to get the user information for the recipient by using the email entered by the person who triggered the flow. This way I have the display name and can address the person in the email a bit more politely.

After getting the information for the user, I continue with a simple condition where I check if the user decided to receive a copy of the file or not. In case that is true, I send to emails, one to the recipient entered by the user and one to the user him/herself. Otherwise, only to the recipient entered by the user. Link to C# Corner Blog Post for the column formatting: https://www.c-sharpcorner.com/article/use-json-formatting-to-create-button-and-trigger-power-automate-flow/

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: https://www.youtube.com/channel/UCPjs69d9ahFE0P-edf5chYQ

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

Microsoft Forms directly from SharePoint Online List! 😮

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 this will not work since you need to have access to the SharePoint list as well. The best part is that you can create multiple Forms for each SharePoint list and select the fields you want to have in the Form for different audiences and you can use People Picker fields to allow the user to select people from your organization.

A big thing missing is the option to upload files. I hope Microsoft will add that feature as well since it is necessary!

What do you think? Let me know in the comments!

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Thanks for watching!

Power BI Table to HTML & PDF

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 some love soon since it is a very usefull tool.

If you want to learn more about Power BI, you are welcome to follow the channel and subscribe to the Power BI playlist here: https://youtube.com/playlist?list=PLNsXDj3270fvc1BTL8Z1BY5gzs3W42ABb

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

Copy Data from Multiple Lists into One

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 course being in the same row, and thats the tricky part.

Hope this helps you find the solution you were looking for, let me know your feedback in the comments! Enjoy!

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

Power BI - Show Multiselect Column Values in 1 Row!

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

....

#"Extract_List" = Table.TransformColumns(#"Removed Columns", {"Content.People", each Text.Combine(List.Transform(Table.TransformRows(_,each [FirstName] & " " & [LastName]), Text.From), ", "), type text})

#"Extract_List"

Here is the code for expanding the table row from the multiselect Choice Column:

...

#"Extract_List" = Table.TransformColumns(#"Removed Columns", {"Content.Color", each Text.Combine(List.Transform(Table.TransformRows(_,each [Value]), Text.From), ","), type text})

#"Extract_List"

If you want to learn more about Power BI, you are welcome to follow the channel and subscribe to the Power BI playlist here: https://youtube.com/playlist?list=PLNsXDj3270fvc1BTL8Z1BY5gzs3W42ABb

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

Power Automate - Who triggered the Flow?🔍

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!

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

Customize SharePoint Lists with Plumsail Forms 🤩

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 was to go and use complex data gathering controls like the table input or the signature. To display that information in a SharePoint list is not that simple, but this video is brought to you, to make it easy for you to understand how it can be done.

After a quick intro we jump right into the topic and go through the Plumsail website to check out where you can find Plumsail Forms for #sharepointonline and how to get started. Then we move on to creating the SharePoint tenant and connecting that to our Plumsail account. After that we continue with adding the app to the SharePoint App Catalog. Here is a link from #microsoft to read how to do it: https://learn.microsoft.com/en-us/sharepoint/use-app-catalog

After setting up the App in your App Catalog we continue with the installaton of Plumsail Designer. Here is a link to download it: https://forms.plumsail.com/designer-sp/setup.exe

After the designer has been isntalled, we take a quick look into the SharePoint list we created last time to refresh our memory on what we are trying to achieve, we launch the Designer, connect it to our list and continue with the customization of the form.

After we have finished the customizations we take a quick look into the rest of the features and settings Plumsail Forms has to offer and I quickly go through a cool feature called "Form Sets". They allow you to provide a unique form for members of certain groups which are easily configured in the menu when you create a new Form Set. Here you can read more about this very usefull feature: https://plumsail.com/docs/forms-sp/design-sp.html#form-sets-for-user-groups

Next we continue to see if everything works as it should and test our newly created SharePoint Form. After a minor change in the data types of the table component we finaly have our Form in the good form (pun intended) and are happy with the results!

Please make sure to check out the Plumsail Website to learn more about all the awesome stuff they have to offer: https://plumsail.com/Enea

And if you were looking for exactly this solution, check out https://plumsail.com/forms/sharepoint-forms/Enea for all the information that you need.

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

How to Preview Power BI Reports in SharePoint and OneDrive

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 the three dots and preview them directly in your browser. Pretty helpful!

If you want to learn more about Power BI, you are welcome to follow the channel and subscribe to the Power BI playlist here: https://youtube.com/playlist?list=PLNsXDj3270fvc1BTL8Z1BY5gzs3W42ABb

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

3 SharePoint Mistakes you must avoid

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 YouTube 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: https://www.linkedin.com/in/dougie-wood-sharepoint-consultant/

YouTube: https://www.youtube.com/channel/UCbl8QtLtzfnv6jPoc8gPqFQ

Where you can find Ami:

LinkedIn: https://www.linkedin.com/in/ami-diamond-mvp-70a798b/ YouTube: https://www.youtube.com/@SharePointWizard

Enjoy!

Join the channel: https://www.youtube.com/channel/UCPjs69d9ahFE0P-edf5chYQ/join

Talking about Future Tech. With Vesa Nopanen and Ami Diamond

On the next episode, Ami and I invited Vesa to talk about Microsoft Teams, Microsoft Metaverse and of course Microsoft Power Platform.

Enjoy!

Join the channel: https://www.youtube.com/channel/UCPjs69d9ahFE0P-edf5chYQ/join

Interview with Andre Lage & Ami Diamond

In this episode Ami 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!

Join the channel: https://www.youtube.com/channel/UCPjs69d9ahFE0P-edf5chYQ/join

All you need to know about the NEW Power Automate Designer!

Finaly took the time to record a video about the new Power Automate Designer. In this video I go through the new features of the designer and compare it to the old one.

If you like my content, it would be awesome if you would subscribe to the channel. Enjoy!

Thanks for watching!

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

NEW Forms Live Data to Excel!!! 🤯

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 Excel from a #sharepoint library.

The main difference I could find was the storage section (SharePoint Library Vs. OneDrive) and that the Excel file on SharePoint was a second slower than the one on OneDrive. But what will be the main reason to use one over the other? Or are they just two completely separate scenarios?

Here is the link to the preview infos from @Microsoft : https://techcommunity.microsoft.com/t5/microsoft-forms-blog/introducing-forms-data-sync-to-excel/ba-p/4036051

Thanks for watching!

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

Get SharePoint Version History with Power Automate

In todays video I am showcasing how to get the version history of your SharePoint List Items. After setting up the SharePoint list and creating a couple of data entries we directly move to Power Automate. Star of the show is the HTTP Request to SharePoint (standard connector) action!

The tricky part is to write the functions to grab the right data from the response comming from the HTTP Request to SharePoint action.

Thanks for watching!

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

From Plumsail Public Forms to SharePoint List

Our next collaboration with @Plumsail is all about getting data as easily as possible and as cool as possible! 😎 You know how much I love @Microsoft #forms and all the awesome stuff you can do with it. But when it comes to personalizing a form to gather data from your target audience, Plumsail brought it to another level. While building my first Plumsail Public Form I thought I was building an app! They have built-in so many options to customize and add in your Form that I was wondering if it would be more fair to compare to Microsoft #powerapps than to #microsoftforms 😅!

Don't forget to like, subscribe, and hit the notification bell for more insightful content! And be sure to check out Plumsail at https://plumsail.com/Enea

Get a one-month free version of Plumsail Public Forms at https://plumsail.com/forms/public-forms/Enea

Thanks for watching!

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

When a Microsoft FTE, a Microsoft MVP and a Microsoft Business Consultant sit together for a chat...

Ami invited me to co-host one of his shows where we chatted with one of the Power Platform community stars, Marco Rocca. Marco is a Microsoft FTE with many years of experience in Power Apps, Power Automate, Teams, and Microsoft Copilot.

2023 I joined one of Marco's sessions at the Global Power Platform Conference in Dublin but unfortunately never had the opportunity to speak with him in person. It was really nice getting to know Marco a bit better and I hope we will meet again soon.

Enjoy the video where we speak about the following topics:

- Short presentation of each of us

- Marco's role at Microsoft

- The impact of the Power Platform on people and businesses

- Importance of community involvement when working in tech jobs

- Common challenges people and businesses face when they first start with the Power Platform

- Insights on the new SharePoint Premium

For more such videos, follow my good friend Ami and his channel!

LinkedIn: https://www.linkedin.com/in/ami-diamond-mvp-70a798b/

YouTube Channel: https://www.youtube.com/@SharePointWizard

Thanks for watching!

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

Book Review & Givaway: "Automate Testing for Power Apps"

This video is a short review of the book "Automate Testing for Power Apps" and at the end I will be spinning the weel of fortune to pick 4 peoples names from the list of people who took part on my poll on LinkedIn. 2 will get a hard copy of the book 2 will get an ebook copy You can find the book on Amazon: https://packt.link/HrtZz Thanks for watching #powerapps #books #automationtips #apptesting #giveaway

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

Power BI: How to Combine Multiple Excel Files in one table

In this video I am going to show you how to work with multiple #excel files saved either in your local drive in a folder or in a #sharepointonline library folder, in Power BI.

In this scenario, every month a new sales Excel file is saved in one of the above mentioned locations. The goal is to automatically and dynamically bring that data into one table in Power BI. For that, the different Excel files will have to be combined and merged. Lets see what we need to prepare and how to achieve that in Power BI.

If you want to learn more about Power BI, you are welcome to follow the channel and subscribe to the Power BI playlist here: https://youtube.com/playlist?list=PLNsXDj3270fvc1BTL8Z1BY5gzs3W42ABb

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

Generate & Merge PDF from Microsoft Forms

Welcome to my channel! In collaboration with Plumsail, I'm excited to showcase an incredibly powerful tool called 'Documents', part of Plumsail's suite designed to seamlessly integrate with Microsoft Power Automate. Join me as I walk you through a practical use case, demonstrating how to leverage Plumsail Documents alongside Microsoft Forms and Power Automate to streamline document generation and management.

Use case: An employee fills out a Microsoft Form for expense reimbursement and attaches all receipts related to their business expenses. We then send a request for approval to a supervisor. If the request is approved, our goal is to compile all the information from the Microsoft Form fields, including the attachments files, into a single PDF file. This consolidated file will be saved into a SharePoint folder.

Don't forget to like, subscribe, and hit the notification bell for more insightful content!

And be sure to check out Plumsail at https://bit.ly/47H1ju8

Get a one-month free version of Plumsail Documents at https://bit.ly/47g4Ors

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

How to Trigger a Flow from a SharePoint List Item

In this video we are going to learn how to trigger a Powerautomate workflow from a SharePoint list item. To achieve that we will have to formatt a single line of text type column called "RunFlow" in a way that it shows an envelope icon and allows the user to click it. On click, a side pane will open on the right hand side of the screen and the workflow will then ask the user to enter some data like email address, subject and body. After clicking run flow the workflow will be instantly triggered.

To make the video even more interessting, we will also see how we can get multiple attachments from the list item and send them via email as well.

Link to C# Corner Blog Post for the column formatting: https://www.c-sharpcorner.com/article/use-json-formatting-to-create-button-and-trigger-power-automate-flow/

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

Sync Item Attachments between two SharePoint Lists

In todays video I am showcasing a way to sync the items between two SharePoint lists and their attachments. This automated cloud flow will not only create a new item in the child (second) list and as a copy from the parent list with its attachments but will also update an already copied item.

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

Power Automate: How to Automate SharePoint File Indexing

In this video we will solve a problem found in the Power Automate Forum. A user asked if there is a way to check if a SharePoint Folder exists and if yes, to generate a share link. If not to create the folder.

📂 Topics Covered:

🔹 Automating File Reception from Microsoft Forms

🔹 Saving Attachments to SharePoint Library

🔹 Adding Incrementing Numbers to File Names

🔹 Enhancing File Organization and Searchability

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

Check if a SharePoint folder exists, generate share link

The create folder path is very simple and straight forward.

The generate link path was a little bit trickier but I figoured it out and now it works fine.

Enjoy!

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

Latest videos on my YouTube Channel

Save Forms in Teams Channel with Attachment

In this video we are going to see how we can bring the data from Microsoft Forms with the attachment in Microsoft Teams and post about it in a Teams Channel.

As we know, #microsoftteams is backed by #sharepoint. This means when we save a file in Teams, we actually save it in SharePoint. The file from the submitet #microsoftforms will be saved in the SharePoint back-end of our selected Teams Channel. Then a simple post in the Channel will notify the users about the newly submitted Form.

Enjoy!

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

Power BI - Load Multiple SharePoint Lists In one table!

In this video we will see how to load multiple SharePoint lists in one single table in Power BI. There are two ways of doing this in #powerbi:

1. Load all the tables as separate queries and then merge them one by one in #powerquery

2. Select one of the #sharepoint lists and in Power Query you can then delete the last automatically created step. This will show all the lists and libraries available in your SharePoint Site. There you can select the lists you want to use and expand the tables in each row.

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: https://youtube.com/playlist?list=PLNsXDj3270fvc1BTL8Z1BY5gzs3W42ABb

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

Create a Custom Dynamic Index Column in SharePoint 🧾

In this video we will see how we can create a custom and dynamic incrementing column just like the one we are familiar seeing in Excel and other similar tools.

The reason why we cannot use the internal ID column is because that keeps incrementing and does not adjust to the number of items we have, when we for example delete an item. To achieve this, we need to use two #powerautomate workflows, one when an item is deleted and one when an item is creted in our #sharepoint list. Both of them will be automated cloud flows, which means they will automaticaly run on the above mentioned changes.

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: https://youtube.com/playlist?list=PLNsXDj3270fvc1BTL8Z1BY5gzs3W42ABb

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

📊Power BI: SharePoint List - Image Columns

In this video we will learn how to show SharePoint List Image Columns in a Power BI Report. Since the actual image is not saved in the image column, just using that column will not work.

The column is made out of a bunch of key:value pairs that provide the necessary information of where the actual image is stored. With a little bit of data transformation in Power Query, we can put together a dynamic Image URL that Power BI can use to go and fetch our image for each row.

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: https://youtube.com/playlist?list=PLNsXDj3270fvc1BTL8Z1BY5gzs3W42ABb

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

How to fix SharePoint Lookup Column Errors in Power BI

In this video, we will see how we can bring data from SharePoint List Rich Text Columns in Power BI, especially with the "Append changes to existing text" option activated. Enjoy!

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: https://youtube.com/playlist?list=PLNsXDj3270fvc1BTL8Z1BY5gzs3W42ABb

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

How to fix SharePoint Lookup Column Errors in Power BI

In this video, we will see how we can bring the Version History of our SharePoint List Items from SharePoint into Power BI.

To achieve that, first, we will connect to our SharePoint List. Then we will eliminate all the columns we do not need and keep only the ones we need. After having prepared our table we are going to use a custom query to invoke the Version History data from SharePoint into each and one of our item rows in the main table.

The code for the Query Invoke can be found here since I cannot paste the code in the description due to character limits on YouTube video descriptions: https://community.fabric.microsoft.com/t5/Desktop/Getting-SharePoint-List-items-with-full-history-version/td-p/64743 After that, we are going to invoke a custom function in our main table and use the query that we just created to call the SharePoint API and pass the information from each row into the API call to retrieve the version history for each row.

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: https://youtube.com/playlist?list=PLNsXDj3270fvc1BTL8Z1BY5gzs3W42ABb

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

How to fix SharePoint Lookup Column Errors in Power BI

In the second part of this video, we will bring the data from our Version History List into the App, show that data in a gallery filtered by the specific item from the Main List, and try to highlight the changes made to that item in the gallery by using the font-weight property. But you can use the same logic to highlight the changes in a different way, for example by displaying a different text or changing the size or the color of the text. Up to you.

A big thank you goes to my dear colleague Martin Lehmann for helping me achieve the comparison.

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

How to fix SharePoint Lookup Column Errors in Power BI

In this video, we are going to recreate the Version History similar to what SharePoint lists offer when activated. To my knowledge, there are two ways of doing this, you can either do an HTTP request to SharePoint and pull the version history for each item, or you can create your own with a copy of the main list and use that as your version history storage. Here are the steps taken in the video:

- First, we are going to create a copy of the main list

- Set up the saving logic of the app, to allow the user to create and update items in the main list and create a new item with the same information in the version history list.

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

How to fix SharePoint Lookup Column Errors in Power BI

In today's video, we will take a look at how to restore deleted workflows. If you have deleted a Flow there is no way of restoring them from the Power Automate editor. But there is a workaround by using Power Automate itself and leveraging the Admin actions like the "List Flows" or "Restore Flows".

Keep in mind that only Flows that have been deleted in the last 21 days can be restored, after that it's unfortunately too late.

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

How to fix SharePoint Lookup Column Errors in Power BI

From the amazing Low Code Podcast host Feroz Khan:

"In this episode, we speak to our first Power Platform guest Enea Liçaj who gives us an overview of the different solutions which are offered by Microsoft with their Low Code offering which includes Power BI, Power Apps, Power Pages, Power Automate and Power Virtual Agents.

Enea talks about how he first started using Power Platform, interesting projects that he has worked on and why he decided to start his own YouTube channel."

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

How to fix SharePoint Lookup Column Errors in Power BI

In this informative video, we delve into the intricacies of handling multi-select person columns in SharePoint using Power Automate. Whether you're a novice or an experienced user, this tutorial is designed to simplify the process and empower you to efficiently manage these columns within your workflows.

Follow along as we demonstrate a step-by-step approach to tackle this challenge. Learn how to initialize a string variable, effectively append values from the multi-select person column using an apply to each loop, and visualize the end result through a compose action. By leveraging the outputs of the compose action or the variable, we showcase a simple technique to send a single email to multiple users within that column's value, eliminating the need for multiple emails.

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

How to fix SharePoint Lookup Column Errors in Power BI

Having trouble working with SharePoint Lookup columns in Power BI? In this video, we dive into the common errors you may encounter and provide 2 effective solutions to handle them.

1. Solution: Split the tables and build relationships between them

2. Solution: Change the SharePoint API version to fix the error and expand the values inside the same table.

If you want to learn more about Power BI, you are welcome to follow the channel and subscribe to the Power BI playlist here: https://youtube.com/playlist?list=PLNsXDj3270fvc1BTL8Z1BY5gzs3W42ABb

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

🤖Power Apps + 🍾Pop Ups☝🏼= Amazing

In this video we will see how we can use pop ups in our Power Apps canvas applications to help the user have a better user experience when they are using the application. Pop ups can be used in many cases like for example when they have already started filling out the data and they cancel, asking them if they are sure and that they are going to lose the data.

Another example is when they are saving the data, providing them with a short summary of the inserted information asking them if they are sure the data is correct and they want to save it.

There are many more cases where you can utilize this logic. In this video I am showcasing the two cases mentioned above so that you can understand how it works, and then let your imagination do the magic!

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

🤩Power Apps - New Modern Controls🤯

Microsoft recently released some new and updated versions of controls in Power Apps Canvas.

All of them look nice and have a very fresh and modern look and feel. Unfortunately, they all lack many properties, making them unusable at the moment. I hope #microsoft will let the new controls inherit the properties of their older versions and populate the new ones with at least the necessary properties.

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

Power BI: SharePoint {Link to Item}

In this video we will see how we can create a Link to Item in our #powerbi report. When we work with SharePoint data, the Link to Item value can be seen in Power Automate but not in Power BI (or at least I did not find it). A viewer of my channel asked if there is a way to create a custom Link to Item for #sharepointonline list items and that is excactly what this video is for.

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: https://youtube.com/playlist?list=PLNsXDj3270fvc1BTL8Z1BY5gzs3W42ABb

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

How to FILTER one SharePoint List with another?

In this video, I will show you how to filter a SharePoint List by another SharePoint List. In this showcase, we have one #sharepointonline list with some schools listed and another with some teachers and their school IDs. With the help of a #powerautomate #flow we will get all the items from the first list (Schools) and save them in an array variable. Then we will grab all items from the second list (Teachers) with their SchoolID column = ID from the School list.

This way we end up with two array variables containing the IDs from the first table and the matching from the second, having prepared a left join. The next step would be to create a new list with merged IDs. Since the viewer asked how to filter with Power Automate, the creation of a new list and writing the merged data is not part of the video.

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

🤖Power Apps + ⏳Loading Spinners = Awesome

In this short video, I will demonstrate how you can implement loading spinners into your application. First I quickly go through the Canvas #powerapps and the #powerautomate Workflow that I am using to demonstrate this use case. Then I show a website I use to download free loading spinners. After that, I am showcasing how you can use them by clicking a button in combination with an upload document #flow so that we get a couple of seconds to see the loading spinner.

You can implement this logic in all the places in your app where the user is supposed to wait. This way the user will be informed that something is happening and they will not be able to click around in the app while the file is being uploaded or data is being collected.

Link to more loading spinners: https://loading.io/

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

💪🏼 Dynamically generate Microsoft Forms from Power Apps 🧾

This is a recording of my first live video where I joined Robin (R2Power - Lern PowerApps) to showcase my findings around the #microsoft Forms API.

During the first part of the video, I am showing how to get all the responses from a specific Form into Power Automate by calling the Forms API. In the second part of the video, Robin is demonstrating his findings and how we can create a custom connector to create, edit or delete Forms.

I hope you liked the video and if you have any questions feel free to ask in the comments!

A big thank you goes to Robin for organizing this event and for his efforts on extending my findings and bringing even more value to the topic!

Follow him on

LinkedIn: https://www.linkedin.com/in/robin-rosengr%C3%BCn-ab35091b6/

YouTube: https://www.youtube.com/@R2Power

Buy me a pizza 🍕- https://bmc.link/enealicaj

1️⃣ - One Flow for all your SharePoint Lists 🤯

In this video, I am demonstrating how to sync multiple #sharepointonline lists with #powerautomate without having to decide from which list you are going to trigger the Flow. This is a truly dynamic flow that will allow you to have multiple lists and be able to run the syncing process from all those lists.

In this case, I am using three SharePoint Online lists but you can of course further extend the logic of the flow to be used with more and to fit your use case.

The only way to achieve this is with Encodians new product called Trigr. This brand new solution makes Power Automate Flows available across multiple and targeted SharePoint Online sites. Possible via a SharePoint Framework (SPFx) Extension, users can access Flows from within SharePoint Online libraries and lists. Trigr is deployed as an app in your SharePoint environment over the Admin Center. You choose if you want Trigr to be deployed immediately to all SharePoint Sites or to leave it up to the Site Owners to decide if they want to use it or not.

There are three main setup processes you need to complete to get your first Trigr Flow up and running:

1. Download and deploy Trigr as an app in your SharePoint Admin Center

2. Start building the Flow in Power Automate

3. Create a Trigr Action on the configuration section of your Encodian Portal.

Everything is well documented on their website but here is some key information you need to get started:

Learn more about Encodian: https://www.encodian.com/

Learn more about Trigr: https://www.encodian.com/products/trigr/

Encodian Trigr App Deployment and Installation: https://support.encodian.com/hc/en-gb/articles/7389080747921

Create a Trigr 'Action': https://support.encodian.com/hc/en-gb/articles/7389088176401

Pricing: https://www.encodian.com/products/trigr/#pricing

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

Part 2: Learn how to Bring your Dataverse for Teams into Power BI

Learn how to Bring your Dataverse for Teams into Power BI This is a recording from my latest community invitation to present a Power Platform-related topic. My choice was to introduce Dataverse for Teams and how we can visualize data in Dataverse in Power BI. The presentation begins with a short introduction of myself, continuing with an introduction to the Power Platform, then Microsoft Teams and the Power Platform. After this general information for the viewer, I continued with Dataverse for Teams and Power BI for Teams which were also the most important parts of the presentation. The fun begins in the demo session after this and closes with a quick overview of the licensing topic.

These are the topics discussed in the presentation:

Part 1:

Introduction

Microsoft Power Platform

Microsoft Teams & the Power Platform

Part 2:

Dataverse for Teams

Power BI for Teams

Demo

Licensing

Hope this video helps! If you want to learn more about Power BI, you are welcome to follow the channel and subscribe to the Power BI playlist here: https://youtube.com/playlist?list=PLNsXDj3270fvc1BTL8Z1BY5gzs3W42ABb

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

Collaboration at its Best ❤️ - Power Platform and Microsoft Teams

These are the topics discussed in the presentation:

Part 1:

Introduction

Microsoft Power Platform

Microsoft Teams & the Power Platform

Part 2:

Dataverse for Teams

Power BI for Teams

Demo

Licensing

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

📊Power BI - How to work with SharePoint List Attachments📎

In this video instead of triggering a Flow every time a form has been submitted, we are going to send an HTTP request to the Forms API and receive all submitted answers at once.

The HTTP request connector is the one we also use for SharePoint, so it's free to use as a standard connector in Power Automate. The problem with this method is that the answers are received in one array. We are going to use a compose action to split the array at specific places so that we can extract the answers. This will be done inside an apply-to-each loop so that we can go through all responses.

In the end, we have all answers from all responses in a structured and easy-to-use format. What you do with that data after this stage is up to you!

Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

📊Power BI - How to work with SharePoint List Attachments📎

Today's video has been inspired by a comment in one of my previous videos. The viewer asked how we can handle SharePoint List attachments in Power BI. Here are my findings:

There is no known way to view all types of files in a Power BI Report. If you are only uploading image files then you could format the column in Powe BI as an "Image URL" type of column and can show the images in the canvas. If you are uploading different types of files then the best way at the moment to handle that is to format the column as a "Web URL" type of column which will then open any type of file in your browser.

Hope this video helps!

If you want to learn more about Power BI, you are welcome to follow the channel and subscribe to the Power BI playlist here: https://youtube.com/playlist?list=PLNsXDj3270fvc1BTL8Z1BY5gzs3W42ABb

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

📊Power BI and SharePoint 👥Multi-People-Picker Columns

In this video, we will take a look at how to work with Multi-Choice columns and Multi-People-Picker columns from #sharepointonline in #powerbi.

SharePoint Multi-Choice columns are shown in Power BI as lists or tables depending on the API version being used to connect to SharePoint. If it's API version 15 the column is seen as a list and the values can either be extracted in the same row separated with a delimiter of our choice or extracted into new rows. The latest will break the distinct values condition and the table cannot be used for a one-to-many relationship anymore (being on the 1 side of the 1:n relationship schema). If it's API version 14 the column will be recognized as a table which then allows us to expand the column called "Value" and get the data in new rows. This will again break the distinct values of the table.

The Multi-People-Picker column throws errors with API version 15 and I haven't been able to find any solution other than switching to API version 14. This will cause the already applied steps to not be recognized anymore and force us to retake the steps in Power Query from the beginning. After that, the column is recognized and the data can be extracted. To keep the main list with distinct values, I moved the two columns into their own tables and extracted the values there into new rows. That way I was able to create a one-to-many relationship between the main list table and the other two tables, one containing the Multi-Choice column and the other one containing the Multi-People-Picker columns.

Feel free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

🤖 Power Automate Desktop - Data from .txt to Excel

In today's video, we will take a first look into Power Automate Dekstop with a scenario I had in one of my last projects. We are going to get a .txt file from a specific folder, read its content, count its rows and save that data in a predefined Excel file which is also saved in a specific folder.

We will also learn some basic concepts around RPA, such as actions, variables, loops, and if statements.

If you want to learn more about Power Automate Desktop, you are welcome to subscribe to the channel :)

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

📊⤵️EXPORTING SHAREPOINT DATA TO EXCEL - A Step by Step Guide

Today's video is inspired by a comment from a subscriber. The request was to create a workflow for exporting data from a #sharepoint List to a new #excel file on a weekly basis. After the document has been populated with the data, the #workflow will empty the list for it to be filled again in the new week.

To make it a bit more errorproof, #powerautomate will check if the file has been successfully created, otherwise it will send a notification email to the owner of your choice.

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: https://www.youtube.com/channel/UCPjs...

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

🔃 Sync Multiple SharePoint Lists: A Quick and Easy Guide

In today's video, we will see how we can automatically sync data from one SharePoint list to another. An Automated Cloud Flow will help us achieve the synchronization between the lists.

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: https://www.youtube.com/channel/UCPjs...

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

🗗 Power Apps - Document approval process 🔀

During this webinar, we will be creating a SharePoint Library with Metadata columns, a Power App to upload documents with metadata in the library, and an approval process for the uploaded document.

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: https://www.youtube.com/channel/UCPjs...

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

Create & Edit Teams Meetings from Power Apps

Today we are going to take a look at how we can create and edit Microsoft Teams meetings from Power Apps. Since I am currently working on an App that requires this functionality, I was searching on solutions and found Shane Young´s Video on how to create a Microsoft Teams Meeting from Power Apps and Power Automate: https://www.youtube.com/watch?v=hPRzHbMzoI0&ab_channel=ShaneYoung

Unfortunately for me he just shows how to create a meeting, but not how to edit one. So I did some research and found out that you cannot edit a meeting with the Microsoft Teams connector, but with the Outlook365 connector you can.

Here is the link to the Microsoft Formatet Time Zones: https://docs.microsoft.com/en-us/previous-versions/windows/embedded/ms912391(v=winembedded.11)

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

📊📈Power BI - Get, Clean & Analyze data

Welcome to my very first Webinar all about Power BI with the Community! Here is an overview:

- Power BI and the Power Platform

- Power BI Desktop

- Power BI Service

- What is a Report, a Dashboard, and a Power BI App

- What Sharing options are available in Power BI

- How to manage DEV and PROD in Power BI Workspaces

- Live Demo on getting, cleaning, and analyzing data

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

Part 1: 📝 Microsoft Forms to SharePoint List with Validation

In today's video, we will use Microsoft Forms and Power Automate to enter the submissions in a SharePoint list. We will use validation to check if an entry already exists in a SharePoint list. If yes the item should be created, if no the item that already exists should be updated.

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

Save Forms 📝 & Attachments📎 in a Sharepoint List

In todays video we will create a Microsoft Forms Application with Attachments. Next we will go on and create a SharePoint List to save the responses as an Item and the attachments from the Form as an Item Attachment. The responses will be captured by a Power Automate Flow and saved on trigger in the SharePoint List.

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

Power Apps - ⬆️Upload Excel Data to SharePoint

Hi PwrPeeps, today we will continue from where we left and after uploading an Excel File from our Canvas App into our SharePoint Library, we want to extract the values from the Excel File and and insert them into a SharePoint List. We will also implement a filter option so that we only get rows that are not empty.

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Buy me a pizza 🍕- https://bmc.link/enealicaj

⬆️Upload to a SharePoint Library with Metadata

In todays video we will create a SharePoint Library with multiple metadata columns and learn how to use the Attachment Component in Power Apps and upload a file to the library we just created. Since there is no way at the moment to upload a file directly from Power Apps into SharePoint without using an Edit Form, we are going to use some help from a simple but very helpful little Power Automate Flow.

Power Automate - Update a Multi-Person-Column 👨‍👩‍👦‍👦

In this video we will learn how to use the Select & Compose data actions in Power Automate to grab a list of users from one SharePoint List and bring them in a Multi-Person-Column of another SharePoint list.

SharePoint Document Management with Automated Versioning

In this video, we will explore another solution of #uploading #documents into a #sharepointonline Library. The challenge this video is trying to overcome is that when the same document is uploaded (name-wise), the document will be replaced. But what if we have changed the content and we need the document to exist as a new version of the one that's already there? The user would have to rename the document by themselves and copy the metadata of the older version to the new one, although they have not changed it.

The solution I came up with uses two SharePoint Online Folders in a Library. One is for uploading the documents and it will be emptied every time the document has been moved to the final destination folder. The other one is the final destination folder of the documents. The user will upload the document in the Upload Folder and when they are finished updating the metadata, a column called "MoveFile" (Yes/No column) can be set to Yes, the Trigger Condition of the Workflow will be met and the workflow will start running.

The workflow will check if the document already exists in the final destination folder, if not it will copy the file to the folder and delete it from the upload folder. Here you can also use a move file action, up to you :)

If the document does exist in the final destination folder, the workflow will count the documents that start with the same name. If for example the length of the "Get Files" action is 3, then the newly uploaded document will receive a new version number in the file name "Document_004".

If you want to learn more about SharePoint, you are welcome to follow the channel and subscribe to the playlist here: https://www.youtube.com/channel/UCPjs...

Feel Free to follow me on other social media platforms as well: https://linktr.ee/EneaLicaj

Latest videos on my YouTube Channel

Learn How to Add Up Values in a For-Each Loop

How to Trigger a Flow from a SharePoint Library File

Microsoft Forms directly from SharePoint Online List! 😮

Power BI Table to HTML & PDF

Copy Data from Multiple Lists into One

Power BI - Show Multiselect Column Values in 1 Row!

Power Automate - Who triggered the Flow?🔍

Customize SharePoint Lists with Plumsail Forms 🤩

How to Preview Power BI Reports in SharePoint and OneDrive

3 SharePoint Mistakes you must avoid

Talking about Future Tech. With Vesa Nopanen and Ami Diamond

Interview with Andre Lage & Ami Diamond

All you need to know about the NEW Power Automate Designer!

NEW Forms Live Data to Excel!!! 🤯

Get SharePoint Version History with Power Automate

From Plumsail Public Forms to SharePoint List

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"

Power BI: How to Combine Multiple Excel Files in one table

Generate & Merge PDF from Microsoft Forms

How to Trigger a Flow from a SharePoint List Item

Sync Item Attachments between two SharePoint Lists

Power Automate: How to Automate SharePoint File Indexing

Check if a SharePoint folder exists, generate share link

Latest videos on my YouTube Channel

Save Forms in Teams Channel with Attachment

Power BI - Load Multiple SharePoint Lists In one table!

Create a Custom Dynamic Index Column in SharePoint 🧾

📊Power BI: SharePoint List - Image Columns

How to fix SharePoint Lookup Column Errors in Power BI

How to fix SharePoint Lookup Column Errors in Power BI

How to fix SharePoint Lookup Column Errors in Power BI

How to fix SharePoint Lookup Column Errors in Power BI

How to fix SharePoint Lookup Column Errors in Power BI

How to fix SharePoint Lookup Column Errors in Power BI

How to fix SharePoint Lookup Column Errors in Power BI

How to fix SharePoint Lookup Column Errors in Power BI

🤖Power Apps + 🍾Pop Ups☝🏼= Amazing

🤩Power Apps - New Modern Controls🤯

Power BI: SharePoint {Link to Item}

How to FILTER one SharePoint List with another?

🤖Power Apps + ⏳Loading Spinners = Awesome

💪🏼 Dynamically generate Microsoft Forms from Power Apps 🧾

1️⃣ - One Flow for all your SharePoint Lists 🤯

Part 2: Learn how to Bring your Dataverse for Teams into Power BI

Collaboration at its Best ❤️ - Power Platform and Microsoft Teams

📊Power BI - How to work with SharePoint List Attachments📎

📊Power BI - How to work with SharePoint List Attachments📎

📊Power BI and SharePoint 👥Multi-People-Picker Columns

🤖 Power Automate Desktop - Data from .txt to Excel

📊⤵️EXPORTING SHAREPOINT DATA TO EXCEL - A Step by Step Guide

🔃 Sync Multiple SharePoint Lists: A Quick and Easy Guide

🗗 Power Apps - Document approval process 🔀

Create & Edit Teams Meetings from Power Apps

📊📈Power BI - Get, Clean & Analyze data

Part 1: 📝 Microsoft Forms to SharePoint List with Validation

Save Forms 📝 & Attachments📎 in a Sharepoint List

Power Apps - ⬆️Upload Excel Data to SharePoint

⬆️Upload to a SharePoint Library with Metadata

Power Automate - Update a Multi-Person-Column 👨‍👩‍👦‍👦

SharePoint Document Management with Automated Versioning

Diese Website verwendet Cookies.