cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cmanning
Super User
Super User

Selected Gallery Item Populating a Form But Dropdown Menu Has an Error and Not Populated

I have a canvas app a Dataverse table that has a "RequestStatus" Choice column (with a single select option set) populating a dropdown menu.  There is a gallery on the left side and a form on the right side with the form displaying the data from the gallery's selected item.  All the form fields should be populated and I have the text fields populating as expected from the gallery selected item, but the "RequestStatus" dropdown menu is throwing an error and therefore is not populating the dropdown.  The form's DataSource property include the name of the Dataverse table. 

This first image shows the Default property for the Request Status DataCard and there is an error.   It looks like I just don't know the correct formula. Any recommendations?
DI App - ThisItem Choices DataCard DEFAULT.png
This image below shows the Items property for the data card's dropdown control and there is no issue there but is included for reference. 
DI App - ThisItem Choices DataCardValue ITEMS.png

1 ACCEPTED SOLUTION

Accepted Solutions
cmanning
Super User
Super User

The only way I was able to get rid of the errors was to remove the form controls that had issues and add them back.  This solved all my issues. 

View solution in original post

7 REPLIES 7
Prakash4691
Super User
Super User

@cmanning ,

Hover over the red line. It will give you the error message/description or find error through app checker.

If the error is "Name is not valid. The identifier is not recognized", field/column name might be different. 

 

Check if any changes done to the column recently. If so, refresh the datasource and find your column name through intellisense like after (ThisItem.)

 

If it answers your question, kindly give kudo and accept it as solution.

 

Regards,

Prakash

@Prakash4691 - Thank you for your response.  I typed "ThisItem." and then intellisense found "RequestStatus". However, after selecting "RequestStatus", it immediately threw an error (see below).  There have been no changes to any of the columns but I am in the process of updating all formulas after converting from using a SP list as a data source to using Dataverse.  Everything worked with SP list, now I am fixing all the errors after replacing SP list with Dataverse. 
DI App - RequestStatus ERR OptionSetValue values.png

@cmanning ,

As per the error screenshot, it expects the column to be lookup but in dataverse it has created as optionset. In SP is that column created as lookup which points to another table?

 

 

Regards,

Prakash

@Prakash4691 - In SP the column was a simple choice column, not a lookup column.  I still can't figure out how to populate the form's DataCard value for "RequestStatus".  

cmanning
Super User
Super User

Anyone know how to reference a form's DataCard value from a selected gallery?  

cmanning
Super User
Super User

Any recommendations are appreciated. 

cmanning
Super User
Super User

The only way I was able to get rid of the errors was to remove the form controls that had issues and add them back.  This solved all my issues. 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (2,611)