Answered

Choice field just show me items, not my choices that i did in my sharepoint

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi!

I need your support;

when I link my sharepoint in Forms--Edit, it show me all my columns that I created before, but when I select the dropdown field where I have to choice an option, it didn't appear, just appear as "item 1, item 2...etc"

culd somebody tell me why? I attach an evidence and my sharepoint,

btw, I tried to go to seeting in my sharepoint and but choose option and I put the options, so, when I link again the sharepoint in the dropdown field it didn't appear anything 😓

help 😞

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (3)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Anonymous

This is a current bug in the latest release! Please first put in a support ticket on this so that they have more information in order to resolve it.

Next, you should be able to correct the issue by going to the Items property of your Combobox and selecting the entire formula there, then removing it (ctrl-x), and then putting it back (ctrl-z).

This will cause the control to re-initialize and should resolve the problem you are seeing. But not the issue that caused it...for that, again, please put in a ticket for it to be fixed.

I hope this is helpful for you.

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!

@Anonymous

Choices(yoursplist.yourchoicecolumn).Value as the Items property of your control

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Drrickryp

You should not have to do that to a field added to the form! That is the point...there is currently a bug in the latest release. It needs to be reported and fixed as much as possible.

The only thing that adding a .Value to the formula does is cause the formula to re-evaluate, and it will appear as if it is fixed, but now you have changed the schema of the combobox and the Update property of the datacard will fail to update the underlying record properly (because it is no longer a record...it is now just text).

Removing the existing formula and putting it back in will cause the same re-evaluation, but will keep the schema as needed.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi!
how can I put a ticket?

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

At the top of this forum web page is a Support menu. In there, selecting Overview will take you to a general overview of support options. At the bottom is a link to open a support ticket.

The above is for your FYI. The link is this link.

Also, in regard to your chosen solution - just keep in mind that the only thing you needed to do was wipe out and re-enter the formula in the Items. You chose one that will change the schema of your combobox and will impact the operation of your form negatively. If you are okay with those problems to come, then go with what you have, otherwise you will want to make the change back to maintain the schema.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes

Thanks for the explanation. I had no idea why it worked, just an empirical observation that it did after I experimented a bit.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!

@Drrickryp

Yeah, the trick is just to get the control to re-initialize its Items. Wiping the formula and putting it back will normally do that. Sometimes it is more extreme (not in this case though) and you have to give it a whole other table (like ComboboxSample) and then put the original back.

But, the main point with the recommended change was, Choices(source.column) will return a proper record based on the underlying column - if a Choice column, then the record will be a record with a single column called Value. If a Lookup, then a record with a Value and Id column. But, they are both records. By adding the .Value, it restricts it to only a Value column. This will not be consistent for the Update property to work as it will usually default to: theCombobox.Selected and Selected will be a record...if that is altered, then it could be the wrong record going to the datasource during submit.

All of this because of a new bug for something that was obviously not tested properly prior to release! Have you ever seen that before with PowerApps?? 🤔🙄😫

Was this reply helpful? Yes No