cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Flashback
Helper I
Helper I

Open record for edit based on textinput value

Hello,

 

i have TextInput where i write SampleName (column in SQL) and by button i need open this record for editing.

 

How can i do this?

 

Thank you

Jakub

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Flashback ,

 

So there would be 3 parts of functions.

1\ You could set a variable with scanned text, set OnTimeEnd to:

Set(varScanned, TextInput.Text)

 

2\ Use an Edit form to display the record, set DataSource of the Form to SQL database, and set Item property of the Form to:

LookUp(SQLtable, ColumnName = varScanned)

 

3\ Add a button to submit, set OnSelect of the Button to:

SubmitForm(EditForm1)

 

Hope this helps.

 

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

6 REPLIES 6
v-jefferni
Community Support
Community Support

Hi @Flashback ,

 

Could you please share more details about your scenario? Would you like to edit a specific record from SQL database in Power Apps?

 

If so, you could learn this from creating an App from data source -> SQL Server. With this App, you will be able to search the record in a Gallery and navigate to an Edit screen to edit the selected record.

198.png199.png

If you would like to modify the layouts of the App, please refer to the official doc below, basically the same method although with different data source:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/customize-layout-sharepoint

 

Hope this helps.

 

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Flashback
Helper I
Helper I

But i want open record by button based on value in TextInput. Is it possible?

 

I have in SQL table record "PR2102546001" and i want write this to TextInput and open for editing.

Hi @Flashback ,

 

Could you please explain more of your scenario? I'm not pretty sure what need you would like to achieve.

 

In my post, you could see a search box, if you already have records in SQL database, when you typing in text the respective result would show up in the Gallery. Then you could click the ">" button to navigate to the edit screen you will see in which an Edit Form with details of the selected record, a TextInput box would display the value "PR2102546001" for you to edit. After editing, clicking the save button would save changes to your SQL database.

 

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Flashback
Helper I
Helper I

I need automatically open record if his name is scanned to TextInput

 

So i have TextInput and Timer

 

To the TextInput i scan sample name (by hand scanner, not mobile) and by Timer i need to open record based scanner sample name for editing.

 

thank you

BR

Jakub

Hi @Flashback ,

 

So there would be 3 parts of functions.

1\ You could set a variable with scanned text, set OnTimeEnd to:

Set(varScanned, TextInput.Text)

 

2\ Use an Edit form to display the record, set DataSource of the Form to SQL database, and set Item property of the Form to:

LookUp(SQLtable, ColumnName = varScanned)

 

3\ Add a button to submit, set OnSelect of the Button to:

SubmitForm(EditForm1)

 

Hope this helps.

 

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

It works 🙂 Thank you!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,062)