Help with ComboBox Displayfield Supposed Error

[Eduardo_C]

Hi guys, i've been creating a canvas app in the past days that uses Dataverse to keep track of overtime hours. I've created inside the app a form for each employee to imput its data. The "Overtime" table has 2 columns, respectively "Year" and "Month" that are actually just a Choice type column with the possibility to choose the month and the year. Inside the form, there are the two combobox from wich the employee can choose the Month and Year. So, here's the deal: I've been trying to limit the choice they have by filtering the Items property this way, turning the usual "Choice(Month)" into "Filter(Choices(Mese);Value in ACTUALMONTH)"

Actualmonth is defined in the app formulas as "Actualmonth = Text(Today();"mmmm")". The final objective will be to give possibility to the user to select the actual month each day of the current month, but also the next month only after the 15th day of the current month. After i apply this filter to the Items property, the combobox items are sorted correctly, but i get this weird error that i cannot even understand since the combobox and the form both work, and it seems they refer to the DisplayField property
"Table doesn't contain any column of text type"

   

Do you guys know why this happens and how i could fix this? 

[AhmedSalih]

Hello, @Eduardo_C, try this formula instead of your filter formula you are using:

If(
    Day(Today()) > 15,
    Filter(
        Choices([YourTableName].[Month]),
        Value = Text(Today(), "mmmm") || Value = Text(DateAdd(Today(), 1, Months), "mmmm")
    ),
    Filter(
        Choices([YourTableName].[Month]),
        Value = Text(Today(), "mmmm")
    )
)

---

If my reply helped you, please give a 👍 If it solved your issue, please give a 👍 & accept it as the Solution to help other community members find it more.

Visit my Blog: ahmedsalih.blog

Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos

[Eduardo_C]

So, after readapting the formula tu EU formatting, the formula works but i get anyway the same error i showed up. While readapting the formula, It becomes the sequent one:

If(

    Day(Today()) > 15;

    Filter(

        Choices(Mese);

        Value in Text(Today(); "mmmm") || Value in Text(DateAdd(Today();1;TimeUnit.Months); "mmmm")

    );

    Filter(

        Choices(Mese);

        Value in Text(Today(); "mmmm")

    )

)

Using = instead of "in" generates an error of invalid type comparison, such as [table].[month] too 

[AhmedSalih]

@Eduardo_C, can you please translate those error into English? 

[Eduardo_C]

So, the error i'm trying to understand that are here say, respectively the first 3: "Table doesn't contain any column of text type"; "Column type is invalid, text type expected"; "Search function has invalid arguments".
And these errors are the ones that i keep getting even after adopting your code. 
About your code instead, using "=" instead of "in" as comparator i get: "Incompatible types for comparison; You cannot compare these types: OptionSetValue(Month), Text.", and while using [YourTableName].[Months] instead of "Months" only i get "Choices function has invalid arguments".

Just to be clear, filters worked then and work now with your code if i readapt it, the point is that i dont understand the nature of the error

About the first 3 errors: When i click the arrow to go to the error, powerapps opens me the displayFields Property with the ["Value"] formula as you can see on the top, which i dont see why should be a problem

[Eduardo_C · Accepted solution]

The problem randomly fixed itself after some time