Hi @RPA_Noob,
Greetings for the day!!
I've examined the code from your screenshot, and overall, it appears fine to me. However, there's one aspect that requires some scrutiny.
During debugging, please ensure to verify whether the variable, after splitting, contains any blank data in the first row of your claimant variable like below.
If that's the case, you can use replace action instead of split to replace your "Claimant" with empty string or directly reference the claimant index number as like below yellow highlighted power fx syntax (Power Fx Index starts with 1 and not with 0) when writing the data into your Excel file . This approach should resolve the issues you're encountering.
Furthermore, we can adjust the regex to trim any leading or trailing spaces during the split function. You can try this approach if possible.
Another option is to remove blank rows from the list, but please note that Power Fx-enabled flows currently do not support this functionality as it is still in the preview stage.
Finally, since Power Fx is still in the preview stage, I would not recommend using it for any real-time projects at the moment, as there are many challenging scenarios with variable manipulation. If you want to disable Power Fx, simply keep it disabled when creating your flow, as shown in the screenshot below.
Thanks,
Deenuji Loganathan 👩💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥
-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀
