Hi all, I'm having a go at building my first app so very much a noobie but got most of it working pretty nicely. However I've reached a stumbling block that I'm struggling to get past. Any help would be massively appreciated and let me know if I need to provide any additional info.
There is one data card as part of a new submission form where the corresponding column in the SharePoint location (NewTrack) is a lookup to another list (Media Controls).
As you can see below when I add the field 'Media: SLA' into the form without changing any settings the data card value box isn't visible, by default the items option on the datacard is set as 'Choices([@NewTrack].Media_x003a__x0020_SLA)'. This needs to change automatically depending on the option selected within the 'Media' dropdown
Submission form in the app:
SharePoint location data source called 'NewTrack' where the form is created from and data will be submitted to ('Media: SLA' column is required but hidden).
Separate data location called 'Media Controls'. The 'Media: SLA' needs to pull the number value from the SLA column below depending on the selected option in the 'Media' dropdown within the app. The 'Media' dropdown options are the same as the values in the title column.
