cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Prodigy
Post Prodigy

Allowed values from Excel table

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? 

24 REPLIES 24

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

 

Have a look:

Anotação 2020-05-01 125448.jpgAnotação 2020-05-01 1254482.jpgAnotação 2020-05-01 1254483.jpg

 

It is still generating an error and an empty dropdown.

Super User III
Super User III

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.

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.

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:

 

Anotação 2020-05-01 133035.jpg

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

Combobox.JPG

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

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.

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (81,770)