cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dihelp
Frequent Visitor

PowerApps Form Dynamic HTML Text Sharepoint List Field

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:

dihelp_0-1640575309945.png

 

Any help would be greatly appreciated.

 

Thank you in advance!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-jefferni
Community Support
Community Support

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.

 

 

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

1 REPLY 1
v-jefferni
Community Support
Community Support

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.

 

 

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

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