User Access Security in Canvas Power App, Database SQL Server

[PijushRoy]

HI Team,

I have 10 users and 12 KPI. I want to show product in Canvas Power App Gallery as per Office 365 User Login Email
Example
If User().Email =  abc@email.com , so KPI A and KPI B
If User().Email =  xyz@email.com , so KPI C
If User().Email =  pqr@email.com , so KPI D, KPI E, KPI F  so on

How to I implement this in below existing code

Existing Code for Gallery. I have one Dropdown filter and Search Box. 

SortByColumns(
        Filter(
        '[dw_staging].[Performance_Dashboard_Table]',
        StartsWith(
            'KPI Short Name',
            TextSearchBox1.Text
        ) && (Dropdown1.Selected.Value = "All" || Goal = Dropdown1.Selected.Value)
    ),
    "Index",
    If(
        SortDescending1,
        Descending,
        Ascending
    )
)

Thanks in Advance

[PijushRoy]

Any help please

[v-xiaochen-msft · Accepted solution]

Hi @PijushRoy ,

Is this what you want?

SortByColumns(
        Filter(
       If(User().Email= abc@email.com,Filter('[dw_staging].[Performance_Dashboard_Table]',KPI=...),User().Email = xyz@email.com,Filter('[dw_staging].[Performance_Dashboard_Table]',KPI=...),User().Email =  pqr@email.com,Filter('[dw_staging].[Performance_Dashboard_Table]',KPI=...)),
        StartsWith(
            'KPI Short Name',
            TextSearchBox1.Text
        ) && (Dropdown1.Selected.Value = "All" || Goal = Dropdown1.Selected.Value)
    ),
    "Index",
    If(
        SortDescending1,
        Descending,
        Ascending
    )
)

Best Regards,

Wearsky

[PijushRoy]

I will check and confirm
Thanks @v-xiaochen-msft