How to get value of selected choice into SharePoint List

[smcraigo]

I have 3 columns in a SharePoint List that have the lookup type and pulling in data to populate comboboxes from another SharePoint list.  I am using a Power App to get the intake of data from the user and once the Power App is submitted, all fields are populating in the SharePoint List EXCEPT for these 3 columns.  I do have other dropdown boxes in the Power App that are not tied to a column with the lookup type and those values are populating in the SharePoint list.

How can I get the choice/value from these 3 columns to show up in the SharePoint List?  I need to write a condition off one of these columns and in troubleshooting why the condition wasn't working, led me to this discovery.

Thanks!

[v-bofeng-msft]

Hi @smcraigo ,

Could you please offer further elaboration? Perhaps including some formulas or screenshots would be helpful.

Best Regards,

Bof

[v-jefferni]

Hi @smcraigo ,

The trick of updating a selected SP list item into a SP list LookUp column is using LookUp function to get a record from the initial Items (Choices(SPlist.LookUpColumn)) according to the selected item.

LookUp(Choices(SPlist1.LookUpColumn1), Value = ComboBox1.Selected.List2ColumnName)

LookUp(Choices(SPlist1.LookUpColumn2), Value = ComboBox2.Selected.List2ColumnName)

...

Best regards,

[smcraigo]

@v-bofeng-msft - 

I'm wondering if its because the formulas have Distinct and/or Filter in them.  The formulas are as below:

This filters out the signed in person from the dropdown as they can't assign the task to themselves - 
Distinct
(Filter(Filter('SPList3', Not(Advisor in DataCardValue2_1.Text)),
Department = DataCardValue1.Selected.Value), Advisor
)

This filters the majors based on the department:

Distinct(Filter('SPList2', Department = DataCardValue1.Selected.Value), Major)

This filters the concentration based on the major:
Filter('SPList2', Major = DataCardValue4.Selected.Value)

For the Submit button we have this formula - which patches 3 different forms to the SPList1, as it is a lengthy form:
UpdateContext({locIsSubmit:false}); Patch('SPList1', Defaults('SPList1'), Form1.Updates, Form2.Updates, Form3.Updates); Navigate('Confirmation Page', ScreenTransition.None)

In the Power Automate, when the item is created, the SPList1 is populated with the data from the forms, which doesn't populate the above three fields in the list, but populates all the other fields from the forms.

Hope this helps.  Please let me know if you need any further information so I can get this project DONE!  Thank you!

[smcraigo]

@v-jefferni - Where do I put these lookup formulas that you provided?

[v-jefferni]

Hi @smcraigo ,

They need to put in Update property of Data Cards of corresponding fields.

Best regards,

[smcraigo]

@v-jefferni-

I'm getting an error message once I add this to my Update property - it's saying that name isn't valid.  Approver isn't recognized:

LookUp(Choices('Herbert Petition Requests'.'ApproverChoice'), Value = DataCardValue9.Selected.Approver)

For context, 'Herbert Petition Requests' is the SP list that I'm trying to write the value of the combobox to, 'Approver Choice' is the column in 'Herbert Petition Requests' and Approver is the column name in a different list, which is where data for the combobox (DataCardValue9) is pulling from.

I've even tried adding the name of the second SPList just before .Approver without any luck.

Thank you for any assistance that you can provide!

[v-jefferni]

Hi @smcraigo ,

What are the formulas in ApproverChoice Combo box and DataCardValue9? I didn't see the formula in your previous reply. What's the type of Approver column in the other list? Its name looks like a people column.

Best regards,