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

All responses (4)

Answers (0)

manojrohit16 on at

Like (0)

Report

Re: Dropdown(Multiple Column fetch)

This is only for single dropdown but I want multiple column value in to dropdown.
v-bofeng-msft on at

Like (0)

Report

Re: Dropdown(Multiple Column fetch)

Hi @manojrohit16 ，

Please try:

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

Best Regards,

Bof
manojrohit16 on at

Like (0)

Report

Re: Dropdown(Multiple Column fetch)

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)
v-bofeng-msft on at

Like (0)

Report
Re: Dropdown(Multiple Column fetch)

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