cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

I want to view related to the specific record I have captured

Hi

 

When I have saved an attachment  it becomes available on my gallery with the attachment name and date and time the attachment was saved .I need to  allow my users to be able to go back and view the incident and the specific attachment for that incident only ,not all the attachments that user has saved.

 

Iam currently Filtering my gallery Filter('RiskApp vehicle attachments ','Created By'.Display Name=User().FullName) but in actual fact I want any user to  view that attachment but has to be  that specific  attachments linked to an  incident I have captured and not attachments for other incidents .How can I achieve this ?

 

Regards

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Dual Super User III
Dual Super User III

Re: I want to view related to the specific record I have captured

Hey @rmaziwis 

 

On the second screen, you can set the Item property of the control as:

GalleryName.Selected

This will work in a case where the items property of the edit form and gallery points to same datasource.

OR

LookUp('RiskApp vehicle attachments ', IncidentNo = GalleryName.Selected.IncidentNo)

Here, IncidentNo is an assumed name of column in the datasource.

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

Highlighted
Community Support
Community Support

Re: I want to view related to the specific record I have captured

Hi @rmaziwis

 

Does these galleries and form come from the same data source?

What is the Items property of vehicle incidents gallery ?

I think you should add Set(incidentID, ThisItem.ID) to next arrow of galVehicle_Incidents.

And in vehicle incidents gallery, use filter function to filter out the that Incident, and use IsBlank() to check if there is any attachment name in that incident. So the items property of vehicle incidents gallery should be: 

 

Filter('Data source', ID=incidentID && !IsBlank(GlobalINC))

 

Then, the gallery will only show the selected incident, and if there is no attachment name , the gallery is empty, if you have patch any attachment name, it will show that incident.

Also in the Vehicle attachment Form, I think you should use Editform to submit the Attachment to the selected incident.

Set the Items property of form: LookUp('Data source',ID=incidentID)

If my understanding is somewhere wrong, please tell me and correct it.

Best regards,

Sik

If my post is helpful for you, please click on “Accept as Solution” to help other members find it more quickly.

View solution in original post

4 REPLIES 4
Highlighted
Dual Super User III
Dual Super User III

Re: I want to view related to the specific record I have captured

Hey @rmaziwis 

 

On the second screen, you can set the Item property of the control as:

GalleryName.Selected

This will work in a case where the items property of the edit form and gallery points to same datasource.

OR

LookUp('RiskApp vehicle attachments ', IncidentNo = GalleryName.Selected.IncidentNo)

Here, IncidentNo is an assumed name of column in the datasource.

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

Highlighted
Community Support
Community Support

Re: I want to view related to the specific record I have captured

Hi @rmaziwis

 

Do you mean when you select the incidents in gallery, the second screen will show the selected incidents' attachments? Is that a Editform in the second screen?

You can set ViewForm(datEditAttach_1);Navigate('Attach vehicle incidents',ScreenTransition.None) to OnSelect of Right Arrow in Gallery. And Set GalleryName.Selected to Items property of EditForm.

When you select the right arrow of each incident, it will navigate to form and view the corresponding incident attachment.

Note: In view mode, the attachments can't be selected. if you still want to select the attachment, please post back.

Snipaste_2019-11-14_10-57-18.png

Best regards,

Sik

If my post is helpful for you, please click on “Accept as Solution” to help other members find it more quickly.

Highlighted
Resolver I
Resolver I

Re: I want to view related to the specific record I have captured

Hi 

 

Please note on your first question I do not select anything it must be blank because I have not yet attached anything  but it currently shows me attachment names from previous incidents which is not correct and that is what Iam trying to resolve.

By clicking the add icon it takes me to the attaching screen which must show me the attachment name that is linked to that incident, then I just save and yes that form is an Edit form.I then click the save button then it submits  it  to the gallery .If I click the next icon a can view the attchement.But it should only be that attachment. 

Please see may detailed process

 

  1. After I create and save an incident it comes to the Browse vehicle incidents screen which is where I can see the most recent incident in descending order .We are using incident number 10 as an example see screen shots).I have a next arrow that uses the below formula Set(GlobalINC,galVehicle_Incidents.Selected.Attachmentnumber);Navigate(frmRP_VehicleView,ScreenTransition.None)Please note in this formula I have a field that is called the Select .attachment number which I rename to attachment name(as the display) that is the Title or Attachment name that ure seeing in the attachment gallery same name in my SharePoint list.
  2.   The frmRP_Vehicle view form  is a display form I use to display the entire incident for the user to see but that is where they see the Attach icon .Once they  click that attach icon it uses a formula to navigate to the attachments gallery.(see view for incident number 10 and the attachment name  that the user captured) .
  3.  After clicking the attach icon (Navigate('Attach vehicle incidents',ScreenTransition.None) it takes user the vehicle incidents gallery so at this point the gallery must be blank because I have not added an attachment as yet for incident 10 .I should not be seeing any attachment names, I have saved for previous incidents which is what I trying to achieve or resolve
  4. I then on my gallery select the add icon + sign to go to the form where I add the attachment and this is an editable form I use this formula(NewForm('Vehicle attachment Form');Navigate('Vehicle Incidents Attachments',ScreenTransition.None)
  5.  On the attach screen where I save the attachment the attachment name field already picks up the attachment name 1234 as this is a default value set on that field but must show the exact name user captured when creating the incident .That field's display mode is disabled not to allow the user to edit .This is the formula(If(IsBlank(ThisItem.'Attachmentname'),galVehicle_Incidents.Selected.Attachmentnumber,ThisItem.'Attachment name')
  6. Once I attach the document I click the save button with this formula  Submit Form('Vehicle attachment Form');If('Vehicle attachment Form'.ErrorKind=ErrorKind.None,Navigate('Attach vehicle incidents',ScreenTransition.None)).it takes user back to the gallery and should only see incident attachment  for incident number 10 which is what aim trying to achieve .

I hope it makes sense and I apologize for any spelling mistakes ,ink etc.. as  Iam just trying to make it more clear.

Highlighted
Community Support
Community Support

Re: I want to view related to the specific record I have captured

Hi @rmaziwis

 

Does these galleries and form come from the same data source?

What is the Items property of vehicle incidents gallery ?

I think you should add Set(incidentID, ThisItem.ID) to next arrow of galVehicle_Incidents.

And in vehicle incidents gallery, use filter function to filter out the that Incident, and use IsBlank() to check if there is any attachment name in that incident. So the items property of vehicle incidents gallery should be: 

 

Filter('Data source', ID=incidentID && !IsBlank(GlobalINC))

 

Then, the gallery will only show the selected incident, and if there is no attachment name , the gallery is empty, if you have patch any attachment name, it will show that incident.

Also in the Vehicle attachment Form, I think you should use Editform to submit the Attachment to the selected incident.

Set the Items property of form: LookUp('Data source',ID=incidentID)

If my understanding is somewhere wrong, please tell me and correct it.

Best regards,

Sik

If my post is helpful for you, please click on “Accept as Solution” to help other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,527)