Need Help: Setting Filtered Collection Up to Sharepoint list with Dropdown columns showing as [Value]

(0) Share

Report

Posted on by PowerApp_Chaos

Hello,

BACKGROUND:

I am in the process of creating a Timetracking app for our department employees and contractors to use on a weekly basis to submit time on projects and other time in operational or administrative responsibilities.

In my PowerApps I am establishing several Collections OnStart in the App that will be used to control the values shown in dropdown lists dynamically.

One such dropdown connects to our overall project list in SharePoint. When a resource goes to enter a new timesheet I want the dropdown of the projects list to only show available only the active projects (50-60), rather than completed projects of the past. To do so I need to filter this list down to only show projects that are in "Active" status, among a few other statuses that can be included.

I have created a Collection that captures several of the key columns needed from this SharePoint list using a combo of ClearCollect and ShowColumns, which works, however the column that I need to create the filter on shows [Record] in it's values. I believe this is because the column in SharePoint is a dropdown/lookup column. Because of this, I have been unable to apply a filter against this column.

QUESTION:

Can someone please advise how I can get the collection to capture the value of the column, rather than displaying [Record]? I have tried Googling for a solution to no avail.

Thank you, in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

WarrenBelz 156,384 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @PowerApp_Chaos ,

The value for that as Text should be (in the Gallery Label)

Concat( ThisItem.'Overall Status', Value, ", " )

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
PowerApp_Chaos 42 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz , it isn't intended to go into a gallery, it is going into a collection (for now). How can I make the values show their actual value, rather than [Value] in a filtered collection?

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

Like
a
(0)

Report
Copy link

Link copied!
@PowerApp_Chaos ,

You would need to use AddColumns with the code I posted - you have a multi-value column there, so it will always show in your collection view like that.

ClearCollect( colFYProjects, ShowColumns( AddColumns( 'IT Project ListProject NumberShort Project Number’, OverallStatus, Concat( 'Overall Status', Value, ", " ) ), 'Project Name', OverallStatus ) )

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