cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jbarfield
Helper I
Helper I

parent.defualt 'Expected Text Value' .. how to retain values in Edit mode

Setting up the default control on my edit form screen and I keep getting this message shown below on only SOME drop down boxes. Can anyone help me fix this error?

Jbarfield_2-1599748202921.png

 

 

Jbarfield_1-1599748028203.png

 

I understand that the data type is 'Record' and it is expecting 'Text Value'

 

The end goal is to get this formula working 

 

If(EditForm1.Mode = FormMode.Edit, Parent.Default, " ") 

 

So that when the form is in edit mode the dropdown retains the previous value, and shows a blank space when it is a new form. 

 

Again, this formula is working on some drop downs and not others 

1 ACCEPTED SOLUTION

Accepted Solutions

@Jbarfield 

 

Can you try to update the expression as: If(EditForm1.Mode = FormMode.Edit, ThisItem.ColumnName, " ")

 

Here, you need to update ColumnName with the name of column in the sharepoint list.

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS! 

View solution in original post

6 REPLIES 6
yashag2255
Dual Super User II
Dual Super User II

Hi @Jbarfield 

 

Can you confirm if you are updating the Default or DefaultSelectedItems property? You should be updating the DefaultSelectedItems property. There are not much details about the field type in your description, can you share that for the specific field? If you can share more details about the schema of the datasource, we might be able to help you better.

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

I am using the default field, The data source for the places it is not working is a single line text column in sharepoint. The places it is working are from choice columns in sharepoint. @yashag2255 

@Jbarfield 

 

Can you try to update the expression as: If(EditForm1.Mode = FormMode.Edit, ThisItem.ColumnName, " ")

 

Here, you need to update ColumnName with the name of column in the sharepoint list.

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS! 

View solution in original post

@yashag2255  It didn't seem to like this IF statement 

 

Jbarfield_0-1599749391076.png

 

Jbarfield_1-1599749435200.png

 

but I was able to tweak it a little bit by adding .Value

 

Jbarfield_2-1599749694159.png

and now it is working! On edit I have the previous values and on new form I have blank spaces 

 

Still a bit unclear on the logic but *thumbs up since it is working

 

@Jbarfield 

 

If the formula is accepting the .Value attribute, it means it is not a single line of text field but instead an option set or similar type. That is why it drills into the level where there is actual text data.

 

If the issue is resolved, please accept the solution so that it is helpful for others facing the same issue.

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

 

Hi @yashag2255 ,

I am also facing the same issue, i would like to get the submitted value into combo box when the form is in edit mode.

 

Can you help me what is the default values that I need to keep on 

Default and DefaultSelectedItems properties to get corresponding row value when the form is in edit mode

Please visit the below link for more details.

Query is here  

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Did you miss the call? Check out the recording here!

Top Solution Authors
Top Kudoed Authors
Users online (20,146)