![TW-Waytek](/img/default-banner.jpg)
- 16
- 76 653
TW-Waytek
United States
Registrace 18. 11. 2022
Hi, I'm Tyler Wasson, and welcome TW-Waytek, the place to teach, test, and review "Way Cool Tech". I am a technology enthusiast, with a strong interest in Microsoft technologies, and started TW-Waytek as a venue to create content about the technologies I’m passionate about.
My interests range from Microsoft 365, Power BI, Power Automate, SQL Server, Computer Hardware, Networking, and IOT, in both a professional and personal environment. In this blog I'll be teaching, testing, and reviewing about old and new technologies to solve problems and improve processes.
My career spans over 20 years in the private sector, working in retail, manufacturing, and information technology. My areas of expertise are in Business Operations, Information Technology, Sales Support, Warehousing, and Supply Chain.
Be sure to subscribe to get all the latest technology tips and be sure to visit my website where you can find the documented version of my videos.
My interests range from Microsoft 365, Power BI, Power Automate, SQL Server, Computer Hardware, Networking, and IOT, in both a professional and personal environment. In this blog I'll be teaching, testing, and reviewing about old and new technologies to solve problems and improve processes.
My career spans over 20 years in the private sector, working in retail, manufacturing, and information technology. My areas of expertise are in Business Operations, Information Technology, Sales Support, Warehousing, and Supply Chain.
Be sure to subscribe to get all the latest technology tips and be sure to visit my website where you can find the documented version of my videos.
How to setup Microsoft Fabric Capacity for a Power BI Workspace from the Azure Portal
Step by step instructions on how to setup Microsoft Fabric Capacity for a Power BI Workspace from the Azure Portal. Starting from the Azure Portal, this video walks you through the process of adding a Fabric license to your Azure account, selecting the capacity unit, and then adding that capacity to your Power BI workspace to utilize all that Fabric has to offer.
Visit the link below to see the step-by-step breakdown for this video:
www.tw-waytek.com/how-to-setup-microsoft-fabric-capacity-for-a-power-bi-workspace-from-the-azure-portal
More Information on Microsoft Fabric:
What is Microsoft Fabric - Microsoft Fabric | Microsoft Learn
Microsoft Fabric - Pricing | Microsoft Azure
Microsoft Fabric terminology - Microsoft Fabric | Microsoft Learn
Be sure to subscribe to get all the latest technology tips and to visit my website where you can find the documented version of my videos.
--------------------------------------------------------
CONNECT WITH ME:
My Website: www.tw-waytek.com/
Facebook: tw.waytek
LinkedIn: www.linkedin.com/in/tylerwasson/
Twitter: TW_Waytek
___________________________________
Visit the link below to see the step-by-step breakdown for this video:
www.tw-waytek.com/how-to-setup-microsoft-fabric-capacity-for-a-power-bi-workspace-from-the-azure-portal
More Information on Microsoft Fabric:
What is Microsoft Fabric - Microsoft Fabric | Microsoft Learn
Microsoft Fabric - Pricing | Microsoft Azure
Microsoft Fabric terminology - Microsoft Fabric | Microsoft Learn
Be sure to subscribe to get all the latest technology tips and to visit my website where you can find the documented version of my videos.
--------------------------------------------------------
CONNECT WITH ME:
My Website: www.tw-waytek.com/
Facebook: tw.waytek
LinkedIn: www.linkedin.com/in/tylerwasson/
Twitter: TW_Waytek
___________________________________
zhlédnutí: 146
Video
How to Access a SharePoint Site’s User List in Power BI
zhlédnutí 118Před 2 měsíci
Step by step instructions on how to access a SharePoint Site's user list in Power BI. Visit the link below to see the step-by-step breakdown for this video: www.tw-waytek.com/how-to-access-a-sharepoint-sites-user-list-in-power-bi Visit the link below to see the step-by-step breakdown on how to create a project status report in Power BI: Create Project Status Reports from a SharePoint List Using...
Automatically Refresh Power BI Report Data | 2024
zhlédnutí 651Před 3 měsíci
Step by step instructions on how to setup Power BI to automatically refresh report data on a scheduled basis. Visit the link below to see the step-by-step breakdown for this video: www.tw-waytek.com/automatically-refresh-power-bi-report-data/ Be sure to subscribe to get all the latest technology tips and to visit my website where you can find the documented version of my videos. CONNECT WITH ME...
Create Project Status Reports from a SharePoint List Using Power BI
zhlédnutí 622Před 3 měsíci
Step by step instructions on how to connect Power BI to a SharePoint/Microsoft List and build several reports to track the status of a development project. Visit the link below to see the step-by-step breakdown for this video: www.tw-waytek.com/create-project-status-reports-from-a-sharepoint-list-using-power-bi/ Visit the link below to see the step-by-step breakdown on how I made the SharePoint...
Easily Manage Projects Using SharePoint Lists | 2024 Dev Ops Example
zhlédnutí 477Před 5 měsíci
Step by step instructions on how to create a simple SharePoint Dev Ops Project Tracker in using Microsoft Lists. Visit the link below to see the step-by-step breakdown: www.tw-waytek.com/sharepoint-project-tracker Be sure to subscribe to get all the latest technology tips and to visit my website where you can find the documented version of my videos. CONNECT WITH ME: My Website: www.tw-waytek.c...
5 Big Enhancements to a SharePoint Vacation Tracker in Microsoft Lists | 2024 Simple Guide
zhlédnutí 2,7KPřed 6 měsíci
Step-by-step instructions on how to add enhancements to a team vacation tracker in SharePoint using Microsoft Lists. This video builds upon a previous video where I demonstrated how to build a vacation tracker. In this video I show how to add Rules and Alerts, Calendar View Conditional Formatting, Hour's Tracking, Vacation Reminders, and Approvals. Visit the link below to see the step-by-step b...
Directly Query a Power BI Dataset Using Power Automate and Save it to Excel in SharePoint
zhlédnutí 2KPřed 7 měsíci
In this video, I provide step by step guidance on how to directly query Power BI from Power Automate, put the data into an Excel file and save it in SharePoint. Since the data coming from Power BI is in a CSV format, the data must be converted to Excel. A step is added to make sure the column headers are in the right format. I also use Power BI's Performance Analyzer to grab the Power BI visual...
How to Export a Large Filtered SharePoint List into a CSV File Using Power Automate
zhlédnutí 1,3KPřed 8 měsíci
In this video, I review step by step how to export a large, filtered SharePoint List into a CSV file using Power Automate, a total of 42,000 records in all. I'll be using the OData query filter and show how to identify the SharePoint columns name. Visit the link below to see the step-by-step breakdown: www.tw-waytek.com/how-to-import-a-large-excel-dataset-to-sharepoint-using-power-automate/ Be ...
How to Import a Large Excel Dataset into SharePoint Using Power Automate
zhlédnutí 3,4KPřed 8 měsíci
In this video, I review the steps taken on how I imported 100,000 records of data in Excel to a SharePoint Online List and discuss the challenges to import large datasets into SharePoint Online. Visit the link below to see the step-by-step breakdown: www.tw-waytek.com/how-to-import-a-large-excel-dataset-to-sharepoint-using-power-automate/ Be sure to subscribe to get all the latest technology ti...
How to Create a SharePoint Team Vacation Tracker using Microsoft Lists | 2023 Simple Guide
zhlédnutí 23KPřed 10 měsíci
Step by step instructions on how to create a team vacation tracker in SharePoint using Microsoft Lists. I'll also demonstrate how to integrate the list into Microsoft Teams. Visit the link below to see the step-by-step breakdown: www.tw-waytek.com/sharepoint-team-vacation-tracker Be sure to subscribe to get all the latest technology tips and to visit my website where you can find the documented...
Create a Power BI Date Table
zhlédnutí 114Před rokem
Step by step instructions on how create a Date Table in Power BI that includes both the calendar year and different fiscal year. The columns built using DAX formulas include Year, Quarter, Month, Month Number, Year Month Key, Week Number, Day of the Week, Day of the Month, and Day Number for both calendar year and fiscal year. Visit the link below to see the step-by-step breakdown and DAX formu...
Unlock the Hidden Power of Excel: How to Link Notes to a SQL Server Table!
zhlédnutí 609Před rokem
Step by step instructions on how to link note line items to specific rows in a SQL Server table using self-referencing tables using Excel and Power Query. Visit the link below to see the instructions at my website: www.tw-waytek.com/link-notes-to-sql-server-table-in-excel-using-power-query/ Be sure to subscribe to get all the latest technology tips and to visit my website where you can find the...
Copy Dynamic Microsoft Excel Content from One File to Another using Power Automate
zhlédnutí 27KPřed rokem
Step by step instructions on how to copy dynamic Microsoft Excel content from one file to another using Power Automate. Things you'll need to follow along for this video: Microsoft Business 365 account Business Basic Visit the link below to see the instructions at my website: www.tw-waytek.com/copy-excel-dynamic-content-from-one-excel-file-to-another-using-power-automate/ Be sure to subscribe t...
Automatically Save and Rename Email Attachments to SharePoint using Power Automate
zhlédnutí 9KPřed rokem
Step by step instructions on how to rename Microsoft Excel email attachments that includes the date and time and save them to a specific folder in SharePoint using Power Automate. Things you'll need to follow along for this video: Microsoft Business 365 account Business Basic Visit the link below to see the instructions at my website: www.tw-waytek.com/copy-email-attachment-excel-content-to-sha...
Get JSON Cloud Data using an HTTP Request in Power Automate
zhlédnutí 1,2KPřed rokem
In this example I'll be using a scheduled HTTP request in Power Automate to get stock market JSON data daily from IEX cloud services and import that data into SQL Server. Things you'll need to follow along for this video: Premium connectors: learn.microsoft.com/en-us/connectors/connector-reference/connector-reference-premium-connectors#list-of-all-premium-tier-connectors Data Gateway: www.tw-wa...
Setup a Data Gateway in Power Automate
zhlédnutí 4,7KPřed rokem
Setup a Data Gateway in Power Automate
Hi, Just a question. Why is there no x-ms-file-id on my options? :( how can i find it?
Hello @KabayanParesan, thanks for reaching out, there's been some updates from Microsoft that now require some changes to the flow. Change the trigger to SharePoint: When a file is created or modified (properties only) then under Create Table and List rows present change the File dynamic content to Identifier. Let me know how you make out.
Super helpful! Do you have instructions for re-naming the Excel file email attachment (that arrives daily with a variable name) so that it always gets saved with the exact same file name (no date stamp) and over-writes the previous day’s file?
Hello @darrenchewitt, great question, this is a very simple flow with only 3 actions. First is the trigger, When a new email arrives V3, next is For Each, and last is Create file. In the create file action under file name, give your file a name then a "." and then the extension type, if the file is always an excel file then the file name would be FileName.xlsx. Give this a try and let me know how you make out.
@@tw-waytek Thank you so much - I got it to work! I was initially using the method you suggested, and the automation would work perfectly, adding the Excel file to the destination folder, but when trying to open the file, Excel was giving an error indicating the file format or file extension was not valid, and to verify that the file extension matches the format of the file. I did some tinkering and somehow the issue was resolved (it may be that I removed some of the spaces I had in my file name, although I still have one space in my file name and it now works). By the way, wouldn't there also need to be a Get Attachment action (New Email Arrives > For Each-Get Attachment > Create File)? That's how I have the steps set up here.
Great news and great job @darrenchewitt!! So both flows will work, you can still get the Attachment details from the When A New Email Arrives action but at the end of the day if you are getting the result you need, that's what counts. Keep up the good work!!
it worked perfectly!! thanks a lot!!!!!!
Hello @mijailhurtadovillegas1480, that's awesome, great job!!
Hey! Is there a way to automatically calculate the hours? For example, if a vacation is from 1-5 of July, that's 5 days x 8 hours = 40 hours. Also, a good customization would be if the calendar can be integrated with the official national holidays of the country, so that the hours are calculated accordingly. With the example I gave you above, 4-th of July is actually a national bank holiday, so the hours consumed for a vacation between 1-5 July would be 32. Thanks.
Hello @georgegoranoff, very interesting request, I will need to look into more, I'm traveling this week and will try to respond sometime next week.
Hello @georgegoranoff, I was able to figure out how to do the first request in SharePoint Lists. To do this you would need to create 3 calculated columns, called Total Hours Off, Weekend Hours, Net Hours Off. Total Hours Off formula: =(([End Date]-[Start Date])*8)+8, Weekend Hours: =(INT((DATEDIF([Start Date],[End Date],"D")+WEEKDAY([Start Date]-1))/7)*2)*8, and Net Hours Off: =[Total Hours Off] - [Weekend Hours]. I might do a video on this but connected with Power BI and include Federal Holidays. Stay tuned.
great video could I use this method to build something similar to replace wrike? My company wants me to create a sharepoint site to manage our project portfolio and remove from wrike since associates are not updating wrike consistently
Hello @bitokay147, thanks for reaching out, this is the first-time hearing of wrike, but after researching them, yes, it looks like SP Lists would be fine, I have another video on how to connect Power BI to a SP List to run analytics on the data here: czcams.com/video/RjxUhAEB6os/video.htmlsi=mw0Ow-_lJGzFbZrg. Feel free to reach out to me with any questions: www.tw-waytek.com/contact-me/
Hi Tyler! So using the approvals PA flow at my email comes through but it does not say deny or approve at the bottom. It just says “Trey Howard added Test Vacation” and “Go to Item”
Hello @roberthoward2738, thanks for reaching out, that's a tough one, I'm not sure exactly the issue without seeing your flow, can you share a screenshot of your flow and the resulting approval card at the link below and I'll try to help you out. www.tw-waytek.com/contact-me/
hello, great video. Sorry noob question, but i do not see the x-ms-file-id from the dynamic content, what should I do? or can I use full path instead? thanks so much in advanced!
Hello @charisseaustria4711, thanks for reaching out with an excellent question, so it looks like I need to update my video due to recent updates in Power Automate. The trigger "When a file is created in a folder in SharePoint" is now deprecated and the new trigger is "When a file is created or modified in SharePoint (Properties Only)". For the Create Table action under the File property select the Dynamic Content from the SharePoint trigger called "Identifier". Try that out and let me know how you make out.
@@tw-waytek OMG! thank you so much for your reply. It still doesn't work. It says branching condition not satisfied :( I'm trying to get data within the excel table and update file property for one of the columns in document library. Do you think it's possible?
Brilliant video - are you doing more?
Hello @pravinshingadia7337, thanks for your positive feedback, I'll be doing more, do you have anything you'd like to see?
Hi there! I've reached out to you via your website with the error message that I'm getting when trying to replicate your flow. Can you please help me here! Thank you so much!!
Hello @seangeorge6423 , thanks for reaching out, I received your request and will review. Stay tuned for a response.
Hey man , all works but whe the data is copied to the excel file , the headers are wrong. It leaves blanks rows equally to the amount of columns in the csv table and then paste the data. Any ideas ?
Hello @mauvenegas94, thanks for reaching out, can you share a screen shot of each action with me as well as the final excel file from the link below, this will give me a better idea of how to troubleshoot the issue: www.tw-waytek.com/contact-me/
Hi there, Sorry, I have a slightly different request but cannot find a solution anywhere and hoping you can help me please. I have a flow that pulls the attachment from Outlook and creates the file in SharePoint - all works fine! However, the file I receive in Outlook has a date added to the end i.e. TestData May 30 2024 or TestData June 6 2024 etc. I'm looking to remove the date of the end and just end up with 'TestData' so I can overwrite the file that is currently there to be able to link to Power BI. Any help would be very much appreciated. Thanks in advance, Charlotte
Hello @CharlotteGodding, thanks for reaching out and great question, I'll review it, test it, and get an answer to you sometime this week.
Hello @CharlotteGodding, what I recommend assuming your flow is based on the one from this video is to remove all the Variable and Compose actions and under the Create File action change the File Name to: TestData.xlsx and leave all else as is. This change will keep the file name the same no matter what the name of the attachment is and will overwrite the existing file each time the attachment is saved. Give it a try and if you have any issue feel free to reach out to me here: www.tw-waytek.com/contact-me/
@@tw-waytek Thank you so much, I really appreciate your help. It looks like it is working (adding a new version of the file with the updated file name), but I am getting this error when trying to open the file once in SharePoint; "Excel cannot open the file '****' because of the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file" I have checked and both the file being received into Outlook and the option in the Create File are xlsx Thanks
Hello @CharlotteGodding , no problem, I'm happy to help, can you send me a screen shot of each action, including the "For Each action" in your flow from the link below: www.tw-waytek.com/contact-me/
I just started using SharePoint lists to manage my projects with a client. I have two lists, one holds the projects and one holds the subtasks. Looking forward to the next video that shows how to display the [List]. Thanks for sharing this!
Hello @informatic-ai, thanks for sharing, stay tuned as it's coming up next.
How to delete the entries on the pto entry table? When I delete the Row remains visible..also in calender view the name of the employee is not visible ..can we do that ?
Hello @soumyadip1000, thanks for reaching out, to delete a row from the list you need to mouse over a row and select its radio button to the left of its name, then select delete in the menu. This will remove the row from the table and any views you have created. To see the Team Member name in the Calendar View, edit the view and change the "Title of Items on Calendar" to Team Member. I hope this helps, let me know how you make out. If you are still struggling with it, feel free to contact me directly at www.tw-waytek.com/contact-me/
is there a way we can let Power Automate to determine the number of rows in a new file which is needed to create the table?
Hello @tarshmidha5879 , thanks for your question, you can by using the OFFSET and SUBTOTAL formulas. Here is an example of the formula: =OFFSET('Sheet1'!A7,0,0,SUBTOTAL(103,'Sheet1'!$A:$A),37). 'Sheet1'A7 is the starting point and 37 is the number of columns in the table, those should be the only two values you need to change. Let me know how you make out and if you have any other questions.
thanks, helpted a lot. Btw My runtime for 22000 records was 17 min, still aboslutly fine
Hello @nayanfrancis477, thanks for reaching, I'm glad I was able to help and that your import was successful. 17 mins for 22k records is actually not too bad seeing my 50k records was 5 hours, but I guess the column count also affects the import time. Thanks for sharing!!
Thank you this works perfectly for managing my project team's PTO!
Thanks @AprilVaden for your positive feedback, much success for you and your team!
Hi, great video! I have a query. How are you not getting the threshold error? As soon as I uploaded the Excel to list I am only able to view the data in online sharepoint and not the list desktop app. Also in the settings of list it is showing threshold issue. How do I fix that?
Hello @UmairKhan-gx4mw, thanks for reaching out, how many rows are you trying to import from Excel and did you update the Pagination settings in Power Automate under the List Rows Present in a Table action? You can also reference the link to my blog under Large Dataset Limitations: www.tw-waytek.com/how-to-import-a-large-excel-dataset-to-sharepoint-using-power-automate/
On the calendar view by selecting title, how can you tell which leave has been approved or rejected by each user
Hello @ashleymcintosh6697 for your question, based on the existing setup, the easiest way to do this would be to add a choice column to your list called Approved with the option of selecting either Yes or No, then on the calendar view you can add conditional formatting to the title color based on whether the Approved drop down is Yes or No. Visit my post below on how to setup conditional formatting: www.tw-waytek.com/5-big-enhancements-to-a-sharepoint-vacation-tracker-in-microsoft-lists/
the flow run is failing at the run scripts bad gateway after 2 retries timeout
Hello @sohaibnajam1161, thanks for sharing, can you send me a screen show of your flow along with the error output, you can reach me here: www.tw-waytek.com/contact-me/
This was EXACTLY what I needed. Easy-peasy low coding and very effective! Thanks so very much for sharing!😊
Hello @AVielot , thanks for your positive feedback and I'm glad the video was helpful. Reach out anytime if you have questions or feedback as both are always welcome.
Great video! I have only one issue: when im going to add the list to my team in Microsoft Teams, it doesnt show up and when i insert the list link it says "This connection did not work because you do not have access or because it is not supported." Can you help me?
Hello @DinisPereira-wj2ru, thanks for reaching out, there could be several issues, reach out to me via my contact form and share some images of the issue so I can better troubleshoot for you: www.tw-waytek.com/contact-me/
I am looking for the calendar view and it is not there. I have no plus sign next to all items. Any suggestions?
Hello @AngelCook-te3fn, thanks for your question, you're on an older version of Lists, but no worries, click on "All Items" and then "Create New View". You can also visit my blog post which shows it from the previous version: www.tw-waytek.com/sharepoint-team-vacation-tracker. Let me know how you make out.
If i want to add all teams members with 100 people how can i add ?
Please answer
Hello @mohitsaini9231, thanks for reaching out, are you asking how to share the list with your team of 100 people? Visit this link: support.microsoft.com/en-us/office/share-a-list-or-list-items-46ea196c-78a1-4d3d-b672-a272cba06fb0. Let me know how you make out.
Thanks for the video. Its very helpful. do you also happen to know what if i just want to update data in a row referencing from Excel 1 to Excel 2. Like if there are submissions with the same ID or unique row , it will trigger for it to update the existing row and not to just add data in a row? Hope you can read this! thanks again!
Hello @arahabigailbalgos6897 , excellent question, I've never setup a flow in Excel to not only allow appending data but also updating existing data, I've made a note to do a future video on it. In the meantime, you can visit the link below to see how the data comparison part would be done, I hope this helps for now and thanks for turning into my channel. sharepains.com/2020/11/11/compare-2-excel-files-power-automate/
Hi! at 7:03 when you start talking about Team Members Hours... How do you calculate how many hours it is between the two dates selected? Whilst using a number column I am unaware of how to calculate this. In a calculated column you can use [column_name]-[column_name] however, in a number column what formula is used here?
Hello @freddiesymonds7640, thanks for your question, for this post I'm not actually performing a calculation on the number of hours between two dates, I'm manually entering the number of hours taken off based on how many days taken times 8 hours per day. So, in this case it would be up to the user to manually enter the number of hours they are taking off. Let me know if I understood your question correctly and if I answered it.
Hi Tyler! Thanks for sharing and simplifying ways to incorporate the vacation tracker via SharePoint. Quick question - is there a way to display the vacation tracker/calendar for an entire year, Jan 1- Dec 31? For example, not only will it display vacation but days team members are attending conferences as well.
Hello @sherriejohnson6746, that's a great question and thanks for sharing, unfortunately, the only available SharePoint calendar views are "Month", "Week", "Work Week" and "Day".
@tw-waytek ahh, thank you! Do you train on SharePoint? I'm new in my position, and I've been given the task to clean up the sites and integrate the two shared sites to one.
Hello @sherriejohnson6746, that depends, hit me up at www.tw-waytek.com/contact-me/ and we can discuss in more detail and I'll try help you out in the best way I can.
thank you for the video Tyler. I just set it up, but I chose a vacation from July 1st 2024 to July 4 2024. In the calendar view, it doe not show the time frame (period). It only shows the day of July 4th as vacation day. It does that for all vacation time frame added. Any suggestion?
Hello @oangelavenir, thanks for reaching out, if you click on the drop down on the calendar view, you should see the option for the type of calendar views, there is "Month", "Week", "Work Week", and "Day". It sounds like "Day" is selected and you need to change it to "Month". I hope this answers your question, let me know how you make out.
Doesnt work either - the excel file is properly saved to the folder, but it is only 1ko. It doesnt grab the content of the excel file
Hello @fradinalexandre8958, thanks for reaching out, can you send me some screen shots of your flow so I can help troubleshoot the issue, you can reach out to me in any way you prefer by going to the About Me section of this channel.
@@tw-waytek I have the same issue. Is it possible to have a solution. I think the issue arrive with the storage on sharepoint folder but not one drive folder. I don't understand why
Hello@@user-lo2nf6bt6d, thanks for your question, can you share a screen shot of your flow with me by going to this link: www.tw-waytek.com/contact-me/. It shouldn't matter whether you use SharePoint or OneDrive. I'm happy to try and help troubleshoot this for you.
@@tw-waytek Okay not problem
This is amazing in its simplicity! Other instructional videos will have you running 2 scripts and importing them via Power Automate but this circumvents it and gave me a solution in 5 mins. Thankyou so much
@Steve-fs7ze, thanks for your feedback and glad I could help.
How can we add this as with approval actions? i.e having it sent for approval then automatically adding to the calendar?
Hello @cloutierlouise1623, thanks for your post, I created a video that shows how to add approvals to your vacation tracker which can see here: czcams.com/video/yJHLltgiel0/video.html. Question, after an approval are you looking to add the vacation request to the SharePoint List Calendar view or to a Microsoft Outlook Calendar?
Thank you! This video was very helpful!!
Hello @claycampbell5568, thanks for your feedback, I'm glad it was helpful. Reach out if you ever have any questions.
Inefficient. Use batch processing for sharepoint lists instead.
Hello @jakubholasek8290, thanks for your feedback, if you have an example you can share (like to another video) that would be helpful.
It looks like not doable!! i followed same step but got threshold error!!
Hello @nidhishah1353, thanks for reaching out, how many records and columns are you looking to export? Also, do you have any filters in your query?
@@tw-waytek i have records like 6519. When i followed your video i could export only 5000, more than that it said Threshold limit reached. Columns i exported was 2 only, text columns.
@nidhishah1353, did you turn on Pagination and change the threshold limit to something like 10,000?
@@tw-waytek It looks like this works for an instant trigger, but the Scheduled trigger has a limit of 5,000 on the pagination threshold :(
Hello @1987Geraint, thanks for your insight, I'll see if can replicate the issue when running a scheduled trigger and post my findings.
Thank you for your video! It helped me successfully export a long SP list.
Can I integrate this to outlook ?
Hello @ramyayandrapu1935, great question and thanks for asking, I recently posted a new video that shows a few ways of tracking what is happening in the Vacation Tracker via email (to Outlook) that you can visit here: czcams.com/video/yJHLltgiel0/video.html. There is not a Microsoft List app that can be added to the Outlook sidebar like other Microsoft apps, unfortunately. If interested, I could look into either how to receive a daily or weekly email of the current snapshot of open vacations from the tracker or maybe even to integrate the vacation dates into a calendar in Outlook, your thoughts?
Can recurring dates be added?
Hello @bobblandeburgo3842, thanks for reaching out, there is nothing out of the box in SharePoint that I'm aware of to accomplish this task. The best option would be to create a flow in Power Automate, here is a link to a video series on how to set that up: czcams.com/video/6M7GE14E6e4/video.html. I hope this helps and let me know if you have any other questions.
@@tw-waytek Thank you!
Hi! Do you know if it's possible to select a range like from A2 to C6 in your example, and then paste it to the other workbook? Thanks for the video:)
Hello @sofiaibarra1883 , thanks for reaching out and great question, as long as your cell range is set as a table you can copy its contents to other workbooks or worksheets.
Very helpful
Thanks for reaching out @blessingjunior2780, I'm happy to have been helpful.
Thanks for sharing, just quick question can i have field for number of days off excludes weekends
Hello @Mostafahassan14, it is no problem to add additional fields, are you looking for any type of business logic as part of your request?
It is exactly what I have been looking for. Thank you so much!! The only question I have is that if there is a way to add an approval layer? I will try to look for it from my side but would greatly appreciate your inputs.
Hello @sandeeptable , thanks for your comment and I'm glad I was able to help. I plan on doing a part 2 of this video to include an approval process hopefully next month, so stay tuned.
@@tw-waytek Thank you so much!! Looking forward to it. 👍
Hello @sandeeptable, just a heads up, I posted a new video on providing enhancements to your Team Vacation Tracker: czcams.com/video/yJHLltgiel0/video.html to include approvals.
Hi, thanks for the video. Why didn't use th import option from the List app directly? Is it because of the size? Thanks``
Hello @assiabouhadouza1927, great question, the import will timeout with an error message stating the number of rows in the table cannot exceed 20,000 rows. Thanks for reaching out, let me know if you have any other questions.
need to do "set variable" upfront. doing it inside the "for each" step is not allowed.
Very valuable stuff indeed. Only thing I'm missing an wondering if this can be added is how to get an overview on a certain member's total days or hours off or have it being deducted from a grand total of holiday hours which are set at the start of a contract.
Hello @bramaupers2984, thank-you for watching and excellent feedback, I will look into seeing if your suggestion could be implemented.
Hello @bramaupers2984, just a heads up, I posted a new video on providing enhancements to your Team Vacation Tracker: czcams.com/video/yJHLltgiel0/video.html to include tracking hours.
I just did this for my IT team, and it is a godsend. It was so simple and really met a need. The feedback from my team is that they love it, and it is convenient since it is located directly in Teams, which is where we live. The only gripe is that we wish we could have distinct color for the different team members in the calendar view.
Hello Matthew, thanks so much for the positive feedback and I'm so glad I could help. I know there is a conditional formatting option, let me look into it to see if it could solve your only issue, which is a valid one.
Hello @MatthewParksSr, it's my pleasure, if you go to your Calendar View from Microsoft Lists and select the drop down, there should be an option to Format Current View, select it and click on Manage Rules under Conditional Formatting. Here you can assign different colors to different team members. If "Team Member" is equal to "User Name" Show List item as "Specific Color". Create a separate rule for each team member. Try it out and let me know if it works for you and do not hesitate to reach out if you have any other questions. I like where you're going with the other features such as setting up Reminders using Power Automate. Maybe I'll do another video based on your recommendations, let me know if you have any other ideas related to the Calendar view.
@@tw-waytek SHH... This may be a startup collab for us. I will give it a try when as soon as I can. Thanks for the work!
Hello @MatthewParksSr, just a heads up, I posted a new video on providing enhancements to your Team Vacation Tracker: czcams.com/video/yJHLltgiel0/video.html
I followed your video and created a very successful flow. However, why this flow is only able to copy the first 256 rows from one Excel to another. My file actually had over 10,000 rows? Can you suggest why? Thank you!
Hello @shuchenlu3459, thanks for reaching out, there is a 256 row threshold limit for the Power Automate Excel action List Rows Present in a Table, to overcome this limitation, go to the List Rows Present in a Table action in your flow, go to Settings, go to Networking, turn on Pagination and enter the number of rows you need. Let me know how you make out with your flow or if you have any other questions.
An excellent video, thank you. I did an extensive search for this and only your video remotely came close.
This is just installation but How to connect to datagateway in powerautomate to access the onpremise business central
Hello @MrIndra170, thanks for reaching out, there is actually a Business Central (On-Premises) Power Automate connector available and from the documentation it doesn't look like a data gateway is required. Below are two links that can help you get started. Let me know how you make out with the connector or if you have any other questions. learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/powerplatform/power-automate-overview learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/powerplatform/power-automate-setup
I keep getting an error when trying to open the file. 'This workbook couldn't be opened because the file format may not be matching with the file extension'.
Hello annamarievanwyk6411 and thanks for your question, I came across this link while researching your issue, it gives several solutions but I'm guessing it is method 2, let me know how you make out with it: appuals.com/file-format-and-extension-dont-match/#:~:text=As%20it%20turns%20out%2C%20the%20%E2%80%98File,email%20attachments%20as%20a%20security%20option.&text=As%20it%20turns%20out%2C,as%20a%20security%20option.&text=turns%20out%2C%20the%20%E2%80%98File,email%20attachments%20as%20a
I followed each step in the video and each step in this article and nothing works! it breaks the workbook every time. I can manually drag the file over and it works but using a flow breaks it. even when just using the attachment name without any time stamp.
Hello @bendreessen2809, Sorry to hear that, feel free to send me an email of your flow, you can find my contact details in the About section.