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)
Solved! Go to Solution.
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.
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.
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,
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
255 | |
236 | |
82 | |
36 | |
27 |
User | Count |
---|---|
311 | |
266 | |
120 | |
69 | |
44 |