cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nyk
Helper I
Helper I

Bring a SP list to PowerApps gallery using Flow

Is there a way to bring a SharePoint list into a PowerApps gallery through Flow? Any help would be greatly appreciated! Thanks a bunch!

3 REPLIES 3
yashag2255
Dual Super User II
Dual Super User II

@Nyk 

 

Please follow the thread here :

 

https://powerusers.microsoft.com/t5/General-Flow-Discussion/Bring-a-table-from-a-SP-list-into-PowerA...

 

Did you get a chance to see @Pstork1 's suggestion?

I did see that response, but I am somewhat stuck. I have tried messing around with SharePoint permissions, but cant seem to find a way to do what I'm trying to do.

I need a way that the employee can use a leave request app, which let's them "login" and navigate to their respective screen. Then their previous responses will come up in a gallery, and they can submit a response from the app as well, which goes to the same SP list as the ones in the gallery. 

That being said, I would rather the employees not be able to go directly to the SP list and check out who got denied because that's somewhat personal. I have that working in a way that they can only see their data, not other's. But the users are still able to edit the items in the list that they can see, and change the view settings so that they could potentially see the whole list.


Is there a way to block the user from making those changes if Flow would not be the way to go?

v-bacao-msft
Community Support
Community Support

Hi @Nyk ,

 

It is hard to bring a SharePoint list into a PowerApps gallery through flow, but you can put the SharePoint list into the gallery. After an employee "log in " get his name, put the name into the Filter function(), Filter('Leave Request list', Name = Employee.Name)

 

Here's an example that you can refer to:

1.PNG.jpg

And your requirement that users are still able to edit the items in the list that they can see, and change the view settings so that they could potentially see the whole list.

You can add create a Edit form control to let employees edit their information, and add a button ( Items = 'Leave Request list')  to let them could potentially see the whole list.

About these operations, you can refer to this document.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-form-detail

 

Best Regards,

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

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (75,669)