Share
Report
6How do I return data from 1 sharepoint online list (SOL) column based on data in another column in that same SOL
The SOL is called OriginatingDepartment and has 3 columns and multiple rows
-1st column is the default title column and contains a dept name
-2nd column contains a mgr name
-3rd column contains a email address
None of the fields in the SOL will ever contain duplicate data
Data from the 1st column (dept name) is selected by the user via a dropdown field ('combo box') in a DataCardValue using the formula in Advanced>Items "Choices([@HardcatAssetManagement].OriginatingDepartment)"
-Note that the datasource for this field is different to the datasource for the 'Form' in which it is enclosed. Only advising incase this is relevant information.
**Requirement**
I need the data in the 2nd column (mgr name) "adjacent" to the 1st column (which contains their dept name) of the SOL to automatically display in another field in another card in the same form as read only.
**Example**
contents of SOL (I'll delimit the data using a comma for illustrative purposes)
1st column (holds dept name), 2nd column (holds mgr name), 3rd column (holds email address)
dept a, Mary Smith, mary_smith@xyz.com
dept b, Bob Rogers, bob_rogers@xyz.com
User selects 'dept a' in one field in the form
I want 'Mary Smith' to appear in another field of that same form as read-only
I have looked and tried various methods without any success.
Can someone help?
All responses (
Answers (
