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 News & Annoucements carousel

Power Apps News & Announcements

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

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

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 (3,939)