Unanswered

Lookup dropdown doesn't update in SP List on form submit when selection is limited by condition

(0) Share

Report

Posted on by issac_franklin

113

I have a Canvas app in Powerapp, which has DataSource A where it writes the data. Here I have a Lookup column (CostCenter) which fetches data from DataSource B.

In the PowerApp form,

I have a dropdown1 which has three options, (1,2,3) and Dropdown2 which is a lookup column in DataSource A.

I tried to set condition, when dropdown1 is selected as "1", Dropdown2, should automatically fill a option available in the lookup field. Filling works with switch function, however at the backend when the form is submitted, the value of DropDown2 is not patched in DataSource A.

But, if I do not automatically set the values or limit the options in Dropdown2 based on Dropdown1 selection, when user manually selects the value in Dropdown2, it gets updated in SharePoint List.

Can you help me to achieve this ?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

RogierE 879 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

In my experience, lookup columns don’t integrate well with PowerApps.
better to keep your column in DataSource A a simple text column and then perform the lookup in your App.
so in your case I would add a Drop-down field to your App that gets its Items in DataSource B and saves the selected value in the simple text column in DataSource A

Was this reply helpful? Yes No
issac_franklin 113 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @RogierE

Thank you for the suggestion.

I have a different lookup column which works very well, however the selection is manual here.

I tried following your suggestion to create a drop down field and have the source as DataSource B. It works well except a minor thing (This dropdown doesn't scroll along with the form that I have). Do you have any thoughts here ?

Was this reply helpful? Yes No
RogierE 879 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Could you share a screen shot? I’m not sure I understand “doesn’t scroll along” part. 🤓

Was this reply helpful? Yes No
issac_franklin 113 on at

Like
a
(0)

Report
Copy link

Link copied!

@RogierE I managed to fix the scrolling part.

However, still I couldn't get this working as expected.

Now I have below formula on OnSelect of the button

"SubmitForm(OrderForm);"

And In onSuccess of the form, I have the below formula. But it just creates the new row in list but doesn't patch the value of dropdown to the text field

Patch(
Listname,
OrderForm.LastSubmit,
Defaults(Listname),
{
CostCenter1:Dropdown.Selected.Value
}
);

Was this reply helpful? Yes No