SOLVED

show only items assigned to logged on user

%3CLINGO-SUB%20id%3D%22lingo-sub-114583%22%20slang%3D%22en-US%22%3Eshow%20only%20items%20assigned%20to%20logged%20on%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-114583%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%20%2C%3C%2FP%3E%3CP%3Ei%20created%20a%20powerapps%20to%20let%20users%20view%20tasks%20in%20a%20sharepoint%20site.%20i%20just%20us%20d%20the%20tooling%20to%20have%20the%20app%20generated%20automagically%20for%20me.%20how%20to%20i%20configure%20the%20'landing'%20page%20to%20only%20show%20items%20assigned%20to%20the%20user%3F%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-114583%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-115283%22%20slang%3D%22en-US%22%3ERe%3A%20show%20only%20items%20assigned%20to%20logged%20on%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-115283%22%20slang%3D%22en-US%22%3E%3CP%3EGive%20it%20a%20shot%20with%20something%20like%20this...%20for%20a%20Gallery%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EShowColumns(Filter(Complaints%2CUser().Email%3DAssignedToTxt)%2C%20%22Store%22%2C%22PowerappsCompStatus%22%2C%22Complaint_x0020_Source%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20had%20to%26nbsp%3Bcopy%20the%20SP%20list%20data%20to%20a%20single%20line%20of%20text%20column%2C%20then%20filter%20and%20compare%20and%20call%20the%203%20columns%20I%20wanted.%20Hope%20this%20helps...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F21936i9F14ED950C837B51%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22powerapps.png%22%20title%3D%22powerapps.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F21937i45F4A15524177A90%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22splist.jpg%22%20title%3D%22splist.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-114966%22%20slang%3D%22en-US%22%3ERe%3A%20show%20only%20items%20assigned%20to%20logged%20on%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-114966%22%20slang%3D%22en-US%22%3EI%20found%20that%20the%20powerapps%20has%20an%20option%20to%20filter%20the%20data%2C%20but%20has%20no%20example%20to%20provide%20(just%20started%20last%20week%20%3A)%3C%2Fimg%3E%20Check%20out%20this%20PowerApps%20reference%20for%20Filter%20...%20hope%20that%20helps%20you%20on%20the%20way.%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fpowerapps.microsoft.com%2Fen-us%2Ftutorials%2Ffunction-filter-lookup%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerapps.microsoft.com%2Fen-us%2Ftutorials%2Ffunction-filter-lookup%2F%3C%2FA%3E%3CBR%20%2F%3EKind%20regards%2C%20John%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-114911%22%20slang%3D%22en-US%22%3ERe%3A%20show%20only%20items%20assigned%20to%20logged%20on%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-114911%22%20slang%3D%22en-US%22%3E%3CP%3Ebtw%2C%20the%20computer%20im%20using%20to%20try%20this%20out%20has%20windows%207%2C%20so%20i%20can%20only%20use%20the%20web%20ui...%20no%20Powerapps%20desktop.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-114909%22%20slang%3D%22en-US%22%3ERe%3A%20show%20only%20items%20assigned%20to%20logged%20on%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-114909%22%20slang%3D%22en-US%22%3E%3CP%3EGreat%20question%20John.%20I%20don't%20know%20if%20%26nbsp%3Bthere%20is%20a%20view%20defined%20behind%20the%20presentation%20in%20the%20PowerApps.%20If%20there%20is%20I%20could%20certainly%20configure%20it%20to%20show%20only%20the%20items%26nbsp%3B%20assigned%20to%20the%20user.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20view%20defined%20behind%20the%20presentation%20in%20the%20PowerApps%3F%20If%20so%2C%20how%20do%20i%20specify%20the%20view%20to%20use%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-114732%22%20slang%3D%22en-US%22%3ERe%3A%20show%20only%20items%20assigned%20to%20logged%20on%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-114732%22%20slang%3D%22en-US%22%3EIs%20there%20not%20a%20view%20defined%20behind%20the%20presentation%20in%20the%20PowerApps%3F%3CBR%20%2F%3EIf%20there%20is%2C%20can%20you%20not%20filter%20on%20Assigned%20To%20equal%20%5BMe%5D%3F%3CBR%20%2F%3EKind%20regards%2C%20John%3C%2FLINGO-BODY%3E
Highlighted
Frequent Contributor

hi ,

i created a powerapps to let users view tasks in a sharepoint site. i just us d the tooling to have the app generated automagically for me. how to i configure the 'landing' page to only show items assigned to the user?

thanks

 

5 Replies
Highlighted
Is there not a view defined behind the presentation in the PowerApps?
If there is, can you not filter on Assigned To equal [Me]?
Kind regards, John
Highlighted

Great question John. I don't know if  there is a view defined behind the presentation in the PowerApps. If there is I could certainly configure it to show only the items  assigned to the user.

 

Is there a view defined behind the presentation in the PowerApps? If so, how do i specify the view to use?

 

 

Highlighted

btw, the computer im using to try this out has windows 7, so i can only use the web ui... no Powerapps desktop.

Highlighted
Best Response confirmed by Russell Gove (Frequent Contributor)
Solution
I found that the powerapps has an option to filter the data, but has no example to provide (just started last week :) Check out this PowerApps reference for Filter ... hope that helps you on the way.
https://powerapps.microsoft.com/en-us/tutorials/function-filter-lookup/
Kind regards, John
Highlighted

Give it a shot with something like this... for a Gallery 

 

ShowColumns(Filter(Complaints,User().Email=AssignedToTxt), "Store","PowerappsCompStatus","Complaint_x0020_Source")

 

I had to copy the SP list data to a single line of text column, then filter and compare and call the 3 columns I wanted. Hope this helps...

 

powerapps.pngsplist.jpg