web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / What to use as Default...
Power Apps
Unanswered

What to use as Default so that chosen items can show on edit for app that converts apps to HTML before updating to sharepoint

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Howdy Y'all,

 

I have a case where an app is gathering names and links to documents from multiple sources then combining them into a collection. This is so that in one column, someone can select a group of documents that are not housed on the same sharepoint site. The user selects from a list of document names, then the app creates an entry in sharepoint that is a list of document names, but each name is also a clickable link that brings you to the document. This is done using a combobox that displays the document names, then in the same card is a hidden HTMLtext box. This brings in the selected items from the combobox and creates the list of links using 'name' and 'link'.  Then the card's update field has the content of the HTML. 

 

The issue I am facing is that I currently have nothing in the default section of the combobox. this leads the combobox to clear out on edit. I don't know how to bring my selections back into the combobox since technically they were never saved. Any suggestions on what needs to be in the default field. 

 

OnVisible: ClearCollect(AllDocData,ShowColumns('Location 1 Standard Work Instructions',"{Name}","{Link}"),ShowColumns('Standard Documents',"{Name}","{Link}"),ShowColumns('Location 2 Standard Work Instructions',"{Name}","{Link}"))

 

Combobox Items : AllDocData

 

HTMLText: Concat(DataCardValue20_1.SelectedItems,Concatenate("<a href='",'{Link}',"'>",'{Name}',"</a><br>"))

 

Update: HtmlText1.HtmlText

 

TLDR: How do I take just the '{Name}' items from the HTML text and get it back into the combobox so that they show up on edit?

Categories:
I have the same question (0)
  • StalinPonnusamy Profile Picture
    Super User 2024 Season 1 on at

    Hi @Anonymous 

     

    I might over simplifying. Thus gives the name.

     

     

    PlainText(HtmlText1.HtmlText)

     

     

  • StalinPonnusamy Profile Picture
    Super User 2024 Season 1 on at

    Hi @Anonymous 

     

    StalinPonnusamy_0-1634333609307.png

     

    PlainText(HtmlText1.HtmlText)
    
    Or
    
    PlainText(RichTextEditor1.HtmlText)

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Just tried these, but they don't grab anything from sharepoint, so it still doesn't know what to put in the field on edit.

     

    using PlainText(thisitem.'column name') gives a text field when the combobox expects a record value. Is there a way to bring in the column value and satisfy the combobox?

  • StalinPonnusamy Profile Picture
    Super User 2024 Season 1 on at

    The HTML editor has the name of the document. You need to set the DefaultSelectedItems property to

    [PlainText(HtmlText1.HtmlText)]

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    This still has the issue of a resulting in a text value rather than a record. Is there a good way to convert them? I am struggling to find one.

  • StalinPonnusamy Profile Picture
    Super User 2024 Season 1 on at

    We can use Lookup to get the record

    LookUp(SPListName, Name=PlainText(HtmlText1.HtmlText))

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Unfortunately this is creating a circular argument and the app still ends up with no data in the combobox on edit

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 846

#2
Valantis Profile Picture

Valantis 532

#3
Haque Profile Picture

Haque 410

Last 30 days Overall leaderboard