Answered

urgent need why the amount didn't empty in the SP list and update?

(0) Share

Report

Posted on by bbsin

1,994

I have a gallery when the status is rejected the amount is empty which is fine but the SP list amount was not removed, can please help

If(ThisItem.Status.Value = "Rejected","", Text(ThisItem.InvAmt, "$#,###.00"))

Form is Default =Parent.Default

the form and SP List still show the amount but gallery view is empty.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Ramole Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @bbsin

Are you using a form to do the changes ?

Was this reply helpful? Yes No
v-albai-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @bbsin ,

What's your purpose? I cannot get your requirement by the given information.

Do you want to clear the amount when the status is rejected?

At least your formula seems without any error.

Best regards,

Allen

Was this reply helpful? Yes No
bbsin 1,994 on at

Like (0)

Report
Copy link

Link copied!

Yes I am using a Form to submit and it is to update to SP list
and gallery to view

Was this reply helpful? Yes No
bbsin 1,994 on at

Like (0)

Report
Copy link

Link copied!

Hi both

Yes I want the amount to be deleted in SP list when it's rejected, there should not be any amount inside when rejected.

I only input the formula in gallery, do I need to put the formula in the FORM where the amount datacard is too?
the amount datacard in the FORM is Parent.Default
should I change to the same formula - If(ThisItem.Status.Value = "Rejected","", Text(ThisItem.InvAmt, "$#,###.00"))

Thanks

Was this reply helpful? Yes No
Verified answer

Ramole Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @bbsin

If its gallery and you're using a dropdown inside gallery put this code OnChange this code it will also change the Status to Rejected

If( Dropdown7.Selected.Value = "Rejected", Patch( 'Loan Management', ThisItem, { Status: {Value: "Rejected"}, InvAmt: "0" // If you need to change to empty use Blank() } ) )

Please change the dropdown name and the other to your control names

Was this reply helpful? Yes No
bbsin 1,994 on at

Like (0)

Report
Copy link

Link copied!

@Ramole Thanks.

Was this reply helpful? Yes No
Ramole Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @bbsin
You welcome, If my answer helps you, then please consider Accept it as the solution to help the others

Was this reply helpful? Yes No