Format Choices/Lookup Value

(0) Share

Report

Posted on by jeffha77

Building an incident app that uses two list

List 1: Material list with data like Material Name, number, cost per lb.

List 2: Incident list that has list 1 as a look up

In list 1 Cost is formatted as currency but this does not transfer to list 2 and then into the PowerApp. I'm trying to format the Cost as currency in the power app. I have tried the below on the DataCard and DataCardValue Default fields.

"$" & Text(Value(Parent.Default),"[$-en-US]#.00")

"$" & Text(Value(ThisItem.'Cost/lb'),"[$-en-US]#.00")

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Vijay Tailor 2,961 on at

Like (0)

Report

Hi,

You can use the filter in the gallery based on Selected Filter Value.

LIke below - Condition you can Use.

if (IsBlank(ComboBox1.Selected.Value) && IsBlank(ComboBox2.Selected.Value),DataSourceName,Filter(DataSourceName,Column1=ComboBox1.Selected.Value && Column2=ComboBox2.Selected.Value)).

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
jeffha77 27 on at

Like (0)

Report

Vijay,

thanks for the reply but the app is set up as a form so no gallery and not looking to filter. Just need to format data pulled into the app from a SharePoint list. It pulls in as "0.01000000..." I want to format it to "$0.01"

thanks

Was this reply helpful? Yes No
Vijay Tailor 2,961 on at

Like (0)

Report

Hi,

Your Can Formate LIke Below.

Code - Text(Value(Label2.Text),"[$-en-US]$0#.00")

For Reference - https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-text.

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
jeffha77 27 on at

Like (0)

Report

No luck with that either, I don't think it brings that data in as text and cant get it to convert it to text.

The DefaultSelectedItems is what is displayed. MY guess is that its formatted as an array but I cant find any supporting documents.

Was this reply helpful? Yes No
Vijay Tailor 2,961 on at

Like (0)

Report

Hi @jeffha77 ,

Hi, What is the input type your Using?

Thanks,
Vijay

Was this reply helpful? Yes No
jeffha77 27 on at

Like (0)

Report

Hi @VijayTailor ,

It is a lookup column in SharePoint that is being displayed as choices. When the user selects the type of Material (which is the lookup) it pulls in the Cost/Lb.
List 1 in sharepoint

List 2 in sharepoint, pulls in the material info as a lookip, this is the list attached to the form.

Was this reply helpful? Yes No
Verified answer

Vijay Tailor 2,961 on at

Like (1)

Report
Hi @jeffha77 ,

Finally got a solution for your Issue.

Use the below Code for formate your Lookup value.
and
Edit the selected filed for Combobox and select the FormateedValue column.
See the image below.
AddColumns(TestAkshay,"FormatedValue",Text(Value('Cost/lbs'.Value),"[$-en-US]$#.00"))

Final Result
DefaultSelectedItem Code.
[Text(Value(ThisItem.'Cost/lbs'.Value),"[$-en-US]$#.00")]
Hope this solution fits for your Issue.
Thanks,

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No