Power Platform Community Forum Thread Details

Hi everyone!

I hope someone can help me.

I have a SP list Masto50 with more columns.

The task is as follows: to export data from the SP list to Excel depending on who is logged in.
everything works great except for one point.
I can't filter the list by User().Email with Power Automate.

I created a flow with two parameters

And call this flow from app:

If(
    User().Email in AllowR1,
    ExportMasto50ToExcel_DE.Run("field_3 eq 'R1'", User().Email),
    If(
        User().Email in AllowR2,
        ExportMasto50ToExcel_DE.Run("field_3 eq 'R2'", User().Email),
        If(
            User().Email in AllowR3,
            ExportMasto50ToExcel_DE.Run("field_3 eq 'R3'", User().Email),
            If(
                User().Email in AllowViewAllUser,
                ExportMasto50ToExcel_DE.Run("", User().Email),

ExportMasto50ToExcel_DE.Run("Employee/EMail eq 'User().Email'", User().Email)))))

If I explicitly specify the user's e-mail address in the last line (ExportMasto50ToExcel_DE.Run("Employee/EMail eq 'abc@xyz.com'", User().Email)), then everything works fine.
But I need to transfer this parameter depending on who is logged in.

In my case SP the list has a column Employee with Person or Group type.
I would appreciate any ideas.

Categories:

Dataflows