Our SharePoint tenant is host to multiple Client sites, all of which are structured more or less the same and with access to each Client site given to ourselves and the respective client. Each site also contains a Document Library named Jobs, with a column named 'Job Description', as well as a few others, and whenever a Client has a job come in they're to create a folder in the 'Jobs' library, and detail the specifics in the columns.
As a means of making sure this is being done I've been looking into using the Highlighted Content Web Part so as to bring in all the new Jobs that are being created all over our tenant - I currently have it set to a List view, and for the most part this works and I can see Title, Modified, and Modified By details of each list item being created or edited, however ideally I'd like to get the 'Job Description' column from the folders into here as well? I know you can create a column in highlighted content through JSON, but I wasn't sure if this would also pull in the the actual text in the column as well, or if I'd have to use CAML or something else to do that. Is this at all do-able, and if so how?
Any help would be appreciated - Thank you!