Unanswered

Pull information from MS List with a button

(0) Share

Report

Posted on by zya696

Hi everyone,

I have a form set up with multiple screens right now which creates a new record on a SharePoint List. I want to give the option to enter an associated number and have the information pull up so the user can edit it. The only option I have seen is to create a gallery for the user to select which record they want to edit.

I want to keep the list of records out of the user's sight so they can only edit the record if they know the associated number to enter. I created the below screen. I want the user to enter the number, hit the button, and the related information will populate into the following screens which will then be patched to the record queried once completed. Not sure how to go about this. I need this text field to query the SharePoint List and pull the associated data.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

v-qiaqi@microsoft.com on at

Like (0)

Report
HI @zya696,

To retrieve a record based on the associated number, you just need this:

LookUp(Data,'Complaint Number'=TextInput_ComplaintNumber.Text)

Note that if 'Complaint Number' is a Number type column, please try

LookUp(Data,'Complaint Number'=Value(TextInput_ComplaintNumber.Text))

Was this reply helpful? Yes No
zya696 2 on at

Like (0)

Report
Thank you for the fast reply! I am new to PowerApps so I am still having a few problems.

I added the LookUp function to the OnSelect field of the check mark button at the bottom. That makes plenty of sense. OnSelect of the button, the LookUp function will pull the data from the 'Complaint Number' column of the '[data list]' based on the text entered in the ComplaintNumberUpField text field. Since the complaint number will be alphanumeric, I kept it in text format.
LookUp( 'Adverse Event Escalation List', 'Complaint Number' = ComplaintNumberUpField.Text )

Now how do I get the information pulled to populate into fields on the following screens? I do have a mix of date cards, text fields, dropdowns, and cascading dropdowns. Would I need to change the DataSource of the forms which come after this?

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report
HI @zya696,

LookUp() function is only for Text/Default property of a text box control like Label/TextInput, not for behavior property like OnSelect.

To populate a dropdown box, you could try to set the Default property as:

LookUp(Data,'Complaint Number'=TextInput_ComplaintNumber.Text).ColumnName

To populate a combo box, you could try to set the DefaultSelectedItems property as:

Filter(Data,'Complaint Number'=TextInput_ComplaintNumber.Text).ColumnName

Was this reply helpful? Yes No