Update External List by SPD workflow on Office 365

Question

hi ,

i am unable to update "External List" (WCF services BCS) by Workflow (SPD 2010).

i gone through various site and found i have to create SSS (Secure Store Service) and have to use it in BCS (Authentication mode="Impersonate" and Secure Stored Application ID = ''localhostservie") . so i tried on Development server and no issues.

but when try to create in Office 365 i found the "Target Application Type" in "Target Application Settings" is disabled (only defalut 'Group Restricted') available

where as i select 'Indivisual" in Dev. server. while creating 'External List' i face error 'the username must be qulified with a domain(that is DOMAIN\user)'.

so can i update the External List by SPD workflow on office 365? 

---

Thanks and Regards

Er.Pradipta Nayak
Visit my Blog
ISHIR

Answer 1

Office 365 only allows creation of group credentials in Secure Store.  Everything else should be the same, but Secure store will provide credentials for the external list based on group membership, not based on individual user id.

---

Paul Stork SharePoint Server
MVP Senior Solutions Architect: BlueChip Consulting Group
Blog: http://dontpapanic.com/blog
Twitter: Follow @pstork
Please remember to mark your question as "answered" if this solves your problem.

Answer 2

Thanks paul,

but why i am getting this error 'the username must be qulified with a domain(that is DOMAIN\user)'

---

Thanks and Regards

Er.Pradipta Nayak
Visit my Blog
ISHIR

Answer 3

When you fill in the user field in the Secure store did you enter it in the format of domain\userid?  Or just enter the userId?

---

Paul Stork SharePoint Server
MVP Senior Solutions Architect: BlueChip Consulting Group
Blog: http://dontpapanic.com/blog
Twitter: Follow @pstork
Please remember to mark your question as "answered" if this solves your problem.

Answer 4

Hi Paul,

thanks for you replay again i configure my SSS as below. i tried with "ishir365.onmicrosoft.com\xyzadmin" but doesn't recognize..so search xyzadmin and selcted it .

---

Thanks and Regards

Er.Pradipta Nayak
Visit my Blog
ISHIR

Answer 5

That's the configuration of Secure Store itself.   Once the application definition is complete you also need to add at least one set of credentials to the store.  Those are the credentials that will be used to connect to the external datasource.  Its those credentials that the system is complaining don't have a domain in the username field.

---

Paul Stork SharePoint Server
MVP Senior Solutions Architect: BlueChip Consulting Group
Blog: http://dontpapanic.com/blog
Twitter: Follow @pstork
Please remember to mark your question as "answered" if this solves your problem.

Answer 6

hi Paul, i create SSS and then set pemissiion to is also.but after creating ET with this i am not getting error while reading item from External List but it return nothing. i tried to read data from External list through Workflow (SPD).it return Blank values.

---

Thanks and Regards

Er.Pradipta Nayak
Visit my Blog
ISHIR

Answer 7

Hi,

I suggest you open a new thread for better reply.

Thanks,

Rock Wang

---

Rock Wang TechNet Community Support