10
Hello,
I am pushing some data from Dynamics 365 to PowerBI and one of the fields is a lookup field so is not working as hoped. I think the solution would be to duplicate the field and copy the text into a text field. Is this possible at all?
Thank you
Hi Ttaylors,
You can try to use workflow to bulk copy lookup field name to thet ext.
1.Go Settings > Process to create a new workflow.
2.check 'As on-demand process'
3.add ‘check condition’ step to check lookup field is null or not.
4.add ‘update record’ step.
5.clcik 'Set Properties' to fill text with lookup field name.
then save and active the workflow.
6.Test.
Select records that you want to update and expand flow to run the workflow you just created.
before:
After:
Regards,
Leah Ju
Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,407
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
