Power Platform Community Forum Thread Details

Hi All,

I have two list.

1. "ChildList" with two column -"ChildRequestNumber" (lookup) & "ChildRequesterName" (SingleLine text)

2. "ParentList" with two column - "ParentRequestNumber" (Number type filed) & "ParentRequesterName" (SingleLine text).

Here "ChildRequestNumber" is lookup with "ParentRequestNumber".

In powerapp form, in new form, on selection of "ChildRequestNumber" lookup field I am fetching data from "ParentList" and displaying in power app form. for ex - I am fetching "ParentRequesterName" data and displaying in "ChildRequesterName" filed. Its working fine.

I wrote on default property of "ChildRequesterName" filed -: LookUp('ParentList', 'ParentRequestNumber' = Value(DataCardValue35.Selected.Value),'ParentRequesterName').

But in edit form of powerapp, "ChildRequestNumber" (lookup) is showing with extra zeros (because it is lookup with number filed) so to remove extra zero, I wrote

on defaultselectedItem - {
Id: LookUp('ParentList', 'ParentRequestNumber' = Value(ThisItem.ChildRequestNumber.Value), ID),
Value: Text(Value(ThisItem.ChildRequestNumber.Value), "[$-en-US]##,###,###")
}

This is also working fine and removed extra zero. But "ChildRequesterName" is showing empty in edit form. Even I have used same formula in edit form also:

on default property of "ChildRequesterName" filed -: LookUp('ParentList', 'ParentRequestNumber' = Value(DataCardValue35.Selected.Value),'ParentRequesterName').

Note- DataCardValue35 is same in both new and edit form.

If we set default property of "ChildRequesterName" filed to parent.default it will work fine but when again selected lookup column it data will not change because it is set parent.default.

Please help me out in this. what I need to do to show data in edit form by default and after selection of lookup filed.

Thanks a lot !

Categories:

Building Power Apps