Answered

Lookup function ReductionFormula not working

(0) Share

Report

Posted on by Dutycalling

Hi community,

I am using a simple lookup within a combobox in order to pre-populate fields. The app is connected to a SharePoint list with two seperate fields - account & account_name. Now I have tried to use the account as a filter but when I do so it returns only blank values even though I am sure that the account is included. I have also tried to use the account_name as a filter and what I have noticed is that the initial part of the lookup (see below) does show me the result that I need. As soon as I enter the ReductionFormula (see second line) I noticed that the formula demands a table to be referenced to (in this case InputBalances). However, when I enter the formula as InputBalances.Account it seems to loose the connection and does not provide me the results I need.

LookUp(InputBalances;ACCOUNT_NAME = "Goodwill - Gross")
LookUp(InputBalances;ACCOUNT_NAME = "Goodwill - Gross";ACCOUNT)

Cannot see what I am doing wrong but somehow the fields are not behaving as expected.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Mitanshu 1,656 Moderator on at

Like (1)

Report
Copy link

Link copied!

The LookUp function finds the first record in a table that satisfies a formula

Create a Label and put the Text property as:
LookUp(InputBalances;ACCOUNT_NAME = "Goodwill - Gross").ACCOUNT

It should return you the value stored in the Account column.

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
Dutycalling 32 on at

Like (0)

Report
Copy link

Link copied!

Brilliant - that seems to do the trick!

Was this reply helpful? Yes No