Unanswered

Import Data from Blank Canvas to SharePoint List

(0) Share

Report

Posted on by Casey-Lee

Hello

I am a beginner and have designed an app using a blank canvas, I would like to import the data and add a new record to a SharePoint List which I have now created (after completing the app)

The SharePoint Details are below:

SharePoint List

In my app I have made a collection for the above which works well with the below:

Collect(Summary,{Sales_Consultant_Name:Concat('Sales Consultant Name'.SelectedItems, 'Sales Consultants' & ";"), Customer_Name:'Customer Name'.Text, Expected_Invoice_Amount: 'Expected Invoice Amount'.Text,Certainty_Percentage:'Certainty Result'.Text, Invoice_Month:Concat('Month selection'.SelectedItems, Month), Next_Logical_Step:'Next Logical Step'.Text})

The 'Sales Consultant' and the 'Invoice Month' are a ComboBox.

Kind Regards

Casey-Lee

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hey @Casey-Lee

Can you share more details on the usage of collection in this case? You can directly patch the data to create a new records without using the collection as:

Patch(SpListName,Defaults(SpListName),{Sales_Consultant_Name:Concat('Sales Consultant Name'.SelectedItems, 'Sales Consultants' & ";"), Customer_Name:'Customer Name'.Text, Expected_Invoice_Amount: 'Expected Invoice Amount'.Text,Certainty_Percentage:'Certainty Result'.Text, Invoice_Month:Concat('Month selection'.SelectedItems, Month), Next_Logical_Step:'Next Logical Step'.Text})

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Casey-Lee 31 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @yashag2255 for the assistance.

If I would like to import the data based on sales consultant name selected in the ComboBox, please advise how I would do that?

For example. if the Sales Consultant Name is 'Dean Abrahams'

Kind Regards
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Casey-Lee,

Do you mean patch a new record to SP list from the collection?
You can try this:
Collect('SP list', LookUp(Summary, 'Sales Consultant Name' ='Dean Abrahams' ))
Note: the column name of collection should be the same with SP list.
Best regards,
Sik
If my post is helpful for you, please click on “Accept as Solution” to help other members find it more quickly.
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hey @Casey-Lee

If you wish to get data based on selection in combobox control, then you can use the below expressions as:

ClearCollect( MyCollectionName, Filter(SpListName, 'Sales Consultant Name' in Combobox1.SelectedItems.ColumnName) )

Here, ColumnName name needs to be replaced with the column which holds the value of Sales Consultants name based on the items in combobo control.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Casey-Lee ,

Have your issue been fixed?
I can give your hand if you need help.
Best regards,
Sik
If my post is helpful for you, please click on “Accept as Solution” to help other members find it more quickly.