Updating a specific data in a column in sharepoint list

(0) Share

Report

Posted on by Rudy_Digital

114

Hello everyone,

Really need your help urgently.

Actually i want to update the status column (Single line of text) in my sharepoint list (Candidates).

When i submit the Form 1 i need the status to be "Submitted".

Later in screen 2, upon adding some other informations, when i submit the Form2, i need the status in my SPList to change from "Submitted" to "Admitted".

Below the scenario:

I tried a few patch lines of code with first filter and so on, nothing worked.

Thanks for helping 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (1)

JR-BejeweledOne 5,836 Moderator on at

Like (1)

Report

Can you share the formula that is not working? Are there any red lines or error messages?

Was this reply helpful? Yes No
JB0007 308 on at

Like (0)

Report

Hi @Rudy_Digital ,

You can add the Candidate column as a field in the form and set its value to permanently Admitted in the Default function of the DatacardValue.

You can also hide the field afterwards if the users dont have to see it.

Was this reply helpful? Yes No
Rudy_Digital 114 on at

Like (0)

Report

Hello again mate,

I used this formula: Patch('Candidates',Defaults('Candidates'),'Status':{Value:"Shipment Requested"}).

I think it is not the proper syntax to be used.

Thanks 🙂

Was this reply helpful? Yes No
Rudy_Digital 114 on at

Like (0)

Report

Hello,

The "Candidate" is my SPList name. I think you wanted to say 'Status' column.
For the Form1 it worked but when i doesn't work on the second screen. when i hit the button it is supposed to change from "submitted" to "admitted".

Thanks

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (1)

Report

If you do something similar to what we did before with forms one and two, when you open the second form you can set the value of the Status data card to Admitted and then when you save, it will update.

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report

For some additional information, you can do this. In form 2( or whichever form you are updating here) in the StatusDataCardValue, set your property something like this:

If(DataSource, Status = "Submitted", "Admitted", "Submitted")

Was this reply helpful? Yes No
Rudy_Digital 114 on at

Like (0)

Report

The thing is that the status is should show 'submitted' when the second form is opened. If we change the default value to 'Admitted', as soon as the form2 opens, the status is shown as 'Admitted' even if i have not yet hit the button admitted.

Was this reply helpful? Yes No
Rudy_Digital 114 on at

Like (0)

Report

Actually it is not the form2 that i need to update, it is the SPlist 'Status' Column.

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (1)

Report

Right, just add to your existing patch statement the Status: "Admitted", it will update the status column.

Was this reply helpful? Yes No
Rudy_Digital 114 on at

Like (0)

Report

Nope mate it is not working. my patch statement is completely wrong for sure.

On my Form1 --> i put the default property to be Submitted. When i hit submit Form1 my SPList is updating properly.

On my Form2 --> Patch('Candidates',Defaults('Candidates'),'Status':{Value:"Admitted"}) --> i'm using this formula in the Onselect (Admitted button) and notihng is happening. It should normally change from 'Submitted' to 'Admitted' in the SPList when i hit the 'Admitted' button.

Was this reply helpful? Yes No