Patch Status automatically

(0) Share

Report

Posted on by Mandree

Hello guys,

in my Sharepointlist I have 3 stati.

- Pending (default)

- In Progress

- Approved

If the employee now fills out the form and clicks the "Save" button, the status should be changed to "In progress". So I try to implement it in the OnSucces of the form, but it doesnt work.

Patch(employee_interview;LookUp(employee_interview;ID=InterviewForm.LastSubmit.ID);{Status:{Value:"In Bearbeitung"}}) & Navigate(SuccessScreen)

What I am doing wrong or is there a other way to patch one single element in the list after submitting a form or is it possible to set the status in the form?

Thank you for your help.

Mandree

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

Patch(employee_interview;LookUp(employee_interview;ID=InterviewForm.LastSubmit.ID;{Status:{Value:"In Bearbeitung"}}))

Try this code without navigate for now. and see if it works

Was this reply helpful? Yes No
Mandree 17 on at

Like
a
(0)

Report
Copy link

Link copied!

That works. How can I combine it with the Navigate now ? 😄

Was this reply helpful? Yes No
Verified answer

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

well whatever you use to end the sentence. Like we use semi colon. i think you need double semi colon???
then
Patch(employee_interview;LookUp(employee_interview;ID=InterviewForm.LastSubmit.ID;{Status:{Value:"In Bearbeitung"}}));;
Navigate(Screenname);;

Was this reply helpful? Yes No
Mandree 17 on at

Like
a
(0)

Report
Copy link

Link copied!

I don't understand, why I need double semicolon, but it works. Maybe you could explain why? Thank you very much.

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

i think in English version we use single semi colon to end the sentence. But, some other maybe European version double semi colon to end the sentence. Not sure about all of this. but you were using & before navigate. & is used to concat string con functions.
So your structure needed to
Patch ;;
Navigate ;;
because this 2 are different functions.

Was this reply helpful? Yes No