
Hi all,
I have created a component which contains a custom table property. Below is the schema I have defined for my Dataverse table
Table(
{
jd_id:"jdd001",
jd_name:"David",
jd_email:"david@test.com",
jd_address:"3357 Fieldcrest Road,New York, NY,10011",
jd_age:29
}
)
I have another component with define custom property which expects a single record value. Below is the schema I have defined:
{
jd_id:"jdd001",
jd_name:"David",
jd_email:"david@test.com",
jd_address:"3357 Fieldcrest Road,New York, NY,10011",
jd_age:29
}
If you set the table property to a database table (e.g. Sort(Employee, Id)) OR
A single record property (e.g. LookUp(Employee, Id="jdd001")) raises a following warning/error:
"Expected a different collection record structure"
Question
How can set the property as my target table and for single record with defined schema?
Aby help would be appreciated.
Thanks
Hi @Jackson_Dhorty ,
I made a sample for you.
Create a table named ‘E1’ in Dateverse.
Create a component named 'Component1' to customize the table input property.
Add a gallery to the component and set Items to the following formula:
Add components to the screen and set 'E3' property.
RenameColumns(E1S,"crba2_jd_id","jd_id","crba2_name","jd_name","crba2_email","jd_email","crba2_adress","jd_address","crba2_age","jd_age")
Result:
Hope it helps you.
Best Regards,
Wearsky