Customer experience | Sales, Customer Insights,...

Updating entire column of data in a table according to rule

(0) Share

Report

Posted on by Anya

I have a table where the entries in the Owner column as all set to the same value, a lookup field. I would like to attempt to edit this entire column and try to set the owner by using the value from another column. So far, I've done this by exporting to excel, changing the values and importing it.

Is there a better way to go about this? Where do I start?

Thank you.

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Manoj Mane 1,020 on at

Like (0)

Report

Hi Anya,

You can refer below tool to update the data. It is a good handy tool.

Bulk Data Updater for Microsoft Dataverse and the Power Platform

Thanks,
Manoj Mane.

Please mark this as VERIFIED if it helps.

Was this reply helpful? Yes No
Suggested answer

SamiraM 587 on at

Like (0)

Report

Hi Anya,

For Bulk data update or upload best is to use www.kingswaysoft.com/.../ssis-integration-toolkit-for-microsoft-dynamics-365 SSIS.

You also have options to add conditions and do data cleansing work with SSIS.

Regards

Samira

Was this reply helpful? Yes No