cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
freddiejoseph1
Helper II
Helper II

Exporting dataverse/CDS table to SharePoint list

Hi all,

 

I have a powerapp which allows users to submit information about tickets they have been working on throughout the day. That information is stored in the dataverse because the app is built and runs within MS Teams. I was just wondering what the best way of exporting all the entries/rows into a SharePoint list is?

 

I know I will probably need to use PowerAutomate but can anyone guide me how to do a bulk transfer of all the rows which have already been collected?

 

Thanks,

 

Freddie

1 ACCEPTED SOLUTION

Accepted Solutions

Thanks for the feedback. I have managed to get all the past entries over from CDS to SharePoint now. I am trying to now create a reoccurring flow every Friday to upload the weeks entries. I have created another post on that here: https://powerusers.microsoft.com/t5/Building-Flows/CDS-Dataverse-Filter-by-the-last-5-days/m-p/84400... I am really close to getting it right (I think) so any help would be much appreciated.

 

I will create a flow to delete all of the entries from SharePoint that are older than 4 weeks old to avoid the list getting too big 🙂

 

Thanks,

 

Freddie

View solution in original post

2 REPLIES 2
cchannon
Responsive Resident
Responsive Resident

If it's a one-time transfer you're after, I would just Excel export and import: it isn't worth taking the time to try to build something in PowerAutomate for it.

 

If you're looking for ongoing synchronization, you will need to make a lot of considerations including how you handle Creates, Updates, and Deletes when they happen in each system: what do you sync and when and under which conditions? Make sure you've taken the time to map all that out before you even begin to think about a technical design.

 

At that point, you can start to build out your solution. PA will probably do the job well, given its excellent trigger flexibility and baked-in SharePoint and Dataverse connectors. Decide your trigger (scheduled or event-based) decide your filtering and logic, then write your Flow.

 

Lastly, a word of warning if you try to operate this at scale: SharePoint Online is not well-optimized for bulk importing. It has baked-in throttling controls which drop down on you like a lead weight if:

  1. you aren't appropriately decorating your CSOM call headers and
  2. you are hitting the API too many times in too short a period

This matters to you because PowerAutomate's connectors probably (not sure, just guessing here) do not contain the aforementioned decorators so if your volume ever gets high (there is no definitive number for this, but it could be as low as a few thousand transactions in an hour) SharePoint may lock you out temporarily for exceeding its throttle controls. This would result in unexpected failures when your job tries to keep writing to SP, but has been locked out. So, before you go down this road, make sure you know what your expected traffic level is and have plans for how you will gracefully handle failures if there's any chance you'll hit them.

Thanks for the feedback. I have managed to get all the past entries over from CDS to SharePoint now. I am trying to now create a reoccurring flow every Friday to upload the weeks entries. I have created another post on that here: https://powerusers.microsoft.com/t5/Building-Flows/CDS-Dataverse-Filter-by-the-last-5-days/m-p/84400... I am really close to getting it right (I think) so any help would be much appreciated.

 

I will create a flow to delete all of the entries from SharePoint that are older than 4 weeks old to avoid the list getting too big 🙂

 

Thanks,

 

Freddie

View solution in original post

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power Apps User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (38,078)