You’re offline. This is a read only version of the page.
697
Quick background for context:
Users currently use a spreadsheet to track 'things'. It doesn't really matter what they are.
As they do this, individual records are in rows and one of the columns contains notes that they simply edit continuously.
When I built them a PowerApp, I separated the notes into their own list so they could be individually managed like replies to a post with the second list being related to the first through the ID column.
Now, the app does everything we want it to do and they could hardly be happier with all of us here. They don't know any of you of course but none of what I've done would be possible without this site and ChatGPT. 😄
So the only outstanding ask is a little report view. They are accustomed to simply filtering the spreadsheet itself essentially as a report.
I was simply going to build a SP view that mimicked the original spreadsheet but since I normalized the notes, you can't build a view across two lists. At least I couldn't find a way using Google.
So, what's the best way to do this?
Can I use the Datatable function as limited as it currently is? Or should I build another gallery?
Hey @DCHammer,
Are you trying to create a gallery that shows the row item and all the notes alongside it?
If so, you could add a label in the gallery and use the Concat() function to concatenate all the notes in the 2nd list related to the ID column of the current item.
Ok, so like often, people reading my posts get to watch me figure out stuff on my own and then eventually weigh in when I get to a technical point worth addressing.
So, it would appear the answer is to use a Table (named seems to have recently changed from DataTable) and use Collect to populate it.
Should I put the Collect function in the OnStart property? It seems unnecessary to load that data into memory and then worry about updating the collection as the source changes prior to a user actually loading the portion of the page that contains the table. Or do I not have a choice?
The end solution seems to be a Collection built using the AddColumns function. Although it might get ugly.
I've realized an alternative solution is two adjacent galleries very similar to the way I've built the entry and edit form which shows the static 'ticket' data in the left gallery and the 'notes' in the right gallery just formatted much tighter in a table format. This solution may actually be the easiest if I can get the end users to agree.
Flies off and dons salesperson persona...
Further research on my part has eliminated the choice of using SharePoint Designer to accomplish this within SP itself which is unfortunate. That would appear to have been the easiest solution to my requirement but our IS/IT department has not enabled it and I already know what the answer will be if I ask.
Share
Report
All responses (
Answers (
