Answered

Problem trying to return a number from a Lookup

(1) Share

Report

Posted on by ARV84Z

Hi,

I have a formula that needs to count how many candidates are booked on a course, and then to change the status to "Full" once the max capacity is reach. The max capacity is defined by a separate data source that holds the venues' details.

My formula is struggling to recognise a number from a LookUp. If I bypass the LookUp and type the number in my formula, it works, but each venue has a different capacity.

The format of the column my formula is Patching is Text.

If(CountRows(Filter(Class_registrations,Course_ID=ThisItem.Course_ID And 'Attendance Type'="Candidate"))>=
LookUp(ODP_Courses_Lists,Course_ID_Number= ThisItem.Course_ID,Max_Cand) ,
Patch(ODP_Courses_Lists,LookUp(ODP_Courses_Lists,Course_ID_Number=ThisItem.Course_ID),
{Course_Status:"Full"}))

Thanks, Andy

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ARV84Z ,

I assume you are running this from a control inside a Gallery or Form as you refer to ThisItem. If you put this on a Text Label also inside the Form/Gallery, what do you see ?

LookUp( ODP_Courses_Lists, Course_ID_Number = ThisItem.Course_ID ).Max_Cand

I also assume Max_Cand is a number column in ODP_Courses_Lists.
ARV84Z 37 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,
Yes, this is run inside a gallery. If I create a text label and add the code I get a number ,"8".
Max_Cand is a text column, not a number column.

Andy
ARV84Z 37 on at

Like
a
(0)

Report
Copy link

Link copied!
@WarrenBelz , I changed the column type to number, rather than text and it works. But my patch code to add the number in the first instance is now an issue.

How do I patch a number column with a label?

I have tried this:
Max_Can:txtinpMaxCan
but it needs a something after to define it. All I have is '.Text', but this can't be right?

Is it my label format?
Verified answer

WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @ARV84Z ,

The whole issue here is that you need to turn the text value into a number, but I also have some improvement suggestions

With( { _Reg: Filter( Class_registrations, Course_ID = ThisItem.Course_ID And 'Attendance Type' = "Candidate" ), _Max: Value( LookUp( ODP_Courses_Lists, Course_ID_Number = ThisItem.Course_ID ).Max_Cand ) } If( CountRows(_Reg) >= _Max, Patch( ODP_Courses_Lists, LookUp( ODP_Courses_Lists, Course_ID_Number = ThisItem.Course_ID ), {Course_Status: "Full"} ) ) )

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.

MVP (Business Applications) Visit my blog Practical Power Apps
ARV84Z 37 on at

Like
a
(0)

Report
Copy link

Link copied!

Amazing thank you!