Unanswered

Expected table value

(0) Share

Report

Posted on by skd

Hello Team,

I have a made repeating table in a gallery which consists of a dropdown. I'm using Microsoft Dynamics 365 Finance as my backend. I have a table in dynamics 365 finance with a field called Job which is a lookup field. I want this field as a dropdown in my PowerApps. When I inserted a dropdown and gave the value as 'ThisItem.Job' , the dropdown is blank and it gives and error: 'Expected Table value', Please help me resolve this issue as I want all the jobs from my backend in the dropdown.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

WarrenBelz 153,026 Most Valuable Professional on at

Like (6)

Report
HI @sayalides ,

Try

{Value:ThisItem.Job.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.

Was this reply helpful? Yes No
skd 82 on at

Like (0)

Report

Hey @WarrenBelz ,
I tried this, it is giving the same error: "Expected Table value".

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

@sayalides ,

Where are you putting your code, the Items or Default?

Also is this a dropdown or a ComboBox?

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft on at

Like (1)

Report
Hi @sayalides ,

Do you want to insert a drop down inside a gallery and display lookup field in this drop down?

If so, please notice two points:
fill in a table in drop down's Items property

fill in a value in drop down's Default property

You could set like this:

Items:

Choices(entityname.Job).Name

Default:

ThisItem.Job.Name

You need to use this formula to update this field:

LookUp(relatedenetityname,Name=Dropdownname.Selected.Name

Actually, I more suggest you use combo box to display and edit lookup field, which will be more simple.

You could set combo box like this:
1)Items:

Choices(entityname.Job)

2)DefaultSelectedItems:

ThisItem.Job

You need to use this formula to update this field:

comboboxname.Selected

Best regards,

Was this reply helpful? Yes No
norashura 141 on at

Like (0)

Report

hey @v-yutliu-msft
i have a question about variable name, what do we replace entityname with?

Was this reply helpful? Yes No