web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Lookup data with uniqu...
Power Apps
Answered

Lookup data with unique identifier from one Sharepoint List and un-catenate the data to then input into a log SP List with other data input

(0) ShareShare
ReportReport
Posted on by 2

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.

Categories:
  • v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @j007conks ,

     

    First of all, you mentioned that there is a Combo box with SP list data for users to select the concatenated LabJobName, if this Combo box has its Items with exact the SPL1, then it also means you can get each column value in the same record of the selected value. Combobox.Selected will be a RECORD from the Items table, and you can designate a specific column value using the dot (.) after it. For example, you can use a Label, set Text to Combobox.Selected.ColumnName and see the result. The concatenated column can just be used as the unique identifier for users to understand and select in the Combo box. There is no need to use Split function to get individual value based on the selected LabJobName.

     

    Secondly, with the selected Combo box, you can easily use other column values and submit to SPL3 with a Patch function. Let's say there are Client, Name and Job columns in SPL1:

    Patch(
     SPL3,
     Defaults(SPL3),
     {
     Title: Sample Type,
     Client: LabJobName.Selected.Client,
     WellName: : LabJobName.Selected.Name,
     JobType: LabJobName.Selected.Job,
     CementSystem: CemSysCB.Selected.SubType,
     SampleQuantity: Value(SampleQtyTI.Text),
     EEName: Single Line of Text: EENameCB,
     Date:Today() //or Now()
     }
    )

     

    Best regards,

     

     

  • CU22010135-0 Profile Picture
    2 on at

    Thank you very much in reading what I wrote and providing some insight. I thought that I might have been able to just use the unique identifier as finding the other data in the table and I couldn't do it. In fact, I tried what you stated to do with the Label and the text set to 'JobDataCB.Selected.Customer' and I get an error. Following the text as I type it into the Text= I get the following:

    JobDataCB --> Name of the ComboBox on the PA. Data Type: Control

    .Selected --> Data Type: Record

    .Customer --> The name of the column on SPL1 from the URL

    Now if I change .Customer to .LabJobName, I do get the exact text that I chose in the ComboBox. I don't know if it is just looking at the combobox and regurgitating it, or if it is trying to access the SPL1. I have SPL1 tied and refreshed under the Data tab in PowerApps.

     

    I followed the formatting that you put in the post and have the following screen grab showing a error for that code. Reason I didn't copy and paste the code that you put is that you mention is the ComboBox is labeled JobDataCB and I assumed that this is what is needed to be searched up, and when I put 'JobName.Selected.xxxxx' the line was an error.

    The 'Cement System' is a ComboBox with Items inserted in the Items property using ["Item1","Item2","Item3",etc]

     

     

    image.png

  • Verified answer
    v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @j007conks ,

     

    Combobox.Selected.Column will also basis off the list column types. If the Customer column within SPL1 is a Person column, then you need to add an additional sub column name to retrieve the data:

    JobDataCB.Selected.Customer.DisplayName

     

    For the same reason, if JobType column is a Choices column, then it will be

    JobDataCB.Selected.JobType.Value

     

    Best regards,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 236 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 207 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 169

Last 30 days Overall leaderboard