Answered

Submit to sharepoint button formula problem

(0) Share

Report

Posted on by iwannabfishn

I have a button that is suppose to submit to a PowerAutomate workflow. It is sending values to a PowerAppsV2 workflow. One of the values is an optional text field. This is also submitting an attachment to a sharepoint document library and updating some meta data. When I changed it from required to optional, the run formula changed from 'Upload'.Run(Text, Text_1, Text_2, {file:Record}) to this 'Upload'.Run(Text, Text_2, {text:Text, File:Record}. I can't figure out how to enter this information correctly. Here it was originally 'Upload'.run(Title.Text, ISNum.Text, Comments.Text, contentBytes: First(Attachment.Attachments).Value, Name: First(Attachment.Attachments).Name})

I have tried this as the new value, but it isn't accepting this as a formula.

'Upload'.run(Title.Text, Comments.Text {ISNum.Text, contentBytes: First(Attachment.Attachments).Value, Name: First(Attachment.Attachments).Name}})

Any idea on how to fix this? and why this keeps happening when I make a text field optional?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @iwannabfishn ,

Could you please show me your flow?

Best Regards,

Bof

Was this reply helpful? Yes No
Verified answer

iwannabfishn 76 on at

Like
a
(0)

Report
Copy link

Link copied!

So, I did find the answer to this question. It was consistent. When a text field is made optional, the run formula puts it in the curly brackets like this. This is the formula that is working.
'Upload'.run(Title.Text, Comments.Text, {text:ISNum.Text, contentBytes: First(Attachment.Attachments).Value, Name: First(Attachment.Attachments).Name})
If I change the ISNum field to be mandatory the formula will move it outside the curly brackets. Weird but this is what works.

Was this reply helpful? Yes No