Unanswered

Dropdown(Multiple Column fetch)

(0) Share

Report

Posted on by manojrohit16

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:

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

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

v-bofeng-msft on at

Like (0)

Report
Hi @manojrohit16 ,

Could you please tell me:

Does the Lookupcolum allow multiple selections?

Could you please show me some screenshots?(Code bar……)

Maybe you could set the dorpdown's items property to:

Filter(
datasource,
Lookupcolum.Value="Applicant" &&
ID=DataCardValue14.Text &&
!IsBlank(Email)
).Email

Best Regards,

Bof

Was this reply helpful? Yes No
manojrohit16 on at

Like (0)

Report

I did it but it was working only for one email not for all means (Email1,email2,email3,email4).
I have for columns in datasource email1 email2 email3 email 4 and all columns are single line of text and converted it into dropdown by selecting in edit (Allowed Values)

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @manojrohit16 ，

Please try:

Filter(
datasource,
Lookupcolum.Value="Applicant" &&
!IsBlank(Email)
).Email

Best Regards,

Bof

Was this reply helpful? Yes No
manojrohit16 on at

Like (0)

Report

This is only for single dropdown but I want multiple column value in to dropdown.

Was this reply helpful? Yes No