Unanswered

Pulling my hair out! Get SharePoint Columns corresponding to a collection & sorting on choice!

(0) Share

Report

Posted on by teekayzee

Using the OOTB Direct Report function - collection: myDirectReports
I have a sharepoint list that has 1 to 5 items corresponding to each employee in the company. I'm only concerned with the latest record per employee (using built in SharePoint ID)

So I have a gallery - that should list all my direct reports along with information from the latest record from the SharePoint list corresponding to that direct report/person. Additionally - I'd like to be able to sort by a choice field from that SharePoint record.

Here's what I have so far

ClearCollect(myTeamStatus, SortByColumns(
AddColumns(
 If(
 Header_2.SubMenuClicked = "Direct Reports",
 myDirectReports,
 myTeam
 ),
 "currentStatus",
 SortByColumns(
 Filter(
 EmerCheckIn_CurrentStatus,
 Title = Mail
 ),
 "ID",
 Descending
 )
))

This produces a list of my direct reports with an additional column called 'currentStatus' - which ends up being a table (not ideal)

Now I think I can add 3 columns using the add column + filter option for each of my columns I want but my thought process was this would be a no - go because it would produce too many calls to SharePoint (ie: slow).

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

mdevaney 29,989 Moderator on at

Like (0)

Report

@teekayzee
Rather than using ADDCOLUMNS is there any opportunity to create a new column in the the datasource as single-line text and write the most recent status to that column each-time an update occurs? Then you would not have any performance issues 🙂

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
teekayzee 2 on at

Like (0)

Report
I assume using Flow? I'm not sure that's an option.

The SP List is a list of all of the status reports the user has submitted (the latest one via the SharePoint ID being the most current) - I'd like for the managers to use PowerApps and be able to view the most recent status update/report for all their direct reports.

So in my head, Power Apps would get a list of all the direct reports , create a dynamic OR filter for all of them and pass that to SharePoint - then create some columns based on the lastest sharepoint item pulled back.

The direct reports collection would look like (scaled down for obvious reasons):

EmployeeName, Id, mobilePhone, currentReportStatus, currentReportText, currentReportCreatedDate

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@teekayzee
Actually, using Power Apps: not Flow.

I assume all data is input through a Power Apps form. Each time the form is submitted update/patch the new Status to the appropriate column.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No