Power Platform Community Forum Thread Details

I have power automate buttons to update rows in an excel spreadsheet on sharepoint. The buttons work fine when it is just a number being written to excel and I have done literally 100's and never had an issue

For example below the numbers in each on the financial year columns are correctly being written to the excel file row

I now have output as per below in the format of a number and % in brackets as per line in green, however I cannot get the power automate button to write them to excel. The only error I get is 'there is a problem with the flow trigger' 'Action Manual Failed'

The measures that create the financial year figures in the line in green returns the data in the format below.

return IF(ISBLANK(FORMAT(_Pos, "#,##0") & " " & "(" & FORMAT(_RatePos, "Percent") & ")"),0,FORMAT(_Pos, "#,##0") & " " & "(" & FORMAT(_RatePos, "Percent") & ")")

I have tried formatting the actual measures as 'General' and 'text' and made sure I have the same format in the excel spreadsheet, but it still will not write anything. I have recreated the power automate flows and still no good. This is the first time I have tried writing data in this format so I don't know the issue is.

Any help would be greatly appreciated.

Categories:

Power Automate Desktop