Unanswered

Error moving Form answers to SharePoint List

(0) Share

Report

Posted on by Gfickel

I have built a form that collects several items and uses branching to bypass secondary questions if you say No to the primary question. For example:

Do you want Item#1 (Yes No)

If Yes

Start Date (using the built in picker for all of these date field)

End Date

If you choose no it skips to the next primary question

Do you want Item#2 (Yes No)

If Yes

Start Date

End Date

Form completed.

If the user selects "No" to Item#1 the start date and end date skipped. Using the Create Item for SharePoint action I have added IF statements when retrieving the the start dates and end dates to set the date as NULL if the field is empty. here is the formula

if(equals(outputs('Get_response_details')?['body/GUIDBlahBlah'],''),null,formatDateTime(outputs('Get_response_details')?['body/GUIDBlahBlah']))

When I run a test I get the following error.

Unable to process template language expressions in action 'Create_item' inputs at line '0' and column '0': 'In function 'formatDateTime', the value provided for date time string 'No' was not valid. The datetime string must match ISO 8601 format.'.

Any assistance would be great.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Craig Stewart ABZ 959 Super User 2024 Season 1 on at

Like (0)

Report

Hi

You need to add the format to this. I think the below will fix it.

if(equals(outputs('Get_response_details')?['body/GUIDBlahBlah'],''),null,formatDateTime(outputs('Get_response_details')?['body/GUIDBlahBlah'],'yyyy-MM-dd'))

** Sorry I just reread your post so ignore this, I'll go have a think about this **

Was this reply helpful? Yes No
Gfickel 9 on at

Like (0)

Report

Thanks CriagStewart for looking into this.

Was this reply helpful? Yes No
Verified answer

Craig Stewart ABZ 959 Super User 2024 Season 1 on at

Like (1)

Report

Ok

So it looks like your response id is incorrect in your expression - you're picking up the response id from the YES/NO option

I was able to recreate the error by doing exactly that. You'll need to identify the correct id and then your expression should be:

if(empty(outputs('Get_response_details')?['body/r1e2754a5cc824a1082d6aaefc21ad0ff']),null,outputs('Get_response_details')?['body/r1e2754a5cc824a1082d6aaefc21ad0ff'])

If you're not seeing the Start and End Date as response detail options in Power Automate, you can workaround like I did by selecting it in another section then copy and pasting into to notepad to get the details:
Here we see no option:

If we click in another section we do get a list.
click and copy then paste into notepad

SharePoint list column is set up as Date and time

Start and End Date using the same style of expression
if(empty(outputs('Get_response_details')?['body/r1e2754a5cc824a1082d6aaefc21ad0ff']),null,outputs('Get_response_details')?['body/r1e2754a5cc824a1082d6aaefc21ad0ff'])

3 form responses with the date filled in
1 response where we selected NO to the first question and therefore skipped the dates

When we select Yes we get the options

Hope that helps.

Craig

Was this reply helpful? Yes No
Gfickel 9 on at

Like (0)

Report

This was just what I needed thank you!

Was this reply helpful? Yes No