Answered

importing a sharepoint list to sql server

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm trying to import a list from sharepoint to sql server:

This code is not giving me an error, but it also is not working ?

ForAll(
t_PA_Excel_Sku_Export_Import,
Collect(
'[dbo].[t_pricing_escalation_detail_temp]',
{
SKU: SKU,
RBP_MASTER_ID: Value(RBP_MASTER_ID),
RENEWAL_SKU: RENEWAL_SKU,
RENEWAL_OLVP_QUOTENUMBER: RENEWAL_OLVP_QUOTENUMBER,
PRODUCT_DESCRIPTION: PRODUCT_DESCRIPTION,
QTY: Value(QTY),
TARGET_PRICE: Value(TARGET_PRICE),
TARGET_GP: Value(TARGET_GP),
CURRENT_PRICE: Value(CURRENT_PRICE),
VENDOR_GUIDELINE_GP: Value(VENDOR_GUIDELINE_GP),
APPROVED_PRICE: Value(APPROVED_PRICE),
APPROVED_GP: Value(APPROVED_GP),
SEND_TO_LEADER: SEND_TO_LEADER,
PANDEMIC_SKU: PANDEMIC_SKU
}
)
)

Thanks

Dave

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Carlosr Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Use Patch, not Collect. Collect is for in-memory collections. Patch will actually write to the data source. The defaults parameter fills in any missing fields with a default value.
Patch(
'[dbo].[t_pricing_escalation_detail_temp]',
Defaults('[dbo].[t_pricing_escalation_detail_temp]'),
{
SKU: SKU,
RBP_MASTER_ID: Value(RBP_MASTER_ID),
RENEWAL_SKU: RENEWAL_SKU,
RENEWAL_OLVP_QUOTENUMBER: RENEWAL_OLVP_QUOTENUMBER,
PRODUCT_DESCRIPTION: PRODUCT_DESCRIPTION,
QTY: Value(QTY),
TARGET_PRICE: Value(TARGET_PRICE),
TARGET_GP: Value(TARGET_GP),
CURRENT_PRICE: Value(CURRENT_PRICE),
VENDOR_GUIDELINE_GP: Value(VENDOR_GUIDELINE_GP),
APPROVED_PRICE: Value(APPROVED_PRICE),
APPROVED_GP: Value(APPROVED_GP),
SEND_TO_LEADER: SEND_TO_LEADER,
PANDEMIC_SKU: PANDEMIC_SKU
})

Was this reply helpful? Yes No
Abhilash_Swain 901 on at

Like (0)

Report
Copy link

Link copied!

Please use MS flow to run the query to insert items into databse.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

carloser,
I'm trying to take this sharepoint file "t_PA_Excel_Sku_Export_Import"

and insert it into the sql server file "[dbo].[t_pricing_escalation_detail_temp]'" ?

Was this reply helpful? Yes No
Verified answer

Carlosr Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

To use power fx, just add your ForAll statement to my sample:
ForAll(
t_PA_Excel_Sku_Export_Import,
Patch(
'[dbo].[t_pricing_escalation_detail_temp]',
Defaults('[dbo].[t_pricing_escalation_detail_temp]'),
{
SKU: SKU,
RBP_MASTER_ID: Value(RBP_MASTER_ID),
RENEWAL_SKU: RENEWAL_SKU,
RENEWAL_OLVP_QUOTENUMBER: RENEWAL_OLVP_QUOTENUMBER,
PRODUCT_DESCRIPTION: PRODUCT_DESCRIPTION,
QTY: Value(QTY),
TARGET_PRICE: Value(TARGET_PRICE),
TARGET_GP: Value(TARGET_GP),
CURRENT_PRICE: Value(CURRENT_PRICE),
VENDOR_GUIDELINE_GP: Value(VENDOR_GUIDELINE_GP),
APPROVED_PRICE: Value(APPROVED_PRICE),
APPROVED_GP: Value(APPROVED_GP),
SEND_TO_LEADER: SEND_TO_LEADER,
PANDEMIC_SKU: PANDEMIC_SKU
}))

If this is a one time thing, then Power Automate might be better.

Was this reply helpful? Yes No