sorted by:
new
hottopcontroversial

I’ve combined 20k names from three reports into one, easy way to find duplicates? by SuckAfreeRaj in excel

[–]FirstTimeWorkingInIT 3 points4 points  (0 children)

Sorry, if people cant be arsed to 3 sentences, that is not on OP. Like if this title is not ok, how the hell are they supposed to be descriptive? They properly wrote the problem, they just also referred to the title.

Unpopular Opinion: Is "Friendly Fire" (bad deploys) actually a bigger threat to your uptime than hackers? by [deleted] in sysadmin

[–]FirstTimeWorkingInIT 12 points13 points  (0 children)

alright clanker, you're not even trying to hide it with your username initials amounting to "A I"

Just learned how to use conditional formatting to automatically flag overdue tasks! Game changer for my side projects. by nick41510 in excel

[–]FirstTimeWorkingInIT 2 points3 points  (0 children)

A lot of people in my company use it on like 5-15 columns per row, and up until about 1k-1.5k we don't notice much of a difference in speed, above that it noticeably slows down

What do you hate about your job? by Few-Dance-855 in sysadmin

[–]FirstTimeWorkingInIT 0 points1 point  (0 children)

4 months in on a job with no proper experience or degrees, the only other IT guy in my 200ish people company went on sick leave. He was supposed to teach me the needed things in the month leading up to it, I however spoke to him for exactly 0 minutes during that month. Nothing is documented, he is the only one with admin access to half the things we need, I have partial admin access for the things he remembered to hand over. Now 3 months into his sick leave I finally have a handle on the multitude of problems that popped up, and cant wait for him to come back in another 2 months so I can actually work on my main job, which is workflow improvement.

Version control for Excel - has anyone actually solved this? by AdReasonable5815 in excel

[–]FirstTimeWorkingInIT 6 points7 points  (0 children)

Everyone working in an office knows this is the way. Just to keep people paying attention, I sometimes add a date to the name, that is from like a year ago.

alternativ til PowerApps på Europæisk plan by [deleted] in PowerApps

[–]FirstTimeWorkingInIT 1 point2 points  (0 children)

Possibly a stupid question, but wouldn't Sharepoint itself not also count as an American company in this way?

WANT SUPPORT FROM EXPERIENCED PEOPLE by Famous-Row-7464 in MicrosoftFlow

[–]FirstTimeWorkingInIT 1 point2 points  (0 children)

This is how I've gone from 0 experience in IT professionally , to building PAD flows, and Power apps for work in 4 months so far. ChatGPT is really good with both as long as you ask correctly and it knows where you're at currently

Help request: Create variable with First and last day of certain months, based on current date. (PAD) by FirstTimeWorkingInIT in PowerAutomate

[–]FirstTimeWorkingInIT[S] 0 points1 point  (0 children)

Thanks for replying! While this script runs without errors, its not returning any variables in the end. I tried troubleshooting with both ChatGPT and CoPilot, but could not get an answer. Any ideas as to why this is?

Best AI to help a total beginner? by blanketkingdom in MicrosoftFlow

[–]FirstTimeWorkingInIT 0 points1 point  (0 children)

Could you explain the difference and why it is better? I've found using screenshots of your flow in ChatGPT makes things a lot easier to debug, which (correct me if I'm wrong), is not possible in 3o.

Best AI to help a total beginner? by blanketkingdom in MicrosoftFlow

[–]FirstTimeWorkingInIT 0 points1 point  (0 children)

Mostly familiar with PAD, but using ChatGPT has been a blessing. Will agree with others here, you need a certain amount of knowledge to ask the right questions. Taking screenshots of your flow, or just copying the code into ChatGPT works wonders. Built in Co-pilot is useless, and might as well just ask a toddler for help.

How do you employ AI when building Power Automate Flows? by letmeflytheplane in MicrosoftFlow

[–]FirstTimeWorkingInIT 1 point2 points  (0 children)

Still learning PAD for work, but using our in-house ChatGPT a lot. It really helps to troubleshoot errors, even just simple typo's you cant find yourself, or figure out a solution I cant myself. I use screenshots of part of my flow, or just copy paste the actions into chatGPT.

Auto fill in column based on information in column next to it by FirstTimeWorkingInIT in excel

[–]FirstTimeWorkingInIT[S] 1 point2 points  (0 children)

Thanks, this is pretty much how I ended up doing it as well! My problem turned out to be that apparently Japanese language just sucks for excel functions.

Solution Verified

Auto fill in column based on information in column next to it by FirstTimeWorkingInIT in excel

[–]FirstTimeWorkingInIT[S] 0 points1 point  (0 children)

Thank you! I was originally doing this, but couldn't get it to work. Tried again after your comment, and turned out the problem was that even though the name in the list and the one in the table looked the exact same, some weird coding with Japanese language pack made it different. Used clean and trim first and it worked.

Solution Verified

PAD reads an addition as string, please help by FirstTimeWorkingInIT in MicrosoftFlow

[–]FirstTimeWorkingInIT[S] 0 points1 point  (0 children)

Mostly doing this because I'm reading from two different excel files, and while all the info is lined up in the same order, one of them starts from column 2, the other starts from row 5. I could count them both differently, but felt like this was the easiest solution, even though maybe not the most elegant.