Answered

choice column inside the form not updating when using different source item

(0) Share

Report

Posted on by nagestiada

504

I have two Sharepoint List and using edit form on the first list called SALES and have a dropdown (Choice column type) where the item is filtered and distinct from the PRODUCT list. I was able to show the items of my dropdown based from the product using lookup

Sort(
 Distinct(
 Filter(
 ETT,
 Category= "Car"
 ),
 Prod
 ),
 Result,
 Ascending
)

and the update property of my data card of the dropdown is DataCardValue47.Selected but its not updating on the sharepoint list

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 154,945 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @nagestiada ,

Try the Update of the Data Card

{Value: DataCardValue47.Selected.Result}

or if you want to keep your existing Update - the Items

Sort( RenameColumns( Distinct( Filter( ETT, Category= "Car" ), Prod ), "Result", "Value" ), Value )

Please click Accept as solution 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 giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
nagestiada 504 on at

Like (0)

Report
Copy link

Link copied!

Hello @WarrenBelz,

This is really helpful! Thank you very much!

Was this reply helpful? Yes No