cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rlburg
Advocate II
Advocate II

How to handle building a form for employees to submit, but not see underlying data

Been waiting patiently for PowerApps for SharePoint Custom Forms to be released but a little unsure how to handle. The use case is simple and I think common to every business. We want an easy way to build a form, that employees can fill out with a good experience, and then not see the underlying list where it is submitted to.

 

What is the best practice here? In the past have used InfoPath to build the form, broken inheritance on the list, given the "everyone except external users" contribute rights, and changed the security of the list for users to only be able to see their own items. 

 

I have also used SP workflows to change owenrship of an item, or move the item to a new list, and then delete the original item so the user who submits can not see. A lot more work than this should be.

 

How can we easily develop a form, deploy, and only have the user see a well built form and a simple confirmation page without having access to the list where the info goes?

1 REPLY 1
v-micsh-msft
Community Support
Community Support

Hi @rlburg,

 

I am not sure I understand your full scenario.

Currently PowerApps is able to create an App directly from the SharePoint list data, we could filter the List with the help of the User() function, so that the SharePoint list will only show items associated with the user logged in.

 

You may get start from here:

Generate an app to Manage data in a SharePoint list

 

If here you would like to be able to deal with the data without go to the SharePoint list site, then create an App should be the option.

 

 

Further, for SharePoint list form integration, please check:

SharePoint custom forms: Build seperate forms to create, show or edit the list item

 

Regards,

Michael

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

Helpful resources

Announcements
PA 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 Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (67,385)