cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mays
Level: Powered On

Gallery and Edit Form

Dears I have a gallery contain all the employees (EmployeesGallery) when click the arrow it tooks him to the next screen which is the details of this employee ,

now in the details (EmployeeProfile) i added two edit forms in a scrollable screen 

the item of the first form(PersonalInfoForm) = EmployeesGallery.Selected

the item of the second form (Filter('Employee-Work-Info',EmployeeW.Email=EmployeesGallery.Selected.'Employee(PersonalInfo)'.Email))

the common field between them EmployeeW and Employee(PersonalInfo) 

 

I got the error "The property expects record values,but this rule produces incompatible table value"

 

Please any help why I got this error?

Filter('Employee-Work-Info',EmployeeW.Email=EmployeesGallery.Selected.'Employee(PersonalInfo)'.Email)
1 ACCEPTED SOLUTION

Accepted Solutions
Thomas_B
Level: Powered On

Re: Gallery and Edit Form

Hi @Mays ,

 

The error message tell you that the property want a record because Filter function always return table value (even if there is only one record in the table)

 

You just have to change your Filter() for a LookUp() that can return one record.

 

Hope this will solve your problem.

2 REPLIES 2
Thomas_B
Level: Powered On

Re: Gallery and Edit Form

Hi @Mays ,

 

The error message tell you that the property want a record because Filter function always return table value (even if there is only one record in the table)

 

You just have to change your Filter() for a LookUp() that can return one record.

 

Hope this will solve your problem.

Mays
Level: Powered On

Re: Gallery and Edit Form

Thank you @Thomas_B  it worked ... as I put ".Email" I thought that will bring only one record

 

LookUp('Employee-Work-Info',EmployeeW.Email=EmployeesGallery.Selected.'Employee(PersonalInfo)'.Email)

Appreciate it,

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

Users Online
Currently online: 214 members 4,710 guests
Recent signins:
Please welcome our newest community members: