Power Platform Community Forum Thread Details

Oracle Database to SharePoint List

Working off of an already established workflow that seems to be dropping some records from Oracle to SharePoint.

Currently we use Oracle/PeopleSoft as our source of truth for employee records. We have a view setup just for our SharePoint list. This list is used in countless Power Apps from everything for HR forms down to records requests. Recently it was brought up that an active employee was not pulling when entering their coworker ID into one of these forms. After looking at the SharePoint list where this employee's record should be, it is missing.

Our Oracle table currently has 20659 records that we are pulling, while our SharePoint list only shows 20510 records. We've verified that the record is being pulled from the Get Rows Oracle connector.

The issue seems to be in our Send an HTTP request to SP. The output shows 20660, but in a compose directly following the Send to convert base64 to string, this employee's name does not appear as well as the other 149. The doesn't seem to be anything 'different' from that coworker's record compared to the others that are on the SharePoint list.

This is what was originally used to base this build off of:
Power Automate Flow to batch create SharePoint List Items (tachytelic.net)