You’re offline. This is a read only version of the page.
So I hate to even ask because this has come up multiple times here obviously.
Little pat on the back for me since I did a diligent search and tried posted solutions.
But they didn't work.
I have a gallery of tickets on a dashboard page. Clicking an item navigates to a details page where values can be changed. In addition to updating the actual Tickets datasource, I also write activity logs to a related table.
When the user Saves on the detail page, everything writes successfully to both Tickets and ActEntry tables. I can see the data land immediately upon save. The app navigates the user back to the Dashboard at Save on Details page. In that save, I added a Refresh(ActEntry) which didn't solve the problem. After landing back on the Dashboard, if you click the Ticket you just modified, the details page loads with all of the correct data from the Tickets table. But, the ActEntry gallery doesn't show the most recent values.
So then I thought I'd move the refresh closer to the view. So when the item is clicked in the Tickets gallery, the very first command in OnSelect is Refresh(ActEntry).
Still no go. I'm stumped.
ps. I'm using an Excel file as the data store. Is that my pain?
Yes I've considered it. I almost did it last week and may still yet.
In theory, it should be really simple to copy the data into SP and then connect but I also know theory often runs into reality during implementation. LOL
And yes, the gallery is pointing directly and not to a collection in between.
Thanks Warren.
Hi @DCHammer ,
Short answer with Excel - probably yes - it is a terrible data source - have you considered a SharePoint List ?
Also is the Gallery "pointing" directly at the data table in Excel ?
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
Share
Report
All responses (
Answers (
