Answered

Filtering submitted forms for verification page

(0) Share

Report

Posted on by Austenb1237

Hello everyone,

I am new to powerapps, creating my first app for work. I've figured out most things myself which is how I prefer to learn but I'm having trouble with one thing. Within the app there is a page for management to sign off on completed inspections but I am having trouble making it so they can sort by date submitted, location, or employee ID number. I have the correct SQL Datasource connected to the form but when I try to select a date on the date picker or any of the other filtering options it always comes up blank. Please let me know if any more information is need. Looking for any ideas on what I may be doing wrong, and any help is appreciated.

Thanks,

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

BCBuizer 22,899 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Austenb1237 ,

Can you please share the formula you are currently using?
Austenb1237 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Filter([Datasource],LocationID=LocationDropdown.SelectedText);
Filter([Datasource],EntryDate=DatePicker.SelectedDate);
Verified answer

BCBuizer 22,899 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Austenb1237 ,

Few pointers:

- You'll have to combine the conditions in a single Filter

- SelectedText has been deprecated, and needs to be replace with Selected.ID (assuming ID is the column in the data source connected to the DropDown that has the value you want to filter for)

Filter([Datasource],LocationID=LocationDropdown.Selected.ID && EntryDate=DatePicker.SelectedDate);