cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
San28
New Member

Cannot get the "Owning user" ID from a collection

Hi 

I'm facing a annoying problem !

I'm trying to create a collection that store a column with the Owning User ID of each record found from an entity "DFT_Saisie Compétences": 

 

So i've created the following Collection :

San28_0-1660172039894.png

When a execute this code, the collection show this result : 

San28_1-1660172198025.png

 

So i've tried to get the ID of the record type "owninguser" colum : 

San28_2-1660172341172.png

He doesn't purpose me the ID column after the "." !

 

How can i create a collection that contain only the Owning user ID column from the clearCollect result ? 

 

San

 

 

 

 

2 REPLIES 2
shoog
Dual Super User
Dual Super User

You can use the AddColumns function in your ClearCollect to achieve this like:

ClearCollect(
   colGlobalCritere,
   AddColumns(
      Filter(...).'Owning User',
      "ID",
      'Owning User'.ID
   )
)

 

shoog
Dual Super User
Dual Super User

@San28 

Do you need further help on this? If the suggested solution is working as expected then please mark it as solution accepted. This will help others in the community looking for solutions.

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (2,361)