Hello there,
I have a task where I have to fetch multiple columns like Email, Email1, Email2, and Email3 so in the Sharepoint list all fields are a single line of text.
In powerapps, I converted this field to allow values so that I can get dropdown.
Now, I want values in dropdown like below:
Email
Email1
Email2
Email3
I tried below query in items :
With(
{
witem:
Filter(
datasource,
Lookupcolum.Value="Applicant" &&
ID=DataCardValue14.Text &&
!IsBlank(Email)
)
},
Table(
{Value:witem.Email}
)
)
I tried the above but got errors like "Expected a different collection record structure".
Let me know how to solve the above error.
Regards,
Manoj Roy
