Formula Help

(0) Share

Report

Posted on by NP-18101421-0

237

Hi,

I have a tabbed form. The user fills out the form and then the approvers get a deep link to the tabbed form to approve and update a few other fields.

On this form, the Vendor Number on Tab 2 needs a formula to pull the vendor number if there was an input by the user in the first tab of the form "Existing Vendor Number". IF there was no input in this field by the user then the approver should be able to manually enter one. IF there is already an input in the field by the user, then the approver should be able to update it/correct it.

Tab 1 where the user inputs are:

Tab 2 where the approver will need to be able to make edits and submit:

Right now the Vendor Number field has a default property of Parent.Default.

Any help in getting this formula together will be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Vaish123 136 on at

Like (0)

Report
Copy link

Link copied!

Hi,
First filter the vendor number which exist and save it into a variable. Map the variable into the vendor number column in tab 2.

Was this reply helpful? Yes No
NP-18101421-0 237 on at

Like (0)

Report
Copy link

Link copied!

Hi what does that formula look like? and when would I set that variable? When the user hits submit?

Was this reply helpful? Yes No
Verified answer

NP-18101421-0 237 on at

Like (0)

Report
Copy link

Link copied!
I was able to use a variable.

For the Existing Vendor Number, I set the onchange property to set the variable to the datacard value that was entered. On the next tab, I set the vendor number default property to:
If(IsBlank(varExistingVendorNumber),ThisItem.'Vendor Number',varExistingVendorNumber)
and I set the onchange property of the Vendor Number field to:
Set(varExistingVendorNumber,DataCardValue6.Text)

Was this reply helpful? Yes No