web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Format datacard from l...

Power Apps

Answered

Format datacard from lookup column

(0) Share

Report

Report

Posted on by td1979

157

Hello again,

I have this list column as number with no decimals

Which is a lookup column in another list that displays correctly

By default the machine number is displayed in my app gallery with lots of following 00000s

And I use the following formula to correct the display

First(Split(ThisItem.'Numéro Machine'.Value; "." )).Result

However I can not apply the same logic to the display in the datacard of a form, it displays with all the zeros

I need to filter the datacard to remove blank machine numbers so the defaultSelectedItems is

Filter(Choices([@MainIntList].'Numéro Machine');!IsBlank(Value))

How do I combine the filter above with

First(Split(ThisItem.'Numéro Machine'.Value; "." )).Result

so that the list is filtering out blank rows and removing the .000000s ??

thanks

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

Verified answer

v-dezhili-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @td1979 ,

Please try:
ForAll(Filter(Choices([@MainIntList].'Numéro Machine');!IsBlank(Value));Text(Value(Value);"0"))

Best Regards,
Dezhi

Was this reply helpful? Yes No
td1979 157 on at

Like (0)

Report
Copy link

Link copied!
Hi, thanks - your solution worked perfectly!

May I pose a second question: In the datacard for the machine number I have the following in the defaultSelectedItem

If( IntMainForm_1.Mode = FormMode.New; Blank(); Parent.Default )

I have tried to incorporate the code example you gave, for example
If( IntMainForm_1.Mode = FormMode.New; Blank(); Text(Value(Parent.Default);"0") )

but with no success, how is this achieved?

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

Like (0)

Report
Copy link

Link copied!
Hi @td1979 ,

Please try:
If( Not(IntMainForm_1.Mode =1); Text(Value(Parent.Default);"0") )

Best Regards,
Dezhi

Was this reply helpful? Yes No
td1979 157 on at

Like (0)

Report
Copy link

Link copied!

I get the following error (which is the same I had with the previous formula)

"Expected Table Value"
"Text or number was expected, We are expecting text or number at this point in the formula"
"The function "Value" contains invalid arguments"

Was this reply helpful? Yes No

Join the conversation