Modern Forms Table, Edit Form with Sharepoint List

(0) Share

Report

Posted on by Canerhan87

Hallo,

i have a a Problem with the Choices Column in my Sharepoint List.

Lets call the Column "ChoiceMe". It has Multiselect Option.

I added the "Table" Element from Modern Controls (Name: tblEditColumns)

and the "Form" Element from Moderns Controls.

1. Problem: Table

The Column "ChoiceMe" is empty in the Table view.

Even if there are elements chosen, it does not show them.

How to fix that?

2. Problem: Form

The Form has for "Item" Property the Setting "tblEditColumns.Selected".

It takes the selected item form the Table.

In the preview of the form it shows for the Column "ChoiceMe" :

If the User opens the dropdown, it can NOT see with previous selected elements.

This Elements are at the bottom of the list in an array.

How can this Elements be shown normal in the Dropdown List with a selected box,

like this?

3. Dropwdown with Office User Selection

In the Field "User" you can choose a User from then company.

On the Sharpeoint Site you see the normal User and the profile Picture.

In the Drowndown-Field of the Form, i only see a Number, not the Name or the Email.

How can i change the settings, so i can see the Full Name OR List of Email-Addresses,

where the Editor can pick from?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

v-jefferni on at

Like (1)

Report
Hi @Canerhan87 ,

The default modern Table control doesn't support multiple selected Choices/LookUp columns. A workaround to this issue is using collection where includes all the items and also add a new column to the source, connecting selected choices with a specific separator:

ClearCollect(colItems, AddColumns(SPlist, "AllChoiceMe", Concat(ThisRecord.ChoiceMe, Value, ", ")))

For the second question, you need to unlock the data card, and then modify the DefaultSelectedItems property of the Combo box, remove the brackets from [Parent.Default]

If using the workaround, Item of the form would be different:

LookUp(SPlist, ID = Table.Selected.ID)

Best regards,

Was this reply helpful? Yes No
Canerhan87 8 on at

Like (0)

Report

@v-jefferni thank you, i fixed 1. and 2. Problem
But now i have another Problem. My new Datasource is the collection "colItems" for the table and the Form.
If the User submits the form, it will not change the Sharepoint List,
because the new Source is not the Sharepoint List anymore but the Collection.
How can i fix that?

Do you have a advice for Problem 3 with not seeing the Fullname or Email of our Office Users?

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (1)

Report
Hi @Canerhan87 ,

You need to add the Mail or DisplayName fields to the user Combo box:

and also in DefaultSelectedItems, add below formula so that the same user would be automatically selected from office:

First(Office365Users.SearchUser({searchTerm:ThisItem.User.Email}))

For the new issue, form cannot use collection as data source. So, you should still use the list and populate the form using LookUp with a criterion of ID in Item property:

LookUp(SPlist, ID = Table1.Selected.ID)

Best regards,

Was this reply helpful? Yes No