hello folks welcome back in this video i will show you
how to set up a simple powerapps application with
one data entry form and how to save data to sharepoint list so stay tuned and
let's go to the demo after this short intro
as you may aware that you can quickly create an app from sharepoint list which
will automatically provision the display edit and detail forms for you
but what if you just need to collect for example
employee feedback in this case you only need one form
which can capture the feedback and save to SharePoint list
or what if the sharepoint data entry form is part of
a larger powerapp application in these cases the full functional
sharepoint powerapp application will not be an appropriate approach
hence we need to create the data entry form in powerapps from scratch
and link it to sharepoint list data source to create new records so let's
see in the demo how it all works so if i navigate to a sharepoint site
i will just go to the site content and here i will just create a new list
i will create a blank list i will just name it feedbacks
and click create so this is the feedback list we have a title column as default
here i will create another multi-line text column which is the description of
this feedback and i will click save now we have two columns i can add as many
columns as i want but for the demo purpose
i will just leave these two columns so what if you have
another powerup application and part of the application
is to collect the feedback and the information needs to be saved here if
you come from sharepoint you can just click on
new item and it will display it here and you can create the record but what if
you want this form to be part of a larger powerapp application to
collect this feedback so as you can see from this powerapp
dropdown you can customize this form or you can create an app if i create an app
like this it will provision the new added display
and search and query all those forms which comes with power app automatically
for this list and it will be provisioned as a new
app but we don't want that we want this to be as part of
another power application so a person can fill the information
and post the feedback to this list i'm inside office 365
from the top left menu if i click on the ellipses i will see the powerapp
application here and this will take me to the powerapps studio homepage from
here i need to select a canvas app from blank
if i click on that i will just give this app a name i will call it employee
feedback app and the format i will leave it as tablet
format click on create now this will create a
blank tablet app for me from the left hand
menu you can see that this screen one already created so what i need to do is
i need to insert the form here so we can capture the
information capture the feedback and post it in sharepoint list so from the
left hand menu if i click on the plus icon here and
edit form i need to select i click on that so this will add
an empty form on this screen i need to connect this form to
a data source in our case it will be a sharepoint list so if i click on connect
to data and under connectors if i scroll down i
should be able to see the sharepoint connector so sharepoint connector if i
click on that i have already used this connector
before so it is saying that you have logged in with this user account so i
will select account and then from this right menu i can select any of
the site which your recent sites so we know that this
list is sitting on a training site so we'll select this training site here and
then we can select the list name which is
feedback i will click on connect now this form is connected to SharePoint list
now we have added a data source here from that list so that source name is
feedback what we need to do is we need to apply
this data source to this form so we select this form and by default it's
already selected the data source on this menu
and we will just type feedback we are assigning the feedback data source to
this form now if we select this form and it's
saying that there is no field in this form so we can select the form
and from this right menu click on edit fields and then click add
fields now we can see all the fields from that list the default fields and
the one which we have created are listed here so in our case we will select title
and the description field those are the only two fields we want on this form so
if i click on add as you can see those fields are added on the form i can
just make this form bit bigger and this one will probably select this
one and i will make it multi-line and then i can just extend it what i can do
is i can just make it one column format and the description i can just make it a
bit bigger yeah so we are done with the form really what we
need is we just need a button to save this information to sharepoint
list so i will just add a button here so if i click on the
insert and button okay so if i drag this button
this side here and just call it submit so you can
actually submit your feedback okay so now last two things i have to do
and we will be done so the first thing is when this form will be open
it will be open as a added form so if i just show you again
this by default is going to be an added form which means that
it will try to fetch information from an existing record from shape on list and
displayed in the edit mode but we actually want it to be a new entry form
so we can change the mode of this form so if i select the form and from this
drop down menu i will click on default mode and you can see the default mode at
the moment is edit i can change it to new so every time when someone give a
feedback it will be a new form okay and the other thing we need to
do is that on the button when someone hit this
submit it should submit the information into that sharepoint list
so i will just need to select submit form and then i will select which form
you want to submit so the form one so we actually
done and this should work but one thing we can add is that once someone
submitted we can redirect that person to a different page
which is like your feedback is submitted successfully
just for the confirmation to that person so if i
go back to the tree view here and if i click on new screen
and you can see that the success screen already created the default template i
will click on that and i will just rename this screen
i will just call it success screen and i will just
change this message i will just say that the feedback was submitted successfully
that's it and then what we want is that the behavior of this application is on
success it should navigate to the success screen
so if i go back to the screen one and click on the form one and here from
the drop down menu if i click on on success i want to go to
the success screen so if i click on navigate to
success screen okay click on that so we are done with the form really so
just to recap we have created an empty canvas app and we
dropped an edit form in here and then we connected that form to a SharePoint list
and then we change the default mode of the form
to a new form and then we also dropped a button and on the click
we're going to submit this form and then we have created
a second success screen so once this feedback is submitted the user will see
the success screen in front of them so they get notified
that yes their feedback is submitted so what i
will do now is i will click on the file tab here and click on save
and i will save it to the cloud click on save here
this is saving a power app application in office 365 environment
you can just share this application with other people or if i
just go back one step and i will go back to the powerapps
application landing page and if i click now on the apps from the left hand menu
i will see the employee feedback app created 21 seconds ago so if i click on
that as you can see in the in the sharepoint
list if i quickly go back to that list feedback list
there's no record created at the moment so if i just click on title so i will
just put some title and some description and click on submit
so this should submit the information into SharePoint list and also
you can see the success message here if i navigate back to SharePoint list there
is one record created in this sharepoint list now you
can see how easily you can create a single form app and
this could be a part of a bigger powerapp app where you just want to
capture some information in sharepoint list and you
just need a new form to capture the information you're not
looking for edit or display form of search form which is a
full-fledged application based on that one single sharepoint list
so today you have learned how to set up a simple powerapp application with one
data entry form and how to save the data into SharePoint list
thank you for watching this video consider subscribing if you're new to
the channel by pressing the red subscribe button below this video
and click the notification bell icon so you don't miss any of my future videos
as i upload them every week give this video a thumbs up if you found
it useful if you have any question regarding this
topic or any other queries related to office 365
put in the comment section below i review my comments on daily basis i will
be happy to answer thank you