Unanswered

Using buttons to populate fields from a SharePoint List

(0) Share

Report

Posted on by KeyboardTsar

I've got a bit of a complex one here:

I have a set of input fields (Text Inputs and Drop-Down Menus) that are assigned columns in a SharePoint list as their 'DataField'. The user enters the data (for example their email address) into the fields and when the form submits a new entry is written to the SharePoint list (this all works fine).

What I want to be able to do is have the user enter their email and, if they have submitted the form before (i.e. if their email is already in the relevant SharePoint list colum), have the option to click a button and prepopulate the other fields with the data from their last entry (which would be the row with the highest ID containing their email).

Any suggestions? Thanks for any and all help.

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

hpkeong 2,944 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

May I suggest:

-When the user enter their email into:
TextInput1.Text = for entering email

Button (which you wish to click, to be visible using):
Button1.Visible = !IsBlank(First(Filter(DS, TextInput1.Text = UserEmail)))

Then If the email is already exists in the DS, the button will be Visible (True), and you can
Button1.OnSelect = to populate your data based on the TextInput1.Text (Email address).

I hope this will give you a hint.
TQ
KeyboardTsar 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your response hpkeong.

I was able to populate the desired fields using the LookUp function and context variables. Your button trick was very helpful.