Power Automate BULK / Batch Create Dataverse records FAST with the Web API
Vložit
- čas přidán 10. 04. 2024
- Instead of an Apply to Each you can create Dataverse records in batches using the Invoke an HTTP action mentioned here!
Training for Architects:
www.untethered365.com/archite...
Documentation:
learn.microsoft.com/en-us/pow... - Krátké a kreslené filmy
Here's a link to even better documentation that uses a different endpoint that's even faster:
learn.microsoft.com/en-us/power-apps/developer/data-platform/bulk-operations?tabs=sdk
I can't force it to work, I'm getting InternalServerError
@@Gregix1337 can you even ping the API? Like do a get request. I'd confirm that's accessible first.
@@Untethered365 I was able to check if CreateMultiple method is available for my table using GET method to this endpoint:
GET [Organization Uri]/api/data/v9.2/sdkmessagefilters?$select=sdkmessagefilterid&$filter=sdkmessageid/name eq @message and primaryobjecttypecode eq @table&@message='CreateMultiple'&@table='my_table_logic_name' HTTP/1.1
Content-Type: application/json
Its mentioned in documentation that you provided under "Availability with standard tables" section, and as a respose I recieve appropiate sdkmessagefilterid GUID which according to docs is good (if my table wasn't capable I would recieve an empty string).
I made reddit and PA community post with screenshots of header & body request however I cant put a link because my comment will get automatically removed.
@@Untethered365 yes, I was able to make GET call to check if my table supports CreateMultiple endpoint (see "Availability with standard tables" section in docs^). As a response I recieved sdkmessagefilterid GUID.
I made a post on PA Reddit and PA Community forum with screenshots but I can't put links in a comment because it gets automatically deleted.
@@Untethered365 Just woke up and it randomly started to work. I don't know what was the problem...
This is epic!.. both the approach and the delivery. Spot on. Thanks for sharing 🙏
Woo! I'm curious how often I'll actually use this :)
Wow great video 👏
Does this only create records or can it do delta update too?
I haven't tried with update but I'll make a video on it if I get to it
Hello , I am in the process of attempting to utilize excel to create / update records in a SharePoint List. I currently have mu flow functioning the way i want. However, I am stuck at that 5000 limit. My data will be upwards of 200 times that. I know this will move slow but will work for what I would need.
How do I implement this on of these methods into it? I understand that I will have to turn my flow into a solution. Just not sure what that will look like with my needs.
Currently I am utilized a Scheduled Flow--->Get files (properties only)--->Apply to each->Update file properties->List rows present in a table->Apply to each-Get items-Conditions->Delay->Update file Properties
The video I watched to do this is
Reza Dorrani - Add & Update Excel Data to SharePoint List using Power Automate | Excel Import using flow
My flow will be almost Identical to his. The only difference is I did not need to do all the extra steps to select choices. My data is very clean and singular text.
But are you using Dataverse? Because SharePoint batch create is a different API.
@@Untethered365 Sorry SharePoint. When I googled this popped up.
I really don't get it... Everything is green in PA, but no records are showing up... How can I see some kind of logging how Dataverse receives the data?
I would create a Compose and copy and paste what's in the documentation and just see if you can make it work. From there look at the difference between your createdOutput and the documentated output.
You won't be able to "debug" because it's handled on the Server side for processing. I think there's an executions or "job" table.
@@Untethered365 thanks for your response. The web api doesn't seem to do anything with the body of the request. Even if I make errors or put a placholder text like 'blabla', all green. In the output I see a "$content": "long text string of different ", but not the body I put in there.
unfortunaly i have this error "The response is not in a JSON format."
Try the example payload in the documentation and compare it to yours. I'm sure there is a simple misplaced comma or something.