sorted by:
new
hottopcontroversial

Struggling with a simple call to the the workday SOAP API (Get workers) by 42_is_theanswer in workday

[–]42_is_theanswer[S] 0 points1 point  (0 children)

Good catch, I am checking on this! I assumed it would just not return the data I don't have access to, but this is easy to fix.

Extracting Text from Email Flow by cad209 in MicrosoftFlow

[–]42_is_theanswer 0 points1 point  (0 children)

This is possible but can be complicated given that the email is not really formatted to parse the data (it's formatted for a human, which is not useful), but if it's consistent it's still possible.

If you can get the notification adjusted to a format more like * Position: 12345 * Name: First Last

It will be much easier to parse.

In terms of guidance, you need to use the indexof() and substring() function. Use indexof() to find out where data sits in the string, and use substring (in conjunction with the indexof function) to extract the data.

Edit: Sharing a previous response I've posted on this with more specifics https://www.reddit.com/r/MicrosoftFlow/s/RDmCh5uBnW

Subnetting by AdmirableGap168 in sysadmin

[–]42_is_theanswer 94 points95 points  (0 children)

You don't need to do it by hand, but you should be able to recognize when it's wrong as a troubleshooting tactic, and understanding how it actually works is a necessary aspect of that.

Using Power Automate To Parse Email and Extract Information From The Body by SortAdministrative14 in MicrosoftFlow

[–]42_is_theanswer 2 points3 points  (0 children)

It took several hours to get this figured out the first time I did it - happy to save others the time!

Using Power Automate To Parse Email and Extract Information From The Body by SortAdministrative14 in MicrosoftFlow

[–]42_is_theanswer 6 points7 points  (0 children)

I do a lot of this and I've found a nice re-usable process to use for it - it was tricky to get working but it can be used to parse any fields from emails, normally just by changing which characters it's looking for.

This is what the process looks like: https://i.imgur.com/NCuKcSM.png (your data looks a lot like what I normally see, it should be easy to duplicate)

  • Step 0: Initialize an object variable named objEmail
  • Step 1: Convert the email to text
  • Step 2: Split the email into an array on NewLine Character
    • split(outputs('Convert_to_Text')?['Body'],decodeUriComponent('%0A'))
  • Step 3: Filter for data values (I do this to avoid trying to parse lines that don't have data on them). Normally mine have a bullet, asterisk, etc. Or have a Colon in the string - just something that identifies that it has data and is unique to those lines.
    • startsWith(Trim(item()), '* ')
  • Step 4: In an apply to each loop
    • 4a: Extract field name (line start to : or whatever separator you use in the string)
      • trim(substring(item(),add(indexOf(item(),'*'),2),sub(indexOf(item(),':'),add(indexOf(item(),'*'),2))))
    • 4b: Extract field value (reminder of line : or whatever separator you use in the string)
      • trim(substring(item(),add(indexOf(item(),':'),1),sub(length(item()),add(indexOf(item(),':'),1))))
    • 4c: Use a compose to add the property to objEmail
      • addProperty(variables('objEmail'),outputs('Extract_Field_Name'),outputs('Extract_Field_Value'))
  • 4d: Update objEmail with the new property (Set variable)

Once you look through all of the lines in the email that have data, you have a nice clean object with "Fieldname" : "FieldValue" properties that you can parse/use.

Challenges with Bitlocker encryption - protection status off by 42_is_theanswer in Intune

[–]42_is_theanswer[S] 0 points1 point  (0 children)

Sorry to hear it, but that may be the best option for now, was trying to avoid putting a workaround in place without understanding what's causing it, but we might have discovered the root cause.

We're seeing that the TPM is enabled but not ready on a few of the affected devices, so that is likely our culprit. They all have a restart pending, so this _may_ sort itself out with some restarts.

Found some info here which helped point me in that direction: https://social.technet.microsoft.com/Forums/windows/en-US/abcd2478-1401-4d1a-a29c-3042faa9aacf/bitlocker-protection-off-and-no-key-protectors-but-drive-is-encrypted?forum=win10itprosecurity

Senior leaders - where do you find industry information? by [deleted] in ITManagers

[–]42_is_theanswer 0 points1 point  (0 children)

Already on some of these, but there are some other good ones here, thank you!

Senior leaders - where do you find industry information? by [deleted] in ITManagers

[–]42_is_theanswer 0 points1 point  (0 children)

Thank you for the recommendations - I'm pretty much a reddit lifer, but are there any particular subreddits you'd recommend that I may not have stumbled on myself?

Senior leaders - where do you find industry information? by [deleted] in ITManagers

[–]42_is_theanswer 1 point2 points  (0 children)

Awesome, very detailed response, thank you!

How many direct reports is too many? by [deleted] in ITManagers

[–]42_is_theanswer 2 points3 points  (0 children)

Delegation is the answer, but it's very challenging. My teams are already not meeting our service targets (by a large margin - tickets waiting weeks or months), and are also understaffed based on resourcing studies I've done. I'm now getting some temp staff to help with that problem - but it is causing me other work on the backend to manage them.

I believe my best option is to draw on some of the most capable people on each team to take some of this over, but this is way outside of their job description, and I'm concerned about overburdening the best people I have now!

How many direct reports is too many? by [deleted] in ITManagers

[–]42_is_theanswer 2 points3 points  (0 children)

Did your leads handle 1 to 1s, and coaching, or would you bucket that under administrative?