Power App

(0) Share

Report

Posted on by raks2703

Im new to Power App.. Im developing an sharepoint list using power app..

I have form with auto populate name of the person who submitted the form.

Once the form is submitted by someone, im going to edit some other field in the same form. In this time, the name of person who submitted form will overwrite with my name. This should not happen.

How to lock the auto populated field once the form is submitted. In simple once the form is submitted, his name should be there in the form.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Rusk 1,369 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @raks2703

Is your data source a SharePoint List? And what formula are you using to auto populate the name of the person who submitted the form?

If you are using the "Last Modified" property, it will be overwritten by a new name each time there are changes. I'm just guessing because there isn't enough information here to know for sure. If this is your case, you can make a new column named "Submitted By" and then save the name value to that column when the form is submitted.

But we can offer more help if you can give more info regarding how the form is submitted, what is your data source, and what formulas you are currently using!

Was this reply helpful? Yes No
raks2703 4 on at

Like (0)

Report
Copy link

Link copied!

Yes, my Date source is SharePoint List. I have used below formula to auto populate the person's name.

{
DisplayName:User().FullName,
Claims:"i:0#.f|membership|" & Lower(User().Email),
Department:"",
Email:User().Email,
JobTitle:"",
Picture:""
}

Was this reply helpful? Yes No
raks2703 4 on at

Like (0)

Report
Copy link

Link copied!

@Rusk Any Luck..?

Was this reply helpful? Yes No
Rusk 1,369 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Sorry for the slow reply...

So you are pulling the name for each user. How does that get saved? It seems you could use an If statement to only save the name upon submission, and not save the name when editing.

How does the submission of the form work? Is your column value blank until they submit it? If so, for the submission, you can add use IsBlank. If the value is blank, save the name (the submission). If not, do nothing (for those editing later).

If(IsBlank('Column Name'), your submission save formula

Was this reply helpful? Yes No