HTML Text & Form

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a HTLM text that is linked to a form using concat function.

So if the datacardvalue in form is updated, unless I click on SubmitForm the HTML text value would not update.

Is there any way to active the link between the two to achive the target?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

leyburn19 2,157 on at

Like
a
(0)

Report
Copy link

Link copied!

I would capture the ID before getting to the form and put it in a variable, or you could hav ethe ID in a hiddent datacard.

Then I would do a filter in your conact like

cancat(Source,ID=variable)

or

Concat (Source, ID=Value(DataCardValue?.Text)

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you please share a bit more about your issue?

Do you mean that the concatenated HTML text value would not be updated in real time when the data card value is updated in your Edit form?

Could you please share a bit more about your concat formula?

Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. If you want to concatenate the data card values within the Edit form, I think the Concatenate function would be better than Concat function in your scenario.

I have made a test on my side, the screenshot as below:

Set the Html Text property of the Html text control to following:

"Form Details as below: <br>" &
Concatenate(
"Title: ", EditForm1.Updates.Title,
"<br> ProjectName: ", EditForm1.Updates.ProjectName,
"<br> Executor: ", EditForm1.Updates.Executor.DisplayName,
"<br> Due Date: ", Text(EditForm1.Updates.DueDate)
)

On your side, if you want to reference the Data card value from your Edit form, please use the following formula:

EditForm1.Updates.ColumnName /* <-- EditForm1 represents the Edit form in your app */

Please consider take a try with above solution, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Below is my codes for HTMLTEXT. It is a table mimics what how the form lays out on screen.
It does not refeshes itself when form datacardvalue gets updated.
"
<!DOCTYPE html>
<html>
<head>
<style>
table, th, td {
border: 1px solid black;
}
</style>
</head>
<body>
<h2>Report for " & DataCardValue235.Text & " Dated " & DataCardValue234.Text & " </h2>
<p>Please login to Powerapps to approve.</p>
<Table style='width:100%'>
<tr>
<th>Unit</th>
<th>Total</th>
</tr>"
&
Concat(Filter('List Unit',Key=VarUnitKey),
"<tr><td>" & "100 Dollar: " & 'CafeRight-100 Dollar' &
"</td><td>" & "" &
"</td></tr>" &
"<tr><td>" & "50 Dollar: " & 'CafeRight-50 Dollar' &
"</td><td>" & "" &
"</td></tr>" &
"<tr><td>" & "20 Dollar: " & 'CafeRight-20 Dollar' &
"</td><td>" & "" &
"</td></tr>" &
"<tr><td>" & "10 Dollar: " & 'CafeRight-10 Dollar' &
"</td><td>" & "" &
"</td></tr>" &
"<tr><td>" & "5 Dollar: " & 'CafeRight-5 Dollar' &
"</td><td>" & "" &
"</td></tr>" &
"<tr><td>" & "2 Dollar: " & 'CafeRight-2 Dollar' &
"</td><td>" & "" &
"</td></tr>" &
"<tr><td>" & "1 Dollar: " & 'CafeRight-1 Dollar' &
"</td><td>" & "" &
"</td></tr>" &
"<tr><td>" & "50 Cent: " & 'CafeRight-50 Cent' &
"</td><td>" & "" &
"</td></tr>" &
"<tr><td>" & "20 Cent: " & 'CafeRight-20 Cent' &
"</td><td>" & "" &
"</td></tr>" &
"<tr><td>" & "10 Cent: " & 'CafeRight-10 Cent' &
"</td><td>" & "Total Cash: " & 'Total Till - Cash' &
"</td></tr>" &
"<tr><td>" & "Visa & Master: " & 'CafeRight-Visa & Master' &
"</td><td>" & "" &
"</td></tr>" &
"<tr><td>" & "Amex & JCB: " & 'CafeRight-Amex & JCB' &
"</td><td>" & "" &
"</td></tr>" &
"<tr><td>" & "Diners Club: " & 'CafeRight-Diners Club' &
"</td><td>" & "Total EFTPOS: " & 'Total Till - EFTPOS' &
"</td></tr>" &
"<tr><td>" & "" &
"</td><td>" & "Total Till: " & 'Total Till' &
"</td></tr>" &
"<tr><td>" & "" &
"</td><td>" & "CafeRight-Total Vend: " & 'CafeRight-Total Vend' &
"</td></tr>" &
"<tr><td>" & "" &
"</td><td>" & "Variance: " & Variance &
"</td></tr>" &
"<tr><td colspan=2>" & "Shift Report:" & 'Shift Report' &
"</td><td>" & "" &
"</td></tr>"
)
&
"</Table>
</body>
</html>
"

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Have you taken a try with the solution I provided above?

I have made a test on my side, I think the solution I provided above could achieve your needs. Please take a try with it, check if the issue is solved.

When you want to reference values from the Data cards in your Edit form, please use the following formula:

EditForm1.Updates.ColumnName

rather than DataCardValue1.Text, DataCardValue235.Text, DataCardValue234.Text, ...

Best regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you! The update works but.
Update only apply to item that is showing in the form.
What if there is a field that is only used in Display form that won't have .update property?

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ，

I assume that your Display form connects to the selected item in a Gallery control (The Gallery connects to your data source), you could reference the displayed value from the Display form within your HTML Text using the following formula:

BrowseGallery1.Selected.ColumnName

Or

'The Item property formula of the Display form'.ColumnName

Note: 'The Item property formula of the Display form' represents the formula you used within the Item property of the Display form.

Please take a try with above formula, check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Discovery, the form.updates funcation works fine except need to add a resetform on transition of records if not the updates from 1st unsaved record will carry over to the next record and even if there is no change made the update would still be reflected in recored after submit.
So I do wonder the .updates having some sort of patch/submit property as well.

Was this reply helpful? Yes No