Update single record of a editform with a button

(0) Share

Report

Posted on by gennarodp

294

Hello,

i have an edit form that is related from a gallery (source sharepoint list)

when i select a single records of gallery, the app open a new screen with a editform linked with detailed datas of selected record.

i would like in this editform to update a single field with a button, that switch the value from ‘open’ to ‘closed’.

i have tried with function patch, but i have some errors.

thank you all

Categories:

Building Power Apps

All responses (8)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Consider this formula:

Patch(Datasource,LookUp(Datasource,ID=Value(DataCardValue1.Text)),{StatusColumn:"Closed"})

Note: Change ID to your unique column in your List

Change DataCardValue1 to the Textbox on your form

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
gennarodp 294 on at

Like
a
(0)

Report
Copy link

Link copied!

Some questions:

Id is unique Id of Sharepoint list ?
DataCardValue is a DataCard of what fields ?
StatusColumn is the column in wich is there open e closed status ?

Thank you
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Id is unique Id of Sharepoint list ? YES

DataCardValue is a DataCard of what fields ? THE ID FIELD (Textbox) IN YOUR FORM

StatusColumn is the column in wich is there open e closed status ? YES

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
gennarodp 294 on at

Like
a
(0)

Report
Copy link

Link copied!

ok, it doesnt' work.
gennarodp 294 on at

Like
a
(0)

Report
Copy link

Link copied!

the problem is that, the values "open" and "closed" are selected value, not simple text.

How can i resolve it ?

Thank you
Verified answer

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

If it a choice column:

Patch(Datasource,LookUp(Datasource,ID=Value(DataCardValue1.Text)),{StatusColumn:{Value:"Closed"}})

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
gennarodp 294 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much
mbhatt 525 on at

Like
a
(0)

Report
Copy link

Link copied!

i want to use button for change value of choices from sp list and update

i have gallery which is indicate when i select any record redirect on new screen which is display the dat on form edit . i set the button for change value what i want to with this button . when user click button the existing record change and update again in to app and sp list