Video

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.

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

Hello @mijailhurtadovillegas1480, that's awesome, great job!!

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.

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/

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

Hello @pravinshingadia7337, thanks for your positive feedback, I'll be doing more, do you have anything you'd like to see?

Hello @seangeorge6423 , thanks for reaching out, I received your request and will review. Stay tuned for a response.

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/

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/

Hello @informatic-ai, thanks for sharing, stay tuned as it's coming up next.

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/

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.

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

Thanks @AprilVaden for your positive feedback, much success for you and your team!

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/

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/

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/

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.

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/

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.

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.

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/

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.

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.

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.

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

@Steve-fs7ze, thanks for your feedback and glad I could help.

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?

Hello @claycampbell5568, thanks for your feedback, I'm glad it was helpful. Reach out if you ever have any questions.

Hello @jakubholasek8290, thanks for your feedback, if you have an example you can share (like to another video) that would be helpful.

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.

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?

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!

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.

Thanks for reaching out @blessingjunior2780, I'm happy to have been helpful.

Hello @Mostafahassan14, it is no problem to add additional fields, are you looking for any type of business logic as part of your request?

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.

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.

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.

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

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.

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

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.