How to filter SharePoint List for current user without using People or Group column?

Question

I have lost on SharePoint which contains transactions details like Transaction Id, Transaction date, Transactions Type, Transactions amount, Transaction Country, and Transaction Owner. When any transaction owner opens this list he should be able to transactions wherein he is owner. I don't want to user people or group column as due to some restrictions their name is not getting recognised on SharePoint while uploading list to SharePoint. I know using people or group column I can simply filter on [me]. Hence I was wondering if this can be achieve with Text column?

Answer 1

Dear Pravin Karne

Good day and a warm welcome to the Q&A forum!

Based on your information and after thorough research and testing, I regret to inform you that using a Text column in place of a People or Group column to filter items based on the current user is currently not feasible in SharePoint. I also explored the use of Calculated columns to achieve the desired outcome, but unfortunately, this method does not provide dynamic filtering based on the logged-in user.

I'm truly sorry we couldn’t achieve the desired result through these methods.

At this point, the most effective and reliable workaround would be to use Power Automate. With it, you can automatically capture and store the creator’s email in a text column at the time of item creation, which then can be used to configure a filtered view using JSON formatting or other logic.

However, in the Q&A forum, we are currently unable to determine the most precise solution for this specific case. For more advanced and tailored support, I highly recommend reaching out directly to Microsoft Power Platform Community Forum Thread. You can get more professional help; there will be very professional people to tell you about the steps on how to realize this function.    

We hope this information is helpful and sincerely appreciate your understanding. Please let us know if there’s anything further, we can do to support you

---

If this answer helped, please click “Accept Answer” and consider giving it an upvote. For follow-up questions, simply click “Comment.”

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.