cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cmanning
Helper III
Helper III

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
Helper III
Helper III

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
Helper III
Helper III

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

cmanning
Helper III
Helper III

Any recommendations are appreciated. 

cmanning
Helper III
Helper III

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 Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (1,650)