flow to add update and delete from excel to SP - how to get the JSON?? HELP need... anyone can help

(0) Share

Report

Posted on by bbsin

1,994

I followed the video by Jamie McAllister, I want to use excel to add, update and delete into SP List.

but how to get the JSON scheme that he mentioned?? I not a coding person. please help

The SP list date has not time just date. startdate, enddate and action date.

"Title": "",
"NameCompany": "",
"BusinessPartner":"",
"SOCI":"",
"Email":"",
"Group":"",
"RL":"",
"StartDate":"", - is the startdate right - addSeconds('1899-12-30 00:00:00', int(formatNumber(mul(float(items('Apply_to_each')?['StartDate']),86400),'0','en-us')),'yyyy-MM-dd HH:mm:ss')

"EndDate":"",
"ActionDate":"", is is a text hyperlink in Excel
"Others":"",
"Terminated":"",
"Email(Non)":""

The error stated , which part is wrong

How to get Parse JSON Scheme?

HOw to get the Parse JSOn code?? Thanks.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

eliotcole 4,363 Moderator on at

Like (0)

Report

Re: flow to add update and delete from excel - how to get the JSON?? HELP need...

This one has been coming up a bit, @bbsin , lately, it seems.

Here's a recent example, see if anything there helps you out:
Working out if a date field is formatted correctly

Otherwise, I would give you this advice ... work backwards through the expression to see where you get the failures.

Also, if this is happening for every input (or you have an iterative action in your flow) then you can make a variable to hold the data in, and separate it out a little bit. This will help you isolate the errors better.

I'll often have HUGE flows which show the logic, then I condense them into expressions at a later date.

Was this reply helpful? Yes No
bbsin 1,994 on at

Like (0)

Report

Re: flow to add update and delete from excel - how to get the JSON?? HELP need...

Hi @eliotcole,

Thank you. I need the JSON scheme, are you able to help?

Regards

Was this reply helpful? Yes No
eliotcole 4,363 Moderator on at

Like (0)

Report

Re: flow to add update and delete from excel to SP - how to get the JSON?? HELP need... anyone can help

Hi, @bbsin , could I suggest another method for you to input?

Have you tried to use Microsoft Forms? It also creates an excel sheet (so you can use that to appease anyone that needs excel for some reason)

This way you get a proper input method, instead of people using a calculator. 🙂

Was this reply helpful? Yes No
bbsin 1,994 on at

Like (0)

Report

Re: flow to add update and delete from excel to SP - how to get the JSON?? HELP need... anyone can help

thanks.

Was this reply helpful? Yes No