In Progress, Completed Functions

(0) Share

Report

Posted on by ReyOrtiz

146

Hi Everyone

I'm trying to see if it is possible when pressing a button to go to the next page automatically reflects the case as pending on SP List, and it could stay like that until the done button on the next page is selected then can it change the case to complete. I don't know this is possible, any assistance will be greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

slerch 59 on at

Like (1)

Report

Hi Rey,
Do you have a Status column in your list? If so, Use the Patch function on the Item to change the Status to "Pending" with the "Next Page" Button and "Complete" with the "Done" button.
-Spencer

Was this reply helpful? Yes No
ReyOrtiz 146 on at

Like (0)

Report

Thanks for the quick response, I try the Patch as you mentioned and I came up with this Patch('DataTTS',Defaults('DataTTS'),{IssueStatus:"Pending"}) but is not adding pending to SP list, Im new in PwA so I don't know if I did the formula correctly.

Was this reply helpful? Yes No
slerch 59 on at

Like (1)

Report

If the Record doesn't already exist on your List, you need to do a Collect to create the item before you can Patch it. You can set the IssueStatus to "Pending" when you create the Item like:
Collect('DataTTS,{IssueStatus:"Pending"})
To grab that record I would set that Item I just collected to a variable like:
Set(currentCase,Last(Collect('DataTTS,{IssueStatus:"Pending"})))

Was this reply helpful? Yes No
ReyOrtiz 146 on at

Like (0)

Report

I apply your suggestion and it does add the pending and complete but it's not doing it on the same case, is creating a blank case for each. so I get 3 lines one for the case, one for pending no date, and one complete no data (The other one is the Patch i was testing something)

{AEC3A66F-7716-4F...

Was this reply helpful? Yes No
ReyOrtiz 146 on at

Like (0)

Report

Hi, I'm still having trouble getting the buttons to mark the case either Pending or complete, I'm creating a request type form so when it moves to the second page I want the next button to submit the form (which I already have) but to be on pending mode, so when it goes to the next page and the questionnaire is completed and they press done it changes from pending to complete. Can this be done? thank you for the help

Was this reply helpful? Yes No
Verified answer

ReyOrtiz 146 on at

Like (0)

Report

I was able to figure out the issue I ended using LastSubmit and it worked perfectly.
Patch('DataTTS',Form2.LastSubmit,{IssueStatus: "Completed"}) And Patch('DataTTS',Form2.LastSubmit,{IssueStatus: "Pending"})

Was this reply helpful? Yes No