web

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

News and Announcements icon

Power Platform CommunityForums Power Automate - General Discussion Remove null Values fro...

Power Automate - General Discussion

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:

Process Advisor

All responses Img

All responses (1)

Answers Img

Answers (0)

Chriddle 7,934 Super User 2025 Season 2 on at

Like (0)

Report
Remove null Values from type object

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] )

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Announcing our 2025 Season 2 Super Users!

Quick Links

Leaderboard > Power Automate

#1

Tomac 986 Moderator

#2

stampcoin 699 Super User 2025 Season 2

#3

Riyaz_riz11 577 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

How to Ask for Help with Your Power Automate Workflow

Product updates

Microsoft Power Platform Community release plans