Answered

Set the value of lookup field to other single line of text field

(0) Share

Report

Posted on by Hetvik

In my table (dataverse) I have a lookup field and I would like to set a business rule to set the value of other field(single line of text) to the value of lookup field selected.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (10)

Answers (1)

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (3)

Report

Hi @Hetvik,

Unfortunately this is not possible using a business rule because the data types do not match up (you can set a text field using another text field value, etc.). If you need to see the text value set immediately upon setting the lookup in the user interface, then you will need to use JavaScript to achieve this. If it doesn't need to be immediately but can be on save, then you can use a classic Dataverse synchronous workflow to achieve this.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report

Hi @Hetvik,
This is not possible with a business rule in Power Apps.
Some options:
1. Custom JavaScript or Plugin
2. Power Automate flow - Although this would be asychronous...

Hope this helps. Please mark accepted or Like if provides some value.

Thanks,

Drew

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @ChrisPiasecki,

I was replying about the same time as you and testing out the real-time workflow. I was not able to accomplish this with a real-time classic workflow, were you able to make this work?

Thanks,
Drew

Was this reply helpful? Yes No
ChrisPiasecki 6,422 Most Valuable Professional on at

Like (1)

Report

Hi @dpoggemann,

You're right in that the workflow will only get the lookup fields primary field text, not the GUID of the record.

A custom workflow activity, plugin, or Power Automate Flow are options in addition to JavaScript as mentioned.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
Fubar 8,379 Super User 2025 Season 2 on at

Like (1)

Report

@ChrisPiaseckithink all that is being asked by the original poste is for it to copy the 'name' from the Lookup to a Text field and not the guid or other fields off the lookup record - and as such Real-time workflow is probably the way to go.

Was this reply helpful? Yes No
ChrisPiasecki 6,422 Most Valuable Professional on at

Like (0)

Report

@Fubar yes my original response was based on that assumption as well but after re-reading the original post I feel it could be interpreted as the value (guid) of the Lookup too. We'll see what @Hetvik responds back with.

Was this reply helpful? Yes No
Verified answer

EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report

Hi @Hetvik,

Not sure if this is resolved yet, but another option is with calculated columns/fields which would also avoid customizations with code (e,g. JavaScript) if you need real-time/sync.

Cheers!

Was this reply helpful? Yes No
Bruno Oliveira 23 on at

Like (0)

Report

Hi @EricRegnier ,
I tried with calculated columns, they work. However, the text field is only updated when I save the form. I wanted the field to be immediately updated, as soon as I change the lookup value. A part the option of auto saving the form in JS, can we do anything else?

Many thanks

Bruno

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report

Hi @brunex01, for calculated columns, unfortunately it would only only after saved because calculated columns are caclulated ar runtime when the record is retrieved (values are not stored in the database). JS would be your only option for now with an onchange handler. Maybe eventually when PowerFX calculated columns are released it may be possible, but something to try out them.

Hope this helps!

Was this reply helpful? Yes No
Bruno Oliveira 23 on at

Like (0)

Report

Thanks @EricRegnier . I appreciate your answer.
Cheers

Was this reply helpful? Yes No