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 III
Super User III

@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 III
Super User III

@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

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
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,133)