Unanswered

Apply to each erroring due to '@body('Create_HTML_table')' returning type 'String'

(0) Share

Report

Posted on by MD8

I am in need of some expertise with my current issue.

I'm in the process of creating a flow that is meant to check a sharepoint list, calculate the a 90 day grace period and send an email of the items in their grace period.

At the moment the flow errors on the apply to each step:

Here is an overview of the flow currently

All responses (3)

Answers (0)

v-chengfen-msft on at

Like (0)

Report

Re: Apply to each erroring due to '@body('Create_HTML_table')' returning type 'String'

Hi @MD8 ,
The time format needs to follow the IOS8601 specification, and must be consistent with the SharePoint format, so that it can be compared

Here is a link about get items filter query for your reference:
Power Automate get items examples - SPGuides

Best Regards
Cheng Feng
MD8 2 on at

Like (0)

Report

Re: Apply to each erroring due to '@body('Create_HTML_table')' returning type 'String'

Hi Chen,

Thank you for your above solution. I updated my flow to it but I did however get an error in the Get_items action:

The expression "field_14 gt '2023-03-08T16:10:02.3028655Z' and field_14 lt'2023-06-06" is not valid. Creating query failed.

I suspect it may have to do with my date field including time as well?

Many thanks
Melissa
v-chengfen-msft on at

Like (0)

Report

Re: Apply to each erroring due to '@body('Create_HTML_table')' returning type 'String'

Hi @MD8 ，
I made a template for your reference:
Triggered once a month;
Get items : Filter out all items whose date is from today to 90 days later through filter query

Send an Html form for each record and send it to the Person user in this column
Here is a link about get items filter query for your reference:
Power Automate get items examples - SPGuides

Best Regards
Cheng Feng