power app from spo list |

(0) Share

Report

Posted on by Vstar19

381

Hello.

I am a newbie to PowerApps.

I have a SPO list, e.g below. The Owner Column is a People and Group Column.

Item | Owner | Description

Item A | Joe Bloggs | this is for abc

Item B | John Smith | this is for def

Item C | Joe Bloggs | this is for ghi

etc..

An owner can own several items.

i would like to create a PowerApps, so when it loads the canvas app, the app filters the items to the user logged in. So if Joe Bloggs loads the app, the canvas just shows his items (Item A and Item C) alongside the items description - Then he can go ahead and edit some fields or assign Ownership to someone else.

However, i would like there to be an option for the logged user to see all other items, maybe a button that is pressed which un-filters the filters and allows the logged in user to see ALL items and then search the list for the Item they are looking for.

Would this be possible. Could someone guide me?

Thank You

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Vstar19 ,
For this requirement you have to do the below steps.

On App start
ClearCollect(colData,Filter(YourDataSource,'YourCreatedByColumn'.Email=User().Email)) //This will populate user specific values
On All button click
ClearCollect(colData,YourDataSource) //This will collect all data

Map the gallery items to colData

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.

Was this reply helpful? Yes No
Vstar19 381 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello.
This doesn't appear to work on the On Start of my app. I think the problem is the the Owner column is coming through into PowerApps as a text column.
Filter('Datasource', Lower(Owner.Email) = Lower(User().Email)) does not work on start.

However, if i apply the above filter onto the actual gallery the filter works fine.... But then i dont know how to clear the filter form the gallery, as there is no variable applied.

How can i have a button that clears the filters from the gallery, once applied?

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Vstar19 ,

You can try the formula onVisible of the screen ?
ClearCollect(colData,Filter(YourDataSource,Lower('YourCreatedByColumn'.Email)=Lower(User().Email)))

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.

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Vstar19 ,

You could use a toggle or check box to set a variable on the Gallery screen for users to choose whether display all items or its own items.

OnCheck:

Set(varOwned, true)

OnUncheck:

Set(varOwned, false)

OnStart of the App:

Set(varUser, User())

Items of the Gallery:

Filter('Datasource', If(Owned, Lower(Owner.Email) = Lower(varUser.Email), true))

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No