Powerapps for Teams: Default value in a dropdown field in within a card

(0) Share

Report

Posted on by dpotta

In a powerapp I have a card called 'Hire'. The card contains a dropdown field.

The card and dropdown field are linked to a column called Hire in a dataverse table. The column in the table is a Choice field with two options On/Off.

The result I would like to see in the powerapp forms is: If no data has previously been entered then On, else the value from the dataverse table record.

I have tried using variations of a formula like this, but cannot get the result I need

If(IsBlank(ThisItem.Hire),LookUp(Choices(Hire),Value=Hire.On,ThisItem.Hire)) I have also used Parent.Default in the If statement, used just the Lookup part of the formula in DefaultSelectedItems...

I am sure I must be nearly there, please can anyone offer some help to get me over the line!

Many thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @dpotta :

Please try:

If( IsBlank(ThisItem.Hire), Filter(Choices(Hire),Text(Value)="On"), [Parent.Default] )

Best Regards,

Bof

Was this reply helpful? Yes No