Answered

Display Infromation in Different Columns, Different Rows

(0) Share

Report

Posted on by PANA1

Hi everyone!

I am new at PowerApps, so I can't find a way to make my texts to align in the same rows. I need that my information is displayed in the same way as in my Power Apps (I added a reference image).

Until know I have only been able to display my info in their respective column, but the information is out of phase (for example, when the text inputs of a column are all displayed, the data of the next column begins to be projected in the row following the last data of the previous column).

I have been using the following code for every column:

Patch(SharePoint Source,{Title:"",Column Name : Text Input .Text});

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@PANA1

Your formula will be creating a new record each time...

Please consider changing your Formula to the following:

UpdateIf('SharePoint Source', {ID: ThisItem.ID, Title:"", 'Column Name': Text Input .Text} );

I hope this is helpful for you.
PANA1 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Randy, thanks for your quick response 😀!
In fact, I need to keep record in my SharePoint from every user's new answers register in the PowerApp (I'm using this information in a DashBoard).
My actual concern is that I need that all my Text Inputs project in their respective columns, but in the same row; kind of a table form. (For example, I need to now number of units in a Yard for Bronco & Maverick and the users comments, but since we are talking of one yard, i want all the information in one single row, and so on for every Yard)
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@PANA1

My assumption was this is all in a Gallery...is that correct?

What is the formula you have now to perform the data writing?
PANA1 4 on at

Like
a
(0)

Report
Copy link

Link copied!

No, i just added Text Inputs in the screen for every Yard in this case.

My code for the button to save my data in the SharePoint is the following:
Patch(Inventario_Patios_HSAP,{Title:"",Patio:P15.Text});
Patch(Inventario_Patios_HSAP,{Title:"",Patio:P16.Text});
an so on, until I assign all the yards...

Patch(Inventario_Patios_HSAP,{Title:"",Bronco:Inv_p15B.Text});
Patch(Inventario_Patios_HSAP,{Title:"",Bronco:Inv_p16B.Text});
an so on, until I assign all the Bronco units for their receptive yard...

Patch(Inventario_Patios_HSAP,{Title:"",Maverick:Inv_p17M.Text});
Patch(Inventario_Patios_HSAP,{Title:"",Maverick:Inv_p21M.Text});
an so on, until I assign all the Maverick units for their receptive yard...

Maybe if I do it with a Gallery will be easier?
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PANA1 :

Please try:

My code for the button to save my data in the SharePoint is the following:

Patch(Inventario_Patios_HSAP,{Title:"",Patio:P15.Text});
Patch(Inventario_Patios_HSAP,{Title:"",Patio:P16.Text});

an so on, until I assign all the yards...

Patch(Inventario_Patios_HSAP,LookUp(Inventario_Patios_HSAP,Patio=P15.Text),{Bronco:Inv_p15B.Text});
Patch(Inventario_Patios_HSAP,LookUp(Inventario_Patios_HSAP,Patio=P16.Text),{Bronco:Inv_p16B.Text});

an so on, until I assign all the Bronco units for their receptive yard...

Patch(Inventario_Patios_HSAP,LookUp(Inventario_Patios_HSAP,Patio=P15.Text),{Maverick:Inv_p17M.Text);
Patch(Inventario_Patios_HSAP,LookUp(Inventario_Patios_HSAP,Patio=P16.Text),{Maverick:Inv_p21M.Text});

Best Regards,

Bof