Answered

Data card values not populating

Like (0) Share

Report

Posted on 9 Nov 2023 15:40:20 by djohnson1223

When selecting an entry to edit, the data card values for 3 items are not populating on the edit screen. These 3 fields are derived from choice columns - not sure if this is the problem or not. Other values are populating as they should.

Power Apps items ...

All responses (5)

Answers (1)

Verified answer

djohnson1223 13 on 20 Nov 2023 at 17:38:51

Like (0)

Report

Re: Data card values not populating

Solved by Microsoft support:

Our senior engineers pointed out that working with Modern Controls has many limitations as per today, one of them the functionality of the combo box control as we checked with our colleague Fernando yesterday. That is why we encourage to work with the classic controls:

Now, on our tests, the feature worked as expected with a classic combo box, but instead of ‘Default’ property as we tried yesterday, should be ‘DefaultSelectedItems’ and in the formula bar should be ‘Parend.Default’. We tried this and it worked from an app created for testing.
djohnson1223 13 on 09 Nov 2023 at 19:55:05

Like (0)

Report

Re: Data card values not populating

Yes, it is a ~~choice~~ lookup column.
Sundeep_Malik 6,480 on 09 Nov 2023 at 19:29:26

Like (0)

Report

Re: Data card values not populating

@djohnson1223

On the lookup try

LookUp('Employee PTOs', ID = PowerAppsOneGrid1.Selected.ID).'Employee Submitting PTO'.Value
djohnson1223 13 on 09 Nov 2023 at 19:27:51

Like (0)

Report

Re: Data card values not populating

Hello Sundeep_Malik,

For item #1: The property of the form is PowerAppsOneGrid1.Selected
For item #2: The default property of the data card is ThisItem."Employee Submitting PTO"
If I changed this to Parent.Default I received an error
I changed the default in a data card to the following:
LookUp('Employee PTOs', ID = PowerAppsOneGrid1.Selected.ID).'Employee Submitting PTO'

But that gave me an error message indicating that the formula was incompatible for types of comparison.
Sundeep_Malik 6,480 on 09 Nov 2023 at 16:45:34

Like (0)

Report

Re: Data card values not populating

Hey @djohnson1223

There could be multiple issues and there are also multiple ways to fix them too.

Try the following:

1) Check Item property of the form. It should look like: GalleryName.Selected

2) In the default property of the data cards its written Parent.Default.

If still not coming then in the default of all the data cards write a similar formula:

Lookup(ListName, ID=YourRecord.ID).YourColumn

Or

Lookup(ListName, ID=GalleryName.Selected.ID).YourColumn

If above two dont work just write .Value at the end of the Lookup function.

Let me know if any of the methods dont work.

I hope this helps 🙂