Unable to pull SP ID Coloumn unti PowerApps Combo Field

[Deano12]

Hi there all - Hope everyone is ok.

I'm new to PowerApps but trying to pick it up as quick as possible.

In the app I'm creating, I'm using a Sharepoint list as the data source and destination of data writeback when submission is made form the app.

However as part of that process, for every entry that is submitted via the app to the SP List, I use the SP ID column as the entry's unique reference.

There is a process we have by which users should be able to submit amendments to the entry's made previously, but without changing any of the data deposited in the first submission. The way I've got around this is by having a combo box field that is visible depending on the selected option in field 1 (New Submission or Amendment). If the user picks amendment, an additional field called 'Amended Reference Number' appears.

This is where my issues begin - 

The selectable options in the Amendment Reference Number Combo Box field, I want to automatically reference back to the ID column in SP. This is so that the user can select their previous submission ID. Then anyone reviewing the data for audit or any other purpose would know that the entry made was an amendment to previous entry ID#65. Once the user clicks submit, although the Amended Reference Field in the PowerApp is displaying the ID column entries, it writes that data back the submit form data for that field to the SP column of Amended Reference # not the ID column in SP.

Is anyone able to help me with the right coding to use here as fr the life of me I can't find the answer... And I've sat through a number of Shane Young's videos on YouTube (They are great) but have not been able to find an answer.

Thanks

Dean

[Anonymous]

Yes, you are correct. I just tried it and I could submitForm the ID to both a text and number column. It's not that then.

So, when "Amendment" is selected the "Amending previous entries" field is shown. Do users then select the referencing ID from a Dropdown list? If so, how do you get that ID? Can you share some code and a screen shot with the dropdown selected?

[Deano12]

That is a very good question - and in my time messing with the code to try and get it to work, I've now changed things to such a degree, I can no longer remember the code that I got it to work with.

I won't give up, but I may have to 'Start again' just to get some working code to play with 😞

[Anonymous]

@Deano12 if I may, could I suggest a different way that your App could flow which may make things easier?

Assuming that the 'Type of Entry' is only 2 options why not lock this down like this:

For New Entries

- Set the DisplayMode of the 'Type of Entry' datacard to either View or Disabled so it can't be changed.

  note: you may need to change the dropdown back to a label, just playing around to get it to work

- Set the default property of the datacard If( varTypeOfEntry = "New", "New Entry", "Amendment")

- On the Submit New Entry button add the code: Set(varTypeOfEntry, "New")

This should sort New Entries

For Amendment entries:

- I assume this it the current flow: Historical Entries --> Previous Entries --> DOB Entry --> END?

- If so, on your DOB Entry screen, add a button called "Amendment to Previous" [or something that makes sense for your project]

- in the OnSelect of this button add the code: 

Set(varTypeOfEntry, "Amendment"); Set(varPreviousID, Gallery.Selected.ID); Navigate('Dob Data Entry',ScreenTransition.Cover)

- set the default value of 'Amending Previous Entry Number' to: If(varTypeOfEntry = "Amendment", varPreviousID, Blank() )

- Set the DisplayMode of the 'Amending Previous Entry Number' datacard to either View or Disabled so it can't be changed.

So what all the above will do is 

- if a New Entry is required, 'New Entry' will be set (no need for dropdown selection) in the 'Type of Entry' field. The rest of the process stays the same.

- is an Amendment Entry is required, 'Amendment' will be set (no need for dropdown selection) in the 'Type of Entry' field and the previous related ID will be set (no need to enter it) in the 'Amending Previous Entry Number' field. The rest of the process stays the same.

Let me know if I'm on the right track. If there are more than 2 options (ie New Entry & Amendment) then you can always extend your If() statements to fits.

Hope this helps!