Power Platform Community Forum Thread Details

Hello all!

I am trying to autofill an app based on a single text input.

Example of functionality: User enters an ID Number, if the record exists in the specified excel table, fields will autofill. I have no problem with anything except for choice values.

Issue: I cannot figure out how to take a text value from excel and convert it to a choice/combo box value. I have tried assigning variables but I think I got lost somewhere

Current variables set to OnVisible of Screen1

Set(varA, false);
Set(varB, false);
Set(varC, false);

Use entered ID Number to determine if coverage is A, B, or C. This formula is located in OnChange of a previous, successfully autofilled item.

If(
 LookUp(
 Table1,
 DataCardValue13.Text = 'ID Number',
 Coverage
 ) = "A",
 UpdateContext({varA: true}),
 If(
 LookUp(
 Table1,
 DataCardValue13.Text = 'ID Number',
 Coverage
 ) = "B",
 UpdateContext({varB: true}),
 If(
 LookUp(
 Table1,
 DataCardValue13.Text = 'ID Number',
 Coverage
 ) = "C",
 UpdateContext({varC: true})
 )
 )
);
If(varA = true, UpdateContext({ComboBox1.Selected.Value: "A"}));
If(varB = true, UpdateContext({ComboBox1.Selected.Value: "B"}));
If(varC = true, UpdateContext({ComboBox1.Selected.Value: "C"}));

Any help would be GREATLY appreciated.

Categories:

Building Power Apps