Display Filtered items from SharePoint list as Items in Dropdown

(0) Share

Report

Posted on by nemanjasovic011

240

Hello,

I have a situation where a Power Apps dropdown is tied to a data source which is SharePoint list. I would like to be able to display filtered items from SP(not all of them) as options in the dropdown. For example, show 'title' as selection option in dropdown only for rows where SP column StartDate < Today(). I am not able to find a way to do this on the web despite the fact that it appears to be a simple problem. Again, I need only only a filtered set of SP items(based on date) to be showing in the dropdown.

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 154,926 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @nemanjasovic011 ,

Something like this should do it

Filter( YourSPListName, DateDiff( StartDate, Today(), Days )>0 ).Title

Please click Accept as solution 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.

Was this reply helpful? Yes No
nemanjasovic011 240 on at

Like (0)

Report
Copy link

Link copied!

This works - thank you - before I mark this as an answer, if you get a chance, could you let me know how to add additional condition 'AND' on this filter for column name 'visible;=='yes'.

Was this reply helpful? Yes No
nemanjasovic011 240 on at

Like (0)

Report
Copy link

Link copied!

Answer to my question : Filter( 'Event itinerary',
DateDiff(
'Start date and time',
Today(),
Days
)>0 And ('Expose to Event Registration app'.Value = "Yes")
).'Name and Date'

Was this reply helpful? Yes No