Unanswered

Limit the columns from SharePoint in "Create items" flow output

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I have a simple flow where i'm trying to create items in a SharePoint list .

In the output of this flow this step is retrieving default column values (ID, created by, Modified by etc) too which i haven't passed in Create item.

How can i control this ?

This is the output of create item:

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Pstork1 69,657 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

In the Create Item action there is an option to limit the columns by view (SharePoint view). Create a view in the list and use that to limit the columns. The system columns will still be included. There is no way to remove them from the results of the Create Item. Is there some specific reason you want to limit the number of columns returned?

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

Like
a
(0)

Report
Copy link

Link copied!

Hello.

Thank you for the answer.

Well my next step is Get item which needs to get the newly added item to the list.

And after that i need to create a HTML table.
When i use Select , i am not able to find Value (Which is an array) , which can be used in Select "from" tab step.
Instead i see Body (which is in an object) which is in json and when i parse it i still don't get array.
Hence, i thought it i might have to exclude the other columns.

Could you please give me a solution for the above.

Thank you again.

Was this reply helpful? Yes No
Pstork1 69,657 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

That's because Create Item returns a single item, not an array. Initialize an array variable, append the Body of the Create Item to the variable, use that variable as the input for the HTML table.

You don't need the Get item at all. The Create Item outputs the record you just created.

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

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I did what you asked me to:
I am getting this error:

Was this reply helpful? Yes No
Pstork1 69,657 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Check my reply again. I said to initialize the variable and then append the body to the variable. You are trying to initialize an array variable with something that's not an array.

Was this reply helpful? Yes No