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.
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.
Try to break the solution and check first if you are getting the required values to update in compose action. The. If it works the you can use same output in Excel row to update, using compose you will be able to bedug easier also try to test with only sample data or 1 row by limiting to test faster and make changes. Hope this helps
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Share
Report
All responses (
Answers (
6
