address null rows in Create HTML Table

(0) Share

Report

Posted on by Tango

1,164

Hi,

Putting the results of Get Items from a Sharepoint list into a HTML table for emailing.

What would be the approach to Create HTML Table but sometimes a row for a specific column will not have an entry?

In the 1st column I am just pulling the first 6 characters hence why the error message includes substring but I also have other columns that wont necessarily have data in them. There will always be a number of "main" columns that always have data in them.

Currently when I run the flow I get error message

The value of first parameter is of type 'Null' but the function 'substring' expects a string.

Thanks in advance

Todd

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Rhiassuring 8,690 Moderator on at

Like (1)

Report

If I understand correctly, your issue is that you are applying a substring to everything you want to put into the HTML table, but since sometimes the column might be empty, the substring errors.

If that is correct, then you'd likely just want to say if(empty(YOURDYNAMICCONTENT),'',substring(YOURACTIVITY)).

Ie, "only perform this substring activity if this isnt null"

Was this reply helpful? Yes No
Tango 1,164 on at

Like (0)

Report
Thanks @Rhiassuring No This just happened to be an example where I was using a substring. Other columns would be to just show their normal value.
Actually Ive just realised that this might only be showing an error because I have the substring for this column as other columns with no value are displaying correctly.

My attempt thanks to your assistance is but is still showing error
if(empty(item()?['Title'])'',substring(item()?['Title'],0,6))

Basically if there is any text in title field show 1st 6 characters, if it is blank do nothing.

Thanks again

Todd

Was this reply helpful? Yes No
Tango 1,164 on at

Like (1)

Report

@Rhiassuring I was missing a ,

Was this reply helpful? Yes No