Power Platform Community Forum Thread Details

Hi Everyone,

I am hoping to get some help on something I have been working on for a while today and everything I try fails. The current situation is that I have a simple form named 'Input_Files_Form' which is linked to a SharePoint list named 'Files'.

It has 3 fields shown to the user: | Title | Attachments | Owner |

Currently the Title field is a dropdown that is populated from a SharePoint list called 'System List' (not sure if this is relevant but it might be given no luck with reading other solutions).

I have another SharePoint list named 'Users' which has 3 columns -> | Title | Owner | Active | which are all populated with information. Owner is a person/group type field.

What I am trying to achieve is for when someone uses my form, they select a title from the dropdown and the owner field of the form is populated by matching the title selected in the dropdown and matching it with the title in 'Users'. I was trying to accomplish this by using:

LookUp('Users',System.Value=ThisItem.Title,Owner)

After it is prepopulated, the user will submit the form and the 'Files' sharepoint list will be updated with a title, attachment & owner.

I am not getting errors but the field remains blank.

Any help would be much appreciated.

Categories:

Building Power Apps