Answered

Updating multiple records in SharePoint

(0) Share

Report

Posted on by StefanV

I am working on an app that enables management in our company to pick winners for our recognition program from a SharePoint list. From this list we are grouping by column to display staff, and in a different gallery all the nominations they received on the quarter.

Now, management can go through all the nominations for this staff member and then using the toggle switch, select if the person is a winner or not.

This only reflects on the selected record though… they want the one selection to update every instance where the user was nominated to be updated as well.

This is what I came up with, but it is missing something:

If(varQuarterChanged = 1, Patch(
 'F23_Selection_v1.2', 
 LookUp('F23_Selection_v1.2', (galNominees_1.Selected.Grouped).'Employee ID' = 'Employee ID') , 
 {'Quarterly Winner': DataCardValue5.Value} , 
 {Location: DataCardValue19.Selected}),
 Navigate(Quarterly_Nominees,ScreenTransition.UnCoverRight));

varQuarterChanged = var I set up on the OnChange for the toggle

Please can you help me fix this?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

StefanV 34 on at

Like (0)

Report
Update: I was able to make this work, but it obviously only updates the first record:

If( varQuarterChanged = 1, Patch( 'F23_Selection_v1.2', LookUp( 'F23_Selection_v1.2', First(galNominees_1.Selected.Grouped).'Employee ID' = 'Employee ID' ), {'Quarterly Winner': DataCardValue5.Value}, {Location: DataCardValue19.Selected} ), Navigate( Quarterly_Nominees, ScreenTransition.UnCoverRight ) )

Any suggestions on updating all records?

Was this reply helpful? Yes No
Verified answer

StefanV 34 on at

Like (0)

Report
If anyone is interested, this worked:

If( varQuarterChanged = 1, UpdateIf( DataSourceName, 'Employee ID' = Gallery2.Selected.'Employee ID' And 'Nomination Quarter' = "Quarter 2" , { 'Quarterly Winner': DataCardValue5.Value, Location: DataCardValue19.Selected, 'Quarterly comments': DataCardValue53.Text } ) )

Was this reply helpful? Yes No