You’re offline. This is a read only version of the page.
Announcements
I have inserted a gallery for users to check which task they didn't start yet.
Below is my ‘task summary’ table which shows tasks status of each city.
And i also have another table called 'address book' that show the relationship between users & city.
My target is that：
When user login apps, he can see all tasks which is not started in his region.
For example:
If Tom login, Gallery.item=filter (‘task summary’, 'Status_Changchun'='Not started'),
If Alice login, Gallery.item=filter (‘task summary’, 'Status_Foshan'='Not started')
.......
Different user login, filter different columns.
Now i have to use the formula:
if( user().email=Tom@Microsoft.com, filter (‘task summary’, 'Status_Changchun'='Not started'),
if( user().email=Alice@Microsoft.com, filter (‘task summary’, 'Status_Foshan'='Not started'),
.....))
it looks stupid and actually i have lot of users, and it's also not convenient to update, every time user changes, i have to modify formula.
i want to know that how can i achieve my target or what’s your experience when you develop,
I'm appreciate that if you can give me any helps, thank you
Hi,
Refer blow article for filter based on logging user in canvas app.
https://www.matthewdevaney.com/3-ways-to-filter-a-power-apps-gallery-by-the-current-user/
Share
Report
All responses (
Answers (
109
