I have a library of training courses in SPOnline, but I want a column to state whether the current user has completed a course or not.
Obviously this changes depending on which user is viewing the data.
I realise this can be done in the powerapp form, but cannot be done in the list itself- ie, a column shows "completed" or not?
Edit: I think this might be possible using column json formatting, looking up the username, along with the file ID & version from another list, returning either the date or "null" (which would change the content to a "complete now" button/link which would add the data to the other list - likely via a flow. No idea how to fo the json part though. Any help appreciated.