Uploading Files to Document Library using PowerApps

[Sidhant_02]

Hi everyone,
I was working on a requirement wherein I had to upload files (file type can pdf,jpg, txt,etc and it can be more than 1) using Power Apps. So for that I created a Document library in my SharePoint site (named: DEMO_PowerApps) and the document library is named ('IZ'). In this Document library I have created few sub-folders like the following:

To upload files in the Document library I am using Power Automate Flow which is as follows:

So here basically I have created an Instant cloud flow and created a condition (which always evaluates to false) and have used the SendEmail activity in which I am defining the attachments (like name of File, Folder path, content) have used Dynamoic Expression : Ask in Power Apps (for the Yes Part) and then I am using the same defined parameters in Creating a SP file in the Document library.
Now one is issue is  when I am uploading the file in the Folders I am able to only see till Level-1 folders like in my Document Library (Intelizign) there are the following levels:
Main Level:
Folders: PLM, Software Services

(In Software Services: Mendix , Polarion). So currently the drop-down is only showing till Main level the other nested folders are not displayed and the second thing is there are duplicates:

So the flow is working fine (like I selected Intelizign/PLM) and uploaded a file pdf it gets uploaded properly in that file location.

So my final expectation is like this:

In the main drop down it will list all the folders at the very first level (here it will be PLM, Software services). Based on the selection made in drop down 1 (Suppose users selects PLM) then only the respective file or sub-folders should be shown (like in PLM there is only one sub-folder so it only show that folder in the second drop-down).
For Type: Drop down there will some choices that will be shown user can select one or more and that should be associated with all the attachments.

2. Associating Types with all the attachments
Now my upload screen looks:

I want to add another column in the document library named: Type which is a choice column (which will have certain choices) and the choices will be dependent based on the Destination choice selected.
Example:
Assume we have following choices: security, implementation, data-consume, certification, api.
So if user selects PLM then only show: implementation, data-consume, certification.
For Software Services: security, implementation, api.
And then after clicking on Upload the selection (type) should also get associated with the uploaded file, if user has uploaded 3 files and has chosen Type: security,implementation should get that value associated with it (multi-selection).

Do let me know on how to proceed further, hoping for some help for this topic.

Regards,
Sidhant.

[BCBuizer]

Hi @Sidhant_02 ,

I'm not quite sure what it is you are trying to do in your last post, but the use of the ClearCollect function will re-introduce delegation issues, so I would try to stay away from that and rather connect to the data source directly.

The direct connection can be implemented using a Filter function in the Items property of the gallery. If you can share the names of the drop downs you are using and which property they are supposed to be filtering by, I can support with the actual formula.