Unanswered

Update SharePoint List user records to closed from PowerApp

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I have a PowerApp built for tracking Associate coaching records. When they are submitted by the supervisor, they get stored in a SharePoint List with the supervisor and their direct reports Office365 User information selected for tracking by our department heads. When I submit a form with a selected commitment like "Attention to Detail" and mark it as Open. I want the supervisor to submit a new form later in the coaching process to mark it as closed and submit, when that occurs it marks the other records in the SharePoint List for the Associate selected "Attention to Detail" as closed as well. Is this possible?

Currently what I have for the submit button.

SubmitForm(Form1);
Navigate('Coaching Home Screen');
NewForm(Form1)

Thanks,

Joshua

Categories:

Building Power Apps

All responses (6)

Answers (0)

Sort by

WarrenBelz 156,576 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

On the OnSuccess of the Form

If( Self.LastSubmit.YourOpenClosedField = "Closed", UpdateIf( SPListName, Associate = Self.LastSubmit.Associate && YourCommitmentField = Self.LastSubmit.YourCommitmentField && YourOpenClosedField = "Open" ), {YourOpenClosedField:Closed} )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I made some updates based on how my form is set up, but can't get it to update the other records that match in SP List. The form for the Leader will look like this and is connected like the Associate Field via Office365 User Connector.
Commitment Area (Choice Field)
Associate (People or Group)
Commitment Status (Choice Field)

onSuccess for Form1

If(
Self.LastSubmit,
DataCardValue22 = "Closed",
UpdateIf(
'Digital Locker',
Associate = Self.LastSubmit.Associate && DataCardValue21 = Self.LastSubmit.'Commitment Area' && DataCardValue22 = "Open"
),
{DataCardValue22: Closed}
)
WarrenBelz 156,576 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

You need to refer to the field values, not the control values.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz I tried updating to both options below. It just submits the record like it was already, with out updating any of the older records for the users marked as "Open" to "Closed".

If(
Self.LastSubmit,
"CommitmentStatus" = "Closed",
UpdateIf(
'Digital Locker',
"Associate" = Self.LastSubmit.Associate && "CommitmentArea" = Self.LastSubmit.CommitmentArea && "CommitmentStatus" = "Open"
),
{CommitmentStatus: Closed}
)

and

If(
Self.LastSubmit,
CommitmentStatus = "Closed",
UpdateIf(
'Digital Locker',
Associate = Self.LastSubmit.Associate && CommitmentArea = Self.LastSubmit.CommitmentArea && CommitmentStatus = "Open"
),
{CommitmentStatus: Closed}
)
WarrenBelz 156,576 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous ,

Try

If( Self.LastSubmit.CommitmentStatus = "Closed", UpdateIf( 'Digital Locker', Associate = Self.LastSubmit.Associate && CommitmentArea = Self.LastSubmit.CommitmentArea && CommitmentStatus = "Open" ), {CommitmentStatus: "Closed"} )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz unfortunately that didn't work. I don't know if a Patch or PowerAutomate would work better? Or if i don't understand the field values correctly, but so far zero luck getting it to find the office365 user I submitted past coaching's for and then closing them all out based on the relevant area.

If( DataCardValue22.SearchText.Value = "Closed",
Set(_fieldVar,txtOpen.Text),
Set(_fieldVar,txtClosed.Text))

// Then run Patch
Patch('Digital Locker', Defaults('Digital Locker'),
{
CommitmentStatus: txtCommitmentStatus.Text,
Field: _fieldVar, txtClosed.Text
}

or

If('Commitment Status_DataCard1'.Selected.Value= "Closed",

PowerAppsbutton.Run ('Commitment Area_DataCard1'.Selected.Value, 'Team Leader_DataCard1'.Selected.Value, 'Commitment Status_DataCard1'.Selected.Value
))