Unanswered

Two fields feeding one SharePoint list column

(0) Share

Report

Posted on by Matt-BH

Hi all,

I have a generated powerapp attached to a SharePoint list. One column in the SP list is called "Comments".

Can we have two field within the PowerApp, always be blank, and be able to send information to the one SP list column, then for that information to be displayed as a read only in a separate space within the powerapp.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Matt-BH ,
If you would like to combine/concatenate Date and Comments and add it to Comments column in your SP list, it can be done by using below formula on Update property of Comments Datacard -
DatePicker1.SelectedDate & " : " & TextInput1.Text
Where DatePicker1 control will have Date and TextInput1 control will have Comments added by the user.
You can add these 2 controls onto your form and make the visibility of Comments DataCard to false or make the display mode to view.
OR
If you have 2 columns in SP List named Date and Comments and you would like to show the result of these columns in your power app form, then you can add a TextInput control in your form with below formula in Default property of it -
ThisItem.Date & " : " & ThisItem.Comments

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (0)

Report
Hi @Matt-BH ,

For SharePoint integration, you can use custom field cards along with Patch function OnSave/OnSuccess of the control. Please follow below steps:

1. Add two custom cards in SharePointForm1:

2. Copy the controls from the two default cards

3. Change OnSuccess of SharePointForm1:

Patch(SPListName,SharePointForm1.LastSubmit,{comments:"Concatenate inputs of controls in custom cards"});ResetForm(Self); RequestHide()

4. Set Display Mode of Comments Data Card Value to DisplayMode.View

5. Remove the two system Cards from SharePointForm1, save and publish.

Note:

This should only work for create new items, edit exists need use another edit form and link OnNew and OnEdit with different forms. The reason is on editing exists need to modify the saved comments.

Best regards,

Was this reply helpful? Yes No