cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
samsam
Level: Powered On

Get items from Sharepoint list return Blank field

Hi, 

 

I tried to get items from SharePoint list with Person Type. 

But it returns blank value.

 

However, if i get item from sharePoint list with Text/String Type .

Everything is normal.

 

Is there any trick to get the Person type?

Q23a.PNG

 

Q23b.PNG

 

Thanks in advance

Sam

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Gareth1
Level 8

Re: Get items from Sharepoint list return Blank field

Hi @samsam 

From what I can find because the column is a person field, you need to be able to access the child properties of the Applicant field, such as the EMail address. 

In testing I couldn't find a way to filter based on the display name the only field that I could filter on was the email address. Given that you are trying to search based on the persons name you could do a search on the users name with the Search for Users action, then get the email from the results and apply the filter on that. Hopefully this helps

Screen Shot 2019-12-09 at 6.47.54 pm.png

View solution in original post

13 REPLIES 13
Gareth1
Level 8

Re: Get items from Sharepoint list return Blank field

Hi @samsam 

From what I can find because the column is a person field, you need to be able to access the child properties of the Applicant field, such as the EMail address. 

In testing I couldn't find a way to filter based on the display name the only field that I could filter on was the email address. Given that you are trying to search based on the persons name you could do a search on the users name with the Search for Users action, then get the email from the results and apply the filter on that. Hopefully this helps

Screen Shot 2019-12-09 at 6.47.54 pm.png

View solution in original post

samsam
Level: Powered On

Re: Get items from Sharepoint list return Blank field

I got this error, am I doing any incorrect setting?

Thanks 

 

Q23c.PNG

Super User
Super User

Re: Get items from Sharepoint list return Blank field

its been a bit buggy lately did you try a second time? If its still not working just insert mail as dynamic content, you will get a loop but it'll only run once anyway assuming two users do not have the same name then you'll end up with the last one it retrieves.

Gareth1
Level 8

Re: Get items from Sharepoint list return Blank field

It looks like you have the correct expression. I was trying to just get the email address returned from the first record returned.

 

Unless there are no records been returned. 

 

If you were to leave that step out and just run a test do you see the body object in the Dynamic Content tab from the Search for Users results

Screen Shot 2019-12-09 at 7.22.37 pm.png

samsam
Level: Powered On

Re: Get items from Sharepoint list return Blank field

It returns error at the first step, Search for users

 

Q23d.PNGQ23e.PNG

Gareth1
Level 8

Re: Get items from Sharepoint list return Blank field

It looks like an issue with the connector for the Search for Users, not with the query

 

In the past when I have had a similar error it has been because I have tried to do a test based on a previous run just after adding a new connector. To fix this normally I would just perform the test again and select the option "I'll perform the trigger action" then it creates the connections automatically, however given that this is from PowerApps I'm not 100% sure if it works the same 

 

You may be able to add the connection manually, by clicking on the 3 dots at the top right of the action and selecting add a connection

Screen Shot 2019-12-09 at 7.45.32 pm.png

samsam
Level: Powered On

Re: Get items from Sharepoint list return Blank field

The search user and variable has been configured. 

however, the "Get Items" value still return nothing. Same as before. 

Any idea?

Thanks 

 

Q23f.PNG

Gareth1
Level 8

Re: Get items from Sharepoint list return Blank field

It looks like the Filter Query is incorrect

It should be using the email address to find the user

Screen Shot 2019-12-09 at 8.38.23 pm.png

I think in your one the filter should be Applicant/EMail eq 'email variable'

samsam
Level: Powered On

Re: Get items from Sharepoint list return Blank field

@Gareth1 Just update it to email address, and assigned to variable "vApplicant"

however, in "get items" step, it still returns nothing

 

Q23g.PNG

Super User
Super User

Re: Get items from Sharepoint list return Blank field

you still did not put /Email in the filter query as per his examples 🙂

Gareth1
Level 8

Re: Get items from Sharepoint list return Blank field

@samsam 

Almost there I think you just need to change Applicant to Applicant\EMail in the filter

 

Also making sure the you have a capital E and M in EMail

samsam
Level: Powered On

Re: Get items from Sharepoint list return Blank field

Just changed it, but it returns the following error 

 

Q23h.PNG

samsam
Level: Powered On

Re: Get items from Sharepoint list return Blank field

It works now ~~ !!

I've changed the backslash to slash 

application\EMail

application/EMail

 

Thanks a lot for the help 😀

@Gareth1  @Gristy 

Helpful resources

Announcements
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,309)