web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Remove null Values fro...

Power Automate

Unanswered

Remove null Values from type object

(0) Share

Report

Report

Posted on by CU08070651-1

Hi,
I have a JSON object with multiple key-value pairs, and I want to remove all keys with empty string ('') values.

Example:

Input:

{
  "Key1": "value1",
  "Key2": "value2",
  "Key3": ""
}

Expected Output:

{
  "Key1": "value1",
  "Key2": "value2"
}

How can I achieve this with Power Automate?

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Chriddle 8,441 Super User 2025 Season 2 on at

Like (0)

Report
1. https://community.powerplatform.com/forums/thread/details/?threadid=7af7eed6-738a-ef11-ac20-7c1e5214681b

2. If there are only a few properties, chain this approach:

if( empty( outputs('Compose')?['Key3'] ), removeProperty( outputs('Compose'), 'Key3' ), outputs('Compose') )

3. If there are a lot of possible empty properties, this approach uses less actions:

Select

From: all the property names

Map:

if( empty( outputs('Compose')?[item()] ), removeProperty( outputs('Compose'), item() ), outputs('Compose') )

Compose 3

an intersection of all the items from the Select

intersection( body('Select')[0], body('Select')[1], body('Select')[2] )

Was this reply helpful? Yes No

Join the conversation