News and Announcements icon

Power Platform CommunityForums Power Pages - General Discussions Hi, How can I update a...

Power Pages - General Discussions

Unanswered

Hi, How can I update a field based on values from other fields in real time?

(1) Share

Report

Report

Posted on by Ollie_mcerl

12

Hi,

I want to update the field Annual Salary, see below. The value comes from a SP list which has a salary beside Grade and Scale (other 2 fields on the page).

Ive added in the default function for the field but when I run this and change the values in the other 2 fields (Dropdown1 and Dropdown2) nothing happens.

Do all these fields need to be within a form or is an OnChange function required?

Any help appreciated.

Ollie

Categories:

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Michael E. Gernaey 33,282 Super User 2025 Season 1 on at

Like (0)

Report

Hi, How can I update a field based on values from other fields in real time?

Hi

1. Make sure that the correct Field is bound to the Text box. (that its not blank)

2. Make sure that you are not getting any errors (if it errors out it will not show anything)

3. Manually verify that what you are putting in matches.

You are doing a lookup, so you should be able to easily do this

Add another label.

In the Text do not take the values from the dropdowns/text instead hard code it

LookUp('Salary Information', Title = "DP" And Scale = "2")

Or

LookUp('Salary Information', Title = "DP" And Scale = 2)

If Scale is a Number then make sure to convert it to a number, OTHERWISE if you put in a string, it will essentially fail, but not always tell you.

If you are unsure then put 2 more labels, and put one with a number 2 and one with a string 2 and see which one errors out.

If it does NOT show you any data, then you know its an issue with your data in the back end.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,318 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 65,111 Most Valuable Professional

Leaderboard

Featured topics

Solution to LinkedIn Authentication in Power Apps Portals

Product updates

Microsoft Power Platform Community release plans