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.
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.
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
Hope that helps!
Ferran
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2