Export dropdown and free-text from rich-text editor to SharePoint list.

(0) Share

Report

Posted on by AL-26080723-0

Dear Community,

I hope I can turn to you for advice.

I have an existing form that has a few fields that get information by using " User().FullName " and " User().Email " to autopopulate.
I have also a field that is based on the above determines the District the user belongs to from a sharepoint list type dataset.
" LookUp('Dataset',Email= EMAIL_ADDRESS.Text,District) "
I have some dropdowns that have rule set to them so the dropdown elements only show people in your District only.
I also have Rich text fields associated to each of dropdown fields. So when the user select his/her choice he/she can also write a supporting text why he/she chose the person appearing in the dropdown.
Example:

I imagined to take the name, Email and district, and also to take the result of the dropdown selection and the rich-text and when clicking on a submit button the app would add it into relevant columns created in a SharePoint list.
Example:

Whenever somebody would vote for "XYZ" person in their own district the SharePoint would just add one row using the relevant columns.

Please help me if there is a solution to export elements selected in a form to a SharePoint list.
Thank you for your contribution in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

anandm08 1,936 Super User 2024 Season 2 on at

Like (0)

Report
Copy link

Link copied!

hi @Liebmann_Attila ,
SubmitForm(you_form_name)

try this

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.

Was this reply helpful? Yes No
AL-26080723-0 80 on at

Like (0)

Report
Copy link

Link copied!

sorry @anandm08 but I don't understand your answer. (Or rather how to apply)

Was this reply helpful? Yes No
AL-26080723-0 80 on at

Like (0)

Report
Copy link

Link copied!

I tried to use Patch function somehow and experimented a bit so far.
Even if it accepted my formula in the end it gave me a bunch of errors.
Test 1.:
this lead to :

Test 2 :

This had a bunch of errors.

Was this reply helpful? Yes No
AL-26080723-0 80 on at

Like (0)

Report
Copy link

Link copied!

Since then I managed to work out the first part. That is now working.:

Patch(
PowerApp_Feedback_SharepointList,
Defaults(PowerApp_Feedback_SharepointList),
{
NominatedBy_Name: NAME.Text,
NominatedBy_Email:EMAIL_ADDRESS.Text,
Nominated_District: DISTRICT.Text,
Nominated_Name:DROPDOWN_NOMINATED.Selected.'{Name}'
}
);

I am still struggling to add the rich text editor's test into the SharePoint list.

Was this reply helpful? Yes No
Verified answer

AL-26080723-0 80 on at

Like (0)

Report
Copy link

Link copied!

By adding it as " .HtmlText " I was able to use it but it formats everything of course as a HTML script.

Solution :
Patch(
PowerApp_Feedback_SharepointList,
Defaults(PowerApp_Feedback_SharepointList),
{
NominatedBy_Name: NAME.Text,
NominatedBy_Email:EMAIL_ADDRESS.Text,
Nominated_District:DISTRICT.Text,
Nominated_Name:DROPDOWN_NOMINATED.Selected.'{Name}',
Rich_Text_Editor:RichTextEditor1.HtmlText
}
);

It displays it on the sharepoint list as :

Is there any easy fix for this ?

Was this reply helpful? Yes No