I need to take the 'Office' display of the 'Created By' column and display the first 5 digits of it so that my flows can run a conditional check on it. The reason is that Microsoft flows has all the 'Created By' dynamic contents besides 'Office'.

I figured simple enough I'll just do a calculated column on the SharePoint list. Then I find out that 'Created By' cannot be used in calculated columns.

So I figured I'll have my PowerApp write the Users 'Office' as a default to a field when submitting a form and calculate it off that column. Unfortunately PowerApps only has User().FullName, Email, and Image.

I have pretty much exhausted the options for a workaround that my knowledge will allow. Hopefully someone might have some ideas.

  • Still attempting to find a solution. Haven't found one yet. Commented May 21, 2019 at 22:23

1 Answer 1


Since it seems that this is not a property of the user that you can grab I'd suggest just adding a column for Office and giving your users a dropdown list to pick from.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.