cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yerlasdutco
Helper III
Helper III

Save changes from PowerApps to SharePoint

Good Day Gents,

 

I faced with a problem in developing of Report tool and no idea how to find a solution.

I have a rich text editor, dropdown, 9+1 buttons and edit form that takes items from SharePoint List. In SP List I have 9 columns as 9 types of Department and 1 column for Reporting Period.

Now, in PowerApps, when I click button of corresponding department1, this button do "UpdateContext to Richtexteditor an DataCardValue of dept1" . Form read all items where Reporting Period equals Dropdown selected item.

Now issue is, to change any content in PowerApps in RichText Editor and save them to SharePoint List. Please help

 

Screenshots attached 

SharePoint ListSharePoint ListButtons in PowerAppsButtons in PowerAppsRichTextEditorRichTextEditorFormForm

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @Yerlasdutco :

You could try :

1\Set the textinput control in People data card

Default

Switch(
 Soz1.Topic,
 "People",
 RichTextEditor1.HtmlText,
 Parent.Default
)

2\Set the textinput control in PGPA data card

Default

Switch(
 Soz1.Topic,
 "PGPA",
 RichTextEditor1.HtmlText,
 Parent.Default
)

……

 

 Best Regards,

 Bof

View solution in original post

4 REPLIES 4
v-bofeng-msft
Community Support
Community Support

Hi @Yerlasdutco :

You could try :

1\Set the textinput control in People data card

Default

Switch(
 Soz1.Topic,
 "People",
 RichTextEditor1.HtmlText,
 Parent.Default
)

2\Set the textinput control in PGPA data card

Default

Switch(
 Soz1.Topic,
 "PGPA",
 RichTextEditor1.HtmlText,
 Parent.Default
)

……

 

 Best Regards,

 Bof

@v-bofeng-msft In Save button, I need to put command, like Textinput1=People.DataCardValue?

Hi @Yerlasdutco 

Sorry, I did not understand what you mean. Shouldn’t the formula in the Save button be

SubmitForm(FormName)

?

Best Regards,

Bof

Just SubmitForm doesn't save the changes.

I wanted to add like 

Patch('General Report', Defaults('General Report'),{Title:"No Title",People:TextInput1.Text, HSE:TextInput2.Text, 'SP&BP':TextInput3.Text, Finance:TextInput4.Text, PGPA:TextInput5.Text, Legal: TextInput6.Text, Operations: TextInput7.Text, 'M&T':TextInput8.Text, 'FGP-WPMP&MCPs':TextInput9.Text}));

 

But this create new Item in General report. How can I add condition, to update selected item by 'reporting period = dropdown1'  f.e

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,594)