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 / Collecting JSON type c...
Power Apps
Unanswered

Collecting JSON type column data of all records into a collection

(0) ShareShare
ReportReport
Posted on by

Hi Everyone!
I am new to Power-platform as well as low code development and stuck in the following logic for about a week.

The problem is I want to collect all JSON type sharepoint column data into a list which will later be used to validate whether a specific email is included in the list or not.

I have a sharepoint column of named 'usersEmail' and data format is as below : 

usersEmail
[{user1@gmail.com}]
[{user2@gmail.com}, {user3@gmail.com}]
[{user4@gmail.com}, {user5@gmail.com}, {user6@gmail.com}]

 

I want a collection which will only contain user emails as below :

colUserEmails
user1@gmail.com
user2@gmail.com
user3@gmail.com
user4@gmail.com
user5@gmail.com
user6@gmail.com


It would be a great help if there is someone who can help me.

Categories:
I have the same question (0)

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

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 326 Most Valuable Professional

#2
11manish Profile Picture

11manish 168

#3
sannavajjala87 Profile Picture

sannavajjala87 75 Super User 2026 Season 1

Last 30 days Overall leaderboard