Formula using input fields and datasource records

(0) Share

Report

Posted on by JRitt

I have a data source:

I have two input fields

1. text field 'PageCount'

2. Drop Down Menu 'Paper', which pulls the options from the Paper Type column in the data source

I'd like to have a text field that would then display the results of a formula. Something like this...

If(Paper='70# Offset', Sum(PageCount/field at Pages Per Inch, 70# Offset)

How do I refence that specific field in the formula? Ultimately, I need to divide page count by the "pages per inch" for the paper that was selected in the drop down.

thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Ethan_009 4,838 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @JRitt ,

Try using following code:

With( { pageCountValue: Value(PageCount.Text), pagePerInch: LookUp(PaperData, 'Paper Type' = PaperDropdown.Selected.Value, ThisRecord.'Page Per Inch') }, If( !IsBlank(pagePerInch), pageCountValue/pagePerInch ) )

replace if any mis-spelled names

Hope this helps

Was this reply helpful? Yes No
JRitt 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Ethan_R

That makes a lot of sense! A much better way to do it.

It's close, but doesn't like some of the code.

The error for the '=' is:
Incompatible types for comparison. These types can't be compared: Text, Error.

The error for the ".Value" is:
Name isn't valid. 'Value' isn't recognized.

I think if we can get that link made between PaperDropdown and the Paper Type column in the data we'll be good.

thanks so much
Josh

Was this reply helpful? Yes No
Verified answer

Ethan_009 4,838 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JRitt ,

That's fine, usually .Value is given when there's no internal columns within.

In your case, there are internal columns meaning that it is a record in your dropdown.

So, replace '.Value' with '.<columnName>'

I'm not sure which columns you have but in PowerApps formula bar, you add "." dot and PowerApps suggestions will show you fields it holds.

Note: Add it with the same datatype by which it is comparing.

It will work

Hope this helps

Was this reply helpful? Yes No
JRitt 6 on at

Like
a
(0)

Report
Copy link

Link copied!

@Ethan_R

perfect, working wonderfully now. thanks!

Was this reply helpful? Yes No