Answered

Patch Table to Sharepoint

(0) Share

Report

Posted on by niklasjegg

539

Hello, i am struggling to find a solution to this.

I have a Custom table inside my Powerapp. it is used for a Hardware Request where i want to be able to Request hardware. e.g 5 Laptops and 10 monitors.

My Table looks like this:

the formula to add and remove items works fine:

If(
 HardwareSelection.Selected.Value = "" || Value(HardwareCount.Text) <=0,
 Notify("Please select the type of Hardware and enter a valid Number!",Error),

Collect(Hardware,
 {
 HWID: CountRows(Hardware)+1,
 HWType: HardwareSelection.Selected.Value,
 HWCount: HardwareCount.Text
 });
Reset(HardwareCount);
Reset(HardwareSelection);
)

Now i want to Patch the Table with a mix amount of 10 items to Sharepoint.

How can i achieve this without creating a single column for each table item? is there a way?

Thank you and BR Niklas

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

kylzbaba 182 on at

Like
a
(0)

Report
Copy link

Link copied!

If I understand you correctly, you want to patch all the 10 items into one record in SharePoint.
So for instance request column will have

Laptop standard,10; Keyboard,5; Mouse,16;

Is this it ?
niklasjegg 539 on at

Like
a
(0)

Report
Copy link

Link copied!

yes i would like to do that 🙂
Verified answer

kylzbaba 182 on at

Like
a
(0)

Report
Copy link

Link copied!

Spoiler (Highlight to read)
This should help

https://powerusers.microsoft.com/t5/Building-Power-Apps/Combine-rows-in-collection-separated-by-commas-so-that-Patch/td-p/163877

This should helphttps://powerusers.microsoft.com/t5/Building-Power-Apps/Combine-rows-in-collection-separated-by-commas-so-that-Patch/td-p/163877
niklasjegg 539 on at

Like
a
(0)

Report
Copy link

Link copied!
thanks this is also a way to do it you are right.

i have found something on the weekend that also works for me
If( IsEmpty(Hardware), Notify("Please select at least one item to request!",Error), Patch('IT-Request',Defaults('IT-Request'), { 'Request-Type': "Hardware-Request", Devices: Concat(Hardware,HWCount & " " & HWType & Char(10)), Status: "Started" }); Clear(Hardware); )
kylzbaba 182 on at

Like
a
(0)

Report
Copy link

Link copied!

This makes sense as well. Very nice.
niklasjegg 539 on at

Like
a
(0)

Report
Copy link

Link copied!

yes and in further steps i am generating a table in flow out of these inputs. works like a charm 🙂