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 List
Buttons in PowerApps
RichTextEditor
Form
Solved! Go to Solution.
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
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
User | Count |
---|---|
256 | |
110 | |
90 | |
51 | |
44 |