How can I input a number value for a condition that uses 'ends with'?

(0) Share

Report

Posted on by happyyear

633

Hello, Could you do me a favor?

I encountered an issue with Power Automate where, even though the value to be entered was the same, it seemed to overlook the input for the condition. I entered six items with different titles but the same condition. Strangely, the workflow didn't work for two of the items. The value in question is the account number, such as '1234', and the condition should involve 'ends with'.

However, when using the "Initialize variable" action, there was no option available for 'ends with' in the condition settings.

That is why I used 'string(account number)' to have access to the 'ends with' option. Is there any way to resolve this issue?

Categories:

Building flows

I have the same question (0)

All responses (28)

Answers (1)

rzaneti 4,241 Super User 2025 Season 2 on at

Like (1)

Report

Hi @happyyear ,

Your Condition structure seems to be correct. The error message says that your 'Account' value is null.

Could you please share the raw outputs from your SharePoint action from where you are capturing this 'Account' value?

Was this reply helpful? Yes No
happyyear 633 on at

Like (0)

Report

@rzaneti Thank you for your help.
I can't find the raw outputs. This is what I found.

Was this reply helpful? Yes No
rzaneti 4,241 Super User 2025 Season 2 on at

Like (1)

Report

Hi @happyyear ,

To get the raw outputs from your SharePoint action, you can follow these steps:

In the 'flow run' view, go to the SharePoint action from where you are pulling the "Account" and click in "Show raw outputs" in the OUTPUT section. In some cases, this button appears as 'Click to download':

It will show a sidebar on the right side of your screen containing this JSON notation (if you had the 'click to download' option, it will open the outputs in a new tab):

Find the "body" property. It is always after the "headers" property. Make sure to remove any sensitive content from the image before sharing. You also can find more details about how to access the outputs in Power Automate in this blog post that I wrote recently: http://digitalmill.net/2023/06/29/how-to-access-the-raw-outputs-in-power-automate/

Was this reply helpful? Yes No
happyyear 633 on at

Like (0)

Report

@rzaneti Thank you for your huge help.
This is what I have found.

Was this reply helpful? Yes No
rzaneti 4,241 Super User 2025 Season 2 on at

Like (1)

Report
Hi @happyyear ,

For any reason, the 'Account' property is not appearing in your outputs. It is possible that it has a different name for the outputs (for example, 'Title'), but it is more probable that, for any reason, it is not pulling from your SharePoint.

Some questions:
What is the value stored for 'Account' in your List item?
Please, double check if you have an 'Account' property in your outputs (you can use 'Ctrl+F' and search for 'Account' or for its value).
If you find it, please share the image of its property (removing any sensitive data)
If you do not found the 'Account' property in your outputs, please go to your flow in edit mode and hover your mouse on the dynamic content of 'Account' in your 'Condition' action. It may show something similar to it:

The 'Account' property name will be the text between single quotes highlighted in green. Please check if this property exists in the outputs.

Was this reply helpful? Yes No
happyyear 633 on at

Like (0)

Report
@rzaneti Thank you for your huge help. It means a lot to me.
What is the value stored for 'Account' in your List item? Single line of text.
Please, double check if you have an 'Account' property in your outputs (you can use 'Ctrl+F' and search for 'Account' or for its value). - I searched using "account or its value", but there was no. What I found is this.

If you find it, please share the image of its property (removing any sensitive data)
If you do not found the 'Account' property in your outputs, please go to your flow in edit mode and hover your mouse on the dynamic content of 'Account' in your 'Condition' action. It may show something similar to it: What I found was

Was this reply helpful? Yes No
happyyear 633 on at

Like (0)

Report

@rzaneti This is my workflow.

Was this reply helpful? Yes No
rzaneti 4,241 Super User 2025 Season 2 on at

Like (1)

Report
Hi @happyyear ,

The 'Account' property is has a logical name of 'Account_x0020_x0023_', and you are pulling it from the list of records generated by your 'Get items' action. Based on your outputs, it is like you do not have this column in your SharePoint List - which makes no sense.

Are there any entries in your List with empty values in 'Account'? If yes, it may be causing the problem and we can solve it by adding an additional condition to do something when the account is empty.
Could you please share (1) an image from your List columns only (without the records), and (2) an image of the List columns in the List Settings?

To access the List settings, you just need to open your list, click in the engine on the top-right corner of the screen, select "List settings" and you will see a section reserved for the columns:

I'm asking you for the both images because the first will show the "display name" of the columns (the friendly name), while the second one will show the "logical name" (which is used for Power Automate purposes).

Was this reply helpful? Yes No
happyyear 633 on at

Like (0)

Report

@rzaneti Thank you for your huge help again!

I entered six items with different titles but the same condition(same account number). Strangely, the workflow didn't work for two of the items.

1. This one was successful.
This one was failure.

I exactly entered the same account # with different title.

What I assume that this might cause this trouble, I used the grid view when I entered the value.
But users need this grid view to enter since there are many items to enter.

Was this reply helpful? Yes No
happyyear 633 on at

Like (0)

Report

@rzaneti
I tried 15items using different titles but with the same value for the account #. Some successfully worked. The others failed. I used the grid edit to enter values

Was this reply helpful? Yes No