cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KotaroKo
Helper III
Helper III

How to convert record type into the text type

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?

1 ACCEPTED SOLUTION

Accepted Solutions

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

View solution in original post

4 REPLIES 4
KroonOfficeSol
Resident Rockstar
Resident Rockstar

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. 

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

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

 

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

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

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,004)