web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Saving lookup forms va...

Power Apps

Unanswered

Saving lookup forms value to list

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hello!

I am having issues saving my cascading dropdown to my sharepoint list.

I have list A which I am trying to save the selected dropdown 2

List B which has my lookup (to have cascading dropdowns)

The formula I am using is the following:

Distinct(Filter('ListB',ColumnA= DataCardValue.Selected.Value),ColumnB)

Column B shows a cascading dropdown depending on column a selected value, but when saving the form, the values are not showing up on my sharepoint list

THANK YOU!

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ，

Do you want to use a drop down control to update a lookup field?

Could you tell me

1)you set this formula in what control's what property? Distinct(Filter('ListB',ColumnA= DataCardValue.Selected.Value),ColumnB)?

2)ColumnA and column B is in which list?

3)what is columnA and column B data type?

4)what is DataCardValue?

Based on your description, I haven't figured out the relationship between listA and listB.

If you could show me screenshoots , it will be better.

What's more, usually we use this to update lookup field:

(set the datacard's Update)

{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id:LookUp(Choices(listA.lookupfield),Value=drop down.Selected.Result,ID), Value:drop down.Selected.Result }

Best regards,
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

thank you @v-yutliu-msft for your answer!
Tried using your tip for the update field but couldnt get it to work, due to the urgency I opted for infopath forms which was a lot easier

thanks again!

Join the conversation