Unanswered

Add columns to SharePoint list

(0) Share

Report

Posted on by LukeSykes

I have seen a few posts on this but none seem to work for me.

Here is my flow

It creates a list on a site, calls it by the display name of an email address in a form, then it's supposed to start adding columns to the list. No matter how much I try to start adding the columns using the other examples on this and some other forums, it just won't do it.

Can anyone see what I'm doing wrong?

UPDATE:

I may have found the problem, I noticed that the site name in the HTTP request 2 was not the site name of the newly created list. I use a custome address to include the display name but on the site its 'Firstname%20Surname.AllItems.aspx'

How do I include the %20?

Categories:

Building flows

I have the same question (0)

All responses (15)

Answers (0)

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

Can you show us any errors from a recent run? You may need to add a short delay between the list creation and adding the additional columns.

Was this reply helpful? Yes No
LukeSykes on at

Like (0)

Report

Hi

Not sure if you saw my update from my original post.

It wasn't actually showing up an error, the flow succeeded it just wasn't adding the columns. noticed afterwards that the site address was wrong for the second HTTP request.

UPDATE:

I may have found the problem, I noticed that the site name in the HTTP request 2 was not the site name of the newly created list. I use a custom address to include the display name but on the site its 'Firstname%20Surname.AllItems.aspx'

How do I include the %20?

I have since added /Allitems.aspx to the custom name and the flow is just sitting there doing nothing

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

YOu can use the EncodeURIComponent() function to translate spaces into %20

Was this reply helpful? Yes No
LukeSykes on at

Like (0)

Report

So if I was using display name from dynamic content, how would I split that to include that function please?

It finally timed out

UPDATE:

I have tried this but it is currently just running

Was this reply helpful? Yes No
LukeSykes on at

Like (0)

Report

I have used the following to include the %20

Site Address/GivenName%20Surname/AllItems.aspx

The output looks right, and the flow runs successfully, but again it still does not add the column! 😞

Does the json look right?

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

Where you are inserting Display name now just use the Expressions tab to insert the function EncondeURIComponent() with DisplayName as the parameter for the function.

Was this reply helpful? Yes No
LukeSykes on at

Like (0)

Report

Hi

That doesn't seem to be working for me at all

The list is named after the display name of the staff member so I expected it would find it no issue. The first one creates the list and the second one finds the list based on its name (the display name) and adds the columns. What else am I missing?

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

The function is

encodeUriComponent()

Yours has a capital E and Uppercase URI, it is case sensitive.

Was this reply helpful? Yes No
LukeSykes on at

Like (0)

Report

I don't get an error now, but it still isn't adding the column

Is the field type number incorrect maybe?

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

I don't think the AllItems.ASPX should be on the end of the Site URL. If you just pick the site out of the dropdown does it add the column?

Was this reply helpful? Yes No