Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Updating two columns f...
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Updating two columns from spreadsheet

(0) ShareShare
ReportReport
Posted on by mykedeabreu 95

Hi All,

I am trying to update two columns in an entity that match on a column in a spreadsheet. My problem is that there are more rows than I want in the spreadsheet and the job will import those rows. I just want to update the rows that already exist in my entity.

I have tried using PowerAutomate but the job runs for 3 hours and also has a limit of 5000 with rows and does not seem reliable. Tried using Azure Data Factory but dataflows are not supported for Dyanmics(Dataverse). Any ideas how I can do this?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Updating two columns from spreadsheet

    Hi,

    You can export all the rows of your entity as excel/csv file and store it in Azure Blob Storage. Then you can inner join your spreadsheet and output to your Azure Blob Storage.

    Finally, copy the output file to your dataverse.

  • mykedeabreu Profile Picture
    mykedeabreu 95 on at
    RE: Updating two columns from spreadsheet

    I have a spreadsheet that is exported from another system daily. I want to then have a job that will list all the dataverse rows that match on a column with the spreadsheet and then update two columns within dataverse from the spreadsheet.

  • CaptJoe Profile Picture
    CaptJoe 140 on at
    RE: Updating two columns from spreadsheet

    Could you provide some more info?  When you say "match on a column" is there a single value that you're trying to filter on? Or is it more of a vlookup/primary key situation?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans