Answered

SP fields not returning values to edit form in app

(1) Share

Report

Posted on by ahhollan

576

I have an app which creates records in a SP list. Submit form works great. However, the edit form returns fields with blanks when I can see the data in the SP item. Has anyone seen this issue and how did you resolve? I can't seem to find an exact solution for this issue. It seems to affect fields that are dropdowns in the app that feed text fields in the SP.

Thanks for any help you can provide.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Verified answer

Joel CustomerEffective 3,224 on at

Like
a
(0)

Report
Copy link

Link copied!

do Refresh(nameofdatasource) after you submit your form. That should then make the new values appear.

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

I suggest you insert a Gallery2 on the same screen with the form5 (If not already inserted) and on the ITEM put the Datasource.
Then In the Item of the Form put: Gallery2.Selected
Finally on the Default of the Dropdown, put: If(form5.Mode=FormMode.Edit,Gallery2.Selected.ColumnInDropdown,"")

Replace ColumnInDropdown with the Column on the Dropdown
------------

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.

Was this reply helpful? Yes No
ahhollan 576 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm not selecting the item from a gallery. I'm opening the item directly from a custom url that is created by power automate. It opens to the correct record in the edit screen, some of the fields are there. Just not the dropdowns.

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ahhollan ,

Could you please elaborate more about the data card which shows blank?

What is the items property of dropdown?

This may be because the default values are not configured

Please go to check the following properties.

Default property of Data Card: ThisItem.'Column Name'

Default property of inside Dropdown: Parent.Default

If what in the DataCard is a Combobox (not dropdown ), you need to configure the record retrieved from Items property to the DefaultSelectedItems property.

For example, If the Combobox Item property is Accounts.'Account Name', the DefaultSelectedItems property should be :

LookUp(Accounts.'Account Name','Account Name'=Parent.Default)

Hope this helps,

Sik

Was this reply helpful? Yes No
ahhollan 576 on at

Like
a
(0)

Report
Copy link

Link copied!

I think i've got it set up right now. However, when I go to the edit screen something is happening in SharePoint to wipe out the field value that was originally submitted. Any ideas why? I can't seem to figure it out.

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you give a screen shot
------------

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.

Was this reply helpful? Yes No
ahhollan 576 on at

Like
a
(0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ahhollan ,

Can you share the following properties of SBU/BU field?

1. Update property and Default property of Data Card

2. Items property and Default property of dropdown

Sik

Was this reply helpful? Yes No
kmw1130 995 on at

Like
a
(0)

Report
Copy link

Link copied!

@ahhollan Wish there was more to this forum question, because I'm having a similar issue and can't find a solution.

Was this reply helpful? Yes No