Change Drobbox field value when in edit mode, use default in new mode - Powerapps, Dataverse for Teams

[CrazyCol]

Hi,

I have a field that default populates the user email in the form new mode but when I select a record from a gallery, the field changes to the value of the selected record. This has been achieved using the below formulae in the Value property.

If(FormBasicInfo.Mode=FormMode.New, User().Email, ThisItem.RaisedbyEmail)

I want to do the exact same for a drop box field in the same form

At present, I have the following:

Items: Choices(DRF_Status)  

DefaultSelectedItems ["Draft"]

There is no value property therefore it must have to be entered somewhere else.

I have experimented with the above formulae in different property fields for the drop-down with no luck. and my search in this forum and on youtube I find similar yet slightly different requirements and I have failed to translate their solutions to meet my objective.

Any assistance would be much appreciated, 

Thank you.

[Amik]

@CrazyCol - could you replace ["Draft"] with {Value: "Draft"} ?

[CrazyCol]

@Amik I assume you mean within the formula in the defaultSelectedItems property?

If(FormBasicInfo.Mode=FormMode.New, {Value: "Draft"}, ThisItem.DRFStatus)
//{Value: "Draft"}
//["Draft"]

 This returns an error stating ... formula uses scope not presently supported.... 

[Amik]

Yes correct. Could you create a brand new form and apply that logic to that field and check if the same error occurs. This will help you identify if there is a problem with your Form.

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

[CrazyCol]

Same error is showing. 

[Amik · Accepted solution]

@CrazyCol - that is not an error and is a red herring. Is the Combo Box displaying "Draft" in New Form mode?

You could try other variations, but the same "error" will appear without impacting the output you need.

If(
    FormBasicInfo.Mode = FormMode.New,
    { Value: "Draft" },
    Parent.Default)

If(
    FormBasicInfo.Mode = FormMode.New,
    {Value: "Draft"},
    ThisItem.DRFStatus
)

If(
    FormBasicInfo.Mode = FormMode.New,
    {Value: "Draft"},
    {Value: ThisItem.DRFStatus}
)

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

[CrazyCol]

@Amik yes that's correct, it showed default draft on new form with either

//{Value: "Draft"}
//["Draft"]

, however, once applied, when I select on a record to view or edit, that I know has had its record changed, it still shows Draft.

[Amik]

@CrazyCol ....so it does work.

If you started with that, it would have saved both of us a lot of wasted time.

What do you have in the Item property of your Form?

[CrazyCol]

@Amik I am not sure what you mean by wasted time..... the default value was not my issue, it is when I select an existing record to view or edit, it still shows the default value draft regardless of its actual value. In edit/view mode i want it to show its actual value.

Items: Choices(DRF_Status)  

DefaultSelectedItems was ["Draft"] , {Value: "Draft"} also works.

I tried the variations suggested above in DefaultSelectedItems property, the same error occurs. 

[Amik]

@CrazyCol again - what do you have in the Item property of your Form?