cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

HELP NEEDED: Button to Auto-Populate

Hi. I built a form on Sharepoint Online, then customized it in powerapps. I included two buttons to auto-populate a multiple line of text field with Current user, date and time. There seems to be an issue with the buttons. Below is the Process on how the form works and the problem.

 

Step 1: User Fills in the form to get approval and saves it. (User will indicate who is the approver for that record in people picker group, there is also a approver 2 if a condition is met)

Step 2: The approver will go in and verify the details and click the "Approver Button" and saves the form. That button will capture the approvers Name, Date and current time in a multiple line of text field. (Formula for Multiple line of text input box If(Button1.Pressed=true,varsig, User().FullName) & If(Button1.Pressed,varsig, ", ") & If(Button1.Pressed,varsig, Now()) )

If approval 2 is need then, Approver 2 will also do the same thing and save the form, same formula but in a different multiple line of text field.

 

Approver 1 clicks on the button, Name, Date and time is captured

PROBLEM: When approver 2 clicks/view the form, the field will capture the logged in user name and update it. 

 

Solution needed: Each button to caputre details and locks it. Other users should not be able to change it or it should not auto-populate with other logged in users.

 

Screenshots for reference

 

Untitled-1 copy.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Hi @kanishk ,

 

You can make the button only clickable for the approvers who need to press it so that it won't be triggered by the wrong user. 

 

Set below formula in the DisplayMode property of the button control:

If(User().Email="xxx" ||User().Email="xxx" ||User().Email="xxx",Edit,Disabled)

Regards,

Mona

 

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

View solution in original post

1 REPLY 1
Highlighted
Community Support
Community Support

Hi @kanishk ,

 

You can make the button only clickable for the approvers who need to press it so that it won't be triggered by the wrong user. 

 

Set below formula in the DisplayMode property of the button control:

If(User().Email="xxx" ||User().Email="xxx" ||User().Email="xxx",Edit,Disabled)

Regards,

Mona

 

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

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (8,700)