cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Titiwai
Level: Powered On

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
Community Support Team
Community Support Team

Re: HTML Text & Form

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
Super User
Super User

Re: HTML Text & Form

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)

Community Support Team
Community Support Team

Re: HTML Text & Form

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.
Titiwai
Level: Powered On

Re: HTML Text & Form

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

Community Support Team
Community Support Team

Re: HTML Text & Form

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

Titiwai
Level: Powered On

Re: HTML Text & Form

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?

Community Support Team
Community Support Team

Re: HTML Text & Form

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.
Titiwai
Level: Powered On

Re: HTML Text & Form

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
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (4,275)