cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sakthi1
Regular Visitor

Distinct value from table and populate it in dropdown

Hi Team,

 

I want to execute the below oracle query using PowerApps formula.

 

"select distinct(ic_udf_024) from reprt_part_master where ic_udf_024 is not null"

 

I want to put the result in the items of dropdown component.

 

Can you please suggest how can we achieve this?

 

Thanks,

Sakthi S.

 

 

1 REPLY 1
Sakthi1
Regular Visitor

The DB table has total of 174k records. 

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Kudoed Authors
Users online (1,679)