PowerApps Form Dynamic HTML Text Sharepoint List Field

[dihelp]

Hi -

I'd like to create a dynamic HTML Text Sharepoint  List Field that changes based on the users form selection. The HTML Text is used for the products description. On submission of the form it would update the thisitem.description field with the proper template from a excel datasource that would be determined using a if statement and change specific pieces of text in the description. 

After browsing the help forum I found this solution which seems to be close to what I need but it is using the confirmation screen OnVisible property which I'm unable to locate within the form. https://powerapps.microsoft.com/en-us/blog/html-markup-with-dynamic-data/

The If statement would be something like this in layman's terms:

If(AND(thisitem.bestoffer=true, thisitem.condition = "Used", thisitem.returns = true, thisitem.quantity.value <=1), Return the DescName template and populate the {} variables with the current items values.

Template Source:

Any help would be greatly appreciated.

Thank you in advance!

[v-jefferni · Accepted solution]

Hi @dihelp ,

The solution in that blog could be used for your scenario, the only difference from your end is you will need to get the the specific HTML template based on the desc name selection, which you will identify it according to some conditions like the If statement in your post. You could get the line using LookUp function to achieve this goal.

Speaking of populate the {} variables with the current items values, I think you will need to create a blank collection OnVisible of the form's screen, update this collection using Patch based on the item values in this form. Assume that item values will be populated in the form, you will need to update OnChange of data card value controls.

At last, Default of the description data card value, which is a TextInput box, set to the last formula in that blog, SessionInfo collection is the collection I mentioned above and AppSettings is the HTML template filtered from the first step.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.