cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Panitan
Regular Visitor

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

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

Panitan_0-1663327151521.png

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

3 REPLIES 3
sperry1625
Solution Supplier
Solution Supplier

@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.

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.

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

Panitan_0-1663376554118.png

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_1-1663376831064.png

 

 

Panitan
Regular Visitor

@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.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,118)