Get Items values not populating variables

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello all,

Im having trouble geting my values into variables so I can use them in emails and conditions.

My Configurations . . .

Get items:

The output

Set the variables

Yet all the variable come up blank when I add them to an email

Email Config:

Email output

How get I populate these variables so I can use the values?

Thank you for any help I can get

Cheers, DWTKBrook

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

I was able to figure it out. Because I had filter query on my get items that was comparing requestor of one list another list but the account being used was not in the list the my Get Items was targeting it wasn't pulling any data.

Was this reply helpful? Yes No
wskinnermctc 6,519 Moderator on at

Like (0)

Report
Copy link

Link copied!

It looks like the Get Items from SharePoint is coming back empty.

I'm surprised your flow runs with a column name "Requestor/EMail" in the filter. I just made a SharePoint column with the exact name "Requestor/Email" and attempted to run a Get Items filter and it errored/failed because it could not find a column named "Requestor".

The internal SharePoint column name of "Requestor/EMail" for me is "Requestor_x002f_EMail"

I had to change the filter to be Requestor_x002f_EMail eq '{Name}'

Can you check your filter and internal column name?

This might not be your issue since your flow seems to be running. However, I would look to see why your Get Items is coming back empty.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hello @wskinnermctc My requestor names were coming back empty because the requestor name in the requestor Column in the List1 was not in the Requestor Column in List 2, so the filer couldn't be satisfied. Once I was add the same name in the requestor column in list 2 it started working.

Also your syntax - The internal SharePoint column name of "Requestor/EMail" for me is "Requestor_x002f_EMail"
should use single quotes like;
The internal SharePoint column name of "Requestor/EMail" for me is 'Requestor_x002f_EMail'

I also didn't use any quotes for the firstpart i didn't use quotes;
Requestor/EMail eq '@{triggerOutputs()?['body/Requestor/Email']}'

I hope that explains it

Cheers!

Was this reply helpful? Yes No