Unanswered

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

(0) Share

Report

Posted on by 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.

Categories:

Building Power Apps

I have the same question (0)

All responses (15)

Answers (1)

Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report

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

Was this reply helpful? Yes No
CrazyCol 49 on at

Like (0)

Report
@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....

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report

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

Was this reply helpful? Yes No
CrazyCol 49 on at

Like (0)

Report

Same error is showing.

Screenshot 2023-0...

Was this reply helpful? Yes No
Verified answer

Ami K 15,679 Super User 2024 Season 1 on at

Like (1)

Report
@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

Was this reply helpful? Yes No
CrazyCol 49 on at

Like (0)

Report
@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.

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report

@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?

Was this reply helpful? Yes No
CrazyCol 49 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report

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

Was this reply helpful? Yes No
CrazyCol 49 on at

Like (0)

Report

@Amik
In My original form - Gallery1.Selected

In the new form - If(BrowseGallery1.DisplayMode = DisplayMode.Disabled, selectedRecord, BrowseGallery1.Selected)

Was this reply helpful? Yes No