web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Two of the fields not ...

Power Apps

Answered

Two of the fields not getting updated on Submitting the form

(0) Share

Report

Report

Posted on by Prem4253

697

Hello,

I'm using lookup function to update my A2 and A4 fields.

When entered value in A1, A2 gets auto populate.

When entered value in A3, A4 gets auto populate.

For A1 - OnChange below formula is added:

UpdateContext({var_employee: LookUp(SPListName,Title=Self.Text,ColumnName)})

For A2 - for Default below formula is added:

Coalesce(var_employee, Parent.Default)

But after submitting the form, A2 and A4 fields does not gets updated in form and SharePoint. It returns blank for both the fields.

Note: for lookup in A3 and A4, I've created a list to SharePoint.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (1)

Sort by

Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Prem4253 - in your Form, what do you have in the Update property of the DataCards (not the Data Card Value)

Was this reply helpful? Yes No
Prem4253 697 on at

Like (0)

Report
Copy link

Link copied!

@Amik
Update property for A1 is A1.Text and A2.Text for A2

Was this reply helpful? Yes No
Prem4253 697 on at

Like (0)

Report
Copy link

Link copied!
For OnSelect property of the Submit button I have added below code
UpdateContext({var_employee: Blank()}); SubmitForm(Form3)

Was this reply helpful? Yes No
Verified answer

Ami K 15,687 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@Prem4253 the code above is clearing var_employee prior to the SubmitForm function which is likely the cause for the blanks. I would move this line to the OnSuccess property of your Form.

UpdateContext({var_employee: Blank()})

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
Prem4253 697 on at

Like (1)

Report
Copy link

Link copied!

@Amik ,
Thank you! this did the trick after updating the code to OnSuccess property.

Was this reply helpful? Yes No

Join the conversation