Obtaining Data from flow issue

Like (0) Share

Report

Posted on 29 May 2025 11:34:19 by Kmayes

786

Hi

I have a flow that is set up like this :

It all seems to work as expected apart from one column (shown below). The SharePoint column is set as a single line of text and the column from the excel file is also text, I can see in the output of the 'List rows' element that that required data is there but im unable to get the data into the create item part???

Categories:

Business Process Flows

I have the same question (0)

All responses (3)

Answers (0)

Kmayes 786 on 02 Jun 2025 at 11:24:53

Like (0)

Report

Obtaining Data from flow issue

Hi @Michael E. Gernaey

From doing some further testing it appears it didnt like the forward slash in the title of the column from the excel file once removed it worked when testing

Was this reply helpful? Yes No
Michael E. Gernaey 46,906 Super User 2025 Season 2 on 31 May 2025 at 20:27:31

Like (0)

Report

Obtaining Data from flow issue

@Kmayes

Are you saying that you do not see the dynamic property itself and so you cannot add it?

Also, are all the columns of data Json like that? Is that entire thing your string? I see several possibilities

1) It doesn't see it as a proper string because

a) the separation with "'s

b) the / can also cause issues

If you for example, intentionally change the entire column (Make a copy of your data first), to a literal string like the word THE. does it work?

Also, you are only looking at the properties of the file so you must have hard coded the file/path etc since its a manual trigger.

Format/content of the column data itself is the problem just need to figure out which one it is.

Was this reply helpful? Yes No
Vejai SH 326 on 30 May 2025 at 10:44:10

Like (0)

Report

Obtaining Data from flow issue

Hi @Kmayes,

Can you share the details, how you are retrieving the column value in loop!

Thanks,

Vejai SH

Was this reply helpful? Yes No