ClearCollect is not rendering values

(0) Share

Report

Posted on by ShondaT

228

I have the following code that should be rendering results but it doesn't:

ClearCollect(CollectMyRequests,{Value:"All"});Collect(CollectMyRequests,Distinct('ListName',Status.Value))

My "Status" column is a Sharepoint Choice column and contains the choices "To Be Started" "In Progress" and "Completed"

Any help would be appreciated. I've tried changing Value to Result and still no luck.

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,064 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @ShondaT ,

This should work

ClearCollect( CollectMyRequests, {Result: "All"}, Distinct( AddColumns( ListName, "StatValue", Status.Value ), StatValue ).Result )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
ShondaT 228 on at

Like
a
(0)

Report
Copy link

Link copied!

That did it!
I hate to expand this because the additional thing I'm trying to do is have the list by default display requests where all of the user's requests appear when they land on the screen. I have a Requestor field that is a people and group sharepoint field from Active Directory.

Thank you so much! I am so curious to know why the code I had didn't work since I got it from watching one of Shane's videos from Powerapp911. I'm trying to grasp the whole concept of Collect and Clearcollect and how those work with various field types.

Thank you so much for helping me get this far WarrenBelz! If you have any thoughts on the above I'd really appreciate the help.

Was this reply helpful? Yes No
WarrenBelz 156,064 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @ShondaT ,

Your main issue was you had Value in the "All" part instead of Result. You can actually do without the collection and put this directly into the Items

Ungroup( Table( { Menu: Table({Result: "All"}) }, { Menu: Distinct( AddColumns( ListName, "StatValue", Status.Value ), StatValue ).Result } ), "Menu" )

Your additional question would require a filter based on the user's name or email, depending what you have in your list.

Was this reply helpful? Yes No
ShondaT 228 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok. I'll have to figure out the filter thing. Thank you again!

Was this reply helpful? Yes No