cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Titiwai
Helper II
Helper II

HTML Text & Form

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?

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Titiwai ,

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
leyburn19
Memorable Member
Memorable Member

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)

v-xida-msft
Community Support
Community Support

Hi @Titiwai ,

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:1.JPG

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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>
"

Hi @Titiwai ,

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

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?

Hi @Titiwai ,

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,511)