I am using a REST Data connection in my InfoPath form to query a SharePoint List. I have a Person Type Column in my list and when I try to query $filter on this column, i amreceiving an error. Examining the XML from page source, I noticed that this column was renamed with suffix of Id and is of type Int32.
Must be something what sharepoint is doing in the backend, how do I query this column by Name?
I just need Name from this column and I am not sure how to use the int value returned by the REST query.
I can make that column text and have users type in the Full Name but that solutionis prone for errors.