Unanswered

Update collection from drop-down ONLY when not blank

(0) Share

Report

Posted on by paulieHETI

Hi Folks

I am trying to update numerous records based on a single drop-down value. However, if the drop-down value is blank I do NOT want the selected records to change. I am using the following code which works but updates all selections including blank.

"Devices_collection" is the collection of ALL my records

"ColSelected" is a few records selected from Devices_collection

//CODE

UpdateIf(
Devices_collection,
ThisRecord in ColSelected,
{
'deployment-status': DeploymentStatusUpdate.Selected,
'device-status': DeviceStatusUpdate.Selected,
'device-location': DeviceLocationUpdate.Selected,
'model-lookup': ModelUpdate.Selected
}
);

//END code

thanks in anticipation

paul walker (not fast or furious)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

WarrenBelz 156,033 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @paulieHETI ,

I am a little unclear here - you are updating one collection from another, but the drop-downs (you seem to have 4 of them) are controls on the screen, so are unrelated to either collection, so what is it you are wanting to happen when (whichever) drop-down is blank ?

Was this reply helpful? Yes No
paulieHETI 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Warren
Thanks for your response.
I first select a few records that I wish to edit.
There are 4 drop-down options in each of these records.
I have a four drop-downs controls containing the same options as each selected record which update the selected records on save.
However, If one of the controls is left blank I do not want the blank value sent to each record - I want those drop-downs to remain as they were.
So, in my head, the code would look like this:
UpdateIf(
Devices_collection,
ThisRecord in ColSelected,
If(
!IsBlank(DeploymentStatusUpdate),
{'deployment-status': DeploymentStatusUpdate.Selected}
),
If(
!IsBlank(DeviceStatusUpdate),
{'device-status': DeviceStatusUpdate.Selected}
)
);
Hope this makes sense
Thanks again
p

Was this reply helpful? Yes No
paulieHETI 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Graphical representation

Was this reply helpful? Yes No
WarrenBelz 156,033 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@paulieHETI ,

The drop-downs are not part of the collection - they are part of the galley - you need to refer to whatever field names in colSelected get populated from those drop-downs.

Was this reply helpful? Yes No