Power Automate Update list item with User's Department

(0) Share

Report

Posted on by rpawliko

I'm somewhat new to Power Automate and I've been banging my head on this seemingly simple scenario:

User enters a new record. The record contains a People column. A single user name is entered in that field.

On submit, I want Power Automate to get the Department name for that user, and populate a text field called Department.

I've successfully used "Get My Profile" and extracted the Department name and forwarded it in an email.

But for the life of me, I cannot figure out how to get the string to populate the Department field on the record.

The most obvious method leaves the field blank:

And I've attempted to do it using a JSON trick I found online:

But always the same result - the flow runs without error and the Department field remains blank.

Help!

Categories:

General Questions

I have the same question (0)

All responses (4)

Answers (1)

WarrenBelz 151,709 Most Valuable Professional on at

Like (0)

Report

Re: Power Automate Update list item with User's Department

Hi @rpawliko ,

You are welcome to post here, but this seems to be a Power Automate question and you will probably get a quicker response from the experts over at the Power Automate Community

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report

Re: Power Automate Update list item with User's Department

HI @rpawliko,

Do you mean that Department column is single-line-of-text type?

If so, you should be able to use the Get user profile (v2) action for this. The output of that action returns the Job Title and Department fields.

If your Department column is single-line-of-text type, please directly apply the department string to this field.

Was this reply helpful? Yes No
rpawliko 12 on at

Like (0)

Report

Re: Power Automate Update list item with User's Department

Yes the Department column is a single line of text.

I've been able to capture the string in an email that goes out at the end of the workflow.

However, I've not been able to get the string into the Department column for the new item.

Can you tell me how I would do that?

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report

Re: Power Automate Update list item with User's Department

HI @rpawliko,

Add a compose and apply your extracted string to it, in your Create item action, select this Compose from dynamic content.

Run the flow, check if this Compose display the department correctly.

Was this reply helpful? Yes No