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.

View solution in original post

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.

View solution in original post

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

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Demo Extravaganza Championship Voting Open

Voting Ends: October 30, 2019!

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

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

Top Kudoed Authors
Users Online
Currently online: 486 members 5,429 guests
Please welcome our newest community members: