I am going to preface this by saying I am brand new to PowerApps, but I am attempting to learn about it.
I am currently trying to create an app that will allow the End User to Log samples in to allow external personal to keep track that a sample was dropped off and when it was dropped off. Currently using Paper and pen, and no one records times. Plus, others can't see that it was dropped off and have to rely on someone to see a message request asking if it was dropped off.
With that being said, we have a Dashboard that has the different jobs that the sample could be for. There is one column that concatenates 4 other columns and creates a unique identifier to the list. Each of the data strings is separated by a forward slash(/). This column is called LabJobName in SharePoint List 1 (SPL1) located in location 1. I am able to bring that into the PowerApp with no issues and select it in a Combo Drop Down with Search functionality. I would like to either use PowerApps to un-concatenate(split) this OR use it as a lookup to find the information in SPL1 to pull into the PowerApp for the ultimate goal of gathering all information needed to go into SharePoint List 3 (SPL3). I would like to use the 2nd, 3rd, and 4th data values from the LabJobName concatenated data point (LJ2, LJ3, LJ4).
I currently have my PowerApp set up to have the End User input the following after selecting which 1 of 3 Types of Samples it could be:
Select a concatenated identifier from a ComboBox labeled JobDataCB.
Select their name from a searchable ComboBox (this draws its list from SharePoint List 2) labeled EENameCB.
Select a SubType of Sample from a DropDown box with data points inserted into 'Items=' labeled CemSysCB.
Input an integer to indicate how many of that sample was dropped off into a text box labeled SampleQtyTI.
And I would like the date and time to be automatically added once End User clicks the Submit Button. And then all of this data goes onto SPL3, with the following columns and data points going to each place (Column Name: Column Formatting: Data Point) (column names pulled from the URL in List Settings).
Title: Single Line of Text: Sample Type
Client: Single Line of Text: LJ2
WellName: Single Line of Text: LJ3
JobType: Single Line of Text: LJ4
CementSystem: Single Line of Text: CemSysCB
SampleQuantity: Number: SampleQtyTI
EEName: Single Line of Text: EENameCB
Date --> Don't have a set column for this yet as I am unsure how to appropriately format it.
In all my comboboxes and dropdowns, only one data point is allowed to be selected.
From my limited understanding with all of the searching that I have done, I understand that I have to Patch the data together to get it from the PowerApp to the SharePoint List, but in my attempts at basic syntax with this, I have failed to do so. Some of the errors cite that I have the data format incorrect and do not match the intended format.
Any and all help is appreciated, I have been trying for weeks and have gotten the runaround with the examples currently available on the internet.