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?
