Unanswered

Field is blank in edit mode

(0) Share

Report

Posted on by ahhollan

576

I have a PowerApp tied to a SharePoint list. One field on the app is a dropdown that feeds a simple text field on SP. Submit is fine and the data gets populated to SP. However, when I create the edit form the field is not showing the value. How can I make the field show the text value from SP in edit mode?

Categories:

Building Power Apps

All responses (11)

Answers (0)

Sort by

rebeccas 2,591 on at

Like
a
(0)

Report
Copy link

Link copied!

You want a text value to show as the selected item in a dropdown...is that correct?

You will be setting the default of the dropdown to do this. Example would be you have a single line text column called "Status" and you allow it say either Requested or Closed and so you add a dropdown into your card and it is the items as ["Requested","Closed"] and then the default for that Dropdown would be ThisItem.Status
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

A work around is to Insert a Gallery (If not already done)
1. Put the List on the ITEMS of the Gallery1
2. In the ITEM of the Form, put: Gallery1.Selected
3. On the Dropdown Default, put:
If(YourFormName.Mode=FormMode.Edit,Gallery1.Selected.ColumnOnDropdown,"")
4. You can set the AllowedEmptySelection property of the Dropdown to true

Please change Gallery1 to your actual Gallery name
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
ahhollan 576 on at

Like
a
(0)

Report
Copy link

Link copied!

To be clearer, when I open the edit form to a specific ID from the SP list, I have fields on the edit form that are not returning any values from the SP list item. One of those fields WAS a dropdown when the form mode is new. However, in edit mode, the field should reflect whatever the value is in SP for the specific record.
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Did you try the approach i gave, i have encountered such issue before
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
rebeccas 2,591 on at

Like
a
(2)

Report
Copy link

Link copied!

When you change a field from a TextInput to a dropdown it does not automatically give it a default. You have to set the default value for the dropdown to show a value. Do you have any default value set for the dropdown to allow it show a value? I typically just set the default to ThisItem.ColumnName and that does it for me.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Not sure if this will help now, but I just ran into a similar issue. I had column with type "multiple lines of text" as a description. When submitting the form, it populates and saves fine. When I tried editing however, this field was suddenly blank.

My issue was in the Advanced Properties on the form element for this field, the "Default" was blank. I simply needed to add "ThisItem.Description" as the value for Default and editing now maintains the value previously stored.
ahhollan 576 on at

Like
a
(0)

Report
Copy link

Link copied!

When I set the default value of the card to thisitem.fieldname, and then the default of the dropdown to parent.default, the dropdown does not show the value from the record in the SharePoint list. It remains blank.
rebeccas 2,591 on at

Like
a
(0)

Report
Copy link

Link copied!

Check the "Update" value for that card it is in. (It is in a Form, in a Data Card?).

That Update needs to say what to look at to decide what to update for that field. So you would put something like DropDown1.Selected.Value as the Update.

Hope this helps.
ahhollan 576 on at

Like
a
(0)

Report
Copy link

Link copied!

it accepted dropdown84_1.Selected but still shows 'expected record value' error.
LS579 134 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, I am having a similar issue with a SharePoint Integrated App I am building. Did you ever find a solution to this problem?