You’re offline. This is a read only version of the page.
Hi All, I am trying to build an app that updates my sharepoint list. I want the app to have 5 columns to be filled out but the first column will be a text box and i have dropdowns for the other columns. Can i have set up that when someone enters text in the first box and it matches an existing record.. data in the other fields is automatically pulled but allow the user to update them. Or else, if its a new record in the first column, then the user is allowed to just add details of other columns.. i am trying ro avoid duplicate entries in the datasource. Your advice on how i can go about this will be highly appreciated. CHEERS.
Hi @Ronnie256 ,
Yes, you would do a Lookup to the list on the OnChange of the Text box
Share
Report
All responses (
Answers (
155,779
UpdateContext(
{
varRecord:
LookUp(
SPListName,
YourTextFieldName = Self.Text
)
}
)Then the Default of the other controls would be based on whether varRecord contains information
Coalesce(varRecord.YourFieldName,Parent.Default)
Note this is structure guidance only - in particular the code above will depend on the control and data type.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps
