Need Help with how to get data from sharepoint with multiple column

[Panitan]

Hi everyone
I tried to build Loaning Equipment Application and have a shapoint list like this

what i want is,
for example
when i loan item "I01" date 8/31/2022 time  00:00-02:00

the result i want is column

AvailableTimeStock1 

AvailableTimeStock2

AvailableTimeStock3 

AvailableTimeStock4

then get the minimum value from this to checking min stock within loaning time

when i loan item "I01" date 9/1/2022 time  00:00-01:00

the result i want is column

AvailableTimeStock1

AvailableTimeStock2

then get the minimum value from this too

is there any way powerapp can select data like this

[sperry1625]

@Panitan I am having trouble following what exactly you are trying to do. Are you trying to determine an items availability based on what has already been reserved?

Additional clarity would be helpful.

Regards,

-S

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.

[Panitan]

Yes, I want to determine an items availability  the reason i build sharepoint list like that because
if i build list like this:

There will be a lot of data for 1 day per Item

and i can't build a list to display like this on powerapps

[Panitan]

@sperry1625 I would like to explain more about what I'm looking for...

I need to select columns(AvailableTimeStock) where match my time conditions( Column time1, time2, time3, time 4)

like if I'm looking for data between time value '00:00' to '01:00'

the result what I want is to show AvailableTimeStock where the in put time is in between and match the value of column time1, time2, time3, time 4.

I don't know how to select and show the result.