Answered

Update a choice column from an independent collection

(0) Share

Report

Posted on by SpartaBI

Hi,
I have a choice column. In some cases I want to update it with a set of values from a collection I created instead from the original option that comes with that card.
I created a dropdown with the collection and have put it inside the relevant data card.
Then I wrote this in the Update property:

If(
 Condition (working),
 DataCardValue17.Selected, // the original choice from the original data card combo box (working)
 {value: DataCardValue17_2.SelectedText.Value} // what I'm trying to insert from the dropdown with the collection (not working) 
)

I also tried:
DataCardValue17_2.Selected in the 3rd line instead.

It gives me a success message but in SharePoint the record for that column is not picked up.

How should I write it correctly?

Categories:

Building Power Apps

All responses (14)

Answers (3)

Sort by

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @SpartaBI ,

I am trying to work out the difference - you will always be selecting an item from the combo box and this will be the Update of the card. If you want different choices, put this in the Items.

The two options you have are actually the same.
SpartaBI 48 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz thanks for your reply.
In case I go with the original combo box (so I won't need to edit the update property) so what should I write on the else branch for the items property?

And what for the defaultselecteditems property?

This is my collection:

I also added these values to the choices in the SharePoint to the original Supplier column just to be on the safe side it will be able to pick up the values from the alternative demo supplier collection.

This function doesn't return an error for the items:
If(
First([@PowerBIIntegration].Data).'Selected Showcase For Expenses App' = "Real",
Choices([@Expenses].Supplier),
DemoSuppliers.Supplier
)

However, it doesn't pick them up in case the else branch kicks in.

Really appreciate your help, thank you for replying.
Verified answer

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
HI @Donzera ,

I will start with some basics on the Items

If( First( [@PowerBIIntegration].Data).'Selected Showcase For Expenses App’ = "Real", Choices([Expenses].Supplier), RenameColumns( DemoSuppliers.Supplier, "Supplier", "Value" ) ) )

both options need to output the same "Value".

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
SpartaBI 48 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz ok, checking, 1 min
SpartaBI 48 on at

Like
a
(0)

Report
Copy link

Link copied!

ok, yes, now I see in the same combo box the items for the collection.
How can I change the default? Currently it's still showing the default of the real supplier.
I tried to edit the DefaultSelectedItems like this, but it give me an error function for the else branch
Verified answer

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @SpartaBI ,

Try this

{Value: ThisItem.Supplier.Value}

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
SpartaBI 48 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz that works :)) but I needed to change it to:
{Value: ThisItem.'Demo Supplier'}
That make sense to you that my version also works?

Your version worked because currently for fake suppliers the values are the same for both columns in the SharePoint list but I aim to remove those fake choices entirely from the real supplier column and add a logic that will add a real matching supplier to the real column based on the selected item when I'm in demo mode.

So I will need in this case to use my version of the code right?
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@SpartaBI ,

The main issue is that you are writing to a Table field (Choice field) which has one Text field called Value and you need to write a Text value into that, so if 'Demo Supplier' is Text, then yes that will work.
SpartaBI 48 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz Demo Supplier is a calculated field that returns text, so same goes also for this case?
Verified answer

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@SpartaBI ,

Be careful with calculated fields - they are not the best friends of Power Apps and do not always refresh if their dependant values in the source is changed. If it works in your case, then keep using it, but it is better to do the calculation in Power Apps.