Detail screen not showing all records.

(0) Share

Report

Posted on by Community Power Pla...

Hello,

I am a bit confused on why my data isn't showing on the form. It has data on some and the other doesn't show data.

I have in both text property Parent.Default, but for some reason, only one shows data and the others don't have data.

Both coming from same data source

Any ideas?

Thanks,

Jvang

MS Ignite event.PNG

Categories:

Building Power Apps

I have the same question (0)

All responses (17)

Answers (2)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

What are you expecting to see? In other words, what is in the datasource for the record you are editing and the field you are looking at?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@RandyHayes,

It's not showing the data in some columns that I have in SQL.
I'm looking at the text field that should show the value of each column. I did try to enter in the datacardvalue that was associated with the same partnumber from the edit screen to the detail screen, but still doesn't show the values.

Thanks,

Jvang

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

Not sure I am understanding what you are showing. You have your form with the part number highlighted and then you are showing a run history for a PowerAutomate flow!?

In your original photo, you showed two data columns. Each was deriving the value from the Parent.Default. Which, unless altered, should be the underlying record value. So if TotalBinL is showing nothing, then it would be assumed that the TotalBinL value in the underlying record column has nothing.

Please check the record in your table and see what value you have for that column.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@RandyHayes,

Oh my apologies, meant to show my sql table.
TotalBinL does have records in it, as well as the other columns.

Thanks,

Jvang

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

Not really following you!

You mention that TotalBinL has "records in it as well as other columns"

What is TotalBinL then? It was assumed that this was a column in your datasource. Yet the picture of your SQL table shows nothing of the TotalBinL. You seem to be highlighting other column values, but those are for totally different columns...not a TotalBinL.

Trying to relate this to the other post we worked on...My impression there was that you were going to have a dropdown with all the bin names in and then have the visibility of the datacards in the form respond to which one was selected in the dropdown. I am not sure how TotalBinL or TotalBinLo comes into play (or where they even are!)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@RandyHayes,

It does have value in it. I just haven't figured out how to do the math right in sql for just counting the values for each cell if it has value. As for the TotalBinLo, I have it to where it sums the value of each row.
As for the highlight I was just giving an idea on what is the issue.
Sorry for the confusion.

Thanks,

Jvang

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

Okay, so if TotalBinL has a value in it and it is not showing in your control in the form, then what is the Default property on TotalBinL_DataCard2 (the datacard, not the value control)? What type of column is TotalBinL in your sql table?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@RandyHayes ,

The default properties of that card is ThisItem.totalbinl.
It is a narchar on sql. I will change it once I figure out how to add value for that column.

Thanks,

Jvang

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

Yes, I would suggest getting that column correct first. You will then need to remove the field from your form. Refresh your Datasource in the designer, and then add that field back to the form. Otherwise it will still think it is the type you have now.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Ok, I fixed the totalbinl column and removed the datacard field in the app then refreshed the database and added that field back in and still has isn't showing the value for that column or the others.

Thanks,

Jvang

Was this reply helpful? Yes No