Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Collection, Current User, Nested Collection

I have a collection called myTheory that looks like this


Test 1OpenUser 1 | User 2
Test 2OpenUser 1 | User 2 | User 3 | User 4
Test 3OpenUser 1 | User 2 | User 3


The users column is a nested collection for each record and can have a wide ranger of users that are within that column.


The nested collection looks like this


User Claim Doe,  
User Claim Doe,  


  1. How can I compare the current user to the Users listed in that column for every record in the collection.
  2. If the current user is listed in that column, I want to change his status to "Submitted" in a dropdown box labeled "ChoicesDropdown" with the choices of "Open" "Submitted" "Closed"


I have tried multiple ways of looping through the collection, then looping through the nested collection with no luck. Any help would be greatly appreciated.


Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,654)