Form Submission Issue: Lookup Columns Not Saving

(0) Share

Report

Posted on by MP-13021227-0

Hello, I'm building a new app that uses a form to collect data. Two of the fields in the form, 'stream' and 'GBS center', are lookup columns that get their values from separate SharePoint lists. When I submit the form, the data for these two lookup columns isn't being saved correctly. What could be causing this, and how can I fix it?

Form:

List:

Categories:

Error handling

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @MP-13021227-0,

Firstly to give you an accurate answer, I need to know the Items (in Text please) of those two Combo Boxes. I have to assume that you have changed these from the standard Choices(SPListName.FieldName). Also are they single or multiple selection ?

I will give you a start example using the DisplayFields of the Combo Box assuming the second one is Stream. The Update of the Data Card would be
{ Value: ComboBoxName.Selected.Stream, Id: LookUp( YourOtherSPList, YourLookedUpColumn = ComboBoxName.Selected.Stream ).ID }

I will also add that SharePoint Lookup columns are mostly unnecessary with Power Apps and have the potential to cause you unwanted and unneeded complexity and restrictions - I have never used them. It is generally a better idea to get the required field items directly from the second list with Power Apps and write back to a Text column.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
MP-13021227-0 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @WarrenBelz,

Stream is connected to GBS Center, here is the display field, items and Update of the two

GBS Center: Display field: ["Value"] Items: Choices([@'CI List'].'GBSCenter') Update of the data card: DataCardValue46.Selected Stream Display field: ["Value"] Items: Filter(Choices([@'CI List'].'Stream') As strm, LookUp('CI Approvers', ID = strm.Id).Location.Id = DataCardValue46.Selected.Id) Update of the data card: DataCardValue47.Selected

i have a discovery in the sharepoint list lookup column in sharepoint list gbs center and stream column data appears in classic view but when i exit the classic view it is blank

Modern view:

Classic view:

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @MP-13021227-0,

As I mentioned before, Lookup columns cause nothing but unnecessary complication, but anyway back to your problem.

I assume from all of this that the Choices in both Combo Boxes are looking up the 'CI Approvers' List ? Firstly, DataCardValue46 should update with the settings you have posted, so not sure presently what the issue may be there, but I will deal firstly with DataCardValue47. To hopefully uncomplicate this a bit, if you want DataCardValue47 to show the list of values matching the Location field in 'CI Approvers' chosen by DataCardValue46, then make the Items of DataCardValue47
Filter( 'CI Approvers', Location = DataCardValue46.Selected.Value )

and display whatever field you are using for your lookup value from this list. Then the Update of the Data Card can be
{ Value: DataCardValue47.Selected.Value, ID: DataCardValue47.Selected.ID }

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MP-13021227-0,

A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No