Hello, I have a following simplified version of my automate set up involving MS Form/Approval/Excel and am having trouble referencing a specific value from an action "List rows present in a table":
The overall flow looks as following:
1 - Form submission with excel attachment triggers the flow
2 - Excel script is executed to fill column AG with specific value that is dependent on the inputs in the form (e.g.if B2 is "China", AG2 will be "Active", B3 is "Canada", AG3 will be "Reject")
3 - Approval flow is sent
4 - Upon approving, new excel file is generated to copy information from the submitted excel
5 - Each row's relevant items from the submitted excel is copied to sharepoint and newly generated excel
The problematic part of the flow is 4 and 5, as following.
The column AG that was calculated in 2 is not properly referenced and copied to sharepoint and newly generated excel. In here you can see the output of "list rows present in a submitted excel's table". The value for column AG(ReferenceId) is properly recognized.
However, within for-each loop, the ReferenceId value is not picked up. Below is Compose 1 output.
I am pretty sure the actual referencing is correct. I use item()?['ReferenceId'] to refer to the item under column AG "ReferenceId". By similar formatting other values from the excel is properly copied. It's specifically this particular value that is not read by PA flow.
I am very much struggling why my flow can't recognize this column. Could it be that because it's the newly added value within this flow using excel script, it can not be properly recognized?
