Unanswered

Substitute null in a table

(0) Share

Report

Posted on by intrepid505

I am using a data collection and attempting to "substitute" some data table column values, to text, for example "1" equals "Approved" and "2" equals "Denied". However, some entries do not have any status and should be considered equal to "Pending". Meaning, while they show in my table in PowerApps, because they exist in the collection, their status "Approved/Denied" has not been set yet, so that data does not exist in my data collection for this column and I think would then be considered "null", "blank" or "empty" in the data collection. However, I have tried the following strings and while they successfully replace the "1" and "2", the empty field will not update. Perhaps I am missing the "substitute" function in this case?

Substitute(Substitute(Substitute(ThisItem.Status, "1", "Approved"),"2", "Denied"), "", "Pending")

Substitute(Substitute(Substitute(ThisItem.Status, "1", "Approved"),"2", "Denied"), IsBlank(ThisItem.Status), "Pending")

Substitute(Substitute(Substitute(ThisItem.Status, "1", "Approved"),"2", "Denied"), IsEmpty(ThisItem.Status), "Pending")

Substitute(Substitute(Substitute(ThisItem.Status, "1", "Approved"),"2", "Denied"), Blank(), "Pending")

I just need that "Blank" or missing value to return "Pending". Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

WarrenBelz 156,456 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @intrepid505 ,

You could try it this way

With( { wSub: Table( {Value: "1", Sub: "Approval"}, {Value: "2", Sub: "Denied"}, {Value: Blank(), Sub: "Pending"}, {Value: "", Sub: "Pending"} ) }, LookUp( wSub, Value = ThisItem.Status ).Sub )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
intrepid505 10 on at

Like
a
(0)

Report
Copy link

Link copied!

This did not work, it said it could not compare data of two different types. Thank you!

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

Like
a
(0)

Report
Copy link

Link copied!

@intrepid505 ,

It works perfectly here on a Text control

Assuming Status.Value is also text, it should work for you.

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No