Unanswered

Query SharePoint list, return column value in label

(0) Share

Report

Posted on by RMPCoe

Hi,

I'm attempting to return a numeric value in a label from a lookup against a SharePoint list where 2 conditions are true. The conditions are set from values selected within a form.

frm1.dropdown1

OnChange - Set(var_BuildingSelected, ThisItem.BuildingName)

frm1.datepicker1

OnChange - Set(var_DateSelected, ThisItem)

Label1

"Availability is " & LookUp(Building,Text(DataCardValue5.SelectedDate,"[dd/mm/yyyy") = Building.BookingDate && var_BuildingSelected = Building.BuildingName, Spaces)

"Availability is " & LookUp(Building, var_DateSelected = Building.BookingDate && var_BuildingSelected = Building.BuildingName, Spaces)

Spaces is a calculated numeric value within the list.

Thanks in advance 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

RMPCoe 4 on at

Like
a
(0)

Report
Copy link

Link copied!

OK, I'm getting close;

Currently stuck on;
Text(LookUp('Building', BuildingName = Dropdown1.SelectedText.BuildingName && BookingDate = DataCardValue5.SelectedDate,BuildingMaxCapacity))

This works, however the && does not
Text(LookUp('Building 1', BuildingName = Dropdown1.SelectedText.BuildingName ,BuildingMaxCapacity))

Was this reply helpful? Yes No
RMPCoe 4 on at

Like
a
(0)

Report
Copy link

Link copied!
Text(LookUp( 'Building', Text(Dropdown1.SelectedText.BuildingName) && Text(DataCardValue5.SelectedDate,"dd/mm/yyy"), BuildingMaxCapacity ))
I have also tried this format, however still unable to get the && to function correctly

Was this reply helpful? Yes No
Preachman85 38 on at

Like
a
(0)

Report
Copy link

Link copied!

Anyone? Is the issue so easy that noone cares to answer, or can it simply not be done?

Was this reply helpful? Yes No
WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Preachman85 ,'
Firstly you are missing the field you are comparing the text string to - I will use YourField below. I am assuming you want to concatenate two values to form a text string that references a field in the list.
With( { vQuery: Dropdown1.Selected.BuildingName & Text( DataCardValue5.SelectedDate, "[$-en]dd/mm/yyyy" ) }, LookUp( 'Building', YourField = vQuery, BuildingMaxCapacity ) )
Just a tip for the future - I think the main reason for lack of response was the lack of understanding of your question.

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.

Was this reply helpful? Yes No
WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Preachman85 ,
Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

Was this reply helpful? Yes No