Unanswered

Detail Screen/Edit Screen not showing all records from SQL (not writing back to SQL)

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am having a hard time figuring out why my data in detail screen goes blank whenever I enter in data and submit form (it would show data on the detail screen, but when I refresh the page, it disappears).

Another issue is that it's not writing back to SQL, but I can update SQL and it updates on the app. (Doesn't show data in the columns)

I did my best to match datacardvalues back to the correct datacard between edit screen and detail screen. I could be missing something and probable overlooked it.

*Note: DateModified is blank because I was testing which columns would update from SQL.

Any ideas would be much appreciated.

Thanks,

Jvang

After Entering DataAfter Refreshing PageData in SQL

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

What is the Item property of the forms you are working with?

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

Like (0)

Report
Copy link

Link copied!

@RandyHayes,

I have BrowseGallery1.Selected.

Thanks,

Jvang

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

Like (0)

Report
Copy link

Link copied!

@Anonymous

How are you selecting records in the BrowseGallery1 gallery? An icon or something else?

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

Like (0)

Report
Copy link

Link copied!

@RandyHayes,

I have an arrow icon

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

Like (0)

Report
Copy link

Link copied!

@RandyHayes,

The OnSelect: Navigate(DetailScreen,ScreenTransition.None, { Variable: ThisItem })

Thanks,

Jvang

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

Like (0)

Report
Copy link

Link copied!
@Anonymous

So if you are passing a context variable in your navigate. That should be the Item property of your Form.

Then in your OnSuccess action of the Form, set the formula to:

UpdateContext({Variable: Self.LastSubmit})

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

Like (0)

Report
Copy link

Link copied!

@RandyHayes,

I shows the data entered but doesn't show data within SQL and still isn't writing back to SQL.

Thanks,
Jvang

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

Like (0)

Report
Copy link

Link copied!

@Anonymous

So there is a lot of discovery needed for those statements!!

First, you say it is not writing to the SQL table.

Going to need to know then:

- What is the Datasource of your Form?

- What is the DefaultMode of your Form?

- How do you submit the form, and what is the formula you use to do so?

- Have you modified any Update properties of any datacards?

You say it is not showing any data:

- Are you referring to AFTER you submit a form?

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

Like (0)

Report
Copy link

Link copied!

@RandyHayes,

The DataSource is coming from SQL table Bincount
The DefaultMode on EditForm is edit
I use a save icon to submit form (submitform(editform))
I haven't modified any datacards in editform.
Data isn't showing when I open up the app, and after I submit the data.

Thanks,
Jvang

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

Like (0)

Report
Copy link

Link copied!

@Anonymous

Okay...then if you're in Edit mode, what is the Item property of the form? Is it Variable like we discussed before?

Was this reply helpful? Yes No