cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
bbedingfield
Level: Powered On

XML data updating multiple SalesForce records

Hello,

 

I am new to Flow and struggling with how to approach updating multiple SalesForce records from an external data source (in this case, QuickBase).

 

What I am trying to do is use Flow to grab XML out of QuickBase, then update multiple SalesForce records based on the contents of that XML.

 

Below is the XML that I am pulling in. I'm trying to update a status field in SalesForce based on the ID from the XML (which is they key field in the SF table).

 

<?xml version="1.0" ?>
<name>SalesForceItem</name>
<record>
<id>a5j0g0000008mDHAAY</id>
<implementation_status>Install Scheduled</implementation_status>
<update_id>1566594651523</update_id>
</record>
<record>
<id>a5j0g0000008mDGAAY</id>
<implementation_status>Install Scheduled</implementation_status>
<update_id>1566594651523</update_id>
</record>

 

I believe I need to use the "Apply to Each" function, but what's in between that and the raw XML is where I am completely at sea. 

 

Can anyone help point me in the right direction?

 
1 ACCEPTED SOLUTION

Accepted Solutions
bbedingfield
Level: Powered On

Re: XML data updating multiple SalesForce records

For anyone else looking to do the same thing, I was able to solve this using a modified version of this method.

3 REPLIES 3
Community Support Team
Community Support Team

Re: XML data updating multiple SalesForce records

Hi @bbedingfield ,

 

Where is the XML data saved in?

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

bbedingfield
Level: Powered On

Re: XML data updating multiple SalesForce records

Hi, @v-alzhan-msft. Thanks for the quick response.

 

The XML data is generated by QuickBase and is being pulled into Flow via GET request using the QuickBase URI/API.

 

Thanks,

Bo

bbedingfield
Level: Powered On

Re: XML data updating multiple SalesForce records

For anyone else looking to do the same thing, I was able to solve this using a modified version of this method.

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 221 members 3,977 guests
Please welcome our newest community members: