Needing help (workaround) with Lookup Column value showing read-only on SharePoint Mobile

%3CLINGO-SUB%20id%3D%22lingo-sub-1538746%22%20slang%3D%22en-US%22%3ENeeding%20help%20(workaround)%20with%20Lookup%20Column%20value%20showing%20read-only%20on%20SharePoint%20Mobile%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1538746%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20am%20having%20issues%20with%20SharePoint%20Online%20Mobile%20App%20not%20showing%20the%20value%20of%20a%20Lookup%20field.%20Property%20managers%20are%20always%20out%20in%20the%20field%2C%20and%20they%20need%20property%20addresses%20to%20display%20on%20their%20mobile%20devices.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20created%20a%20Site%20Column%20that%20is%20a%20Lookup%20field%20to%20have%20a%20master%20list%20of%20properties%2C%20to%20keep%20one%20source%20of%20%22truth%22%2C%20so%20I%20only%20have%20to%20make%20changes%20to%20property%20additions%2Fsubtractions%20in%20one%20place%2C%20allowing%20the%20change%20to%20ripple%20throughout%20SharePoint.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20issue%20with%20this%2C%20is%20that%20I%20am%20running%20into%20issues%20with%20the%20mobile%20app%20showing%20%22Read%20Only%22%20for%20the%20property%20address%20on%20the%20mobile%20app.%20I%20do%20NOT%20want%20to%20have%20to%20update%20a%20dozen%20lists%20each%20time%20properties%20change%2C%20so%26nbsp%3B%20I%20am%20asking%20for%20some%20assistance%20on%20how%20to%20overcome%20this%20challenge.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20JSON%20can%20achieve%20this%20by%20taking%20the%20Lookup%20value%2C%20and%20applying%20it%20to%20a%20text%20field%2C%20but%20I%20do%20not%20know%20JSON%20to%20this%20point.%20It%20is%20also%20a%20little%20clunky%20to%20have%20to%20add%20so%20many%20additional%20fields%20when%20the%20data%20is%20already%20in%20the%20custom%20list%2C%20but%20not%20showing%20on%20the%20mobile%20app.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20have%20a%20workaround%20for%20this%20issue%3F%20Thank%20you%20in%20advance!%20This%20was%20my%20first%20post%20on%20this%20community%20thread.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20Regards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EChris%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1538746%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3El%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELookup%20Column%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Mobile%20App%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1539871%22%20slang%3D%22en-US%22%3ERe%3A%20Needing%20help%20(workaround)%20with%20Lookup%20Column%20value%20showing%20read-only%20on%20SharePoint%20Mobile%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1539871%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F736581%22%20target%3D%22_blank%22%3E%40cmoses0971%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20in%20a%20similar%20situation.%20I%20have%20a%20series%20of%20Sharepoint%20lists%20for%20sport%20coaches%20to%20fill%20in%20(match%20results%2C%20incident%20reports%20etc...)%20that%20reference%20the%20list%20of%20my%20Sport%20Managers%20(including%20phone%20numbers%2C%20emails%2C%20etc...).%20So%20much%20easier%20in%20the%20App%20to%20fill%20in.%3CBR%20%2F%3EWorks%20fine%20on%20Sharepoint%20lists%20but%20not%20on%20the%20Sharepoint%20App.%3CBR%20%2F%3EBeen%20searching%20all%20year.%20Closest%20I%20could%20find%20is%20%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fin-sharepoint-app-for-android-lookup-columns%2F9f47893d-dcfd-45e0-b72c-f11904c4b05a%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ethis%3C%2FA%3E%26nbsp%3Bbut%20it%20doesn't%20make%20sense%20to%20me.%3C%2FP%3E%3CP%3EI%20shall%20follow%20this%20topic.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello, 


I am having issues with SharePoint Online Mobile App not showing the value of a Lookup field. Property managers are always out in the field, and they need property addresses to display on their mobile devices. 

 

I created a Site Column that is a Lookup field to have a master list of properties, to keep one source of "truth", so I only have to make changes to property additions/subtractions in one place, allowing the change to ripple throughout SharePoint. 

 

The issue that I run into is the mobile app shows "Read Only" for the property address on the mobile app, and doesn't show the actual property address. I do NOT want to have to update a dozen lists each time properties change, so  I am asking for some assistance on how to overcome this challenge. 

 

I know JSON can achieve this by taking the Lookup value, and applying it to a text field, but I do not know JSON to this point. It is also a little clunky to have to add so many additional fields when the data is already in the custom list, but not showing on the mobile app. 

 

Does anyone have a workaround for this issue? Thank you in advance! This was my first post on this community thread.

 

Kind Regards,

 

Chris

2 Replies

@cmoses0971 

I'm in a similar situation. I have a series of Sharepoint lists for sport coaches to fill in (match results, incident reports etc...) that reference the list of my Sport Managers (including phone numbers, emails, etc...). So much easier in the App to fill in.
Works fine on Sharepoint lists but not on the Sharepoint App.
Been searching all year. Closest I could find is this but it doesn't make sense to me.

I shall follow this topic.

@Scott_Johnson Thanks for the interest in the post. I should have also stated that I am running Windows 10 on my laptop, and the Lookup Column displays correctly on this machine. It does NOT show the data on the iOS version of the SharePoint mobile app. 

 

I am finding this to be an unresolved/uncared about issue with SharePoint Lookup Columns, as I have read multiple threads related to this all the way back to 2017. Having to convert these Lookup columns to "Choice" columns creates so many issues. The simple task of adding new list items to a prominent list (this list just happens to be maintenance vendors who check out keys for properties) that is used in many different places in our SharePoint creates the potential to miss the update in certain columns, causing inconsistencies. 

 

I figured creating a Vendor Contact List to draw from could make this much easier, and every other list in SharePoint could draw from this Contact list via the Lookup column. What I am finding is the "Read Only" or "Null Value" on the mobile app related to Lookup columns not displaying the content makes them practically worthless on the app. The data shows fine in the desktop version, but not in the mobile app on iOS. 

 

If anyone knows how to rectify this, I would be very grateful... Thanks in advance!

 

Kind Regards,

 

Chris