Answered

dropdown Value pre populate in new form

(0) Share

Report

Posted on by Danny_Dicaprio

I have a dropdown in my new form where Iam trying to update DSI ,

Items Property : Choices([@Causes_TopRisks].Risk_name)

Default Selected Items  :

If(VarTopRiskCauses,LookUp(Choices(Causes_TopRisks.Risk_name), Value = VarTopITrisknames),Parent.Default)

VarTopRiskCauses is a variable which Iam passing to check whether it is true or not
VarTopITrisknames Iam already collecting the risk Name as Variable ( tested in a label property)

Risk_name is a lookup column in my SharePoint list

It is showing an error expected table value.

Could anyone please help me to fix this issue

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

v-mengmli-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Danny_Dicaprio ,

Please try this:

If(VarTopRiskCauses,[LookUp(Choices(Causes_TopRisks.Risk_name), Value = VarTopITrisknames)],Parent.Default)

Best regards,

Rimmon

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like
a
(0)

Report
Copy link

Link copied!

@v-mengmli-msft

Thanks for the response that worked perfectly fine

Could you please exlain why those [ ] fields bring table value in my formula

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Danny_Dicaprio ,

The error shows the field expects a table, but lookup function returns a record, so we need to use [ ] outside lookup function to convert record to table.

Best regards,

Rimmon

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @v-mengmli-msft

HI can you please look into one more issue I had with same

I am storing the impact value as variable first

ThisItem.Impact * 100 & "%"
Set(Varimpactpercentage,ThisItem.Impact)

I want to update these impact in another gallery ( different sharepoint list ) where I have a lookup column for the impact from the current list

so in the new form ,
I have updated the DSI as
If(VarTopRiskCauseControls,LookUp(Choices(Linked_Risks_Causes_Controls.Cause_x003a__x0020_Impact),Value =Varimpactpercentage),Parent.Default)
item property

could you please let me know how to fix this issue

Was this reply helpful? Yes No