web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Expected table value
Power Apps
Answered

Expected table value

(0) ShareShare
ReportReport
Posted on by 82

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:
I have the same question (0)
  • WarrenBelz Profile Picture
    154,793 Most Valuable Professional on at

    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.

  • skd Profile Picture
    82 on at

    Hey @WarrenBelz ,

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

  • WarrenBelz Profile Picture
    154,793 Most Valuable Professional on at

    @sayalides ,

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

    Also is this a dropdown or a ComboBox?

  • Verified answer
    v-yutliu-msft Profile Picture
    Microsoft Employee on at

    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,

  • norashura Profile Picture
    141 on at

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 519 Most Valuable Professional

#2
11manish Profile Picture

11manish 489

#3
Haque Profile Picture

Haque 327

Last 30 days Overall leaderboard