Allowed values from Excel table

[WebPortal]

My app has a dropdown table that lets users select a month in text form like: "Jan-2020", "Feb-2020", etc.

The app is connected to an Excel file in OneDrive.

The AllowedValues property is set to:

["Jan-2020";"Fev-2020";"Mar-2020";"Abr-2020";"Mai-2020";"Jun-2020";"Jul-2020";"Ago-2020";"Set-2020";"Out-2020";"Nov-2020";"Dez-2020"]

Now, I want to restrict this list to exclude the values already recorded in the Excel table (column "Periodo").

So, how to express this logic in the AllowedValues property using PowerApps formula? It should read the column from Excel and then deduct the existing months from the list above, but how? 

[WebPortal]

@eka24 I appreciate your effort, this is really driving me crazy.

Have a look:

It is still generating an error and an empty dropdown.

[eka24]

Since the formula doe not show errors, hover your mouse pointer on the error (Red) and send the error message.

Also insert a separate dropdown not inside the form and try the formula on it.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[eka24]

Please what's the error message?

Don't use the ClearCollect on the separate dropdown. Use my last formula on filter

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[WebPortal]

The error message is:

"Invalid name. This identifier is not recognized"

I have inserted a separate dropdown, it does not have any error but it is empty:

[eka24]

Run OnStart or Restart the app and check if the separate dropdown will work.

Is the name of the ExcelTable ok?

On your main dropdown, the error is on the DataCard not the dropdown inside the datacard.

My check: For Instance i don have Jan and Oct because is already used

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.