cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
manojrohit16
Helper I
Helper I

Dropdown(Multiple Column fetch)

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

4 REPLIES 4
v-bofeng-msft
Community Support
Community Support

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

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)

 

 

Hi @manojrohit16 ,

 

Please try:

 

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

 

Best Regards,

Bof

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

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (2,525)