Unanswered

Layout using Gallery

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I want to capture 10 items (beds) in a horizontal gallery (2 row by 5 column), with a specific layout eg beds 1-5 are in row 1, beds 6-10 are in row 2

People can be placed in any bed (eg bed 1 and 7 can have patients and the rest are empty) in a non sequential order. However, i'm finding that gallery will automatically place patient beds in any order.

How do i format the gallery to link a specific gallery space with only a specific bed number. Eg i'd like spaces to be blank if there is no one in the bed, and for patients in bed 5 to only show in the space where bed 5 should be

Cheers

Categories:

Building Power Apps

All responses (8)

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do you want to sort the gallery items by bed number? If so , you could set the gallery's items property to:

Sort( DataSource, BedNumber )

Best Regards,

Bof
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, in a way.
I'd want the gallery to have 10 areas to show 10 items. If there's no patient in a bed, then there technically is no item coming in from the data source
I'd like it to show:
| Bed 1 | Bed 2 | Bed 3 |
If there's no patient in bed 2, then there technically is no data coming in for bed 2 to show as an item. The gallery will only show it as: | Bed 1 | Bed 3 |
Is there a way to placemark/reserve the spot where bed 2 is meant to be when there is no patient?
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

You could set the gallery 's items property to

ForAll(Sequence(10,1,1),{Title:"Bed "&Value})

And in the gallery , you could use this formula to get data

LookUp(SharePointList,Title=ThisItem.Title).ColumnName

Best Regards,

Bof
vaubeee 533 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorting is already covered by @Anonymous
Regarding the blanks you could use a toogle and labels visible property with if toggle false to cover the item

(use the same background color as gallery to make the cover invisble)
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Trying to give that formula a try. Having problem with the for all section
What Am i meant to do for this part of the formula {Title: "Bed " &Value}

Currently I've got Sort(AUData, 'Query[CurrentBed]') ; ForAll(Sequence(10,1,1),
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Just set the Gallery's Items property to:

ForAll(Sequence(10,1,1),{Title:"Bed "&Value})

With out

Sort(AUData, 'Query[CurrentBed]')

If you want to show show something like username in the gallery, you could add a label control into the gallery and set it's text property to:

LookUp( AUData, 'Query[CurrentBed]'=ThisItem.Title ).username

Best Regards,

Bof
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Set the gallery item to ForAll(Sequence10,1,1), {Title:"Bed " &Value})

In label control, under text property i've typed that but theres no data showing
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you please show me the value of

First(Sort(AUData, 'Query[CurrentBed]')).'Query[CurrentBed]'

Best Regards,

Bof