Handling Property Existence in SharePoint JSON Responses using Power Automate

In scenarios where SharePoint Lists contain more than 5000 items, handling paginated data becomes crucial. When making HTTP calls to retrieve data, the response often includes a __next property. This property serves as a marker for paginated data, and its absence indicates the end of the dataset. Safeguarding your process against potential errors involves checking the existence of a property before attempting to access it.

To assess the existence of the property, you can use the following formula:

contains(json(variables(‘varSampleJson’)), ‘next’)

Here’s how you can handle property existence in JSON responses using Power Automate:

The formula within the compose action returns a ‘true’ based on the provided JSON sample value.

Conclusion: By incorporating this property existence check, you prevent potential errors that may arise from attempting to access a non-existent property.