cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ABT-263
Regular Visitor

Select (Data Operation) failed to capture data.

Hi all ,

I just established a platform on Microsoft Lists to follow up my to-do-list, and each task is classified into High, Medium and Low Priority.  I create a recurrence RPA to check every morning:

1. If High Priority - send email to myself every day

2. Medium Priority - send email every 7 days

3. Low Priority - send email every 14 days

 

Here is my RPA structure:

1. Recurrence

2. Get items 

3. Filter array - (select priority = High)

4. Parse JSON

5. Select (Data Operation)

  I use   "   item().WKO "   to capture WKO data here

ABT-263_2-1621947762740.png

6. Create HTML table

7. Send an email to myself

 

 

Last week, it did work, and sent me a to-do-list every morning!!

Below is email screenshot:

ABT-263_0-1621947543367.png

 

However, it failed yesterday. WKO data was in Parse JSON Output, but RPA couldn't find "WKO" in Select step. 

ABT-263_4-1621948591395.png

Does anyone know what's happen to my process?  I can't figure out the reason by myself.

Than you so much!!!

 

1 ACCEPTED SOLUTION

Accepted Solutions
DamoBird365
Super User
Super User

Hi @ABT-263 

 

Is it possible that one of your objects is missing the WKO key?

 

You expression explicitly requires the WKO key to appear.  item().WKO vs item()?['WKO']  by using the ? the expression will not fail if the object doesn't contain the Key.

 

If you look through the history of your get items, you might be able to see where an object is missing WKO, maybe it is empty on that item.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien


P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

View solution in original post

2 REPLIES 2
DamoBird365
Super User
Super User

Hi @ABT-263 

 

Is it possible that one of your objects is missing the WKO key?

 

You expression explicitly requires the WKO key to appear.  item().WKO vs item()?['WKO']  by using the ? the expression will not fail if the object doesn't contain the Key.

 

If you look through the history of your get items, you might be able to see where an object is missing WKO, maybe it is empty on that item.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien


P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

View solution in original post

WOW, @DamoBird365 , Just put "?" , and it worked!!

 Thank you so much!!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (3,051)