Read SP List and update the record in Smart Object

  • 28 August 2014
  • 5 replies
  • 0 views

Badge +5

Hello Guys,

I have requirment where first i need to read the SP list and if their is any new records get addded i want to update same in SmartObject.

But base on that outcome of SP list i need to update the smartobject.

Currently there  is looping process is used. idont want loop to implement.

How i can achive this.

 

Thanks


5 replies

Badge +9

So just to clarify

1) You have a SharePoint list.

2) You have a smartobject built upon that SharePoint list.

3) The SmartObject will be aware of any changes to the list it is built upon so I don't know what you mean by update.

 

4)What do you mean by outsome of the SharePoint list? Lists are data sources and so they don't really have outcomes as they do not take actions.

 

Badge +5

Hi Austin,

Thanks for your reply.

 

Here is scenario

I Have SP list. Smart object is based on SQL. I mean data is save in SQL.

I have attached the activity which I need to work on.

Currently it read the SP list and save data in SQL. We had setup rule. The rule first check status of the column in SP list. If status is active it again goes to read SP list and save data in smart object. The rule run every hour which create overhead to process. So I want to remove that looping process.

Can you please help me on this.

 

 


10732i9EF1973B25A655F0.png
Badge +9

It sounds to me like what you want to do is when that SP list gets updated or changed, this triggers a workflow that stores the new version of the list in the SQL db.

That about right?

Badge +5

Hellos,

yes your right.How i can do that? without looping the process.

 

Badge +9

What version of BP are you running so I can use an appropriate VM to try stuff.

Reply