User specific data in sharepoint online

%3CLINGO-SUB%20id%3D%22lingo-sub-3202629%22%20slang%3D%22en-US%22%3EUser%20specific%20data%20in%20sharepoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3202629%22%20slang%3D%22en-US%22%3EI%20have%20a%20library%20of%20training%20courses%20in%20SPOnline%2C%20but%20I%20want%20a%20column%20to%20state%20whether%20the%20current%20user%20has%20completed%20a%20course%20or%20not.%3CBR%20%2F%3EObviously%20this%20changes%20depending%20on%20which%20user%20is%20viewing%20the%20data.%3CBR%20%2F%3EI%20realise%20this%20can%20be%20done%20in%20the%20powerapp%20form%2C%20but%20cannot%20be%20done%20in%20the%20list%20itself-%20ie%2C%20a%20column%20shows%20%22completed%22%20or%20not%3F%3CBR%20%2F%3EEdit%3A%20I%20think%20this%20might%20be%20possible%20using%20column%20json%20formatting%2C%20looking%20up%20the%20username%2C%20along%20with%20the%20file%20ID%20%26amp%3Bamp%3B%20version%20from%20another%20list%2C%20returning%20either%20the%20date%20or%20%22null%22%20(which%20would%20change%20the%20content%20to%20a%20%22complete%20now%22%20button%2Flink%20which%20would%20add%20the%20data%20to%20the%20other%20list%20-%20likely%20via%20a%20flow.%20No%20idea%20how%20to%20fo%20the%20json%20part%20though.%20Any%20help%20appreciated.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3202629%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor
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.
0 Replies