Sharepoint Choice field in Gallery showing errors

(0) Share

Report

Posted on by DandBMike801

I am experiencing an issue when using SP lists as a source for my power apps, and especially dropdowns.

I have built many apps using the choice field in SP, and I would typically use these properties in my dropdowns:

Items: Choices(source).status.value and Default: Thisitem.Status.Value.

For the dropdowns, Items works fine, however Default or event text property is no longer working and it returns an error on all Choice fields.

The error displayed is "Name isn't valid. This identifier isn't recognized"

Int the apps I created in the past I do not experience this issue and I am able to add new input fields in those apps without seeing this problem.

Please advise if you are familiar with this problem and maybe know the solution

(I have a theory that it might be SP related, and either Power apps is not catching the data correct or the updated SP list can´t be read correctly

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

v-jefferni on at

Like (0)

Report
Hi @DandBMike801 ,

Please try below:

Items:

Choices(source.Status)

Default:

Thisitem.Status.Value

Am not sure why this happened because when I was testing from my end the Dropdown I added at the beginning did not work, after I used a Combo box instead, suddenly everything went fine. So if possible please consider use Combo box than Dropdown Control.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
MBC_DK 16 on at

Like (0)

Report

Hi @v-jefferni
Thank you for your reply.
I also considered using combo boxes, but I prefer dropdowns from a visual preference.
I made a workaround, so instead of Choices(source.Status.Value) which returns an error, I created the dropdown options like: Items: ["In Progress";"Not Started";"On Hold";"Migrated";"Remove"] and Default: ThisItem.Status. This works, but I stil do not understand which I can´t use the Choices(source.Status.Value) since the Status field is a choice column in Share point and for all other Apps I built I used the same method
I even tried to roll back Power Apps to an older version but this did not have an effect.

Was this reply helpful? Yes No
MBC_DK 16 on at

Like (0)

Report

@v-jefferni I also tried your suggestion Choices(source.Status) but this also returns an error

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report
Hi @MBC_DK ,

You missed a dot(.) between the data source list and the column, the syntax is:

Choices([@SPListName].Status)

I don't think Choices([@SPListName].Status.Value) could work in Power Apps Studio as I use above syntax for the Choices columns since long time ago. But your screenshot seems like it is Dataverse for Teams where fluent UI controls are used, this could make some differences and perhaps the performance of modern fluent UI controls and classic controls are now unified.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
MBC_DK 16 on at

Like (0)

Report

Hi @v-jefferni Sorry, the screenshot did not show the dot(.) but it is the same error
I am not using Dataverse fluent UI controls. I formatted the classic controls to look more nice 😊
The weird thing is that I built multiple apps using the same method and the same source type being Sharepoint lists, so I do not understand why it suddenly stopped working. I will dig into whether this is a SP related issue

Was this reply helpful? Yes No
soundharya 249 on at

Like (0)

Report

HI,
In items you need to set Choices('Issue tracker'.Priority)

In default you need to set this ThisItem.Priority.Value

Was this reply helpful? Yes No