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 / Displaying Form based ...
Power Apps
Unanswered

Displaying Form based on gallery selected item or last submitted form (Patch to SQL)

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi All,

 

I have created an app where I have a gallery of records created but also a submit page where I can create new records using patch to a sql database. The id for these items is created in sql when i patch. Then, when you want to view the additional info for these records created you can click on the gallery item. I also want to be able to go directly to this additional info screen from the submit new record screen and view this record created but not sure how to do this. 

 

Jeevanj97_0-1627554517501.png

Jeevanj97_1-1627554568676.png

Jeevanj97_3-1627554665097.png

 

 

 

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

    @Anonymous  May I ask  the newly created item is added into the gallery and do you want navigate to the additional info screen from the gallery item ?

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi @PriyankaGeethik yes it is added into the gallery. But currently I am going back to gallery screen after I have created a new record where I can then go into the item by selecting in gallery. I want my powerapp to send the user to the additional info screen when they have created a new record and display that record just created. But also they can go to the additional info screen by selecting the gallery item too which currently works. I just need the ability to view record directly after submitting. Not sure how to do this because it needs to display record if gallery item selected or if submitting a new record

  • PriyankaGeethik Profile Picture
    3,320 Super User 2024 Season 1 on at

    @Anonymous Would you mind trying fetching the newly created item value into a variable and navigate to additional info screen with that variable. Please make sure the variable for the gallery selection and fetching recently patched item should be same. 

    Ex: Set(headeridvar, Patch(tunnel_header....));  

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @PriyankaGeethik What do I need to put in the gallery on select to create the variable. Below is what I have at the moment.

     

    Jeevanj97_0-1627558277626.png

    Jeevanj97_1-1627558401880.png

     

     

  • PriyankaGeethik Profile Picture
    3,320 Super User 2024 Season 1 on at

    @Anonymous  On select of > add Set(headeridvar, Thisitem) and after submitting Navigate to additional info screen.

     

    In additional info screen map all the controls Default value with  headeridvar.[controlvaluerequired]. 

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @PriyankaGeethik great i have done this now. It seems to be working apart from one little thing! When I select the item on gallery the date shows in my additional info screen, but when submitting a new record and it goes to additional info screen the date does not show. The first pic is when navigating from gallery, the second pic is when submitting a new record. 

     

    Jeevanj97_0-1627559621840.png

    Jeevanj97_2-1627559775808.png

     

     

     

     

     

     

     

     

  • PriyankaGeethik Profile Picture
    3,320 Super User 2024 Season 1 on at

    @Anonymous Great! I'm glad it worked. Please share the Default property of Date control. 

     

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up. 

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @PriyankaGeethik it works for every other control, plus the date shows when you select an item from gallery.

    Jeevanj97_0-1627561716651.png

     

  • PriyankaGeethik Profile Picture
    3,320 Super User 2024 Season 1 on at

    @Anonymous Would you please click on the headeridvar variable and check the Date field value when you are on additional info page after create the new item. If the collection below is showing the date value please check the visibility/display mode of the control.  

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @PriyankaGeethik it says the date is blank for some reason, is it because data type is date? 

     

    Jeevanj97_0-1627566177820.png

     

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 June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 326 Most Valuable Professional

#2
11manish Profile Picture

11manish 168

#3
sannavajjala87 Profile Picture

sannavajjala87 75 Super User 2026 Season 1

Last 30 days Overall leaderboard