Answered

Formatting SharePoint list column to be used by power automate flow - bit of JSON syntax help required please

(0) Share

Report

Posted on by DarrenScott

Hi all

I have some JSON code that was shared by another user to allow you to start power automate flows using a button (hidden or shown based on column value). Works great and just what I need.

however I am no JSON expert and whilst I have it working for one status in the column, I need it to check for one of two status options.

The JSON code looks for anything with a status of "Not Started" and hides the button for all other status options but I need it to check for both "Not Started" and "Need More Information".

Any JSON experts out there that can help me with the syntax for some kind of 'or' statement?

Thanks in advance of any help.

Darren.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

v-yueyun-msft on at

Like (0)

Report
Copy link

Link copied!

Hi, @DarrenScott
Based on your description, you want to get a value in Json and you want to judge it based on other values?
First of all, for Json, we can only get the value you want according to the Json schema.
For your Not Started, we can use this to take the value in Power Automate:
If you need other values to determine the Or condition, you need to use the same way to take the value in Json, and then use the Or function in Power Automate to make the logical judgment.
Reference guide for expression functions - Azure Logic Apps | Microsoft Learn

If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you.

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
DarrenScott 12 on at

Like (0)

Report
Copy link

Link copied!

Hi and thank you for the response. So to explain a bit further

I have a button in a SharePoint list column called "Send for Approval" (the orange button) that allows a user to start a power automate flow. But I only want that button visible if the item condition for the adjacent column called "Review Outcome" has a status of "Not Started" OR "More Information Required"

At present the button is visible to items where the "Review Outcome" status is "Not Started" but I am trying to work out how I put some kind of OR statement to also look for "More Information Required" in order to display the orange button.

I believe it would need to go into this section below

Does that make sense?
thanks

Was this reply helpful? Yes No
Verified answer

v-yueyun-msft on at

Like (0)

Report
Copy link

Link copied!
Hi , @DarrenScott
Oh , sorry for i misunderstand your need! I test it in my side , you can try to use this:
"visibility":"=if([$ReviewOutcome] =='Not Started' ||[$ReviewOutcome] =='More Information Required' , '', 'hidden')"
And this is my test list :
And for more information, you can refer to :
Use column formatting to customize SharePoint | Microsoft Learn

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
DarrenScott 12 on at

Like (1)

Report
Copy link

Link copied!

Thank you so much @v-yueyun-msft I am out at the moment but will test this out this evening when I get home it looks just like what I need. Thanks again.

Was this reply helpful? Yes No
DarrenScott 12 on at

Like (0)

Report
Copy link

Link copied!

That worked perfectly @v-yueyun-msft . I really do appreciate your swift help. Thank you so much. Darren.

Was this reply helpful? Yes No