cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Alex_Reig
Helper III
Helper III

Filter data when I download a sharepoint list in Excel

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,

Alex_Reig_0-1637775818489.png

 

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)

 

Alex_Reig_1-1637775818495.png

 

Alex_Reig_2-1637775818501.png

 

Alex_Reig_3-1637775818504.png

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-LilyW-msft
Community Support
Community Support

Hi @Alex_Reig 

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

This is my test list

vLilyWmsft_7-1638161201784.png

Flow in details:

vLilyWmsft_2-1638159821643.png

vLilyWmsft_0-1638157994302.png

vLilyWmsft_1-1638158122204.png

vLilyWmsft_4-1638160856379.png

For testing, I added a Button in Apps.

vLilyWmsft_5-1638160893354.png

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

vLilyWmsft_8-1638161705265.png

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.

 

 

View solution in original post

2 REPLIES 2
v-LilyW-msft
Community Support
Community Support

Hi @Alex_Reig 

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

This is my test list

vLilyWmsft_7-1638161201784.png

Flow in details:

vLilyWmsft_2-1638159821643.png

vLilyWmsft_0-1638157994302.png

vLilyWmsft_1-1638158122204.png

vLilyWmsft_4-1638160856379.png

For testing, I added a Button in Apps.

vLilyWmsft_5-1638160893354.png

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

vLilyWmsft_8-1638161705265.png

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.

 

 

Hi @v-LilyW-msft 

 

It worked 🙂

 

Thank you very much

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,041)