Code is using SharePoint application scope to get list items, update, delete and add list items to SharePoint.but now business is asking to replace SharePoint application scope with Microsoft office 365 scope.
Here in code I am comparing data from get list items that I got using Microsoft office 365 as data table and comparing that data with sql data and storing data again in datatable. But how to use this datatable as input with Microsoft office 365 activities to update list items to SharePoint
Welcome to the community
you need to use for each list item activity and then inside that make any updates you need for the columns and then use update list item activity inside the loop itself
cheers
@Anil_G Thank you
For each list items take list as input but here I have data table as input which I got after comparing and filtering the two data tables one is from SharePoint(using get list items)and another one from sql database. and also I have caml query in SharePoint scope how can I use caml query in Microsoft office 365?
First thing there is no bulk update in sharepoint activitirw as of now
So you need to loop theough your datatable which you want to update to sharepoint then inside that use for eqch list item and filter option in it to get only one list item using any unique column value (or get list items basically would get you a list of listitems which you would have converted to datatable where you can filter and get the list item you have updated) and then use update item inside that by passing the identified list item value to it
The xaml query is used in sharepoint activities which are no more there and in office 365 you can use odata filter to get each item which is the filter i am talkinh about
Cheers
@Anil_G Thanks
In SharePoint I have account column of type Person or group and when trying to get list items in Microsoft office 365 I am getting as ID values instead of actual field.
How to set the Odata filter for this since we cannot use query.
thats a limitation as of now in 0365 activities for columns like person or group
cheers
Ok, but how to get fieldvalue of account instead of ID in O365 ? Any other possible methods.
ideally there will be a master table which you need to get access which would have all the ids and value mappign which can be used…also graph api custom code might needs to be created if you cant get the full access to know the details
example of custom api call
cheers