Solved: Flow does not filter on "Created By" SP List

mennoov · ‎10-02-2020

Hi everyone,

This is an app intended to register your hours. Then I want to use a flow to ensure that this flow filters on the '' Created By '', and then starts a flow, and sends an email to the manager. This manager is the same for everyone. As a result, the manager receives a separate email with the hours for each employee. Now when I do it as in the screenshot, it is not filtered by person now. How do I do this?

Thanks in advance!

v-alzhan-msft · ‎10-12-2020

Hi @mennoov ,

When you add a Filter Array action under the Get items, you need to use the expression from the Filter Array instead of from the Get items in the following steps as screenshot below:

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

sudharsan1985 · ‎10-02-2020

Hi @mennoov

You don't really need the action Filter Array to filter the items returned from Get Items action. You can directly filter the items that have to be returned using Filter Query property. Paste the below condition on Filter Query property of your Get Items action with the email that you need to filter.

Author/EMail eq '<user email id to be filtered>'

Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
-Sudharsan K...

v-alzhan-msft · ‎10-12-2020

Hi @mennoov ,

When you add a Filter Array action under the Get items, you need to use the expression from the Filter Array instead of from the Get items in the following steps as screenshot below:

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.