Hi, I hope you are all doing well, and thank you for the time you will take to help me.
I have a list Sharepoint with a poweapps form for ''wrong manufacture pieces'' or ''problem with part''. Sometime we need to create a request for multiple part but for the same customer.
So I would like to create one form that I can add multiple Item to a sharepoint column so my user will be able to see multiple part in only one request(patch). I tried multiple way to handle this but I would like to have your advice on how I should proceed.
I tried this way, we need to add the part#(#piece) and explain the problem(cause), the quantity. After Filling this info I would like to upload this to my sharepoint column format like this:
Part#: X Cause: X Quantity: X and if there is multiple item I would like them to show like this
Part#: X Cause: X Quantity: X
Part#: X Cause: X Quantity: X
Part#: X Cause: X Quantity: X
I tried with a collection but I am not sure this is the correct way and I had problem converting collection record into a text value(then i would have patch but im stuck).
My Add button(ajouter) look like this:
Notify("Succes";NotificationType.Success;1900);;Collect(
CollParts;
{
valSP: Concatenate(
"#item:";
TextInput6.Text;
" Cause: ";
TextInput4.Text;
" Qty: ";
TextInput5.Text
)
}
);;Reset(TextInput5);;Reset(TextInput4);;Reset(TextInput6)
I do not really need the Gallery, the best for me would be able to have everything into the sharepoint list. So on the submit action I would like to patch those record to get something like this or a similar result.
Part#: X Cause: X Quantity: X
Part#: X Cause: X Quantity: X
Part#: X Cause: X Quantity: X
