Edit Single Field on Detail Form

(0) Share

Report

Posted on by slhangen

356

Good afternoon Community,

I would like to click on the pencil icon and have administrators enter data into AdminNotes column in SP list.

I do not want them to be able to change any other parameters. I just want text input box txtAdminNotes to be editable.

Also, how would I patch this?

Admin Notes Capture.JPG

Any Ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (2)

Sort by

Loose Chippings 185 on at

Like (0)

Report
Copy link

Link copied!

Hi slhangen

I'll put forward one way of doing this. On the OnSelect property of the pencil icon, use UpdateContext to set a 'flag'. Something like OnSelect: UpdateContext ({adminEdit: true}). Then on your Administrative Notes card, set the DisplayMode property to If(adminEdit, DisplayMode.Edit, DisplayMode.View).

The If statement is saying "if the flag adminEdit is true, make the Display Mode = Edit, Else, if the flag adminEdit is false, make the Display Mode = View".

You can use UpdateContext ({adminEdit: !adminEdit}) to switch whether adminEdit is true or false each time the pencil is clicked, if you wish.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @slhangen

In the Pencil Icon OnSelect property ViewForm(FormName) but unlock the Card containing the Administrative notes and change the the Display mode property from Parent.DisplayMode to Edit. You could add a checkmark icon with the OnSelect property SubmitForm(FormName).

Was this reply helpful? Yes No
Loose Chippings 185 on at

Like (0)

Report
Copy link

Link copied!

Hi slhangen

Following on, to Patch the SharePoint list you would use: Patch( SharePoint list name, ThisItem, {AdminNotes: 'Administrative Notes'}). Where SharePoint list name is the name of your list, ThisItem means the current selected item of your gallery, and 'AdminNotes' is the name of the column in SharePoint you are using for the Notes.

I hope that is useful.

Was this reply helpful? Yes No
Verified answer

slhangen 356 on at

Like (0)

Report
Copy link

Link copied!

Getting an invalid use of Patch error. Name isn't valid, identifier isn't recognized.

Patch( 'STAFF Pre-Certification Log', ThisItem, {AdminNotes: txtAdminNotes.Text})

SP column is AdminNotes, input textbox is txtAdminNotes

Not sure what I am missing.

Was this reply helpful? Yes No
Verified answer

Al_10 1,691 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

What if you try this:

Patch( 'STAFF Pre-Certification Log', LookUp('STAFF Pre-Certification Log', ID = ThisItem.ID), {AdminNotes: txtAdminNotes.Text})

Was this reply helpful? Yes No
Loose Chippings 185 on at

Like (0)

Report
Copy link

Link copied!
Hi @slhangen

Your syntax is correct, so it is just a question of tracking down why you are getting the error.
The first thing I would do is check the column name is really AdminNotes in SharePoint by looking at the end of the URL in SharePoint List Settings.
It may depend on where you are putting the Patch statement. If you are using a Submit button on the form, then ThisItem should work. If the Submit button is not on the form you may need Gallery1.Selected instead.
The intellisense of PowerApps is very good, so you should be able to check the validity of each stage as you go along. My suggestions to try are:
Patch( 'STAFF Pre-Certification Log', Gallery1.Selected, {AdminNotes: txtAdminNotes.Text}) if the submit button is not on the form.
Patch( 'STAFF Pre-Certification Log', ThisItem, {AdminNotes: ThisItem.AdminNotes}) if the button is on the form or you are using the OnChange property of the text input box.

Was this reply helpful? Yes No
slhangen 356 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the insight, moved
If("true" in valSymptoms.Text,Navigate(ScreenDenied),Navigate(ScreenCleared)) in OnSuccess of the form and it still navigates to ScreenCleared not matter what.

FacePalm!

Was this reply helpful? Yes No