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.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (1,755)