Add a Form to Power Pages Site to Insert/Edit/View Data

This is the Fifth video of #PowerPages30DaysLearningChallenge series, where you'll learn:

👉 Understand Basic Forms in Power Pages.
👉 Create first page with form in Power Pages site
👉 Create INSERT form to insert data in Dataverse
👉 Create Update/Edit form to update data in Dataverse
👉 Create READONLY form to view Dataverse data
👉 Configure Table Permissions and Web Roles to enable security on the forms

Looking forward to your feedback. Please post your queries in the comments and I'll try to answer them all.

[prashanthjalvancha]

you should have shown table creation before creating the forms. good explanation, thanks

[rahulnl]

It was a great detailed explanation, thank you :)

[jerrywhite]

Hi Arpit,
you are doing a great job. Thank you!
I have a question for you or for everyone who can help me. I have choosen the blank site to start, but i dont have the login page. how can i fixe it?

[kensleylewis]

On a connected note to your excellent demonstration, is it possible to merge contacts? Let say a teacher registers for an event today. But 2 weeks from now does it again under a different registration account because she forgot she signed up earlier, and uses a different email address. What would be a good way to fix (merge) this contact into one?

[MartinBordt]

The videos are very helpful. But keep them short. It is not needed to recap the previous videos in all this details. It looses focus and make the video unnecessary long.

[HyderabadiEmraan]

Hi In which video you have described the Edit Mode with particular with an Id or reference id to another table form ? can you please describe more about the query string?

[poojai]

All your videos are really helpful..Thanks for your contribution..

I have found out 2 issues while I was creating pages:

1. Tried adding a page for new form with Insert data option, unfortunately I don't see any Submit button in my form.. Anything missing here??

2. I don't get Sign in navigation link on the top left corner, do I have to enable any settings?

[vamsivaranasi]

Arpit - Thank you very much for your valuable information.

I have faced the below issues in the Form.

1. I have selected the attachment option while configuring the form but I am unable to see the attachment with in the webpage.
2. where the attachments are going to be stored with in the table record as I haven't created any column as File type.


Please clarify.

[abdussamad]

Can you please explain Access type in details ?
Apart from Global everything seems like same in document and here in video also.

[naveentherawat]

Nice videos Arpit 👍
Just a quick question as you have demonstrated the profile page. You have created contact profile page separately, so now we have two ways to view profile information . As design prospect its not look nice can we have a way to hide OOB profile page and replace our own newly created page.

[arunv]

its great, my doubt is on how the choose a table and select a form means, is the choose the table created by us ? and choose a form is already clreated one ?

[nehxcuv]

in during chose table you select the table which you have made already. kindly tell how to create a table in dataverse.

[prasanthp]

Hai bro
How to create lookup for a particular field like (Event mode field) you have created?

[HyderabadiEmraan]

Hi sir, how can we add cascading dropdown( Choice/lookup) like country & city fields dependent to each other in power pages?

[RaghavRNair]

Hi, I am new to power pages! Is it possible to create a quiz and return the results?

[kubrasambur]

Hi Arpit,
Thanks for video but i have a issue. When i created read-only form, i cant' see it in preview page. it says " The record you are looking for couldn't be found. " I did all things about power apps portal management and i changed Record Source Type to Record Associated to Current Portal User.
do you have any idea about that?

[vishakhamudgal]

how to add attachment to a form and then view same file? Can you please suggest this

[dougydoe]

Another excellent video. However I run into an issue as I was working along. Everything was OK except that, when I clicked the Preview, I wasn't logged in so couldn't see the forms on the page. At the top right, I saw a link to SignIn but that took me to my profile page in O365 (Like the Delve Page) when I clicked it. How do I sign in? When I checked the Set Up page, Azure Active Directory has already been enabled so not sure what else I should do? Thank you.

[shreyasonawane]

I want to get into this microsoft power platform field can u help me understand how much can we earn after a year experience in city like pune

[jawaharlalnehru]

How to solve this problem:; This record hasn't been created yet . To enable upload crate this record