cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User
Super User

Re: Update/Record SharePoint entry using distinct selection from another list

@hnguy71 

Yes, you will not see results with that - the reason is, you are not using the Distinct function.

It is the Distinct function that returns a list of Result values.  (Single column of Result).  So you can use the {Result:""} for that. 

In this case you are using a Filter, so you need to match whatever column you want to make blank.

For example, if it is the Title column you are displaying in your dropdown, then you would replace the result object with {Title:""}.  Or, if it is the GeoMarket column you are displaying, then {Geomarket:""}.

 

With this formula you are adding a record to a collection and then adding zero or more records to that same collection from another function.  You HAVE to match the types.  In the case of the Distinct, we used a {Result:""} record because that matched the fact that Distinct returns a table of single column records with a Result column.

 

I hope that is clear and helpful.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Highlighted
Helper V
Helper V

Re: Update/Record SharePoint entry using distinct selection from another list

Hi Randy. 

 

I think I was editing my previous post when you replied. Do you think you can take a look at that? 

your reply did clear up some confusion but alas I'm still not seeing the result that I require:

 

ClearCollect(colForDropdown, {'Sub Geomarket':""}, Filter('Team Request', Geomarket = DataCardValue7.Selected.Result))

 

I'm doing the debugging test you showed me yesterday and this time it's retrieving the wrong records 

Highlighted
Super User
Super User

Re: Update/Record SharePoint entry using distinct selection from another list

@hnguy71 

I believe in this case, your issue is with when you are collecting that list.  You mention you are doing it OnSelect.  That means that a user has to actually select the control for it to update...but what happens when they change it?

Try this on the OnChange action instead.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

Highlighted
Helper V
Helper V

Re: Update/Record SharePoint entry using distinct selection from another list

Hi @RandyHayes 

 

Looks like that did the trick! I also noticed that my Value Property defaulted and I had to reselect my reference column again but I presumed that was because I changed items Property formula.

 

Whew! What a way to start using PowerApps. Thanks for your help!

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

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