Powerapp to run Powerautomate flow to write attachment data into Sharepoint Document library

[SGP_SGR]

Hi Guys,

I have a PowerApps app that needs data stored in a attachment control to be uploaded into a sharepoint document library.

Video I have followed this tutorial to get my powerapps and power automate to write successfully.

‘’Powerapp-JSON’.Run(JSON(colImages, JSONFormat.IncludeBinaryData));	

I am calling this Power automate function via the following command. 

Right now i have written my Power Automate function to write to a Particular folder in the library which is called "Asia"

 

As in my Powerapps, i have other Regions like Europe, North America, Africa etc which is stored inside a variable called varRegion.

So what i am trying to do is this, im trying to tweak my power automate to get an input from powerapps which is the region so that the automation can create file in the correct folder location. 

Can i know how can this be done? I tried using the PowerApps v2 to request for an input, which i can do for Region and JSON. but i am not able to parse the JSON output correctly. 

If you see the JSON scheme is not reflecting correctly. 

I am kinda stuck here on how to proceed further. The only workaround would be to create 5 seperate flows for each region and then use a IF statement inside PowerApps code to check against the varRegion variable.

Appreciate any help in advance. Thanks

[v-jefferni · Accepted solution]

Hi @SGP_SGR ,

You should use PowerApps V1 trigger, use two 'Ask in PowerApps' dynamic contents in the flow, one for Region the other for uploading files. So, in your App you need to pass two values to the flow. And in the flow, use a Compose to create dynamic folder paths based on the Region, use the result in Create file action:

[SGP_SGR]

Thanks, tried this method and it works.. Appreciate it. Have marked answer as solution. 

[obrienk]

How do I obtain this app so I can download and update SPSS license?