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?
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.
Solved! Go to Solution.
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.
@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.
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?
@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".
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
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.