How to filter PowerApps form to display only items where current user is assigned

(0) Share

Report

Posted on by Jltitus

138

I'm working on an app where the user completed a form to add a goal to their dashboard, then after they create a goal, they create a practice item. The issue I'm having is tying the goal to the practice item.

I have a Goals list with the following columns:

Goal
SPName (Users name in SharePoint) -- People/group column
Goal Cycle starts
Goal Cycle ends
Status

Practice items list:

Practice item
Goal (look up on goals list)
Assigned to - People/group column
Start
End
Status

I'm trying to tie the goal when the user adds their practice item by providing a combo box for them to select the goal that the item aligns to.

QUESTION: How can I filter the Goal combo box to only display those goals where the SPName in the goal = the current user?

The combobox is

Choices([@PracticeItemTracker_1].Goal)

Practice item.jpg

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Jltitus

Set your Items property to the following instead of Choices:

Filter(yourGoalListName, SPName.Email = User().Email )

I hope this is helpful for you.

EDIT: If you want to mimic the results of the Choices then use the following:

ForAll( Filter(yourGoalListName, SPName.Email = User().Email), {Id: ID, Value: Goal } )
Jltitus 138 on at

Like
a
(1)

Report
Copy link

Link copied!

@RandyHayes thank you so much. That was it.