Unanswered

Data Table help

(0) Share

Report

Posted on by JC_INNV

Hi everyone, I'm experiencing some trouble in a data table.

I have this set up to filter values in a Sharepoint list by using the "Created By" field - user e-mail matches the "Created By" e-mail. however it's showing duplicate values for some sessions, as if it were not filtering correctly. I'm using the following formula on the items:

Filter(
'APP - New Training',
Title in Filter('APP - Attendance Sheets', 'Created By'.Email = User().Email).Title
)

Then on the columns I'm just using "ThisItem.ColumnName".

What am I missing here and how can I get this to work?

For context, this is an app to track attendance on training sessions and the data setup is like this:

APP - New Training has data on the sessions (Title, Date, Duration) + a column called Individual Training (this is to separate sessions seen live from recordings seen on the repository, for certificates purposes)
APP - Attendance Sheets has the attendance records (Title and Created By)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Fardy_MADI_2 334 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @JC_INNV,

Try this
Filter(
Filter('APP - Attendance Sheets', 'Created By'.Email = User().Email),
Title in Filter('APP - Attendance Sheets', 'Created By'.Email = User().Email).Title
)

Hope this will help you 🙂

Was this reply helpful? Yes No
developerAJ 4,763 on at

Like
a
(0)

Report
Copy link

Link copied!

With({distinctTitle:Distinct(Filter('APP - Attendance Sheets', 'Created By'.Email = User().Email),Title)},Filter('APP - New Training',Title in distinctTitle))

try this out

Was this reply helpful? Yes No
JC_INNV 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry for the late reply on this, this topic was pushed back due to other priorities. Unfortunately nonce of the provided solutions worked..
Fardy1 - your solution did not have the "Duration" column available, not sure why as it is using the correct list
developerAJ - your solution has the same results I've had in previous attempts, which is duplicate values for sessions with the same name (specifically sessions seen on the repository that have different date, duration and e-mails on the "Created By" column).

Was this reply helpful? Yes No