Unanswered

Cannot make the flow go through all identified rows in a spreadsheet

(0) Share

Report

Posted on by CU26090802-0

With the help from @v-wenjuan-msft, I've built a flow which identifies the number of a new file added or modified towards an existing Excel sheet. It creates a new file based on information from the original document and from a row in the spreadsheet. However, I'm unable to make it go through all the rows where I have this identified number - it only does the first one. So there's something wrong with the logic somewhere.

Note; I know it's messy, but I'm more interested in the function than the beauty at this stage.

Here's the process as it is today:

Codes:

Split: Split(triggerOutputs()?['body/{Name}'],'_')[0]

Outputs('compose')

Body('Filter_Array*

variables('ListRows')

identifier - triggerOutputs()?['body/{Identifier}']

last - last(split(triggerOutputs()?['body/{FilenameWithExtension}'],'.'))

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

v-wenjuan-msft Microsoft Employee on at

Like (0)

Report

Hi @BkkBound ,

Sorry that I'm a little bit confused about your new request.
Do you mean you have retrieved a "identified number" from the SharePoint filename, and you have several rows in Excel sheet with this number as "Itemnumber" and you want to use an action to get them all, but it only return the first row it get? Please kindly correct me if I made any mistake.

If that's the case, the issue is due to this action:
To use this action to search for a row, you have to ensure the key value is unique in the key column. Otherwise, if there are several rows match your search condition, it will return the first one.

You should use "Filter array" to retrieve the rows you want from "Listrows" action:

Community Support Team _ Wenjuan Zou
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
CU26090802-0 32 on at

Like (0)

Report

Hi @v-wenjuan-msft ,
you're correct.

1. A PDF is uploaded to a Sharepoint folder, this PDF have got a filename consisting of <A><B>.pdf
Field A is extracted from the filename and compared to a Excel sheet, this field could occur multiple times in the Excel sheet and I want to create one PDF file per row.

So I have this file coming in:
123456_SomeName.pdf

The Excel sheet have this data:
A B C D
1 Item Name Identifier ValueA
2 123456 SomeName 651321 Italy
3 121748 SomeName 651984 France
4 123456 SomeOtherName 651489 Germany
5 123456 SomeName 651123 Poland

So I want to take the original PDF coming in and create copies with filename based on the values in the excel, so for this example I want to take the info from row 2,4 and 5 and create a file per individual row.
Now this is working, but it only takes the first row.

I have also tried adding the filter array, but no luck still.

Was this reply helpful? Yes No
v-wenjuan-msft Microsoft Employee on at

Like (0)

Report
Hi @BkkBound ,

Thanks for your table. That's clear!

Here's the function I used:
concat(item()?['A'],'-',item()?['B'],'.',outputs('Compose_3'))

Community Support Team _ Wenjuan Zou
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
CU26090802-0 32 on at

Like (0)

Report

Hi @v-wenjuan-msft ,
it doesn't change anything unfortunately. It still only creates a file based on the first row it finds.
It doesn't give any error message either, it just completes "successfully". All the outputs and inputs also gives the right data (All rows) but it doesn't process all of them.

Was this reply helpful? Yes No
v-wenjuan-msft Microsoft Employee on at

Like (0)

Report

Hi,

There're 47 loop here which means there should be 47 rows found from Excel and there will be 47 copies created. Would you please click "Next" to check their processes?

One more tips, you can set concurrent control for the "Apply to each 2" to 50 so that it will handle with 50 loop at the same time.

Community Support Team _ Wenjuan Zou
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
CU26090802-0 32 on at

Like (0)

Report

Hi @v-wenjuan-msft ,
I think i might have a very elementary fault here which I cannot figure out.
It seems to cycle the same row over again. So it takes C column in the example above and just runs that 47 times

Was this reply helpful? Yes No
v-wenjuan-msft Microsoft Employee on at

Like (0)

Report

Would you please spread every action and take screenshots? so that I can check parameters/functions you insert in them and try to figure out what's going on.

Was this reply helpful? Yes No
CU26090802-0 32 on at

Like (0)

Report

Hi @v-wenjuan-msft , and thank you for your continued support!
Here's the whole thing, with the expressions:

Compose expression:
Split(triggerOutputs()?['body/{Name}'],'_')[0]

Value: outputs('ListRows')?['body/value']
itemnumber: item()?['Itemnumber']
Outputs: outputs('Compose')

length: length(body('Filter_array_3')

body('Filter_array_3')
triggerOutputs()?['body/{Identifier}']
last(split(triggerOutputs()?['body/{FilenameWithExtension}'],'.'))

concat(body('Filter_array_3')[0]['Customer'],'_',body('Filter_array_3')[0]['Item Name'],'.',outputs('Compose_2'))

outputs('Compose_3')
triggerOutputs()?['body']

The following is the final step which also adds metadata to the newly created file. I have tried the operation with and without this step, but it doesn't matter whether it's there or not:
outputs('ListRows')?['body/value']

Was this reply helpful? Yes No

Join the conversation

Community site session details

Cannot make the flow go through all identified rows in a spreadsheet

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates

	A	B	C	D
1	Item	Name	Identifier	ValueA
2	123456	SomeName	651321	Italy
3	121748	SomeName	651984	France
4	123456	SomeOtherName	651489	Germany
5	123456	SomeName	651123	Poland

Community site session details

Cannot make the flow go through all identified rows in a spreadsheet

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates