Answered

working with form using SharePoint as data source

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am an absolute beginner on power apps. I am currently developing a form for office entrance. so I would like to ask about is it possible to let user only enter the data once and can later update certain field whenever they use the application when the data-source use is share point list? and how am I going to display the data from form to label in the next page? thank you 🙂 here I attache the form page of my application.form page for office entrance

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Let me answer your request with 2 answers:
1. Restricting user with one submission:
Set this formula on the submit button DisplayMode property
If(CountRows(filter(SPList,CreatedBy.Email=User().Email))>0,DisplayMode.Dissabled,DisplayMode.edit)
2. Show the submitted values on the next screen:
Pass the values to next screen onSelect of the submit button as below:
Navigate(screen1,{Name:textName.text,phoneNumber:txtphonenumber.text......Add the controls})
OnScreen 2 Please use as below:
add a label and set the value of the label with Name

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Based on the needs that you mentioned, I think the PowerApps could achieve your needs. I assume the "Name" field is the Unique Identifier column in your SP List, which could identify one record uniquely.

I have made a test on my side, please consider take a try with the following workaround:

Set the OnStart property of App to following:

Set( PreservedRecord, LookUp('Your SP list', Name = User().FullName) ); If( IsBlank(PreservedRecord), NewForm(EditForm1), EditForm(EditForm1) )

Set the Item property of the Edit form to following:

PreservedRecord

In addition, if you want to display the data using Labels in next page, please try the following workaround:

Set the Text property of Name Label to following:

NameTextBox.Text

set the Text property of the Phone Number Label to following:

PhooneNumberTextBox.Text

set the Text property of the Date Label to following:

DateFieldDataCard.Update //DateFieldDataCard represents the Date Field data card in your Edit form

Note: NameTextBox, PhoneNumberTextBox, .. represents the Text Input boxes in your Edit form.

...

....

Please try above solution, hopes it could solve your problem.

Best regards,
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, thank you for the reply..
I've tried to do for the navigating the form input to the next page like this
is it the label name for the page I'm navigating or the name of the sharepoint list?

while for the display mode,
Created By seems not to work.. Data is the name of my sharepoint list..

Thank you again 🙂
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the reply 🙂

here is my OnStart properties
and I tried to set the item properties of the edit form as Preserved Data but it will not show up my form when I run the application
here my Item property of the form

Thank you again 🙂
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Please consider modify the formula within the OnStart property of App to following:

Set( PreservedRecord, LookUp('Your SP list', Name = User().FullName) ); If( IsBlank(PreservedRecord), NewForm(EditForm1);Navigate(EditFromScreen), // Add formula here EditForm(EditForm1);Navigate(EditFromScreen) // Add formula here )

Note: The EditFormScreen represents the screen in your app which holds your Edit form.

Please re-load your canvas app again, check if you would be navigate to corresponding screen.

Set the Item property of the Edit form to following:

If( !IsBlank(PreservedRecord), PreservedRecord, Defaults(Data) )

or

If( !IsBlank(PreservedRecord), LookUp(Data, ID = PreservedRecord.ID), Defaults(Data) )

Please try above solution, hope it solves your problem.

Regards,
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so so much for the solution 😊
here is my item property.

here is my OnStart of the apps.. for the lookup I used email because it returns error when I use name.. screen 1 is my page that contains the form..

It runs with no error, but when I go back to use the form it is still comes back to the empty form.. I want to achieve a form that user can only enter data once and when they open again their data is there in the form .. is it possible or am I doing it the wrong way from your solution? Thank you again 😊