Can not upload file from powerapps to sharepoint

Like (0) Share

Report

Posted on 14 Dec 2022 08:33:46 by ITSYS

Dear All,

I try to create an automate to upload data from powerapps to sharepoint. When i run manually, it is successful. But i run in powerapps , it is fail. i see the error " Unable to process template language expressions in action 'Create_file' inputs at line '0' and column '0': 'The template language expression 'triggerBody()['file']['Name']' cannot be evaluated because property 'file' cannot be selected. Please see https://aka.ms/logicexpressions for usage details.'.". Can you please help to resolve it ? Thanks you so much.

All responses (7)

Answers (1)

ITSYS 28 on 17 Dec 2022 at 01:31:15

Like (0)

Report

Re: Can not upload file from powerapps to sharepoint

Hi V-Chengfen-msft,
Thank for your support, the test run have created file success on my sharepoint , then i add this flow to powerapps, but i see the new issue.
"Access denied.
clientRequestId: 2ccc0aa0-df44-44f0-9d35-07b3a135df7d
serviceRequestId: 2ccc0aa0-df44-44f0-9d35-07b3a135df7"

I checked connection in flow, it is normal.
Verified answer

v-chengfen-msft on 15 Dec 2022 at 08:28:36

Like (1)

Report

Re: Can not upload file from powerapps to sharepoint

Hi @ITSYS ,
I found two video explanations, detailed video explanations should help you more

Here are some links for your reference:
https://www.youtube.com/watch?v=5XsWgVnR7SU
https://www.youtube.com/watch?v=UYK7yruBHDM

If this post helps, then please consider Accept it as the solution to help the other members find it.

Best Regards
Cheng Feng
v-chengfen-msft on 15 Dec 2022 at 06:42:55

Like (0)

Report

Re: Can not upload file from powerapps to sharepoint

Hi @ITSYS ,
I found two video explanations, detailed video explanations should help you more

Here are some links for your reference:
https://www.youtube.com/watch?v=5XsWgVnR7SU
https://www.youtube.com/watch?v=UYK7yruBHDM

If this post helps, then please consider Accept it as the solution to help the other members find it.

Best Regards
Cheng Feng
ITSYS 28 on 15 Dec 2022 at 06:23:15

Like (0)

Report

Re: Can not upload file from powerapps to sharepoint

Hi v-chengfen-msft,
The flow run successful with test. but it's failed in powerapps.
v-chengfen-msft on 14 Dec 2022 at 09:13:41

Like (1)

Report

Re: Can not upload file from powerapps to sharepoint

Hi @ITSYS ,
Here is a test for your reference:
Note (remember to include the suffix in the file name, otherwise the file content cannot be recognized)
Here is result:

If this post helps, then please consider Accept it as the solution to help the other members find it.

Best Regards
Cheng Feng
ITSYS 28 on 14 Dec 2022 at 08:59:17

Like (0)

Report

Re: Can not upload file from powerapps to sharepoint

Hi v-chengfen-msft,
As you say, user must input name of files which will be uploaded from powerapps. I try adding Textinput to get Filename but it still same.
v-chengfen-msft on 14 Dec 2022 at 08:44:46

Like (1)

Report

Re: Can not upload file from powerapps to sharepoint

HI @ITSYS ,
The reason for this problem is:
You get the content of the file, not the filename,
You can't get filename with formula

Please try to add a Text input to get the filename from power apps

If this post helps, then please consider Accept it as the solution to help the other members find it.

Best Regards
Cheng Feng