Unanswered

Updating a choice type column name Status in share point list from Booked to Checked-in and Checked-in to Checked-out using a Check In/Out button in a container.

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am trying to update a value in Sharepoint list, in a choice type column(Named: Status) with the help of a button in power-apps where if the value in the status in Sharepoint list is, 'Booked' it will change to 'Checked-in', when I hit the Check In/Out button and similarly when I hit the button again the Checked-in will change to 'Checked-out' eventually.

This is my code, so far:

Patch(
Appointments,
LookUp(
Appointments,
Associate.Value = Associate_Number.Text
),
If(
'Checked_In/Out'.Text = {Status : {Value: "Booked"}},
{Status: {Value: "Checked-in"}},
{Status: {Value: "Checked-out"}}
)
);

Categories:

Building Power Apps

All responses (9)

Answers (0)

Sort by

raks on at

Like
a
(0)

Report
Copy link

Link copied!

First, you can make your if or use a switch to put to updated value in a variable.
After, you make a patch or an updateif to update your choice field.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Code?
CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

The condition is quite strange. I think you need:

'Checked_In/Out'.Value= "Booked"
raks on at

Like
a
(0)

Report
Copy link

Link copied!
If( 'Checked_In/Out'.Text = {Status : {Value: "Booked"}}, Set(varValue,"Checked-in"), Set(varValue,"Checked-out") ); Patch( Appointments, LookUp( Appointments, Associate.Value = Associate_Number.Text ), {Status : {Value: varValue}} );
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

This is what i am using rn but it is changing everything to checkout even if it is booked skipping the checked-in.

Patch(
Appointments,
LookUp(
Appointments,
Associate.Value = Associate_Number.Text
),
If(
'Checked_In/Out'.Text = "Booked",
{Status: {Value: "Checked-in"}},
{Status: {Value: "Checked-out"}}
)
);
raks on at

Like
a
(0)

Report
Copy link

Link copied!
Use switch instead if:
Switch('Checked_In/Out'.Text, "Booked",Set(varValue,"Checked-in"), "Checked-in",Set(varValue,"Checked-out") ); Patch( Appointments, LookUp( Appointments, Associate.Value = Associate_Number.Text ), {Status : {Value: varValue}} );
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I am getting an error in the first statement, Booked one. It says incompatibles types:
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

There is no error now but it's not working or changing the status in SP list.
raks on at

Like
a
(0)

Report
Copy link

Link copied!
Maybe could work with updateif:
Switch('Checked_In/Out'.Text, "Booked",Set(varValue,"Checked-in"), "Checked-in",Set(varValue,"Checked-out") ); UpdateIf( Appointments, Associate.Value = Associate_Number.Text, {Status : {Value: varValue}} );