Unanswered

Cant use a Sharepoint online field to be used MS Flows IF or SWITCH statement

(0) Share

Report

Posted on by RicardoC

So, I´ve been struggling with this particular issue, and just for the record i am just starting with Flows I really love it but this time i am starting to hate it

I have a flow that will create an HTML table and send out an email with this HTML table once certain condition matchs with a value from a Sharepoint Online list

I have created a number "status" column called ACTIVITYSTATUS from a PowerApp i am able to patch whatever value I want into this column.

From flows I have added a condition that will evaluate ACTIVITYSTATUS and depending on its current value will be sending out the email with the table. Dont know what else i can do tomake flows take the real value of the column to evaluate it. I have even tried with integers changing the column to number but it is still the same, any advice on this

Categories:

Using flows

I have the same question (0)

All responses (9)

Answers (0)

DeepakS 2,301 Most Valuable Professional on at

Like (0)

Report

Hi @RicardoC

Could you please share your condition expression ,so i can check if that need any correction.

Regards,

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (0)

Report

Hello @RicardoC

To help troubleshoot this, please add 2 Compose actions before the IF condition.

Put the value from SharePoint you are checking in one compose
And put the value from the HTML table in the other compose.

The value are most likely different. Maybe because of the formatting from the HTML table.

Please try that above and let me know what the values in the compose actions are when you run the flow again.

As well as the IF condition.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Was this reply helpful? Yes No
RicardoC 9 on at

Like (0)

Report

@DeepakS this is how I setup my flow, the table, the Activitystatus column in the condition was setup as single line of text on the Sharepoint Online List, I´ve already tried with number type but none of them seems to work

Was this reply helpful? Yes No
RicardoC 9 on at

Like (0)

Report

@Jcook after adding two compose those are the outputs, on the first one it gives me a download link and it takes me to nothing the second takes me to the HTML table and it was created the way it supposed to be. Any ideas?

Was this reply helpful? Yes No
Jcook 7,781 Most Valuable Professional on at

Like (0)

Report

Hi

So the first Compose has ACTIVITYSTATUS?

Can you please share or check the output of the Get items action. What value is being grabbed from that field for Activity Status?

In the HTML table output I cannot see the whole output from your picture. It cuts off right at the ActivityStatus part.

But my guess is that ACTIVITYSTATUS is not the value you think it is.

—Josh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Was this reply helpful? Yes No
RicardoC 9 on at

Like (0)

Report

@Jcook
This is the output from the compose that contains the HTML table

<table><thead><tr><th>act</th><th>status</th><th>ActivitySTATUS</th><th>act2</th></tr></thead><tbody><tr><td></td><td></td><td></td><td></td></tr><tr><td></td><td></td><td></td><td></td></tr><tr><td>test input</td><td>1</td><td>b</td><td>AQUI ESTA EL Ccambio</td></tr><tr><td></td><td></td><td></td><td></td></tr><tr><td></td><td></td><td></td><td></td></tr><tr><td></td><td></td><td></td><td></td></tr><tr><td></td><td></td><td></td><td></td></tr><tr><td></td><td></td><td></td><td></td></tr><tr><td>Ingreso 50000</td><td>1</td><td></td><td>Ingreso 2</td></tr><tr><td></td><td></td><td></td><td></td></tr><tr><td></td><td></td><td></td><td></td></tr><tr><td>Office365</td><td></td><td></td><td>Intranet</td></tr><tr><td></td><td></td><td></td><td></td></tr><tr><td></td><td></td><td></td><td></td></tr><tr><td>PowerBI</td><td></td><td></td><td>Mas BI</td></tr><tr><td></td><td></td><td></td><td></td></tr><tr><td></td><td></td><td></td><td></td></tr><tr><td></td><td></td><td></td><td></td></tr><tr><td></td><td></td><td></td><td></td></tr></tbody></table>

and this is the view of the table when it comes to my email when I set the output in the FALSE condition

and this is the view of the getItems

Was this reply helpful? Yes No
DeepakS 2,301 Most Valuable Professional on at

Like (1)

Report

Hi @RicardoC
I created a sample flow to explain your issue:
here is my SP list with Activity Status column, with three items and each has different status:

Here is my flow very similar to yours:
Now few points to notice:
-This will is working with no issue, but yes i am looping through each item in list (i have three) i will get true condition only once as only one item has Activity Status ="Done" .
now if i look at your Html it has many empty row (as you can also see you have 19 items loop) so your condition is might not be matching for empty records,
this is how your html table looks:

As you see first two records are empty, so lets click on the next on "Apply to each" action until you reach the item 3 , you should have true condition there.

Let me know if that make sense?

-------------------------------------------------------------------------------------------------------------------------------------------
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

Was this reply helpful? Yes No
RicardoC 9 on at

Like (0)

Report

@DeepakS You were right, now I see that the flow is pulling the row with the B status, but how to make the flow to pull just the one modified instead of the whole array.

Was this reply helpful? Yes No
DeepakS 2,301 Most Valuable Professional on at

Like (0)

Report

Hi @RicardoC

You should trigger your flow -"when an item is modified" to make sure it runs only when a item is modified and then you can send email.

-----------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No