Answered

Set text field to CurrentUser when Status drop-down changes to Resolved

(0) Share

Report

Posted on by CarlHRVA

601

Hello, I'm trying to introduce the logic mentioned in the title of the post and having some difficulty with the formula. I would like to set the value of a text field "Resolved by TM" to the current users display name whenever a "Status" drop-down field is equal to "Resolved" else, if "Status" is equal to "Open", "Resolved by TM" should be blank. My current formula looks like this:

If(DataCardValue13="Resolved", DataCardValue37="CurrentUser", DataCardValue376="")

Any help would be greatly appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

PowerAddict 7,316 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

You can store the current user record in the OnStart property of the app with something like this:

Set(currUser, User().Name)

Or do a lookup and store the display name in a variable.

Then use something like this:
If(DataCardValue13="Resolved", DataCardValue37= currUser, DataCardValue376="")

Or if the variable stores the entire record, then use:

currUser.Name or currUser.'Display Name'

Let me know if this helps.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
The Power Addict
https://thepoweraddict.com

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,475 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @CarlHRVA ,
I will call the status drop down Status - substitute it for your drop down name.
I have also used the built-in user name function.
The default of the text box should be as below and you would need to reset it to populate it with this value.
If( Status.Selected.Value="Resolved", User().FullName, Status.Selected.Value="Open", "" )

If this post helps, then please consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
CarlHRVA 601 on at

Like (0)

Report
Copy link

Link copied!

This works! Thank you so much!

Was this reply helpful? Yes No
CarlHRVA 601 on at

Like (1)

Report
Copy link

Link copied!

@PowerAddict Thank you for your thoughtful reply. I tried what seemed like the easier route provided by Warren and it worked but I really do appreciate you taking the time to answer my question.

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

The reply from @WarrenBelz is definitely detailed out well.

Just one suggestion, there might be needs to use the same user record again in the app and if you keep calling the User() function in say a filter expression, it will lead to delegation issues. So as a best practice, you should store the current user in a variable.

Thanks,
Hardit Bhatia
https://thepoweraddict.com

Was this reply helpful? Yes No
WarrenBelz 154,475 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Totally agree with @PowerAddict - I do it on every app.
I just did not want to complicate this one more than I already had.

Was this reply helpful? Yes No
CarlHRVA 601 on at

Like (0)

Report
Copy link

Link copied!

@PowerAddict @WarrenBelz Thank you both very much. I've been able to use the same formula but substitute the currUser variable for the User()FullName and it works as expected

Was this reply helpful? Yes No