Data from Details Screen not loading to Edit Screens

(0) Share

Report

Posted on by ACPBSCi

222

Hi. I can't seem to find the exact answer to what I'm looking for.

I have an app that works fine except when I try to edit an existing record via the Detail screen. On the Browse screen, I set my varRecord variable to this: Set(varRecord,ThisItem);Navigate(DetailScreen1, ScreenTransition.Cover). The pencil icon on the Detail screen has this code: LookUp('SharePoint List', ID=Value(varRecord.ID));Navigate(EditScreen1, ScreenTransition.Cover). This code works because when I select varRecord and click the dropdown, I see all the data stored in the variable. However, when I transition to the Edit screen, the data doesn't load.

The OnVisible of my Edit screens is set to varRecord. I don't have forms on each screen because I'm pulling data from an Excel spreadsheet, so each datacard stands alone. The patch populates my SharePoint list correctly. However, it would be nice for the users to go back into an existing record via the app to make changes. How do I get my record to populate?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@ACPBSCi

Use the same formula in the detail form for the Item property of the edit form and take off the varRecord on the OnVisible property of the edit screen.

Was this reply helpful? Yes No
Verified answer

ACPBSCi 222 on at

Like
a
(0)

Report
Copy link

Link copied!

That won't work because I don't have forms. I have a bunch of individual data cards pulling data from an Excel spreadsheet with this code: Sort(Distinct(Filter(Table3,'Account #' = ComboBox1_10.Selected.Result),'RM Name').Result,Ascending). So when I try to go from the Detail screen to the Edit screen, I need the existing record to populate each data card.

I'm not sure this is an easy fix. I might wimp out and just have them use the OOTB SharePoint form for edits.

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@ACPBSCi

I wouldn't say that was wimping out. Excel sucks as a data source for PowerApps. SharePoint is far better but has limitations too. The best is Dataverse but that is a premium and if cost is a factor, your best bet would be SharePoint. If you are set on using Excel, the best approach is to let PowerApps create an app from your data and using a gallery and two screens (detail and edit) to handle your data. IMHO, you have chosen the most difficult and effort intensive way to proceed by trying to create custom forms from scratch.

Was this reply helpful? Yes No
ACPBSCi 222 on at

Like
a
(0)

Report
Copy link

Link copied!

Excel is our temporary data source until we are able to connect to a dynamic source of truth, such as SalesForce or SAP. But, we have hoops to jump through first. In the meantime, we kludge together a solution. Looking back, I would have rebuilt the whole thing from scratch, but we retooled an existing app that used SharePoint as a data source.

Live and learn.

Was this reply helpful? Yes No