web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Distinct with sharepoi...

Power Apps

Answered

Distinct with sharepoint list

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

Is there way i can use the 'distinct' function to display all the name values in SharePoint list column only once in a combo-box and then auto-fill other values in the form using lookup function. Currently all the values are repeated multiple time in the combo-box and when i try and use distinct function in the default property of the 'name' field, it gives me an error in the fields where i use lookup for auto-fill.

Thanks & Regards

Srinath

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do you want to display non-repeating Name field in combo box and then display the selected item in form?

Is name field text type?

If so, I've made a similar test for your reference:

1)set the combo box's Items:

Distinct(survey,Title).Result

On your side, you should try:

Distinct(listname,Name).Result

2)set the form's Item:

LookUp(survey,Title=ComboBox1.Selected.Result)

On your side, you should try:

LookUp(listname,Name=ComboBox1.Selected.Result)

Then the combo box will display no-repeating Name value, the form will display the selected item.

Best regards,
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-yutliu-msft ,

I have tried your solution and it works well. Thanks again for reaching out and helping. Cheers.

Regards
Srinath

Join the conversation