Skip to main content

Notifications

Power Automate - Power Automate Desktop
Suggested answer

JSON to Datatable

Posted on 28 Nov 2024 15:41:44 by 10
I need help to convert a JSON to datatable, i've been trying to get specific data from columns using parse text, this is an example of what i get
{"accounts": [{"id": 1, "client_vat": "99999999-9", "login": "999999999", "account_number": "10101010", "password": "12345678", "bank_id": "020", "browser": "Chrome", "account_type": "personal"}, {"id": 2, "client_vat": "88888888-86", "login": "888888888", "account_number": "8888888888", "password": "88888888", "bank_id": "020", "browser": "Firefox", "account_type": "personal"}

I can get the logins since they're all 9 digits with \d{9} , but when i try to get the passwords for example, there are some with 8 digits, and there's also some account numbers with 8 digits, i only want to get the passwords but i don't know how to make the parse differentiate between password and account number
Categories:
  • Suggested answer
    VishnuReddy1997 Profile Picture
    VishnuReddy1997 2,127 on 29 Nov 2024 at 07:03:36
    JSON to Datatable
     
    Use Convert JSON to Custom Object action to convert Json to DataTable.
     
     
     
    (Note:- if you got your solution you can mark as solution and gives kudos)
     
    Thanks & Regards
    Vishnu Reddy

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,168

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,851

Leaderboard