Filter data when I download a sharepoint list in Excel

[Alex_Reig]

Hi all,

I create a flow to download a Sharepoint list in Excel from a power app. The problem is that I need to download only the registers where User().FullName = Usuario1 so a user can see only his registers,

The flow that I did is the next one (With it I download all the registers and I only want those where Usuario is Àlex Reig)

The last part of the flow before the Create file in dropbox are only to rename the file with my user().fullname.

Thank you in advance,

Àlex

[v-LilyW-msft · Accepted solution]

Hi @Alex_Reig 

You can add Filter array action to filter out the items created by the user.

This is my test list

Flow in details:

For testing, I added a Button in Apps.

When i click the button, flow automatically runs and the file will be created in Dropbox like below.

Hope the content above may help you.

Best Regards

If my repay helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Alex_Reig]

Hi @v-LilyW-msft 

It worked 🙂

Thank you very much