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 / Allowing reviewers to ...
Power Apps
Answered

Allowing reviewers to add comments to a completed form in view mode

(0) ShareShare
ReportReport
Posted on by 312

I have a requirement to send a completed form in view mode and allow reviewers to add comments. I have an initial screen that asks reviewers to select a record and click a button to review the form. The button sends them to a second screen where I have two forms, the form they are reviewing and another one where they can add comments (connected to the same data source). I used the following formula in OnSelect: 

Set(varRecord,ComboBox1.Selected);Navigate(scrViewMode);ViewForm(frmViewMode);EditForm(frmReviewerComments)

 

When I preview the app, it works perfectly. The reviewer is taken to a screen where they can view the completed form and add comments. When I share it with a link or embed it, it gets stuck getting the data (2nd screenshot). I'm thinking it's because I have 2 forms on one screen and/or because I have too many commands on OnSelect (?) Does anyone have any ideas for making what I am trying to do work better, OR achieving my requirement another way? (I am open to connecting the second form to another data source if that might help). I think it MUST be possible to allow reviewers to comment on a completed form, but I haven't been able to find a cleaner way. I hope there's an obvious feature that I'm just missing. Thanks in advance! 

Screenshot 2023-04-06 at 4.06.06 PM.png

Screenshot 2023-04-06 at 4.11.28 PM.png

 

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

    Hi @KBeale,
    Can you please share item property of EditForm (frmReviewerComments) and ViewForm (frmViewMode).

  • KBeale Profile Picture
    312 on at

    Both of them use the varRecord that I set in the button! (And nothing else). Thanks in advance for your insights! 

     

  • NandiniBhagya20 Profile Picture
    4,667 Super User 2024 Season 1 on at

    Hi @KBeale ,
    Can you please try changing the Item property of edit and view form to below - 
    LookUp(SPListName, ID = Value(varRecord))

  • KBeale Profile Picture
    312 on at

    Hi @NandiniBhagya20! When I enter the formula you suggested I get error message that the Value function expects text or a number. Thanks again for your help! 

  • NandiniBhagya20 Profile Picture
    4,667 Super User 2024 Season 1 on at

    Hi @KBeale,
    Try using below - 
    LookUp(SPListName, ID = Value(ComboBox1.Selected.Value))
    Check the column name of result in ComboBox1, here I have assumed it to be Value

     

  • KBeale Profile Picture
    312 on at

    Hmm. The column it "Title." When I tried the new formula you suggested - in my case

    LookUp('Program Planning Model', ID = Value(ComboBox1.Selected.Title)) - I the second screen is not populated with the record I selected in the dropdown box, and I am still seeing the "Getting your data" message in the actual app 😞 

  • NandiniBhagya20 Profile Picture
    4,667 Super User 2024 Season 1 on at

    Hi @KBeale,
    Can you please check the result of below formula by putting it in Text property of Label control -
    Value(ComboBox1.Selected.Title)
    Is the datasource same of frmViewMode and frmReviewerComments form? If yes, same formula will go in Item property of both the forms.

  • KBeale Profile Picture
    312 on at

    I get a pop up error message that "The value 'Program 3' cannot be converted to a number." Thanks again for spending time on my issue! 

  • NandiniBhagya20 Profile Picture
    4,667 Super User 2024 Season 1 on at

    Hi @KBeale,
    Apologies, I thought that ID column gets populated in combobox.
    Can you please replace columnName with the column name which has "Program 3" in it. If the column is of type Single line of text use below formula in Item property of form - 
    LookUp('Program Planning Model', columnName = ComboBox1.Selected.Title)
    If the column type is of choice, use below formula in Item property of form - 
    LookUp('Program Planning Model', columnName.Value = ComboBox1.Selected.Title)

     

  • KBeale Profile Picture
    312 on at

    The column is the Title column so I added LookUp('Program Planning Model', Title = ComboBox1.Selected.Title) to the Items property in both forms. It worked when I tested, and then for a minute when I opened the app itself, but then went back to endlessly "getting your data." 😞 Thank you again for your patience, and can you think of any other reason why this would be happening? Can I confirm that on principle, using two forms on one screen should work? 

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 356 Most Valuable Professional

#2
11manish Profile Picture

11manish 225 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 211

Last 30 days Overall leaderboard