How to convert record type into the text type

[KotaroKo]

Hi, guys! I have two collections, collection1 and collection2. In collection 2 there are all of our employees. I need to generate a report where there are Partners, managers and employees. At first I get users into collection1, whose "Manager" column  = One of our Partners name. Then i want to loop through this collection(collection1) and  add users from collection2, whose "Manager" column equals to the people from the collection1. The problem is I am not able to use "=" sign between collection2.Manager and collection1.Manager columns. Collection1.Manager is record type and needs to be text type. Any ideas how to work this out?

[KroonOfficeSol]

The manager is a record and a record has properties. So you can probably use 

collection1.Manager.Property

To get the text property you want to use in your condition. 

[KotaroKo]

Hi, @KroonOfficeSol . Thank you, but unfortunately, It doesn't work.  It says: "Name isn't valid. The identifier is not recognized"...

[KroonOfficeSol]

Add some screenshots please, so we can see the error messages.

Maybe collect one record and take a screen shot of the collection preview.

[v-bofeng-msft · Accepted solution]

Hi @KotaroKo :

The key point is disambiguation.

I suggest you use

RenameColumns(collection2,"Manager","TheManager")

instead of 

collection2

In addition,you can also use the disambiguation operator.

I think this link will help you a lot:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/operators#disambiguation-oper...

Best Regards,

Bof