web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Send gallery data to p...
Power Apps
Answered

Send gallery data to power automate flow in json format

(0) ShareShare
ReportReport
Posted on by

Hi all, i have a scenario that i want to send my entire gallery data to power automate in json format but here my issue is I'm dealing with multiple columns sometimes i get only few columns in gallery and some times i get all columns. If the given column is not available in gallery the condition which i have written is giving error can anyone help me on this

I want to make my columns in dynamic or if possible i want to remove column names in condition and get the all columns values in JSON format.

 

My code which I'm using is : 

 

Myflow.run(JSON(showcolumns(gallery1.allitems,"colmn1","column2","column3"), JSONformat.compact))

 

Sometimes i may get 5 columns also - ex : column1, column2, column3, column4, column5

How can i modify my code to work on dynamic column names any suggestions.

Categories:
  • LuizVicente Profile Picture
    984 Super User 2024 Season 1 on at

    For now, I think it's easier for you to remove the "required" property from Parse JSON, making the fields optional.
    I'm thinking of some ways to do this, but I don't have anything for now...

  • CU06020423-0 Profile Picture
    on at

    Hi @LuizVicente  if you can please share me the sample code how can i get all my gallery data in JSON format without specifying column names.

  • CU06020423-0 Profile Picture
    on at

    @@@WarrenBelz , @Amik , @mmollet , @RJM07 , @BCBuizer   Any help on this issue 

  • Ami K Profile Picture
    15,689 Super User 2024 Season 1 on at

    @PrathapReddy1  - sorry this is not an action I have done before so cannot provide any help.

  • CU06020423-0 Profile Picture
    on at

    Ok @Amik  thanks for the reply 

  • RJM07 Profile Picture
    801 on at

    Apologies, I'm not overly familiar with Power Automate, I want to learn it but I still struggle with it currently

  • Verified answer
    Cat Schneider Profile Picture
    488 Most Valuable Professional on at

    Have you tried simply using: Myflow.Run(JSON(Gallery1.AllItems, JSONFormat.IgnoreUnsupportedTypes))?

  • CU06020423-0 Profile Picture
    on at

    Thanks @CatSchneider it worked. Thanks for the help 

  • CU06020423-0 Profile Picture
    on at

    Thank for the reply @RJM07  . I got answer for my question 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 342 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 258

#3
Mohsin Ali Profile Picture

Mohsin Ali 231

Last 30 days Overall leaderboard