cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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.
hnguy71
Level 8

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 

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

hnguy71
Level 8

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
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,790)