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.
