cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TMMK64571
Helper I
Helper I

Passing value from one Display form to another as a Filter

I have a Display Form that shows the details of a request from one SharePoint list, and I want to store the "Req Number" and pass to it on to a Display Form from a different SharePoint list where there is a "Number with Leading Zeroes" value in common.  I want the user to be able to navigate from one form to the other to get more information.  I will add another button to Requisition Details to navigate to the other form if I can find a solution.

 

 Original Search formOriginal Search formAdditional Details formAdditional Details form

1 ACCEPTED SOLUTION

Accepted Solutions
mdevaney
Super User
Super User

@TMMK64571 

From about your issue I understand ReqForm in SPListRequisition has a matching value called NumberWithLeadingZeros in SPListSubmission.  To show the details for the specific item number please put this code in the Items property of your form on the Submission Details screen.

 

First(Filter(SPListSubmission, DataCardValue_ReqNumber.Text=NumberwithLeadingZeros));

DataCardValue_ReqNumber should be the name of your datacard from the Requisition details screen.  Number With Leading Zeros should be the name of your column from SPListSubmission.  If there are spaces in the name it will be something like Number_x0020_with_x0020_Leading_x0020_Zeros

 

 

---
Please click "Accept as Solution" if my response helped to solve your issue so that others may find it more quickly. If your thought the post was helpful please give it a "Thumbs Up."

View solution in original post

4 REPLIES 4
mdevaney
Super User
Super User

@TMMK64571 

From about your issue I understand ReqForm in SPListRequisition has a matching value called NumberWithLeadingZeros in SPListSubmission.  To show the details for the specific item number please put this code in the Items property of your form on the Submission Details screen.

 

First(Filter(SPListSubmission, DataCardValue_ReqNumber.Text=NumberwithLeadingZeros));

DataCardValue_ReqNumber should be the name of your datacard from the Requisition details screen.  Number With Leading Zeros should be the name of your column from SPListSubmission.  If there are spaces in the name it will be something like Number_x0020_with_x0020_Leading_x0020_Zeros

 

 

---
Please click "Accept as Solution" if my response helped to solve your issue so that others may find it more quickly. If your thought the post was helpful please give it a "Thumbs Up."

Unsupported data type errorUnsupported data type error

 

@mdevaney This gives me an error as shown above.  I think I misunderstood the instructions, please help me find my error.

 

I think the problem is you are referencing the datacard instead of the label.

On the left side menu find the card Req Number_Datcard. Now drill down into the card and there will be four components: star, error, value and key. You want to reference the label that stores the value.

If you can’t get it to work please also take a screenshot of your left side menu with the controls showing.

That was it - thank you.  I knew it was something simple.

Helpful resources

Announcements
Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (4,187)