Answered

Fomula issue

(0) Share

Report

Posted on by CU22080239-4

I have a column called "Staff Name" in a form and used below formula in data card value setting. When "Addition" is selected in column RARHeadcounttype, staff name is blank. When other value is selected for column RARHeadcounttype, stall name should be filled with staff name.

The issue is at the beginning, this record was filled as "Backfill", so staff name was filled as well. But later the data was updated by user to change "Backfill" to "Addition", value in Staff name column didn't got removed. Do you have any idea for this issue?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @YanLiang,

Modify your formula as below:

If(RARForm.MOde=FormMode.New || RARHeadcounttype.Selected.Result="Addition","",Parent.Default)

Was this reply helpful? Yes No
CU22080239-4 on at

Like
a
(0)

Report
Copy link

Link copied!
may I know what's the difference between "OR" and "
||
"?

Was this reply helpful? Yes No
WarrenBelz 156,386 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@YanLiang ,

Nothing (it means Or) - it just saves some typing and brackets.

Was this reply helpful? Yes No
CU22080239-4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, but why when I changed value from "Backfill" to "Addition" in column RARHeadcounttype, staff name didn't change to blank automatically? It keeps the value filled at very beginning.

Was this reply helpful? Yes No
WarrenBelz 156,386 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@YanLiang ,

Try resetting the control OnSelect of RARHeadcounttype

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @YanLiang,

Have you solved your problem?

Have you replace the Blank() with empty string ""?

If my formula solve your problem, please mark it as solution or provide more details if it is still an issue.

Thanks for your cooperation.

Was this reply helpful? Yes No
CU22080239-4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Qi, it works. May I know why should use "" instead of Blank()?

Was this reply helpful? Yes No