Unanswered

The property on this control expects Table values. The rule produces Text values which are incompatible.

(0) Share

Report

Posted on by raizanicolem

Is there a work-around for this? I have 2 comboboxes: Month (Items: January, February, etc.) and Year (Items: the previous 2 years, this year, and the next two years). My sharepoint columns of them are of text datatype. When I want to display those data from the sharepoint list in a gallery and still in comboboxes since my client wants them to still get edited and patch, ThisItem.Year and ThisItem.Month gets the error below. I don't really want to change the combo boxes into text inputs since I already made big progress unless there is no other way.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

TheRobRush 11,128 Moderator on at

Like (0)

Report
EDIT** Didn't notice you already had the items set, see AJs solution below

set the items of the two controls to something like ["January", "February", "March", Etc....] &

ForAll(Sequence(50,-25,1) As DateRange, Value(Year(Now())+DateRange.Value))

then set their default selected to reference your existing columns

Was this reply helpful? Yes No
Verified answer

developerAJ 4,628 on at

Like (2)

Report

@raizanicolem

defaultselecteditems use this :{Value:ThisItem.Year}
{Value:ThisItem.Month}

Please click Accept as solution and Thumbs Up. if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
You can connect with me on LinkedIn

Was this reply helpful? Yes No
raizanicolem 70 on at

Like (2)

Report

Thank you so much! The solution was actually so simple. I didn't know.

Was this reply helpful? Yes No
developerAJ 4,628 on at

Like (1)

Report

@raizanicolem

Glad to help you. it happens sometimes we miss the smallest things and make the problem as huge

Was this reply helpful? Yes No