Working with multiple work accounts on a windows 10 device
Hello everyone I think it's time for me to vent my frustration about working with multiple work/education accounts on a windows 10 device... First of all, I have 3 Microsoft Accounts (1x Personal; 1x Work; 1x Education) and oh boy, it's very very frustrating to get all these 3 Accounts work together on the same windows 10 device with one Userprofile. Working with my Personal and Work (or Education) account on the same device works fine, no problems, but as soon as I add additionally either my Work or Education Account in the Windows 10 settings under "Account > Email & accounts" things starting to get complicated. Sync issues across every app that uses one of these work/education accounts (classic Office Apps, ToDo, Edge, OneNote) Upload blocks in the office apps (Word, Excel...) & Credential Errors 4x/day a notification toast that my work accounts need to fix... blabla -> I click okay, now fix it -> Accounts fixed -> later in the day, same error occurs... I just want to use all my accounts on the same device with the same Userprofile, I really love the Microsoft 365 Platform but these things driving me crazy. I had a time, in there I worked completely online, but yeah, we all know how cool it is to work with the online versions of Office Apps. I also tried multi-bootable windows installations or multiple Userprofiles and it worked, but I often need to access files/services that are stored in the OneDrive from my Education Account or vise versa, so it's really impracticable. Then I tried to link my accounts just in these apps where I need it, but Windows 10 really have fun on it to write in my accounts under the named windows 10 settings location. Has anyone a best practice, tips/tricks etc. everything helps... Thanks.
Adding a comment to a DevOps Work Item using a given user
Second time writing this, as when trying to post the first time it gave me an error "invalid html" and discarded all my content -.- In Flow, I am using a DevOps - Update Work Item action, that updates a work item and adds a comment to it, using the Other Field "history" as the content of the comment. The problem is that the author is set to be the owner of the connection that the action is using, yet since the flow is triggering using an email, the author needs to be set dynamically using the email's author (provided he has an account in DevOps). How can I do this? Is there another name in "other fields" section, perhaps something like "Author" that I can use to set the author of the comment given the name, email or id from the email that started the flow? Screenshot:
Overtime Calculation with Multiple Work Rates
I need a formula that will accomplish the following, and I am not sure how to create it. We have employees who have 2 different rates, one for Work and one for Drive. Our payroll spreadsheet has each day of the week broken into work and drive hours. We need a formula that will take the summed total for work and drive hours, apply the first 40 total hours to their respective column, and add the remaining work and drive hours to the work and drive overtime columns. I have figured out how to create a formula that will put the first 40 hours into Work and the remaining hours into Work-OT, but cannot determine how to accomplish this considering both rates, ie. if the employee hits 40 hours half way through their drive on Friday, the remaining drive hours as well as drive hours from Sat + Sun are put to the Drive-OT column, and the remaining work hours for Sat + Sun are put to Work-OT.
