I have two SharePoint List (List 1 and List 2), which have two common Columns Category and Region.
I have created a Gallery with data from List 1 and the Gallery is filtered based on the Dropdowns which comes from List 1 columns Category and Region.
On this same Screen, I added a Display form, which is connected to List 2. And only Attachments are to be displayed and downloaded from List 2 in this Display form. The attachments are to be filtered based on the Category and Region Dropdwons which comes from List 1 but I have the same columns in List 2 as well.
What should the Items property of Attachmenst (display form) to get the data from List 2.
I used Filter(List2,Category.Value = ProductCategoryDDN.Selected.Value && Region.Value=RegionDDN.SelectedText.Value)
But the attachments are not displayed, only document symbol is seen instead of "There is nothing attached." when the dropdowns are selected.
Looking forward for your support and many thanks in advance.
Hi @akashsaraswat19 ,
Could you show us a screenshot of what you are visualizing on your end?
I attempted to reproduce a similar app as you've described in the thread description. In the example shown bellow I have a gallery that displays the list content, including the attachments. Then I have a Display Form that shows me the Attachment referent to the item that is selected in the Gallery.
To make this work you just need to make sure that the Item field from the Form is pointing to the Selected item. In my case the Expression was simply to use "Gallery3.Selected"
Let me know if this helped in any way!
I have similar thing in my PowerAPP. I have a gallery, which then navigates to Display Form when an item is selected from it.
What I want to achieve is, above this gallery add a Display form with only attachments field visible and this Display form is connected to different SharePoint List.
But the Gallery and this Display Form (only with Attachments) have common columns in it which can be selected from DropDown.
Hi @akashsaraswat19 ,
In my power app the function that I used to collect the attachments from the list was the following:
When you filter you get a table of results, so you need to select which of them you would like to retrieve. I filtered in my list "attachment list" for the record with the Title "overtime".
If you insert the filter function into a collection you will see that it will return you a table instead of a row, hence the need of the First function:
Hope this helps!
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.