Skip to main content
Community site session details

Community site session details

Session Id : cV1boGQHp/34B8Z7IQMb1l
Power Automate - Building Flows
Answered

Update SharePoint list with more recent records from DataVerse Table

Like (0) ShareShare
ReportReport
Posted on 13 Oct 2023 08:55:59 by 42

Hi,

 

I have 2 tables:

Dataverse:  id, Date, Notes

SharePoint: id, Date, Notes

 

Is there a simple way to:

UPDATE the SharePoint list, with records from the Dataverse table

WHERE the DataVerse Date col is more recent (greater than) the SharePoint Date col -

AND use the id col to match?

 

I've started writing several long winded flows (trying to avoid nested loops), but I'm probably overthinking it, and there's a short and easy way of doing this. Any help would be much appreciated.

  • Verified answer
    JW-17101720-0 Profile Picture
    42 on 13 Oct 2023 at 11:51:46
    Re: Update SharePoint list with more recent records from DataVerse Table

    Hi @fchopo 

     

    This is great, thanks! Yes this simplifies the process quite nicely - and it's a heck of a lot tidier than my flows.
    The one thing your solution doesn't do is account for records that get deleted in the Dataverse table, however I could easily do this with a separate flow.

     

    Thanks again, Mike. 

  • Verified answer
    fchopo Profile Picture
    7,972 Moderator on 13 Oct 2023 at 09:16:45
    Re: Update SharePoint list with more recent records from DataVerse Table

    Hi @miketurnertech 

    If you want to keep a SharePoint list synchronized with a Dataverse table you could do the following:

    1) Every day at 0AM (UTC)

    2) Get items from Dataverse table that were modified in last 24 hours (modified on gt addDays(utcNow(),-1))

    3) For each item found

    3.1) Check whether the item exists in SharePoint or not (in my sample, search for account name)

    3.2.) If count > 0  -> Item exists in SharePoint -> Update. If not, item doesn't exist -> Create

    update-insert.png

     

    Hope that helps!

    Ferran

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2