Unable to access email list when adding Map to Select function in Power Automate setup for an Excel spreadsheet

(0) Share

Report

Posted on by Redviking110

I am working my way through setting up an automated email list from an excel spreadsheet. I have setup the following:

1) Created and selected a table in an excel spreadsheet

2) Recurrence

3) List rows present in table

Now I get to the "Select" task. When I click on the "From" field, I only see two choices, "value - list of items" and "body - list of items". The you tube tutorials I have been watching indicate that I should see each of the columns which are in my table.

Can someone please advise where I am going wrong?

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-chengfen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Redviking110 ,
First, ensure the creation of the excel table
Second, let flow recognize the Table in the excel file you selected

Third, Please try to delete the [Select] action and add it again

if the column you need still cannot appear, please rebuild the flow

If the above steps still fail, please use the item()?['column name'] formula to dynamically obtain.
like this:

Best Regards
Cheng Feng

Was this reply helpful? Yes No
Redviking110 2 on at

Like (0)

Report
Copy link

Link copied!

Cheng,

Thanks for your helpful reply.
I have been able to get to the test the flow.
I have an issue now with the Date string.
The error message I get is this: There is an unterminated string literal at position 27 in 'ReminderDate eq '02-02-2023'.
inner exception: There is an unterminated string literal at position 27 in 'ReminderDate eq '02-02-2023'.
clientRequestId: 63bc7f02-40ed-436c-b3cc-21e8ecafc5b1
The string I have created is this within the Filter Query field is - ReminderDate eq ' formatDateTime(convertFromUtc(utcNow(),'E. Australia Standard Time'), 'dd-MM-yyyy')
Is there something that I am doing wrong?
Eric

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

Like (0)

Report
Copy link

Link copied!

HI @Redviking110 ,
Could you please provide screenshots?
From the information you provided, my guess is that the formula is not perfect:
Single quotes are required around formatDateTime
Here is a link about filter query for your reference:
Power Automate list rows present in a table filter query - EnjoySharePoint

Best Regards
Cheng Feng

Was this reply helpful? Yes No