Sharepoint form cannot display additional field form lookup column

[Anonymous]

In SharePoint list form, I set a column "Organization" which looks up data from another list.

In SP settings for that column, I also checked option "Add a column to show each of these additional fields", to get 1 additional column from that other list.

The additional column doesn't display in PowerApps form. I can see it in PowerApps designer, and option "visible" is "on", but it doesn't show in form when I publish.

Are these additional fields supported in PowerApps? If yes, are there some additional setting for them?

[WarrenBelz]

Hi @Anonymous ,

You are referring to a Lookup field in SharePoint.

As an example if your field was named Primary and the value in the additional field was Secondary and you put in a Gallery with your List as the data source, the Secondary field would be seen in the gallery as: 

ThisItem.Primary:Secondary.Value

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.

[Anonymous]

Hi @WarrenBelz 

Thank you for the info. Yes, I am referring to Lookup field in SharePoint.

I probably did not explain my issue well - I see the additional field in SharePoint list, I see it in PowerApps in design view, but I don't see it in PowerApps live form. I am not sure why.

Is there some special setting for it?

[WarrenBelz]

Hi @Anonymous ,

When you say I see it in PowerApps in design view, but I don't see it in PowerApps live form what exactly do you mean.?

A strange quirk of the automatic field adding in forms is they seem to leave these out, but if you use "Add Field", you will see it in the list. I will display the same as other fields.

Is this what you are referring to?

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.

[Anonymous]

Hi @WarrenBelz 

Thank you for replying. Let me try to explain this through screenshots.

I see field Owning Org: Grouping in design view (attachment "Design view") - that is the additional field. In design view, I set it to be visible in both view and edit mode.

In live form, however, I don't see this field at all (attachment "Live form").

I hope it makes sense now. Do you know why is this happening?

[WarrenBelz]

Hi @Anonymous ,

This is a SharePoint Integration from you have here? We are both talking about the same thing here regards the fields type. Have you gone into the "Customise Forms" in the PowerApps tab and made any edits?

[Anonymous]

Hi @WarrenBelz 

Yes, this is a SharePoint integration.

I did make edits in "Customize forms", I set the field "Owning Org: Grouping" to be visible in both view and edit mode.

Do I need to make any additional change?

Thank you

[WarrenBelz]

Hi @Anonymous ,

I just did a test on this - if you just leave the form as PowerApps/SharePoint creates it, you are absolutely correct - it disappears.

I then made some changes to the form - just moved some controls around in the cards - used File > Save >Publish and then Back Arrow > Back to SharePoint and it now is both view and edit forms in read-only mode.

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.

[Anonymous]

Hi @WarrenBelz 

Thank you for all the help.

I tried moving around the elements on the form, and publishing again. Now it works, I see "Owning Org: Grouping".

However, field "Owning Org: Grouping" doesn't change when I select another value for "Owning Org". Only when I click "Save" and reopen the form, I can see updated value in "Owning Org: Grouping".

Is there a way to refresh "Owning Org: Grouping" dynamically, as I select different values in "Owning Org" dropdown?

[WarrenBelz · Accepted solution]

Hi @Anonymous ,

Try refreshing the data source.

There is another way with these field types in Power Apps. Connect to the data source that contains Grouping and have the field as (adjust list and field names if required)

Lookup(
   YourOtherList,
   'Owning Org' = ThisItem.'Owning Org',
   Grouping
)

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.