Answered

Add value from multiple rows which match criteria

(0) Share

Report

Posted on by FakeHungry

I'm trying to add multiple tasks which match date and serial number. UI looks something like below.

First, you need to input start date, end date, and serial number. Then, it'll calculate date range between two date as on the right of the picture. Finally, I need to pull tasks and max ot with match criteria next to the date.

This is my sample data. If I search with criteria startDate=1/9/21, endDate=30/9/21, and S/N=FB/6, I will get tasks_ID=13,14,15 (within the same record) and OT=7.50.

Any suggestions are welcom.

Thanks,

FakeHungry

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @FakeHungry

Set the OnSelect property of the Search button to
ClearCollect( ColTasksH, Sort( Filter( TasksH, Request_Date >= StartDateH.SelectedDate && Request_Date <= EndDateH.SelectedDate && 'Vehicle_S/N' = SNSearch.Text ), OT, Descending ) )

Set the text property of Label to
First(ColTasksH).Task_ID
FakeHungry 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @StalinPonnusamy

Thanks for your suggestion, but it didn't work. The result should be as table below.
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @FakeHungry

ClearCollect( ColTasksH, GroupBy( Sort( Filter( [@TasksH], Request_Date >= StartDateH_1.SelectedDate && Request_Date <= EndDateH_1.SelectedDate && 'Vehicle_S/N' = SNSearch_1.Text ), OT, Descending ), "Request_Date", "RequestDateTable" ) ); ForAll( ColTasksH, Collect( ColTasksHNew, { Request_Date: ThisRecord.Request_Date, OT: First(ThisRecord.RequestDateTable).OT, Task_ID: Concat(ThisRecord.RequestDateTable,Task_ID,",") } ) )
Source