cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kanishk
Level: Powered On

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
Community Support Team
Community Support Team

Re: HELP NEEDED: Button to Auto-Populate

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
Community Support Team
Community Support Team

Re: HELP NEEDED: Button to Auto-Populate

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,908)