refer gallery data source

[Anonymous]

Hi All,

Do you know if is it possible to refer to a gallery Data Source ? 

I have to disable a button if

Button1.Text in LookUp(
seatH,
label = Button1.Text And available = false
).label

I have to apply this behavior to many gallery with different data source but with the same structure 

Instead to use direct Data source name SeatH, is there a function helpful to refer it without hard coding it ? 

[v-bofeng-msft]

Hi @Anonymous :

Do you want to get all the items in the gallery?

Do you want to make the button unavailable when Button1.Text appears in the label field of any item in any gallery?

If so, It can be achieved using GalleryName.AllItems.

I assume there are there gallerys(Gallery1,Gallery2,Gallery3)

set the button's DisplayMode proeprty to:

If(IsBlank(LookUp(       /*Gallery1/2/3 is my gallery*/
Gallery1.AllItems,   
label = Button1.Text And available = false
) )&& IsBlank(LookUp(
Gallery2.AllItems,
label = Button1.Text And available = false
) )&& IsBlank(LookUp(
Gallery1.AllItems,
label = Button1.Text And available = false
) ),DisplayMode.Edit,DisplayMode.View)

Best Regards,

Bof

[Anonymous]

Ciao @v-bofeng-msft,

Thank you for your answer,

I have tried but I have an error, it seems AllItems is not recognized as Gallery property.

See the attachment

Thanks 

[v-bofeng-msft]

Hi @Anonymous :

Could you tell me the details of the error?

I suggest you enclose Button1.Text ... .Label in brackets.

Or (Button1.Text …… ).label),……

In addition ,I think this code will be better:

Or IsBlank(LookUp
Gallery1.AllItems,   
label = Button1.Text And available = false
)

 Best Regards,

Bof

[Anonymous]

The specified property is not accessible in this context.

Following the entire code 

If(
(Button1.Text in LookUp(
BookingData,
Seat = Button1.Text And BookingDate = Text(
DatePicker2_1.SelectedDate,
"[$-it-IT]dd/mm/yyyy"
) And Status = "Booked"
).Seat ) Or (Button1.Text in LookUp(
seatH,
label = Button1.Text And available = false
).label),
DisplayMode.Disabled,
DisplayMode.Edit
)

[v-bofeng-msft]

Hi @Anonymous :

Please try this code:

If(
!(IsBlank(LookUp(
BookingData,
Seat = Button1.Text And BookingDate = Text(
DatePicker2_1.SelectedDate,
"dd/mm/yyyy"
) And Status = "Booked"
))) Or !(IsBlank(LookUp(
seatH,
label = Button1.Text And available = false
))),
DisplayMode.Disabled,
DisplayMode.Edit
)

 If an error is reported, could you give me a screenshot of the code box?

Best Regards,

Bof

[Anonymous]

Your code works with seatH , it doesn't if I substitute Galley1.AllItems

Raised error it the same :

The specified property is not accessible in this context.

Thanks again

Elia

[v-bofeng-msft]

Hi @Anonymous :

I made a test but did not encounted the problem you mentioned.

Could you tell me:

• What is the Gallery1's Items property?
• Could you provide a screenshot of the code box? Usually errors are marked with red lines?

Best Regards,

Bof

[Anonymous]

Attached 

[v-bofeng-msft]

Hi @Anonymous :

This is really weird. Is the Items property of Gallery1 set to :

SeatH

?

When you replace Gallery1.AllItems with SeatH, does your formula work?

Could you tell me what available is?A filed in SeatH?Could you delete this condition and try again?

Could you store Gallery1.AllItems in a collection and then check if the collection contains the fields in the formula?

I addition,could you try this code again at the end?

If(
!(IsBlank(LookUp(
BookingData,
Seat = Button1.Text And BookingDate = Text(
DatePicker2_1.SelectedDate,
"dd/mm/yyyy"
) And Status = "Booked"
))) Or !(IsBlank(LookUp(
Gallery1.AllItems,
label = Button1.Text && !(available)
))),
DisplayMode.Disabled,
DisplayMode.Edit
)

 Best Regards,

Bof